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
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
there is activity name calledd get sheet name
by using that activity you can get sheet name
Inside Use excel file activity you can use the For each excel sheet activity which iterates the sheets in the excel.
Hope it helps!!
Hello Robert,
You can use ‘Get Workbook Sheet’ activity which is available in Classic activities.
Regards
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
Your Welcome , I hope you were able to solve it:)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
