I would definitely like to see this if anyone has a link to this and can provide a usable demo.
Thanks Bryce --------------------------------------------------------------------------- Bryce Alcock * Performance Architect * SunGard * ........................................................................... personal website http://www.brycealcock.com/ --------------------------------------------------------------------------- -----Original Message----- From: MSB [mailto:[email protected]] Sent: Thu 5/6/2010 1:40 AM To: [email protected] Subject: Re: Performance Question with CTSheetDataImpl.java If performance is an issue with such a parge worksheet, have you ooked into Yegor's BigGridDemo code yet? I do not have the link to hand to post and accept that it is a proof so to speak and not a complete application, but it does demonstrate an alternative technique if you are working with large amounts of data. Yours Mark B Bryce.Alcock wrote: > > > I am looking at some performance issues with POI saving XLSX > to disk for large spreadsheets (65,000 + rows). > > I have tracked the issue down to: > sheetData.setRowArray(rArray.toArray(new CTRow[rArray.size()])); > > > which invokes some Code: > CTSheetDataImpl.java > > invokes... > XmlComplexContentImpl.java > > invokes... > Xobj.java > > > > My Question: > I cannot find the CTSheetDataImpl.java code. > Where is that code, is it opensource? > > I am tasked with making this faster. > Please let me know where this code is: > > Full Package: > org/openxmlformats/schemas/spreadsheetml/x2006/main/impl/CTSheetDataImpl.class > > BTW > www.openxmlformats.org takes you to the following website: > http://www.microsoft.com/en/us/default.aspx > > > > Thanks > > > Bryce Alcock * Performance Architect * SunGard * > http://www.brycealcock.com > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > -- View this message in context: http://old.nabble.com/Performance-Question-with-CTSheetDataImpl.java-tp28466607p28469819.html Sent from the POI - Dev mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
