search

catamphetamine / read-excel-file

Read *.xlsx files in a browser or Node.js. Parse to JSON with a strict schema.
https://catamphetamine.gitlab.io/read-excel-file/
MIT License
301 stars 52 forks source link

Read Row & Column Data #56

Closed DoraTheCodeExplorer-1337 closed 5 years ago

DoraTheCodeExplorer-1337 commented 5 years ago

Hello,

How do you read the column data from a specific cell. I want to get all the cells that start with ABC. I then want to get each of their column data. For example there might be cells: ABC3943, ABC9438, ABC1823. How do i pass this through the schema and get there data?

catamphetamine commented 5 years ago

Hi. There's no such possibility in this library. For reading cell-by-cell you can use any other library like xlsx. https://github.com/catamphetamine/read-excel-file/issues/38#issuecomment-544286628

DoraTheCodeExplorer-1337 commented 5 years ago

So i cannot read individual cells rows? OK thank you :D

bigabdoul commented 4 years ago

Hello,

How do you read the column data from a specific cell. I want to get all the cells that start with ABC. I then want to get each of their column data. For example there might be cells: ABC3943, ABC9438, ABC1823. How do i pass this through the schema and get there data?

Try out https://www.npmjs.com/package/fast-xlsx-reader