You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When I run xlsx2csv against some xlsx files, found hidden rows are exported to the csv files even if the parameter skip_hidden_rows is true by default.
After digging into it a bit, I noticed those xlsx files have set the attribute value of hidden to true instead of 1 as some others. This caused the condition checking code here not filtering the hidden row out.
elifself.in_sheetand (name=='row'or (has_namespaceandname.endswith(':row'))) and ('r'inattrs) andnot (self.skip_hidden_rowsand'hidden'inattrsandattrs['hidden'] =='1'):
When I run
xlsx2csv
against some xlsx files, found hidden rows are exported to the csv files even if the parameterskip_hidden_rows
istrue
by default.After digging into it a bit, I noticed those xlsx files have set the attribute value of
hidden
totrue
instead of1
as some others. This caused the condition checking code here not filtering the hidden row out.Here is an example xlsx file attached which is exported from Lark docs (https://www.larksuite.com/en_us/product/creation?from=hero_section)
feishu_test_hidden_rows.xlsx
Here are the hidden row attributes from xlsx files exported from MS Excel and Google Docs:
Here are the hidden row attributes from xlsx files exported from larksuite:
Let me know if you'd like to include it. If yes, I'd be happy to raise a PR for it.
The text was updated successfully, but these errors were encountered: