Getting the sheet names in an Excel File dynamically using Modern Excel

[RobertRussell_Monsalud]

Good Day,

May I know how to get the sheet names in an Excel File dynamically using Modern Excel?

Kindly see below attached files for the sample Excel file and .xaml file. Thank you.

Main.xaml (7.5 KB)
Test_Excel_File1.xlsx (10.2 KB)

Best regards,
Robert

[rlgandu (Rajyalakshmi Gandu)]

@RobertRussell_Monsalud

Use Get workbook Sheets activity to get the sheets excel dynamically.

or use for each excel sheet

In the message box give
CurrentSheet.Name it will give the name of the current sheet

[Veera_Raj (Veeraraj Sethuraman)]

there is activity name calledd get sheet name
by using that activity you can get sheet name

[pravallikapaluri]

Hi @RobertRussell_Monsalud

[vrdabberu (Varunraj Dabberu)]

@RobertRussell_Monsalud
xaml

Output

Hope it helps!!

[lrtetala (Lakshman Reddy)]

Hi @RobertRussell_Monsalud

Use Get workbook sheets activity

or

[mkankatala (Mahesh Kankatala)]

Hi @RobertRussell_Monsalud

Inside Use excel file activity you can use the For each excel sheet activity which iterates the sheets in the excel.

Hope it helps!!

[Akshay_B]

Hello Robert,
You can use ‘Get Workbook Sheet’ activity which is available in Classic activities.
Regards

[RobertRussell_Monsalud]

Hi All @pravallikapaluri @rlgandu @Veera_Raj @vrdabberu @lrtetala @mkankatala @Akshay_B

Thank you so much for all of your help and inputs. I really appreciate it.

Best regards,
Robert

[vrdabberu (Varunraj Dabberu)]

@RobertRussell_Monsalud

Your Welcome

Happy Automation!!

[Akshay_B]

Your Welcome , I hope you were able to solve it:)