Hi ,
Can anyone from the asset team help me out for below mentioned use case. @Amit @Piyali
I wanted to download the data from two different entities in one single Excel worksheet one after another with data and headers from both the table. How we can achieve this?
Thanks in Advance!!!
Hi Rohan,
You can use this Forge component for it:
https://www.outsystems.com/forge/component-overview/355/advanced-excel-o11
It also has a demo app, with a lot of code examples to get you started:
https://www.outsystems.com/forge/component-overview/15273/advanced-excel-demo-o11
-- Daniel
@Amit Verma , @Piyali Saha Please let me know how we can achieve this use case.
Hi @Rohan Hanumante
We will check and get back to you :)
Please check this Demo
Hello @Rohan Hanumante,
As per your usecase I have created a demo. Please refer the MultipleEntityExport screen.
I have attached the demo oml below.
Please let me know if you require more assistance.
Best Regards,
Piyali Saha
Hi @Piyali Saha ,
Thank you for sharing the information.
But in my use case I want to export the data in the same worksheet one after another.
In both the tables have around 20 columns so, also not feasible to use cell_write.
Hello,
Kindly switch to EmployeeDetail sheet of downloaded excel. You will see the similar use case. Please refer below image:
I have also attached the sheet below.