UiPath: Get All Sheets Names in Excel
In this 1-minute video tutorial, Mukesh Kala shows, how to get all the sheet names in an Excel book and print them. The intuition is that we store the sheet names in an array of strings, loop through them with a for each and print them with a Write Line.
Mukesh Kala is a UiPath Most Valued Professional 2021 and Development Senior Analyst in Accenture.
🧑 Creator of the video:
Mukesh Kala - / @mukeshkala
🎮 Check the discord, where we solve problems and chat about automation: / discord
0:00 Intro
0:05 Excel Application Scope
Specify a file and create an output variable for the Excel book.
0:19 Create an Array with the Sheet Names
We store the sheet names in an array of strings with the .NET method .getsheets
0:35 Print the Sheet names
We print our array with sheet names with a For Each
#uipath #rpa #shorts
