You should create your sheet in the workbook. If you just create a java
object, how is POI supposed to know to which  workbook it should belong to.

i.e. use:
workbook.createSheet("name")

instead of :
new HSSFSheet("name");

and all should be fine...

Hth,
Tobias


> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 23, 2006 6:43 AM
> To: poi-user@jakarta.apache.org
> Subject: Unable to set the sheetname using POI API
> 
> 
> 
> Hi ,
>     I have written code to create and process excel sheets 
> using POI API.
> I am working on Solaris . There is  problem when i am creating the
> worksheet as below :
> HSSFSheet sheet = new HSSFSheet("Summary");
> 
> It is creating the sheet , but the name of the sheet is not 
> being set. It
> is having the default name as sheet0 .
> I have used wrokbook.setSheetName() method also , but of no use .
> Please help me to solve this .
> 
> Regards ,
> Subhashini Gumpula
> 
> 
> Notice: The information contained in this e-mail message 
> and/or attachments to it may contain confidential or 
> privileged information. If you are not the intended 
> recipient, any dissemination, use, review, distribution, 
> printing or copying of the information contained in this 
> e-mail message and/or attachments to it are strictly 
> prohibited. If you have received this communication in error, 
> please notify us by reply e-mail or telephone and immediately 
> and permanently delete the message and any attachments. Thank you
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

Reply via email to