Can we read data Column Wise in XLSX File using SheetJs? #1729
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#1729
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?
Data is stored row-wise in most formats (Some of the older formats are column-wise but all contemporary formats are row-wise).
You can convert a worksheet to an array of arrays using
sheet_to_json
with the optionheader:1
and transpose it for column-wise access. See https://github.com/SheetJS/sheetjs/issues/1085#issuecomment-384472147 for an example:Thanks a lot for the response!! , transpose solution works great! Earlier I tried iterating through column first and then in the inner loop for rows, so it also worked out.