|
The fesod support reading hidden rows or columns? I think this feature is very practical, but I haven't found any related usage in the API. The key point is that fesod can help me identify which rows or columns are hidden. |
Replies: 1 comment 1 reply
|
Hi @MamyAKKK - I'm not a maintainer, but as I understand: Today: no. Fesod provides hidden state only at the sheet level ( But it may be possible to support: The .xlsx format stores hidden state as a Two ways it could probably be done:
Since it'd be a new feature, it's probably worth opening a feature request :) |
Hi @MamyAKKK - I'm not a maintainer, but as I understand:
Today: no. Fesod provides hidden state only at the sheet level (
ReadSheet.isHidden(),.ignoreHiddenSheet(true)). Individual rows and columns aren't covered: Fesod never reads the rowhiddenattribute or the<col hidden="1">flag, and the "extra" info it reports viaReadListener.extra(...)only coversCOMMENT,HYPERLINK, andMERGE.But it may be possible to support: The .xlsx format stores hidden state as a
hiddenattribute on<row>and<col>. Fesod's streaming reader already passes over both - it just doesn't read those attributes yet. So there's no whole-sheet load or second pass needed, as the information is already flowing throu…