You should be able to find it in the poi source in the examples: org.apache.poi.xssf.usermodel.examples
./examples/src/org/apache/poi/xssf/usermodel/examples/BigGridDemo.java Regards, Dave On May 6, 2010, at 6:41 AM, <[email protected]> <[email protected]> wrote: > > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
