Free Support Forum - aspose.com

How to determine if row is hidden

Hi,

An internal application we developed is using Aspose.Excel (the DLL version is 2.9.0.1).

One of the things the application does is accept an Excel file and pull data from it. The importation is working fine, but we would like it to ignore hidden rows. Unfortunately, we haven’t been able to figure out how to do this. We tried checking the row height, in the hope that getRowHeight() would return 0 for a hidden row, but it is returning the height of the row if it were unhidden.

Is there a way to determine whether a row is hidden? Thank you for your help!

It may be a bug in old version.

GetRowHeight method return 0 in the latest version of Aspose.Cells(an upgrade of Aspose.Excel).

It may be a bug in old version.

GetRowHeight method return 0 for hidden rows in the latest version of Aspose.Cells(an upgrade of Aspose.Excel).

Thanks Laurence, I will suggest that we upgrade to a newer version.