poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew C. Oliver" <acoli...@apache.org>
Subject Re: Regarding HSSF Optimization
Date Wed, 07 Apr 2004 15:19:24 GMT
The other constructor immediately wraps it in a POIFSFileSystem object.  The
InputStream version is just a convenience method.
-- 
Andrew C. Oliver
http://www.superlinksoftware.com/poi.jsp
Custom enhancements and Commercial Implementation for Jakarta POI

http://jakarta.apache.org/poi
For Java and Excel, Got POI?

The views expressed in this email are those of the author and are almost
definitely not shared by the Apache Software Foundation, its board or its
general membership.  In fact they probably most definitively disagree with
everything espoused in the above email.

> From: "Daniel Joshua" <daniel.joshua@gridnode.com>
> Reply-To: "POI Users List" <poi-user@jakarta.apache.org>
> Date: Wed, 7 Apr 2004 10:06:57 +0800
> To: "'POI Users List'" <poi-user@jakarta.apache.org>
> Subject: RE: Regarding HSSF Optimization
> 
> What's the difference of using a POIFSFileSystem object in the constructor
> instead of a InputStream object?
> 
> 
> Regards,
> Daniel
> 
> 
> -----Original Message-----
> From: Srinadh Karumuri [mailto:skarumur@bbn.com]
> Sent: Wednesday, 07 April, 2004 1:05 AM
> To: POI Users List
> Subject: Re: Regarding HSSF Optimization
> 
> 
> I am not sure why it's slow. Maybe someone can help you there.
> 
> Here is what I do (same as in the examples):
>        POIFSFileSystem fs =
>        new POIFSFileSystem(new FileInputStream(_templateFile));
>        wb = new HSSFWorkbook(fs);
> 
> At 09:11 AM 4/6/2004, you wrote:
>> Hi all,
>> 
>> Just curious about one thing, why constructor of the work book
>> is taking maximum time to create itself?
>> 
>> Say for example if i wanted to parse 1 MB file which contains
>> only text, it is taking arround 45 seconds on 256MB/P4 macahine
>> for creating constructor itself, after that more 30 to 35 secs
>> approx for getting the text from HSSFSheet Objects
>> 
>> This is becoming problem for me when deal with large documents.
>> 
>> 
>> 
>> here is how i am construction the workbook object
>> 
>> 
>>     //EXCEL DOCUMENT AS INPUT STREAM OBJECT
>>     InputStream input = new FileInputStream(strDocument);
>>     //HOLDS THE EXCEL BUFFER
>>     ByteArrayOutputStream excelBuffer = new
>> ByteArrayOutputStream();
>> 
>>     HSSFWorkbook workbook = null;
>>     //CREATE A WORKBOOK FOR AN EXCEL DOCUMENT
>>     workbook = new HSSFWorkbook(input);
>> 
>> 
>> =====
>> "No one can earn a million dollars honestly."- William Jennings Bryan
>> (1860-1925)
>> 
>> "Make everything as simple as possible, but not simpler."- Albert Einstein
>> (1879-1955)
>> 
>> "It is dangerous to be sincere unless you are also stupid."- George
>> Bernard Shaw (1856-1950)
>> 
>> __________________________________
>> Do you Yahoo!?
>> Yahoo! Small Business $15K Web Design Giveaway
>> http://promotions.yahoo.com/design_giveaway/
>> 
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: poi-user-help@jakarta.apache.org
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
> 


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


Mime
View raw message