Extract particular table from excel

[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