Specify European Currency Column #2827

New Issue

jazib17 · 2022-11-14T09:29:05Z

jazib17 commented

2022-11-14 09:29:05 +00:00

I am trying to generate an excel file in which a column should be treated as currency.
Now how can I specify column as European currency? Like European currency contains comma instead of decimal.
Example: 533.6 should be treated as 533,6

I am trying to generate an excel file in which a column should be treated as currency. Now how can I specify column as European currency? Like European currency contains comma instead of decimal. Example: 533.6 should be treated as 533,6

sheetjs commented

2022-11-14 10:43:37 +00:00

Thousands separator and decimal symbol are system settings. When exporting, use the normal en-US style (e.g. #,##0 or #,##0.00) and Excel automatically interprets the format using the regional settings. You can actually experiment by changing your system separators and watching Excel use the new settings.

Unfortunately the Excel formats have no way of marking the regional settings of the computer that last saved the file.

Thousands separator and decimal symbol are system settings. When exporting, use the normal en-US style (e.g. `#,##0` or `#,##0.00`) and Excel automatically interprets the format using the regional settings. You can actually experiment by changing your system separators and watching Excel use the new settings. Unfortunately the Excel formats have no way of marking the regional settings of the computer that last saved the file.

sheetjs closed this issue

2022-11-14 10:43:37 +00:00

jazib17 reopened this issue

2022-11-14 11:17:13 +00:00

jazib17 commented

2022-11-14 11:18:14 +00:00

Kindly tell me where do I specify the currency format for the column?

  exportexcel(): void {
    /* pass here the table id */
    const element = document.getElementById('excel-table');
    const ws: XLSX.WorkSheet = XLSX.utils.table_to_sheet(element, {dateNF: 'dd/mm/yyyy;@', cellDates: true, raw: true});

    /* generate workbook and add the worksheet */
    const wb: XLSX.WorkBook = XLSX.utils.book_new();
    XLSX.utils.book_append_sheet(wb, ws, 'Sheet1');

    /* save to file */
    XLSX.writeFile(wb, this.fileName);

  }

Kindly tell me where do I specify the currency format for the column? ``` exportexcel(): void { /* pass here the table id */ const element = document.getElementById('excel-table'); const ws: XLSX.WorkSheet = XLSX.utils.table_to_sheet(element, {dateNF: 'dd/mm/yyyy;@', cellDates: true, raw: true}); /* generate workbook and add the worksheet */ const wb: XLSX.WorkBook = XLSX.utils.book_new(); XLSX.utils.book_append_sheet(wb, ws, 'Sheet1'); /* save to file */ XLSX.writeFile(wb, this.fileName); } ```

sheetjs commented

2022-11-14 19:31:55 +00:00

Remove raw: true. https://docs.sheetjs.com/docs/api/utilities#html-table-input -- for HTML tables, raw keeps the raw HTML strings while the default tries to parse values

Remove `raw: true`. https://docs.sheetjs.com/docs/api/utilities#html-table-input -- for HTML tables, `raw` keeps the raw HTML strings while the default tries to parse values

Sign in to join this conversation.