How to create array values as a drop down menu in input dialog based on the user selection

Help Activities
, ,
1

Hi,

I have a excel file and it contains some data sheets.I need to create these datasheet name as a drop down menu in input dialog.

Please help me to create an array which gets values from the excel and display them in the dropdown menu box.

2

For clarity, the dropdown would need to contain items of the selected range within Excel?

3

Excel Sheet Names would be the dropdown for input dialog.

4

Hi @shyamala_Gurumoorthy

Use Get sheets activity inside excel application scope to get all the sheet names for that excel .The output for this will be an array and you can pass it in the input dialog

5

Thank you so much for your help…Will try this activity.

6

@shyamala_Gurumoorthy Try the attached workflow

Example.zip (10.8 KB)

Capture

Output

Capture1
Capture1698×348 14.5 KB

7

Hi@Usha Kiranmai

I Have attached this workflow and executed successfully.

Thank you so much for your help…

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.