Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

how to hide work sheet in epplus in C#?

Tags:

c#

epplus

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

ExcelWorksheet ddworksheet = package.Workbook.Worksheets.Add("DropDownList");
like image 856
Muzammil Ansari Avatar asked Aug 11 '15 10:08

Muzammil Ansari


1 Answers

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

ExcelWorksheet ddworksheet = package.Workbook.Worksheets.Add("DropDownList");
ddworksheet.Hidden = OfficeOpenXml.eWorkSheetHidden.Hidden;
like image 103
Ernie S Avatar answered Nov 15 '22 21:11

Ernie S