Exporting data from grid containing column in different language not getting exported properly.
When exporting showing in different value in csv.
please check below link :-
Export Data as csv from grid containing multiple language
I’m not sure. In my opinion, values were exported properly.
Could you show me what the wrong value is?
Please see the below screenshots of grid and excel
The grid has Chinese and Japanese languages.
In excel those language are showing as symbols.
@aleksandra_budnik Can you help me with this?
Ok. Maybe you should set the language in Excel.
Or you should set up a mimeType in settings exportFile plugin - https://handsontable.com/docs/7.4.2/demo-export-file.html
Will there be any affect in grid, as there are multiple languages and also how can we set a language?
Can you share an example for it and also with mimeType.
On our documentation, there is an Internationalization section - https://handsontable.com/docs/7.4.2/tutorial-internationalization.html?_ga=2.68202577.1539892143.1582534719-1051546746.1507722840#available-languages
We can only use one language for the table. It’s settings we set language.
Please look at this demo - https://jsfiddle.net/5z6mdrky/
To set the MIME type we don’t have to do anything other than to switch the computer language.
If you switch for example to Chinese you will have access to MIME while writing.