Skip to Content (Press Enter)
Back to Ideas
6
Like
Follow Idea
Record List to Excel need to have facility to change header
138Views
4Comments
New
Frontend (App Interfaces)

Change in the 'Record List to Excel ' needed:

When we export any entity data to excel, 'Record List To Excel' widget is used.

This widget has attribute selection section. Entity names of these selection becomes the header of the attribute column.

If we see, most of the time excel we need more meaningful name to columns.

For example: In above image Attribute 'SelectedEmployee.Id' header may not make sence to business user. It one gets change to change header name may be with third field. It will be more helpful. 

In our case it could be third column which can help us to type name as 'Employee Id' instead of  'SelectedEmployee.Id' 



28 Jun 2024
Copy link to comment

I liked your idea, it would be nice to be able to do this.

Here's a workaround, though :

add calculated attributes to your aggregate, where you do the translation from the attribute to the name you want in the excel

now you can see those pop up in your RecordListToExcel widget

and here they are

Dorine


28 Jun 2024
Copy link to comment

If you need anything fancier, like being able to add spaces in the headers, you can always use the Advanced Excel Forge component.

Just keep all your code as is, using the RecordListToExcel to make your excel binary, then use advanced Excel to just open it and change the headers.

Dorine

28 Jun 2024
Copy link to comment

Thanks,

Dorine.


28 Jun 2024
Copy link to comment

Hi all,

Another (simpler) way of accomplishing that is creating a structure with all the attributes needed to export and, in each one, setting the desired header name in the Label attribute. Then, when the Excel file is created, the platform grabs those Labels and uses them to name the columns. So, there's no need to use a Forge component.

Regards.

01 Jul 2024
Copy link to comment