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.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: Excel sheet not getting deleted in the back end - POI