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:
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!
Benjith Sam
Hi Benjith Sam,
I also want to implement the logic for customize columns order for export to excel but the structure which I am using is fixed. So, basically user will select the columns on the run time and based on the order selected, excel should have same orders of column.
Do you have any idea how we can implement the same?