This project has moved and is read-only. For the latest updates, please go here.

Hide sheet

Feb 25, 2011 at 9: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!!

Feb 25, 2011 at 4:09 PM

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

Feb 25, 2011 at 4: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 9:02 AM

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

For example:

                var wb = new XLWorkbook();
                wb.Worksheets.Add("VeryHidden").Visibility = XLWorksheetVisibility.VeryHidden;

In this case the Hidden and Unhidden sheets are visible.

Mar 7, 2011 at 8:26 PM

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