Alasql: Is there a maximum limit for the data size?

Question

I try to load my xlsx file and it contains about 200,000 rows. When I use the code to load the file:

alasql.promise('SELECT * FROM XLSX("' + fileUrl + '")')
            .then(function (res) {console.log(res)});

It only show 65535 records of the arrays. What could I do if I want to load all data? Thank you!

Answer 1

Excel up to 2003 : an Excel worksheet is limited to 65535 lines.

In 2007: an Excel worksheet is limited to is 1,048,576 lines.

So I think you should try 2007 version.