See the sample code below that denotes how to determine if a row is hidden in a range. I have used your template file in the code. You may refer to it and may add or update code accordingly for your needs:
e.g
Sample code:
// Open Excel file.
Workbook workbook = new Workbook(“e:\test2\HiddenRow.xlsx”);
//If you just want to know any row in referred range is hidden, you may determine as following:
Range range = workbook.Worksheets.Names[“therange”].GetRange();
if (range != null)
{
if (!range.Worksheet.IsVisible)
{
MessageBox.Show(“Worksheet is not visible.”);
}
Cells cells = range.Worksheet.Cells;
for (int i = range.FirstRow; i < (range.RowCount + range.FirstRow) ; i++)
{
if (cells.Rows[i].IsHidden)
{
Console.WriteLine(“Row " + (cells.Rows[i].Index +1).ToString() + " is hidden”);
}
}
//Similarly you may try to evaluate if any column is hidden
Good to know that it figures out your issue now. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.