How to find tables in a excel

[sangasangasanga (sanga)]

Hi, I have multiple tables in a excel. I would like to find a table then get the values as I want to compare the values with another excel. From reading the forum, I understood there is a get table range activity. From the exampple below, I understand how it works. However for input, I have to put in tablename. Not sure what to do put in… Pls guide me

Excel file with Chart Sheet as first sheet - Exception

Hi @Thiago Actually you are getting this error because your cast is wrong because you are using “Excel Activity Scope” with it. Namespace: Microsoft.Office.Interop.Excel Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll) This interface only gives you worksheets - not charts. Go to Remark section On the other hand, if you will use “Workbook Activities” so it’s instance _Workbook.Sheets gives you a Sheets instance. Go to Remark section …

Above, is one of a table in the excel file. I tried putting tablename as “KHAZ IES Pricing” but it says table does not exist.

Thank you xoxo

[kaderms (Kader)]

@sangasangasanga Get Table Range activity only works with ‘Table’ inserted in excel, not just a group of excel cells formatted to look like a table. To be clear, try Insert → Table to insert a sample table. You can then find the Table Name here :