I have the following configuration to parse excel to json,which works fine in general:
const reader = require('xlsx');
let Data = [];
Data.push(reader.utils.sheet_to_json(
file.Sheets[file.SheetNames[0]]))
However, If have an excel with 7000 rows. I deleted the values in all but one row for test (there is styling in empty rows such as borders and colors but no values). When parsing, sheetjs still attempts to parse all of 7000 rows for some reason.
How to avoid this and parse only rows that have values in it or avoid pushing such json to Data array ?
see blankrows option
try:
Data.push(reader.utils.sheet_to_json(
file.Sheets[file.SheetNames[0]]), {
blankrows: false
})