Hello everyone,I am trying to implement Logic to download and create advanced Excel file. My data is stored in these two table as below:I want my extracted Excel file looks like this:Please also find the .OML file where I want to to implement the download Logic in the attachment.I would appreciate any help on building this logic using Advanced_Excel component from Forge.
Hi Fatemeh S,
try to install advance excel forge component and after that try to install demo as well so that you will be able to understand how it exactly works.
forge link - https://www.outsystems.com/forge/component-overview/355/advanced-excel-o11
hope this will help you.
Regards,
Prince
Hi Fatemeh,
Check this Demo page, which allow you to download the excel file.
You can also modify the logic; this implementation is merely meant to provide you with an idea of how to use this component to meet your needs.
Advanced Excel forge component is used to implement this.
I think your requirement is much more than exporting to an Excel Sheet. To me the sample excel sheet shared looks incorrect . Shouldn't this be in this format as below ?
Its possible that some Parent there may not have some attributes ( eg: Email ) in such cases the data under that column should be skipped and the each values should be coming under respective columns.
Hi Siya,Actually the Attribute_Name and Attrvibute_Value pair is dynamic and come from another table that is joined with Parent table.
Ok. The screenshot I have shared was based on the data in the excel sheet screen short shared earlier. If you just need to export the data like the format you have shared what @Mayank Dharmpurikar shared might work. However if you need data under respective column you need to write custom logic to arrange the data.
Hello Fatemeh S,
I have created most of the simple demos for this component. You can download Advance Excel Demo Component to access all the demos.
If you need further help please let me know.