[bug] Row info about visibility is missing #2486
Labels
No Label
DBF
Dates
Defined Names
Features
Formula
HTML
Images
Infrastructure
Integration
International
ODS
Operations
Performance
PivotTables
Pro
Protection
Read Bug
SSF
SYLK
Style
Write Bug
good first issue
No Milestone
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: sheetjs/sheetjs#2486
Loading…
Reference in New Issue
Block a user
No description provided.
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
I'm trying to migrate from PHPOffice/PhpSpreadsheet to this package. PhpSpreadsheet works fine with my xlsx file, while sheetjs gives no info about hidden rows. It's really important since my script needs to ignore hidden cells.
Mentioned file has been sent to email from the Contributing doc.
Package version:
"xlsx": "^0.17.4".
Pass the option
cellStyles: true
to read, then the!rows
property of the worksheet object will be populated. Each object corresponds to a row. Thehidden
property of each row will be set totrue
if hidden.Thanks, @SheetJSDev, it solves my problem.
It's not so obvious that row/column visibility stored in styles props and that it switched off by default. You should mention it in the main documentation. I was searching for an answer over there, but didn't find anything, so I've submitted an issue.
Feel free to submit a PR and change
docbits/54_shobject.md
Oh, I'm flattered. Seems like you didn't notice that I'm not native english speaker. I'm not the right person to write official docs if you have someone from USA/UK.
@reviewher @ybelenko Can I work on the documentation issue and submit a PR
@reviewher @ybelenko I submitted a PR