I need to read only visible rows from an excel file. Now I am getting with all rows in excel file while using the following code.
let fileReader = new FileReader(); fileReader.readAsBinaryString(selectedFile); fileReader.onload = (event) => { let data = event.target.result; let workbook = XLSX.read(data, { type: "binary" }); let rowObject = XLSX.utils.sheet_to_row_object_array(workbook.Sheets[workbook.SheetNames[j]]);
2.1m questions
2.1m answers
60 comments
57.0k users