Som, The problem is all sheets are loaded when opening the worksheet. If it encounters a problem reading the other sheets, which I don't intend to read or update and don't have control on, it will fail. The getSheet method just returns the already loaded sheet.
Ayal. "som kolli" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Ayal, > > use getSheet() method to open the worksheet by name... > > Som > > -----Original Message----- > From: Ayal Leibowitz [mailto:[EMAIL PROTECTED] > Sent: Monday, September 29, 2003 6:05 PM > To: [EMAIL PROTECTED] > Subject: Opening an HSSFWorkbook without loading all sheets > > > Hello, > > In a specific worksheet, I'm responsible only for one sheet (with a constant > name), which I want to produce using POI. The other sheets in the worksheet > are > manipulated by clients. Using POI to produce the sheet, I encountered cases > in > which when I opened the existing workbook (with a HSSFWorkbook constructor > of > course), it failed and issued an exception. This happens in various cases > which > POI doesn't support. Though these cases are supported more and more in new > versions of POI, I would like to have an option to open a worksheet, without > loading all the sheets. I would like to specify explicitly which sheets to > load > (by name). However, still I want to be able to update the loaded sheets and > save the entire workbook, leaving the other sheets unchanged. > > Is there an existing option to implement this requirement with the current > POI > version? Any comments/recommendations would be appreciated. > > Ayal Leibowitz. > > ------------------------------------------------- > This mail sent through IMP: http://horde.org/imp/ > > --------------------------------------------------------------------- > 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]
