File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Other Open Source Projects and the fly likes Excel sheet not getting deleted in the back end - POI Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Excel sheet not getting deleted in the back end - POI" Watch "Excel sheet not getting deleted in the back end - POI" New topic
Author

Excel sheet not getting deleted in the back end - POI

Ankush Kaundal
Ranch Hand

Joined: May 12, 2011
Posts: 36

Hi

I am trying to remove the excel sheet at particualr index in a excel file using the Apache POI using the removeSheetAt() method of the HSSFWorkbook class and the sheet is getting deleted also from the front end but due to some unknown reasons i am still able to see the sheet in Visual basic screen which is effecting my macros. Can anyone help me so that my sheet is deleted completely from the back end.

I am using one of the latest version of the poi i.e. poi-3.7-20101029.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Excel sheet not getting deleted in the back end - POI
 
Similar Threads
java.lang.OutOfMemoryError: Java heap space
How to rectify apache poi error Unknown Ptg 1c (28)
Formating problem
Reading an Excel File using Java
unable to open excel document