| ▲ | 1wd 4 days ago | |
Only if the Windows Regional Settings List Separators happens to be "comma", which is not the case in most of Europe (even in regions that use the decimal point) so only CSV files with SEP=, as the first line work reliably with Excel. | ||
| ▲ | john_the_writer 4 days ago | parent | next [-] | |
Literally did this all day today. Took a csv file, parsed it in elixir, processed it and created a new csv file, then opened that in excel, to confirm the changes. At least 100 times today. | ||
| ▲ | curioussquirrel 3 days ago | parent | prev [-] | |
This, plus the parser in Excel gets thrown off by some multiline edge cases very easily. Also, the file has to be UTF-8-BOM, not just UTF-8. | ||