What you ask for would probably not solve the problems you think it would. For example, if a workbook contains macros, manipulating any of the worksheets might corrupt the macros and cause the file to be unloadable. Formulas which contain cross-sheet references would also change. Changing the size of your worksheet by even one byte would cause some pointers in the other worksheets to need an update.
There may be reasons to allow for opening a single worksheet at a time. For example, in some cases it might reduce memory requirements. But I don't think it will get around the problem of supporting features that POI does not currently support. Your best bet, short of implementing the features that you require and submitting a patch (and hoping someone will post the patch) is to report a bug, including the POI code and sample spreadsheet to reproduce the problem. -----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]
