I am actually setting the refrences for the named ranges to one of the active sheets in the excel.
Tim Wilkins wrote: > > Have you tried deleting all named ranges that refer to the sheets that > you delete? > > HSSFName.getSheetName() > > nupur wrote: >> am using POI for generating excel reports. >> >> The requirement is to write to a template, consisting of several sheets. >> Each sheet in this template corresponds to different type of reports. >> After writing to the template, we check for the reports requested by the >> user; and whatever reports are not requested, we delete the corresponding >> sheets in the template and save it in a specified location. >> >> Now the problem is if we delete a sheet, which has some named ranges, >> using >> POI; while opening the generated excel I get an error- >> Removed one or more invalid names. >> >> Please respond if anyone has faced a similar issue as it is really >> urgent. >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/Error-while-removing-sheets-using-POI-HSSF-tf4640920.html#a13272221 Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
