I want to customize the table header order for excel export

I want to customize the excel file order. If anybody knows the solution, Please help me. And if you give any examples then it helps a lot.

 

Hello Densingh,


Could you please provide more info for your query. Your requirement is not clear.


Thanks,

Sanjay

Sanjay Kumar Sahu wrote:

Hello Densingh,


Could you please provide more info for your query. Your requirement is not clear.


Thanks,

Sanjay

 Hi Sanjay Kumar Sahu,

 As per the above image, I am specifying the column, But how to specify the order of the column.

I want deal status as the first column in excel export.

Hi,

I believe the order is based on the order of the attributes in the structure or record structure.

Regards,

Daniel

I am exporting an excel sheet based on the aggregate. I don't know how it is generating the order of column.

Hi Densingh,

See this  sample app - ExportToExcelDemo


Follow the below mentioned Steps

1) Define a structure with all the selected attributes with an Order based on your requirement

2) Define a structure List type local variable within the action/screen scope

3) Before the RecordListToExcel  node, List Append All the record from the Aggregate List to the Local List type variable

4) Map the Local List variable to the RecordListToExcel node 

5) Check mark the (All Attributes) option in the RecordListToExcel action flow node 

Refer the attached .oml file


Hope this helps you!


Regards,

Benjith Sam