51
Views
7
Comments
Solved
[Advanced Excel] Export selected data using excel and dropdown tags
Question
advanced-excel
Service icon
Forge asset by Carlos Freitas
Application Type
Service

Is it possible to do an implementation using dropdown tags to export an excel file within selected data the user select to be downloaded

ex:

after select data, download only the columns selected. and also an option to select all inputs to download.

2022-12-22 10-00-39
Beatriz Sabino
Solution

Hi Hevert.

Here is an example with the Advanced Excel actions you need.

AdvancedExel_ExportExample.oml
2022-12-22 10-00-39
Beatriz Sabino

Hi Hevert,


If I understand correctly, you want the option for the user to export only the selected values (Barbados, Albania, and Australia), as well as the option to download all records from the dropdown list.


To achieve this, you can use the DropdownItem List from the dropdown with tags component. Then, using the Cell_Write action from Advanced Excel, loop through your selected records and write these values into an Excel file. For the second option, you can fetch all the data from the database and apply similar logic to export all records.


Hope this helps! 

2023-03-29 17-56-44
Hevert Vinicius

Hi @Beatriz Sabino thank you for your help.
Could you do a simple .oml example? I've never use this component before and I'm trying to understand how it works. 
Basically if help with more info, all data it's been fetched from an aggregate from the database and I have a structure to set specifically data I want, the table of countries that I use was just an example and i have more information than just countries.

Regards Hevert 

2022-12-22 10-00-39
Beatriz Sabino
Solution

Hi Hevert.

Here is an example with the Advanced Excel actions you need.

AdvancedExel_ExportExample.oml
2023-03-29 17-56-44
Hevert Vinicius
2025-02-07 09-54-44
Sivasakthi Munusamy
2021-11-12 04-59-31
Manikandan Sambasivam

Hi,

Please check the below forge component

https://www.outsystems.com/forge/component-overview/4847/dynamic-column-export-o11

UserImage.jpg
Bhavadharani M

Hi @Hevert Vinicius,

Please find my oml. I have created solution based on your description and let me know if you need any further assistance.

Thanks,

Bhavadharani Mahalingam.

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