How to hide worksheet in epplus in c #?

Question

I did not find anything on the Internet on how to hide a worksheet in epplus. How to hide ddworksheet ?

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

+6

Muzammil ansari Aug 11 '15 at 10:03

1 answer

Ernie · Accepted Answer · 2015-08-11T12:14:17+0000

Yes, you can use the Hidden property on the sheet:

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