294
Views
6
Comments
Solved
How do you download the record list using [Advanced Excel]?
Question

Hello, brothers in arms... 

How do you make a download button for downloading a record list in an excel format,for example download a "Customer list" in an excel file,  with using advanced excel? 

Could you please educate the dumb dumb me step by step ,please? 


Thank you.

2025-04-17 05-42-16
Ajit Kurane
Solution

Hi,

I have updated your oml please check it. I have used advance excel forge component as you mentioned above.

Demo link.

Customer2s (personal-xyog61l7.outsystemscloud.com) 

But without forge component also we can achieve that easily.

Thanks.

customerlist_Kim_Aj.oml
2025-06-28 01-52-12
Marco Mateo
Solution

No worries.

The "workbook" is the output of workbook_create action

you can check here for the advanceexcel documentation:

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

Since you are working in reactive, you can create a server action then do the download there.

2022-03-10 08-26-10
Cristian Angel Puma Villalva

Hi Seung Hwan Kim,


I understand what you need, so that you understand me better, could you share an example where you have a list and I implement the option to download in an excel file.


Regards!

2022-12-05 08-59-55
SeungHwan Kim

I would like to put a download button(record list download button using Advanced Excel component from Forge)  next to [AddCustomer2] button in [Customer2s] Screen. 

I hope you get what I mean. 

Thank you so much brother. 

customerlist.oml
2025-04-17 05-42-16
Ajit Kurane
Solution

Hi,

I have updated your oml please check it. I have used advance excel forge component as you mentioned above.

Demo link.

Customer2s (personal-xyog61l7.outsystemscloud.com) 

But without forge component also we can achieve that easily.

Thanks.

customerlist_Kim_Aj.oml
2025-06-28 01-52-12
Marco Mateo

Hi,

What app type are you working on ? reactive, traditional, mobile ? 

Yoou can use the recordtoexcel node in server actions then output the binary data


In advancedExcel, you can use the Workbook_GetBinaryData then use the download node

2022-12-05 08-59-55
SeungHwan Kim

I'm working on Reactive. 

What should I put in Workbook ? 

Appologies for such a basic question.

Thank you very much. 

2025-06-28 01-52-12
Marco Mateo
Solution

No worries.

The "workbook" is the output of workbook_create action

you can check here for the advanceexcel documentation:

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

Since you are working in reactive, you can create a server action then do the download there.

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