I am using Q1 2014 telerik controls and i am having a problem in exporting my report to CSV format.
As my exporting language is 'Thai' but after exporting it is giving me garbage values. Please find the attachment to have a clear look.
Previously I don't have this issue in Q1 2012 telerik controls. As i was using the telerik reports but with previous version(Q1 2012).
I'm using WPF application to export report into CSV, Report have been created from Telerik reporting.
Cheers;
Nabeel Shahzad Chishti
As my exporting language is 'Thai' but after exporting it is giving me garbage values. Please find the attachment to have a clear look.
Previously I don't have this issue in Q1 2012 telerik controls. As i was using the telerik reports but with previous version(Q1 2012).
I'm using WPF application to export report into CSV, Report have been created from Telerik reporting.
Cheers;
Nabeel Shahzad Chishti
1 Answer, 1 is accepted
0
Hi Sajid,
We've already answered your inquiry in the other support thread #822542 you've opened, but we will share some parts of the answer here as well for anyone concerned.
We would like to kindly ask you to use just one support channel to contact us. Posting the same questions numerous times slows down our response time because we will need to review and address two threads instead of one.
Thank you for your understanding.
Now to your question:
Due to popular demand, in Q3 2013 we have added the option to choose which encoding to be used and whether or not to include the BOM (Byte Order marks) when exporting to CSV. The default behavior produces a file, saved using the UTF-8 encoding without BOM. The most text editors (MS Word, Notepad, Notepad++, Visual Studio, etc.) open such a file without any problems. However, some versions of Microsoft Excel treats the CSV files as ANSI-encoded by default, which causes the incorrect display of the text. You can read more about this behavior in the following forum thread, where are suggested a few workarounds:
Is it possible to force Excel recognize UTF-8 CSV files automatically?
If your scenario allows it, you can export your report programmatically, as explained in this documentation article:
Exporting Report Programmatically
If you want to export your report, explicitly setting its encoding, you have to set the desired code page as a value of the Encoding parameter of the Device Information Settings instance. The full list of supported code page identifiers is available here.
Regards,
Ivan Hristov
Telerik
We've already answered your inquiry in the other support thread #822542 you've opened, but we will share some parts of the answer here as well for anyone concerned.
We would like to kindly ask you to use just one support channel to contact us. Posting the same questions numerous times slows down our response time because we will need to review and address two threads instead of one.
Thank you for your understanding.
Now to your question:
Due to popular demand, in Q3 2013 we have added the option to choose which encoding to be used and whether or not to include the BOM (Byte Order marks) when exporting to CSV. The default behavior produces a file, saved using the UTF-8 encoding without BOM. The most text editors (MS Word, Notepad, Notepad++, Visual Studio, etc.) open such a file without any problems. However, some versions of Microsoft Excel treats the CSV files as ANSI-encoded by default, which causes the incorrect display of the text. You can read more about this behavior in the following forum thread, where are suggested a few workarounds:
Is it possible to force Excel recognize UTF-8 CSV files automatically?
If your scenario allows it, you can export your report programmatically, as explained in this documentation article:
Exporting Report Programmatically
If you want to export your report, explicitly setting its encoding, you have to set the desired code page as a value of the Encoding parameter of the Device Information Settings instance. The full list of supported code page identifiers is available here.
Regards,
Ivan Hristov
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.