How can I read particular Excel Table from Excel sheet

datatable
excel
readrange

#1

Hi, I’m trying to read Exel Tables from an excel, the length of these tables is not fixed. Any idea how can I read them? Just For Clarity, I’m attaching a screenshot :

The bot should be able to read Excel table 1 and excel table 2 without specifying the range.(Something like what short range activity does)

thank you .


#2

@RishiVC1, This will help you

Regards,
Dominic :slight_smile:


#3

@Dominic, thanks for quick reply. I found a better solution, I’m attaching the Xml of Same , Please have a look.
readExcelTable.xaml (9.5 KB)

I have used get table range activity which takes the required Excel table with sheet name as input and gives range of required table as output. Then passed that range to read Rage activity.