french language issues.

[sakthi1992]

i'm facing french language issues

var res = alasql('SELECT market as "Marché", label_number as [numéro d'Etiquette]  INTO XLSX("' + file_title + '.xlsx",?) FROM ?', [opts, [data1]]); //XLSX

the french language not supported. its returns only error

thanks
sakthikumar

[mathiasrw]

Are you sure its not the ' added in the name?

[sakthi1992]

yes i'm sure. ( ' ) definitely needed. bcoz its a french language need to excel column names.

[noid2]

Just escape it => [numéro d\'Etiquette]

[sakthi1992]

We Can't Understand.

[noid2]

try this:

var res = alasql('SELECT market as "Marché", label_number as [numéro d\'Etiquette] INTO XLSX("' + file_title + '.xlsx",?) FROM ?', [opts, [data1]]);

[sakthi1992]

This also not working.
"numéro d\'Etiquette"

var res = alasql('SELECT market as "Marché", label_number as [numéro d\'Etiquette] INTO XLSX("' + file_title + '.xlsx",?) FROM ?', [opts, [data1]]);

still error comes.

[mathiasrw]

You are right. ' is not supported in row names. Sorry about that.

PRs welcome.