I want to save Excel file in CSV.
I make like that :
- Code: Select all
workbook.SaveToFile("...\file.csv", FileFormat.CSV);
But colums are separate with "," and i want ";" so i use that
- Code: Select all
workbook.SaveToFile("...\file.csv", ";");
Great, file.csv is separate with ";"
But... Excel don't read file.csv like a CSV, all lines of CSV are on first column on Excel, Separator is not interpreted.
Do you know why ?
Thanks