readXlsxFile not reading blank rows
I am trying to read an xlsx file that has many subsheets in it. Each subsheet has few empty rows between header and actual data. I want to get the row count but unable to get the exact value as it is not counting the blank rows.
So, there should be a provision to either take into account the blank rows or skip a range of rows.
const rows = await readXlsxFile(this.state.selectedFile, { sheet: sheetName }); console.log("rows", rows.length);
Edited by Amarjeet Pati