How we get multple sheets name of excel?

[suneel070 (sunil kumar manjhi)]

i have one Excel and i have 3 sheets in excel…how can i find sheet name?

[AshwinS2 (Ashwin S)]

Hi @suneel070

Use Excel application scope

Set workbook variable inside Excel application scope
Use for each item wb.getsheets

And pass the item to read range in sheet

Thanks
Ashwin.S

[suneel070 (sunil kumar manjhi)]

thanks

[lakshman (Ganta lakshman)]

@suneel070

1. use Excel Application Scope activity and create one workbook variable and say ‘varWB’.

2. Then use For Each loop activity and pass like this:

                        ForEach item in varWB.GetSheets
                                   print item
   

[sharathraju489 (Sharath Raju)]

Hi @suneel070

Here is the link to
# How To Get The Sheet Name From Excel – In UiPath

Hope it will be helpful

Regards,
Sharath Raju