loading only 1 sheet from workbook?

[Christopher Cheng <ch...@keentravel.com>]

I have a serious problem with loading data with hssf. The workbook I am 
loading has about 100 sheet. I do not need to load all sheets. Right now, I 
am using the following to load the workbook:

POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(filename));
HSSFWorkbook wb = new HSSFWorkbook(fs);
HSSFSheet sheet = wb.getSheet(sheetName);

That takes me over 30 mins to load the workbook. How could I load only 1 
sheet to improve the performance?





---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/