How can I read particular Excel Table from Excel sheet

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 .


@RishiVC1, This will help you

Dominic :slight_smile:

@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.


thanks bro for the solution. it is helpfull when we dont know the range