ReactJS - How to skip empty rows in excel while reading with xlsx

Question

I'm successfully reading my Excel file in React by following this SO thread as.

    var reader = new FileReader();
    reader.onload = function (e) {
        var data = e.target.result;
        let readedData = XLSX.read(data, {type: 'binary'});
        const wsname = readedData.SheetNames[0];
        const ws = readedData.Sheets[wsname];

        /* Converts a worksheet object to an array of JSON objects*/ 
        const parsedData = XLSX.utils.sheet_to_json(ws, {header:1});
        console.log(parsedData);
    }
    reader.readAsBinaryString(fileName)

But having a simple problem, i.e., it's reading empty rows as well and causing empty entries in array. Output of console.log(parsedData); in the above code is

I know a quick hack is to remove empty entries from the array but I want to know a better approach to avoid this problem even happening.

Abhishek Kaushik · Accepted Answer · 2021-11-20 22:27:23Z

3

Edit - It's "blankrows" and not "blankRows"

I did a search and came across a similar question on gitmemory here, which shows that there's a blankRows property you can set to false in order to skip blank rows, which would look like this with your implementation:

/* Converts a worksheet object to an array of JSON objects*/ 
const parsedData = XLSX.utils.sheet_to_json(ws, {
    header:1,
    blankrows: false
});

edited Nov 20, 2021 at 22:27

Abhishek Kaushik

1172 silver badges11 bronze badges

answered Sep 9, 2020 at 8:38

lh-22

562 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ReactJS - How to skip empty rows in excel while reading with xlsx

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related