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/