Maintaining the cells currency format during the export to an Excel file. #2886

New Issue

Goliath · 2023-02-16T20:31:55Z

Goliath commented

2023-02-16 20:31:55 +00:00

I have this code that exports my table to an Excel file:

const SHEET = XLSX.utils.table_to_sheet(tableElement, {
	'raw': false,
	'cellNF': true
});

In my table, I have cells with this value:

$887,112.00

So I can export the currency as an actual number on the Excel file, but lost the currency sign. How would I set the maintain currency format in the export without tweaking any of the table cell's attributes?

I have this code that exports my table to an Excel file: ``` const SHEET = XLSX.utils.table_to_sheet(tableElement, { 'raw': false, 'cellNF': true }); ``` In my table, I have cells with this value: $887,112.00 So I can export the currency as an actual number on the Excel file, but lost the currency sign. How would I set the maintain currency format in the export without tweaking any of the table cell's attributes?

sheetjs commented

2023-04-05 17:38:29 +00:00

If you can't tweak, you can read with raw: true and try to parse the individual text entries. We will investigate more robust value parsing.

If you can tweak, https://docs.sheetjs.com/docs/api/utilities#value-override

For your example:

<td data-t="n" data-v="887112.00" data-z="$#,##0.00">$887,112.00</td>

If you can't tweak, you can read with `raw: true` and try to parse the individual text entries. We will investigate more robust value parsing. If you can tweak, https://docs.sheetjs.com/docs/api/utilities#value-override For your example: ```html <td data-t="n" data-v="887112.00" data-z="$#,##0.00">$887,112.00</td> ```

Sign in to join this conversation.