Hi @Hanief Fathul Bahri Ahmad ,

We can achieve this functionality using the Advanced Excel component in OutSystems.

To display dropdown values in Excel:

1. Prepare Sheet2: Store the list of values you want to show in dropdowns (e.g., names, categories, etc.) in Sheet2. This acts as your data source.

2. Hide Sheet2: Before uploading the Excel template to OutSystems as a resource, open it in Excel, hide Sheet2, and save the file. This keeps the data source hidden from users.

3. Set Data Validation Manually: In the target columns where you want to display dropdowns (e.g., names in the first column), manually apply Excel data validation using a formula that refers to the correct range in Sheet2.
   For example: =Sheet2!$A$2:$A$100
   This ensures the dropdown fetches values from that specific range.

4. Upload to OutSystems: Add this Excel template as a resource, ensure “Deploy to Target Directory” is checked, and use it with your Excel export logic having Workbook_Open, Worksheet_select, Cell_Write & Workbook_GetBinaryData actions to download the excel using download widget .

Example :

• First column in Sheet1 displays a dropdown of names.

• Names are stored in Sheet2!A2:A100.

Demo Link : DemoScreen

Please refer to the OML file and resource Excel file I’ve shared for implementation details. Also, check the sample logic and screen in the dummy screen provided. 

Hope this works.

Thanks,

Senthil