Skip to Content (Press Enter)
UserImage.jpg
Sello Mamorobela
139Views
7Comments
Dynamically create column header values
Question
Hi,

Is there a way to specify the column header text dynamically on the export to excel in outsystems?
0
0
23 Sep 2015
Copy Link
2012-05-13 15-00-39
Sérgio Gonçalves
Hi Sello,

With RecordListToExcel, no.
Building a csv file by yourself, yes. Do you know how to do?


0
0
23 Sep 2015
Copy Link
UserImage.jpg
Sello Mamorobela
Hi Sergio,

Thats actually what I am trying to achieve, I dont know how to create the csv file...
0
0
23 Sep 2015
Copy Link
2018-11-06 14-26-44
Suraj Borade
Hi Sello,

There is one component in forge called CSV. Download that extension and use it in your Service Studio.

https://www.outsystems.com/forge/component/23/csv/

This converts any recordlist into csv file. 

Thanks,
Suraj
0
0
23 Sep 2015
Copy Link
2012-05-13 15-00-39
Sérgio Gonçalves
You need to concatenate all the data into a string variable (columns separated by ";" and rows separated by NewLine() function. The first line is for header and after you put the rows iteratively).

At the end, you convert the string content to binary and you use the Download widget to get the Excel file what you want.
 
0
0
23 Sep 2015
Copy Link
UserImage.jpg
Sello Mamorobela
Hi Suraj,

I want to specify the column headers dynamically, does this component allow that?
0
0
23 Sep 2015
Copy Link
UserImage.jpg
Sello Mamorobela
Okay Thanks Sergio, Ill try that.
0
0
23 Sep 2015
Copy Link
2018-11-06 14-26-44
Suraj Borade
Hi Sello,

This component allow conversion of values to CSV file which you pass through RecordList.

In order to understand your problem I would like to know that how you are generating columns dynamically. Are you using Advance query or Aggregates?
0
0
23 Sep 2015
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.