Hello all,
Is it possible to translate the name of the columns on the generated document from "Record List to Excel"?
Example:If I have 2 columns like "Age" and "Name" as attributes in a Record List, what do I do when I export it in order to show "Age" and "Name" in another language of my choosing.
The documentation is not very clear on this aspect.
Thank you very much if you could enlighten me.
One possible way to achieve this, though I'd say it's not favorable, is to have a structure for each language you want to export for with its headers being written in the desired language.
For instance, using your example and assuming your current structure is:
You can create one for Portuguese like so:
After that, you'd have to use the GetCurrentLocale (in a Switch for example) to evaluate which language the user is using and from there choose the appropriate Structure on the RecordListToExcel.
Thank you Pedro
Your solution gets the job done for now, hopefully Outsystems will implement a native solution in the future.
Hello Rui,
I am not 100% positive but I think you will not be able to do this using the record list to Excel feature. You will more than likely need to use something like the Advanced Excel forge component and then translate the values manually as you fill in the worksheet.
https://www.outsystems.com/forge/component-overview/355/advanced-excel
I do hope to find out that I am incorrect and I will be watching this post for other suggestions.
Thank you for your reply Jeremy, I am also hoping for a native feature instead of a forge component.