Search code examples
c#epplus

how to hide work sheet in epplus in C#?


I found nothing in web about hiding worksheet in epplus. How can I hide ddworksheet?

ExcelWorksheet ddworksheet = package.Workbook.Worksheets.Add("DropDownList");

Solution

  • Yes, you can using the Hidden property of the worksheet:

    ExcelWorksheet ddworksheet = package.Workbook.Worksheets.Add("DropDownList");
    ddworksheet.Hidden = OfficeOpenXml.eWorkSheetHidden.Hidden;