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]
