Could you please tell me how to ignore hidden worksheets? Below is the code where i’m loading the workbook. Thanks!
HtmlLoadOptions htmlOptions;
if (inputFileFormatId == SharedConstants.FileFormat.Excel)
{
LoadFormat loadFormat;
switch (extension.ToLower())
{
case ".xlsx":
loadFormat = LoadFormat.Xlsx;
break;
case ".xls":
loadFormat = LoadFormat.Excel97To2003;
break;
default:
loadFormat = LoadFormat.CSV;
break;
}
htmlOptions = new HtmlLoadOptions(loadFormat);
htmlOptions.ConvertNumericData = false;
if (stream == null)
{
workbook = new Workbook(); // Only needed to avoid null checks later
}
else
{
workbook = new Workbook(stream, htmlOptions);
}
}