poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Fisher <dfis...@jmlafferty.com>
Subject Re: Performance Question with CTSheetDataImpl.java
Date Thu, 06 May 2010 14:09:42 GMT
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, <Bryce.Alcock@sungard.com> <Bryce.Alcock@sungard.com>
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:markbrdsly@tiscali.co.uk]
> Sent: Thu 5/6/2010 1:40 AM
> To: dev@poi.apache.org
> 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: dev-unsubscribe@poi.apache.org
>> For additional commands, e-mail: dev-help@poi.apache.org
>> 
>> 
>> 
> 
> -- 
> 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: dev-unsubscribe@poi.apache.org
> For additional commands, e-mail: dev-help@poi.apache.org
> 
> 
> 
> 
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> For additional commands, e-mail: dev-help@poi.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message