CSV writefile delimiter change based on region #2923

New Issue

MrShaneH · 2023-04-18T22:28:37Z

MrShaneH commented

2023-04-18 22:28:37 +00:00

My app has a basic "export to CSV" feature that takes users data in JSON format from an API endpoint and writes to an export.csv file.

const worksheet = utils.json_to_sheet(jsonData, { cellDates: true });
const workbook = utils.book_new();
utils.book_append_sheet(workbook, worksheet, "data");
writeFile(workbook, 'export.csv', { bookType: 'csv' })

This works well for users in regions where the delimiter is a comma.
However some users are in regions where the comma is used as the decimal in price information e.g. €5,78 and there the delimiter is the semicolon.

Is this handled natively by, say, using browser detection or should I do the detection in code and use utils.sheet_to_csv setting FS value manually?

Thanks

My app has a basic "export to CSV" feature that takes users data in JSON format from an API endpoint and writes to an export.csv file. ``` const worksheet = utils.json_to_sheet(jsonData, { cellDates: true }); const workbook = utils.book_new(); utils.book_append_sheet(workbook, worksheet, "data"); writeFile(workbook, 'export.csv', { bookType: 'csv' }) ``` This works well for users in regions where the delimiter is a comma. However some users are in regions where the comma is used as the decimal in price information e.g. €5,78 and there the delimiter is the semicolon. Is this handled natively by, say, using browser detection or should I do the detection in code and use utils.sheet_to_csv setting FS value manually? Thanks

sheetjs commented

2023-04-18 22:48:49 +00:00

Currently there is no logic for auto-detecting the user locale settings. This is feasible and is planned before our 1.0 release.

Sign in to join this conversation.