How to add list records to Advance Excel(forge)

I want to add list records to Advanced Excel(forge) sheet

Hi NaveenRaj, can you clarify, do you want to export a list of records to an Excel sheet?

Innovating in Insurance wrote:

Hi NaveenRaj, can you clarify, do you want to export a list of records to an Excel sheet?

 Yes, I want to export list of records to an Excel sheet. But i need to change Excel sheet column names dynamically. I have one structure, it contains attributes like Column1,Column2...Column10. I am able to export data, but i want to keep dynamic column names. Thats my requirement. Kindly find the attachment.

 

Hi Naveen,

You can create the dynamic columns by using the Cell_Write action of the Advance Excel component and also you can use Cell_writeRange as well for more information please refer the demo attached( Try Now link.) with the component that helped me a lot to create a Dynamic Excel sheet

Hope that will give you more understanding

Regards,

Krushna

Hi NaveenRaj,

You can first use the Record List To Excel action from OutSystems. After that you can use Workbook_Open_BinaryData of Advanced Excel to use that Excel binary and change the fields you want.

Regards,
Lennart