Encoding when importing with CsvFormatProvider

[Daniel]

Hi

In the documentation for CsvFormatProvider (https://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/formats-and-conversion/csv/settings) it is decribed that you can use Settings.Encoding to set the encoding when exporting.

How does it work when importing a file? Does CsvFormatProvider automatically detect the encoding of the provided file? Or do I need to ensure that files that I import always have a certain encoding?

 

Thanks!

[Tanya]

Hi Daniel,

When importing, CsvFormatProvider uses the encoding that is specified in the Settings. If the Encoding property is not set by the user, UTF8 with BOM is used as the encoding used by default in MS Excel. 

I have also updated the documentation about the Encoding property to include the information about the import scenario as well.

Please, let us know if you have any further questions.

Regards,
Tanya
Progress Telerik