136
Views
6
Comments
How to add custom header title in Export excel -Reactive
Question
Application Type
Reactive

Hi,

How to add customer header title in excel.


Have to add a Title as "Project care" above 1st row.



Thanks

Saravana

2023-04-06 11-24-23
Paulo Zacarias

Hi KCS, 

Did you check this forge component: 

https://www.outsystems.com/forge/component-overview/355/advanced-excel

I suggest you invest some time studying the AdvancedExcel component and you will be able to build customized Excel files. 

Someone had the same doubt here in this post:

https://www.outsystems.com/forums/discussion/70741/dynamic-header-for-excel-text-file/

Regards, 

PZ



2023-01-26 16-03-24
Ana Agostinho

Hello K C S, 

Okay, to do that (one way of solving this), you can create an AUX structure with the attributes you want to export. The labels of that attributes can be whatever you want (so you can customize the name/label of the first attribute). 

So, you retrieve the data you want to export and then you assign that data to the local variable that has the type the structure you created before (in this case List of the structure created). And then you do the export of that local variable. 

Like this: (example case)




Best regards, 

Ana

2022-10-12 15-20-13
K C S

Hi Ana,

Thank you.  But I tried this already. Getting below like this


This heading should be in Row 1. remaining data should come under title.


Thanks

Saravana 

2023-01-26 16-03-24
Ana Agostinho

Hello again K C S, 

Check this example file :) 

Best regards, 

Ana

export.oap
2022-10-12 15-20-13
K C S

Hay Ana,

Thanks. But this also I'm getting values in the column. Like below.


2020-04-17 08-41-30
Tim Timperman

If you want a title above row 1, you'll need to revert to forge components like the one Paulo suggested. It cannot be achieved with the default RecordListToExcel.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.