Hi Jason ,
Can some one you let me know how to remove or hide a sheet from the parsed XLSX template?
I need to remove some of the sheets from the existing template based on some configuration.
I tried as below but no luck ..
WorksheetPart sheet = worksheets.get(Integer.parseInt(sheetArray));
Worksheet ws = sheet.getJaxbElement();
SheetViews sViews =ws.getSheetViews();
List<SheetView> listView = sViews.getSheetView();
for(int i=0; i<listView.size();i++)
{
listView.remove(i);
}
Appreciate your help.
Thanks,
IK