Thanks Bj�rn for your reply. Below you find comments regarding your reply.
> 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?
> 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.
Thanks
Prashant Patel
-----Original Message-----
From: "Mehner, Bj�rn" [mailto:[EMAIL PROTECTED]
Sent: Monday, September 15, 2003 9:27 AM
To: 'POI Users List'
Subject: AW: Hide Worksheet?
> Since nobody has answered the questions I posted, should I assume that
> POI doesn't support Hiding worksheet functionality as well as
> returning
> the name of excel workbook from "HSSFWorkbook" object?
I do not understand the intentions of your questions. But here is my
guess:
AFAIK:
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?
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.
Bye Bodo
