Hi,
Could you post your template file(s) here, we will check your issue soon.
Thank you.
Here you go..pls find attached
thxs,
Rohit
Hi,
Thanks for the template .xlsx file.
We found the issue, we will provide a fix here as soon as we figure it out.
Thank you for time and understanding.
Hi Rohit,
Please try this attached fix, thank you.
Thxs Jhonson,
The fix works..but I ran into a new problem.. The template file I increased the number of formulas to 70K rows..it gives me following error..I have java heap size to 2G still doesnot work..
The same input file works with 65K formulas in excel 2003 version template..Please help..this is getting very critical to be fixed
-----------------
Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
at java.util.ArrayList.(ArrayList.java:113)
at org.dom4j.tree.AbstractElement.createAttributeList(AbstractElement.java:1641)
at org.dom4j.tree.DefaultElement.attributeList(DefaultElement.java:1001)
at org.dom4j.tree.AbstractElement.setAttributes(AbstractElement.java:528)
at org.dom4j.io.SAXContentHandler.addAttributes(SAXContentHandler.java:916)
at org.dom4j.io.SAXContentHandler.startElement(SAXContentHandler.java:249)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(AbstractSAXParser.java:533)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(XMLNSDocumentScannerImpl.java:330)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(XMLDocumentFragmentScannerImpl.java:1693)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:368)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:834)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:764)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:148)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1242)
at org.dom4j.io.SAXReader.read(SAXReader.java:465)
at org.dom4j.io.SAXReader.read(SAXReader.java:343)
at com.aspose.cells.ab.a(Unknown Source)
at com.aspose.cells.aX.(Unknown Source)
at com.aspose.cells.dv.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.open(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.open(Unknown Source)
----------
Hi,
I simulated your situation, with the template.xlsx you attached in prevoius post, when the sheet "CI" extends its rows to 70K more with formulas, the generated excel file would be about 30-35M. As you know, for Excel2007 xlsx file format, its data is saved in XML files and then compress XML files into Zip format file. In fact, for the template.xlsx, the size of XML file for data of sheet "CI" is about 220-230M. Currently we use DOM to parse the XML file, to build such a DOM object, only this one XML file will need more than 1G memory. We will look into parsing the XML data by SAX mode, but that need some more time for us to rebuild our data model and implement such a feature.
For your situation currently, I think you'd better split the data of this sheet into multiple sheets, and use FileFormatType parameter to specify Excel file format as EXCEL2007 when open the file with API Workbook.open() rather than let Aspose.Cells component to determine the file format automatically. Thank you.
Hi Johnson,
Thxs for looking into it..
1) Splitting the files into multiple sheets is not possible as the input file is csv..creating multiple files has some application issues..hence can't be supported
2) Tried by using FileFormatType parameter as EXCEL2007when opening template file..doesn't work..
I understand implementing SAX parsing is not a 1 day fix..but if you could provide me some sort ETA when this fix would be available..that would be really helpful
Thanks,
Rohit
Hi Rohit,
We will try to implement SAX parsing and release a new version at the end of Oct, thank you.
Thxs…will be waiting for the release…
Hi Aspose Team,
I migrated to v1.9.5.25 (with fixes above) . I found an issue when the getting the output in csv. In the same code as above but with different set of input/output file ( see attached samples).
Instead of getting output as "1236,,-123.00".. I am getting csv output as "1236,-123.00" missing a comma.
Please advice
Thanks,
Rohit
Hi Rohit,
Thanks for providing us the template files.
After an initial test, we found the issue, we will figure it out soon.
Thank you.
Hi Rohit,
Thank you for your template file, we have found the issue and fixed it, please try this fix at https://forum.aspose.com/t/84949, thank you.
Hi Aspose Team,
I tried the fix above..but output csv gives me an extra line on the top..can u pls check??
Thxs,
Rohit
Hi Rohit,
Please try the attached latest fix of Aspose.Cells. We have fixed the issue you have mentioned. Please do let us know, if you still face any problem.
Thank you & Best Regards,
Thxs Aspose Team, the fix provided works.
Another question, Johnson from aspose team mentioned abt providing SAX parsing for excel 2007 by end of october(pls read avove post).. Do we have any definite time when this would be avilable?
Thanks,
Rohit
Hi,
Ok, we will update you related SAX parsing soon.
Thank you for your patience!
Hi,
Sorry for a bit delay,
The feature (SAX parsing ) is still under development, hopefully after two weeks, we can support it for your requirement.
Thank you.
Hi Aspose Team,
Any update on when the SAX implementation would be made available?
Thxs,
Rohit
Hi,
Thank you for considering Aspose.
We have implemented the SAX mode when reading Excel2007 file. please try the attached latest version.
Thank You & Best Regards,
Thxs will check & reply back… I assume all the issues reported above are also handled in this fix?