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

How to skip header or first row? #113

Closed gokujy closed 1 year ago

gokujy commented 1 year ago

I have an Excel file with a header and a second row in the sub-header. Now I want to skip the header row and read from the subheader. Is there any way to skip the header row?

gokujy commented 1 year ago

image I have an Excel file view like this.

and I skip the first row by using this:

readXlsxFile(env.inputFile[0], {map, transformData(data) { return data.filter(row => row[0] !== 'Order Details') } }).then(async (rows) => { console.log('readXlsxFile rows ', rows); })