Goal: We have table with currency format columns, want to export to CSV with exactly same data & format including currency symbol & number format.
Details: We want to export table data as it is to CSV. we are able to export data using utils.export.
However currency code (we want currency symbol like $ ) &
Screenshots:
on Browser (what we want in export)
-In exported CSV (symbols are missing)
In export currency symbol & number format are missing.
Hi @Arvind and welcome to the forum!
I may be completely wrong here, but I think the only way to do this would be transforming your values from integers to string, with both thousands separators and decimals (if any) and add th ecurrency values.
This though would not be ideal for an excel file as you won't be able to do any other operation you would normally do, e.g. sums, tables, charts, etc.
However, one alternative is to download an excel file and you can set the columns up so that the formatting is currency values. This would ensure your cells are still integer values BUT with the actual format of currency.
Would that work for your use case?
hi @MiguelOrtiz Thanks for help.
However, basically we want export exact copy of table displayed on UI.
As alternative, we have built custom logic which is fulfilling our requirement.
However it will be good to include such export functionality in retool which will include currency & format in export as displayed on UI.
