I see a strange behaviour when I run the code below on the attached document:
The two sheets that are still visible are "grouped" (a feature in Excel I was aware of). This causes problems for us.
Can you have a look at it?
public static void DoIt()
WorkbookDesigner designer = new WorkbookDesigner();
Workbook workbook = new Workbook(Constants.sourcePath + "Sheets.xlsx");
designer.Workbook = workbook;
foreach (Worksheet sheet in workbook.Worksheets)
if (sheet.Name == "Sheet3")
sheet.IsVisible = false;
string output = Constants.destPath + "Sheets_result.xlsx";