Importing Excel from <input type="file"> error

[jplevene]

My code is simple:

Code: [Select]

$("#fileInput").change(function(e){
var file = e.target.files[0],
filename = file ? file.name.toLowerCase() : "";

if(file && (filename.endsWith("csv") || filename.endsWith("xlsx")))
{
pq.excel.importXl({ file:file }, function(wb) {
if(wb)
{
// Import the workbook
$("#grid")
.pqGrid("importWb", { workbook: wb, sheets:[0] });
}
});
}
});
I get the attached error from the line "pq.excel.importXl({ file:file }, function(wb) {"

Any ideas???

[paramvir]

The sheets parameter belongs to the importXl method, not importWb.

Please check if this resolves the error.

[jplevene]

I changed import Wb to importXl, but it made no difference because it doesn't get that far, it breaks before that on

Code: [Select]

pq.excel.importXl({ file:file }, function(wb) {
Unless I have misunderstood, please could you post the changes you mean.

[paramvir]

I meant:

Code: [Select]

pq.excel.importXl({ file:file, sheets: [0] }, function(wb) {

can you please share your spreadsheet as an attachment, you can email it to support if it's too big.

[jplevene]

I had already done that and it was left in the code above by accident.

Seet attached and I am still on v10.1.0

[paramvir]

Confirmed an issue with v10.1.0, please upgrade to v11.0.0 as the issue is fixed in the latest version.

[jplevene]

Please can you post a patch or a few lines of code fix for v10.1 as we haven't upgraded and tested v11 yet.