New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Hidden columns and rows #588
Comments
@pascaldls we just pushed a change, to show up in the next release, that will expose
If you are wondering why the expression looks convoluted, the rows and cols arrays are only generated if the file specifies any row or column metadata. If the given row/column uses the default size and is visible, there will be no object for the corresponding row. The relevant docs: |
Hi @SheetJSDev - please can you advise if the change is in v0.10.1 ? |
@robinmackenzie it landed in 0.9.13, so yes :) On the read side, set the option On the write side, add a // to hide row R
if(!worksheet['!rows']) worksheet['!rows'] = [];
if(!worksheet['!rows'][R]) worksheet['!rows'][R] = {};
worksheet['!rows'][R].hidden = true;
// to hide col C
if(!worksheet['!cols']) worksheet['!cols'] = [];
if(!worksheet['!cols'][C]) worksheet['!cols'][C] = {};
worksheet['!cols'][C].hidden = true; |
@SheetJSDev - I was missing the cellStyles option when reading the book. The expressions note above are now returning the expected values. Thanks very much - much appreciated. |
I've use below code:
But the |
Hi, not sure if opening another issue or updating this one. |
Hi is there any way i could exclude hidden columns and rows from a workbook.
If options not available is there any way i could know if columns or row is hidden in the workbook.
Thanks for taking the time.
The text was updated successfully, but these errors were encountered: