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

Open
opened 5 years ago by sweeneyb · 0 comments
sweeneyb commented 5 years ago (Migrated from github.com)
Owner

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.
No Milestone
No project
No Assignees
1 Participants
Notifications
Due Date

No due date set.

Dependencies

No dependencies set.

Reference: sheetjs/sheetjs#1198
Loading…
There is no content yet.