Extract particular table from excel

[Anusuya_Ravi (RPA_Techie)]

Hello All,

I need my BOT to extract on exact 2nd table from the multiple table available on the same sheet in excel. How to accomplish that?

[ashokkarale]

@Anusuya_Ravi,

Refer this thread.

Excel tables

Hello @pari_patel, I noticed that you have several tables in your workbook and I “assumed” that you have more than one table in a particular sheet. In that sense, you were trying to select a table instead of reading the range. Thank you for bringing this up and it led me to a solution but first I would like to share with you the read range activity definition. Read Range Activity Defitnition: Reads the value of an Excel range and stores it in a DataTable variable. If the r…

You can get particular table by it’s name using Read Range activity and in Range property, pass the table name.

Thanks,
Ashok