> > 1.) You can remove sheets in poi. I never heard of hiding > and I do not > > > know of any functions in the api that might be able to hide > a sheet. You > > > can hide sheets in Excel but maybe this is just a > presentation thing and > > > has nothing to do with the file format? > > > > Excel allows user to hide any worksheet. But once you > hide any particular worksheet, and then save the file, MS > Excel write this information in file so that whenever user > opens same excel file again he doesn't see the hidden > worksheet. Doesn't it mean that MS Excel save the information > about what all the worksheets are hidden or visible in the > (.xls) file? If yes, then doesn't it make this feature as > part of file format because while reading excel file you will > encounter some properties which say which worksheets are > visible or hidden?
Ok, that is your point. So it seems the feature is not implemented in poi. I am no developer (maybe in future :-) ) so I can not say anything about the status of this feature or in which way it can be implemented. > > 2.) Sheets have names. I never heard of workbooks having > names. Do you > > > mean the filename? There is no direct connection with a file in the > > > workbook. Outputstreams and InputStreams are used for writing and > > > reading. So you have to manage this yourself. The workbook > does not know > > > where it was read from or where it is written to. This provides more > > > flexibility. This way you can use poi in a webserver > environment, too. > > > > Yes I meant the file name. I am agree with your answer. Ok. One of two is not all that bad. ;-) bye Bodo
smime.p7s
Description: S/MIME cryptographic signature
