I am converting CSV and Excel sheet file to C# datatable
The string “René” is converting to “Ren�” which is wrong.
Code
LoadOptions loadOptions = new LoadOptions(LoadFormat.Auto);
if (extension.ToLower().Contains(“csv”))
loadOptions = new LoadOptions(LoadFormat.CSV);
Workbook workbook = new Workbook(stream, loadOptions);
Worksheet worksheet = workbook.Worksheets[0];
var datatable = new DataTable()
if (extension.ToLower().Contains(“csv”))
dataTable = worksheet.Cells.ExportDataTable(0, 0, worksheet.Cells.Rows.Count, worksheet.Cells.MaxColumn + 1, options: new ExportTableOptions { ExportAsString = true });
else
dataTable = worksheet.Cells.ExportDataTable(0, 0, worksheet.Cells.Rows.Count, worksheet.Cells.MaxColumn + 1);
Thanks
Mahesh