Michael, You're right. But, on the other side, there are many cases POI doesn't handle and new Office releases will cause some more. I can't let the customers wait. I thought maybe taking my sheets out of the Clients' workbook and let them use cross-workbook references. However, it's not very convenient, especially due to the fact the excels are distributed by email and this way, opening the excel from within the email won't work.
Ayal. "Michael Zalewski" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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]
