XLSX.utils.sheet_to_json: Option to ignore hidden rows/columns #1280

New Issue

2018-09-20T06:12:26Z

jlouie commented

2018-09-20 06:12:26 +00:00

(Migrated from github.com)

Is there an option that can be set to ignore hidden rows or cells when using the XLSX.utils.sheet_to_json method?

I have an Excel spreadsheet that has hidden rows and calling XLSX.utils.sheet_to_json returns all the rows (great!) but it would be equally great to have an option to ignore hidden rows similar to the display: true option for XLSX.utils.table_to_sheet.

Is there an option that can be set to ignore hidden rows or cells when using the `XLSX.utils.sheet_to_json` method? I have an Excel spreadsheet that has hidden rows and calling `XLSX.utils.sheet_to_json` returns all the rows (great!) but it would be equally great to have an option to ignore hidden rows similar to the `display: true` option for `XLSX.utils.table_to_sheet`.

👍 12

leoclipet commented

2020-03-27 17:06:59 +00:00

(Migrated from github.com)

Any news on that?

imir-hoxha commented

2020-04-21 14:53:14 +00:00

(Migrated from github.com)

any solution for this?

reviewher commented

2022-03-12 00:26:47 +00:00

(Migrated from github.com)