This bot gets the index of the Excel sheet by name.
you can get the index of any sheet in Excel by its name
Top Benefits
Gets the index of Excel sheet by name
Tasks
This bot gets the index of Excel sheet by name
This bot gets the index of the Excel sheet by name.
Requirements & Inputs:
Name and path of Excel file Input string:
E.g: C:UsersMagdiDesktopDr_MFiles
cTest.xlsx
Name of sheet Input string:
E.g: Sheet1
The result contains an index of sheet E.g: 1,2, ….
See the Bot in Action
Setup process
Install
Download the Bot and follow the instructions to install it in your AAE Control Room.
Configure
Use the Bot in a bot, configure keys and other credentials the Bot will need (see the ReadMe for details.)
Run
That's it - now the Bot is ready to get going!
Requirements and Inputs
Name and path of excel file E.g: C:Files cTest.xlsx