Table tools - csv export encoding

Table tools - csv export encoding

JosephJoseph Posts: 9Questions: 0Answers: 0
edited February 2013 in TableTools
Hi Allan,
I'm using datatables for a long time and it saves me a lot of time !

I've a question about table tools csv export :
Is there a way to export data in latin1 in order to open correctly the file in Excel (2003) ?
I tried this piece of code without the expecting result :

[code]
{
"sExtends": "csv",
"sButtonText": "",
"sToolTip": "Exporter au format csv",
"sTitle": "Mon titre",
"sFieldSeperator": ";",
"sCharSet": "latin1",
"mColumns": [ 0, 1, 2 ]
}
[/code]

I think the answer is in "sCharset" parameter, but I tried "iso88591", "latin1" and I open this file in Excel with bad encoding...

I would be great if you had a solution or a track !

I'm using tabletools 2.1.5 dev

Thank you,
Joseph

Replies

  • allanallan Posts: 63,680Questions: 1Answers: 10,498 Site admin
    Currently no - the only options are `UTF8` or `UTF16LE` . The 'latin' character sets are not supported by TableTools at this time, although they could be added by modifying the Flash file that creates the file (specifically look at the `clickHandler` method).

    Allan
  • JosephJoseph Posts: 9Questions: 0Answers: 0
    Ok, thanks for your quick reply !
    I'll have a look on the flash file.

    Joseph
This discussion has been closed.