rahulbhatt04

Please reply it is quite urgent

I want to remove default wrap text in my Excel report I am using Jexcel AP in a single column. Is there any specific attribute that can be used in Jrxml or any param that needs to be pass Please find attached reports for required & actual sample. Please help Post Edited by rahulbhatt04 at 07/15/2009 09:21

Hi Gianfranco Can you share your custmized JExcel API with me I am also sharing same problem

Html output Rendered properly but Excel is giving eout of memory error [i am using same data set & same Jrxml for both format] I am facing error I am using Swap Virtualizer with following param block Size=1000 Increment = 500 Max Number of Pages in cache=4 I am trying to generate a report with 900000 records with 2 gigs memory on Linux system I get HTML perfect in case of Excel it generates Swap file correctly but while Expoting I get following error Caused by: java.lang.OutOfMemoryError: Java heap space at java.lang.String.<init>(String.java:208) at java.lang.StringBuffer.toString(StringBuffer.java:586) at java.io.ObjectInputStream$BlockDataInputStream.readUTFBody(ObjectInputStream.java:2968) at java.io.ObjectInputStream$BlockDataInputStream.readUTF(ObjectInputStream.java:2764) at java.io.ObjectInputStream.readString(ObjectInputStream.java:1567) at java.io.ObjectInputStream.readTypeString(ObjectInputStream.java:1375) at java.io.ObjectStreamClass.readNonProxy(ObjectStreamClass.java:634) at java.io.ObjectInputStream.readClassDescriptor(ObjectInputStream.java:789) at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1534) at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1466) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1699) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1305) at java.io.ObjectInputStream.readObject(ObjectInputStream.java:348) at java.util.ArrayList.readObject(ArrayList.java:591) at sun.reflect.GeneratedMethodAccessor51.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:946) at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1809) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1719) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1305) at java.io.ObjectInputStream.readObject(ObjectInputStream.java:348) at net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer.readData(JRAbstractLRUVirtualizer.java:604) at net.sf.jasperreports.engine.fill.JRSwapFileVirtualizer.pageIn(JRSwapFileVirtualizer.java:112) at net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer.requestData(JRAbstractLRUVirtualizer.java:493) at net.sf.jasperreports.engine.base.JRVirtualPrintPage.ensureVirtualData(JRVirtualPrintPage.java:312) at net.sf.jasperreports.engine.base.JRVirtualPrintPage.getElements(JRVirtualPrintPage.java:304) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportPage(JRXlsAbstractExporter.java:443) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:383) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:186)

Hi I am facing Same error I am using Swap Virtualizer with following param block Size=1000 Increment = 500 Max Number of Pages in cache=4 I am trying to generate a report with 900000 records with 2 gigs memory on Linux system I get HTML perfect in case of Excel it generates Swap file correctly but while Expoting I get following error Caused by: java.lang.OutOfMemoryError: Java heap space at java.lang.String.<init>(String.java:208) at java.lang.StringBuffer.toString(StringBuffer.java:586) at java.io.ObjectInputStream$BlockDataInputStream.readUTFBody(ObjectInputStream.java:2968) at java.io.ObjectInputStream$BlockDataInputStream.readUTF(ObjectInputStream.java:2764) at java.io.ObjectInputStream.readString(ObjectInputStream.java:1567) at java.io.ObjectInputStream.readTypeString(ObjectInputStream.java:1375) at java.io.ObjectStreamClass.readNonProxy(ObjectStreamClass.java:634) at java.io.ObjectInputStream.readClassDescriptor(ObjectInputStream.java:789) at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1534) at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1466) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1699) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1305) at java.io.ObjectInputStream.readObject(ObjectInputStream.java:348) at java.util.ArrayList.readObject(ArrayList.java:591) at sun.reflect.GeneratedMethodAccessor51.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:946) at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1809) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1719) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1305) at java.io.ObjectInputStream.readObject(ObjectInputStream.java:348) at net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer.readData(JRAbstractLRUVirtualizer.java:604) at net.sf.jasperreports.engine.fill.JRSwapFileVirtualizer.pageIn(JRSwapFileVirtualizer.java:112) at net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer.requestData(JRAbstractLRUVirtualizer.java:493) at net.sf.jasperreports.engine.base.JRVirtualPrintPage.ensureVirtualData(JRVirtualPrintPage.java:312) at net.sf.jasperreports.engine.base.JRVirtualPrintPage.getElements(JRVirtualPrintPage.java:304) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportPage(JRXlsAbstractExporter.java:443) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:383) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:186)