Alasql: Exported xls file shows warning in Microsoft Excel

[harikrishnanp]

When I open the exported xls file in Microsoft Excel it shows this warning "Excel found unreadable content in *.xls. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click yes" . If I click yes , it shows the content correctly. But the warning is really annoying for users. Please resolve.

[mathiasrw]

Interesting.

Would it be possible for you to provide an example generateing a file that gives this alert?

[harikrishnanp]

Yes. I can. Please hold on.

[harikrishnanp]

I have emailed you the document. I'm getting this error "Attaching documents requires write permission to this repository" when I tried to attach.

[mathiasrw]

Its best if you put put the code to generate the problem file here on github.

[mathiasrw]

@harikrishnanp

Hvae you had time to look at what code generates the problem files?

[harikrishnanp]

Please find the sample code that will generate the above error.

var data = [{city:"Minsk",population:100000}, {city:"Riga",population:200000}];

window.exportData = function () {
alasql("SELECT * INTO XLSX('cities.xlsx',{headers:true}) FROM ? ",[data]);
}

JSFIDDLE

[mathiasrw]

Great thanks !

Update: Even a JSFIDDLE - perfect - thanks...

[mathiasrw]

You are just using an old version of AlaSQL

Please use http://cdn.jsdelivr.net/alasql/0.2/alasql.min.js as in this jsfiddle: http://jsfiddle.net/0xgfjcre/51/

[harikrishnanp]

https://cdnjs.cloudflare.com/ajax/libs/alasql/0.2/alasql.min.js is 404

[harikrishnanp]

It's https://cdn.jsdelivr.net/alasql/0.2.1/alasql.min.js

[mathiasrw]

Sorry for that - I posted wrongly first - hoped I had time to correct it before you saw it :)

[rupendra-sharma07]

Did it solved the issue? I am using the suggested version but still getting the same warning message while trying to open the exported excel?

[mathiasrw]

We have not found a solution yet.

[kingsbury]

@mathiasrw your last fiddle worked fine for me in Chrome, no alert generated in Excel 2010.

[mathiasrw]

Oh... thanks @kingsbury - I might got confused about the issues

@rupendra-sharma07 could you try http://jsfiddle.net/0xgfjcre/51/ and see if you get an error in excel? It should work...

[harikrishnanp]

My issue was fixed by updating AlaSQL.

[RAFBOUK]

Hello every body,
I have the same problem when i try to open the export ==>
alasql( 'SELECT * INTO XLS("' + exportFileName + '.xls",?) FROM ?',[ opts, data] );
and when I use this second request alasql( 'SELECT * INTO XLSX("' + exportFileName + '.xlsx",?) FROM ?',[ opts, data] ); I don't have the warning but i can't include styles inside xlsx file, I think it's normal because in the alasql's documentation they use the request without any "opts" just like this (alasql( 'SELECT * INTO XLSX("' + exportFileName + '.xlsx",?) FROM ?',[data] );),
My question is : how can I export excel file from json with ALASQL without the warning message when I try to open it and, I mustto include some styles inside the file ?
thx in advance for your responses

[mathiasrw]

@RAFBOUK Please open 2 new issues with one question in each

[juni103]

I have the same issue as @RAFBOUK . did anyone found solution?

[mathiasrw]

@juni103 Please open a new issue on this.

[starrybleu]

For future readers,
I also met this issue. But the problem was my null value which would be cell value.

For example,

const data = [{city:"Minsk",population:100000}, {city:"Riga",population:200000}]; will be fine.

However,

const data = [{city:"Minsk",population:100000}, {city:"Riga",population: null}]; will cause this problem again.

Additionally, undefined is ok.

[clough1]

Hello @mathiasrw. I have to upgrade the alasql/xlsx versions. I am now on the latest version of alasql (0.4.11) and xlxs (0.7.12). When I download and open the excel file I get the error:

We found a problem with some content in 'test_data.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.

I do have some rows of data with "null". This wasn't an issue in my previous alasql version 0.4.0. Is there a solution for this?

[mathiasrw]

We have not found a way to solve this. Its because we are not Microsoft and its warning that some other party (you) made the file.

If you just click "yes" its all gonna work.

[pedrozan]

Hi @mathiasrw. Is there any news about this problem?

[mathiasrw]

Nope.