sheet_to_csv utility method doesn't respect hidden columns #755

New Issue

2017-08-02T08:34:09Z

the-spyke commented

2017-08-02 08:34:09 +00:00

(Migrated from github.com)

If sheet object contains hidden columns, I should not find them in the output of csv.

If sheet object contains hidden columns, I should not find them in the output of `csv`.

SheetJSDev commented

2017-08-02 14:46:23 +00:00

(Migrated from github.com)

Both Excel 2013 and Excel 2016 export hidden rows and columns in CSV (to test this, make a new file, set each cell in the range A1:C3, then hide column B and row 2 and save as CSV). It would probably make more sense to add that as an hidden option to the writer, keeping the default consistent with Excel.

Both Excel 2013 and Excel 2016 export hidden rows and columns in CSV (to test this, make a new file, set each cell in the range A1:C3, then hide column B and row 2 and save as CSV). It would probably make more sense to add that as an `hidden` option to the writer, keeping the default consistent with Excel.

Sign in to join this conversation.