I found nothing in web about hiding worksheet in epplus. How can I hide ddworksheet
?
ExcelWorksheet ddworksheet = package.Workbook.Worksheets.Add("DropDownList");
Yes, you can using the Hidden
property of the worksheet:
ExcelWorksheet ddworksheet = package.Workbook.Worksheets.Add("DropDownList");
ddworksheet.Hidden = OfficeOpenXml.eWorkSheetHidden.Hidden;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With