Perhaps allow us to specify the name of the column when exported, i.e. add a text field on each column that we can input an 'alias' for the column that when it gets exported.
As per the requirement we can change the header name ..
Create a structure having all the attribute with text type, and change the name of label as per your requirement, if you will export a record list using this structure it will export the label name not the name in excel.
Thanks
Rajendra Singh
RecordListToExcel should be able to translate the column names of the Excel header.
We can translate the labels of a structure attribute but this does not have impact on the RecordListToExcel action output.
Carlos, what's your use case for translating the column names?
our use-case: export (without having to import them later on)
J., so you want to translate the column names on Export, to have them match the current locale? Or in practice you want to always customize the names?
The column names should get the mapping like other stuff in the system does, in my opinion.
J.Ja
Hi Paulo,
We have multi language applications (english, portuguese and spanish), and many of them have export to excel actions near a TableRecord.
Table headers are translated, but when the user exports to excel, the excel header is always in english, the default language used for the label attributes of entities and structures).
It's strange for the user to see all the application translated to his language, but when exporting data to excel getting some parts in another language. It's not coherent.
The weirdest thing is that we can translate structure attribute labels on Language Resources, but with no visible impact, since the RecordListToExcel does not use them.
Yeah, it's really strange this doesn't work. I'd consider it a bug even...
Please add this simple feature to change column header and order.
Current workaround is creating a Structure, mapping fields to Structure and exporting it. This keeps the order and header name.
Andrew,
That would be a different Idea, this Idea is about translation only.
Especially in cases where a list has multiple tables in it, it would be very nice to be able to A) control the name shown on the column in the excel export and B) easier way to edit the order of these columns. As it is now, you don't have much ability to edit the name of the column which can become very confusing to our users when they try to decipher the excel sheet.
This has been requested a number of times in other ideas. :(
Along with the name, below two options will be really useful
1. Option to specify column order
2. Like aggregate, option to add custom calculated attribute