sheet_to_html doesn't honor hidden flag on row or column #1198

New Issue

2018-07-28T16:09:46Z

sweeneyb commented

2018-07-28 16:09:46 +00:00

(Migrated from github.com)

I have a use case where I want to present a subset of columns to a user. The easiest way would be to augment my in-memory sheet with something like:

sheet['!cols'] = [];
  sheet['!cols'][1] = {
    hidden: true
  };

It looks like the sheet_to_csv honors that via an option, but the support just isn't there in the sheet_to_html. It seems like an easy enough feature to add, but I'd be grateful for confirmation this is the correct approach and the feature doesn't exist before diving in.

I think it's as simple as making a check at https://github.com/SheetJS/js-xlsx/blob/master/xlsx.js#L18140 against the options array and ws['!cols'][C].hidden, right?

I have a use case where I want to present a subset of columns to a user. The easiest way would be to augment my in-memory sheet with something like: ``` sheet['!cols'] = []; sheet['!cols'][1] = { hidden: true }; ``` It looks like the sheet_to_csv honors that via an option, but the support just isn't there in the sheet_to_html. It seems like an easy enough feature to add, but I'd be grateful for confirmation this is the correct approach and the feature doesn't exist before diving in. I think it's as simple as making a check at https://github.com/SheetJS/js-xlsx/blob/master/xlsx.js#L18140 against the options array and ws['!cols'][C].hidden, right?

Sign in to join this conversation.