Win a copy of Securing DevOps this week in the Security forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Excel sheet not getting deleted in the back end - POI  RSS feed

Ranch Hand
Posts: 36
Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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.
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!