Get Workbook Sheets and inserting them into variables for further use(2). Please ignore the other one

[KP6689 (KP)]

Have two questions here

1. Not able to get " List < string > " type variable.
2. How to pass the captured sheet name in a variable for further use.

please refer to the screenshot

Get Workbook Sheets.xaml (9.9 KB)

[Madhavi (K)]

@KP6689

1. Open variable panel
2. Enter variable name
3. Click on Variable Type drop down
4. Click on Browse for Types. This opens .Net Type selection page
   
   
   
   In the Type selection page,
5. Type Name as System.COllections.Generic.List
6. You can also select it from the Types tree
7. Select the variable type as string
   
   

Now in Get Workbook Sheets activity, enter the list variable created above in Output Sheets property

[KP6689 (KP)]

@KP6689

How to pass the captured sheet name in a variable for further use

thanks! I was able to get the List < String >. Now please support on the other query as well (How to pass the captured sheet name in a variable for further use).

[Pradeep_Shiv]

you can go through my workflow
@KP6689Sequence.xaml (5.5 KB)
Cheers

[KP6689 (KP)]

It is hard to comprehend in isolation, can you please, if ever, integrate it with the attached file

Get Workbook Sheets.xaml (9.6 KB)

[Pradeep_Shiv]

Get Workbook Sheets.xaml (6.5 KB)
you got the solution??
@KP6689

[KP6689 (KP)]

there seems to be confusion, regrets, I was able to get the Variable Type ’ List < String> ’ but my second question(How to pass the captured sheet name in a variable for further use) still lies unanswered

[Pradeep_Shiv]

okay do you have only three Sheet names ??
if so you can do this

• firstSheetName=yourListVariable(0)
• secondSheetName=yourListVariable(1)
• thirdSheetName=yourListVariable(2)

[Madhavi (K)]

Use Variable1 = lstSheets(0),
Variable2 = lstSheets(1),
So on

[KP6689 (KP)]

@Madhavi

Variable1 = lstSheets(0)

thanks got it!

[KP6689 (KP)]

thanks got it

[KP6689 (KP)]

thank you very much

[Pradeep_Shiv]

Cheers
@KP6689 Happy learning!