This project has moved. For the latest updates, please go here.

Hide sheet

Feb 25, 2011 at 8:26 AM

Is it possible to hide a sheet? Can't find it in documentation or as property on IXLWorksheet..

I want to use a hidden sheet as source of datavalidation lists.

Thanks for a great library!!

Coordinator
Feb 25, 2011 at 3:09 PM

Not right now but it's an easy thing to do. I'll work on it.

Coordinator
Feb 25, 2011 at 3:09 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
Mar 7, 2011 at 8:02 AM

Works fine except for that the first sheet can not be hidden.

For example:

                var wb = new XLWorkbook();
                wb.Worksheets.Add("Hidden").Hide();
                wb.Worksheets.Add("Unhidden").Hide().Unhide();
                wb.Worksheets.Add("VeryHidden").Visibility = XLWorksheetVisibility.VeryHidden;
                wb.SaveAs("c:\\HideWorksheets.xlsx");

In this case the Hidden and Unhidden sheets are visible.

Coordinator
Mar 7, 2011 at 7:26 PM

Good catch. I already fixed it and will release it soon.