I have 20 tables in excel and I want to add a data to all of these tables. For this, I plan to process the data by learning the table names and returning them for each. How can I do it?

Just replace first 2 lines with: Dim excel As Application = New Microsoft.Office.Interop.Excel.Application Dim workBook As Microsoft.Office.Interop.Excel.Workbook = excel.Workbooks.Open("YourPathToExcelFile") You have 2 different types named ‘Application’ and ‘Workbook’. UiPath does not know whi…

How can I find the name of all tables in Excel?

Help Activities

postwick (Paul Ostwick) October 28, 2022, 8:01pm 6

When you say table, do you mean sheets - the tabs at the bottom of the Excel file? This will get a list of them:

Topic		Replies	Views
Get Table names from excel sheet Activities excel	4	1990	October 27, 2021
How to find tables in a excel Help excel	2	4287	October 29, 2018
Looping through excel sheets Help excel , activities , question	4	6647	December 19, 2019
How to Get names of Excel worksheets Help excel , activities	8	14340	June 12, 2019
Custom activity FOR INSERTING TABLE NAME Help activities	0	2095	March 13, 2018

How can I find the name of all tables in Excel?

Related topics