Sylvan.Data.Excel icon indicating copy to clipboard operation
Sylvan.Data.Excel copied to clipboard

Hidden row handling

Open MarkPflug opened this issue 1 year ago • 1 comments

This adds the ability to inspect if a row is hidden, and adds an option to have the reader skip hidden rows via ExcelDataReaderOptions.ReadHiddenRows, which defaults to true for backwards compat.

MarkPflug avatar Sep 28 '24 00:09 MarkPflug

@0xced I've implemented the hidden row feature for all supported types. I need to add more unit tests though, as I'm concerned about some corner cases, especially for .xls files.

Maybe you can test this branch with your use case and see if it handles your needs at least. I'm going to try to finish this feature up, and maybe handle hidden columns separately (if at all).

MarkPflug avatar Sep 28 '24 00:09 MarkPflug

Sorry for the long delay. I just tried your hidden branch and it works fine! (I tested xlsx only though.)

0xced avatar May 01 '25 13:05 0xced