Reading dynamic Table from excel sheet

Help
1

Dears,
I have an excel sheet as shown below:
I need to extract each column in each row. but bare in mind that the table is not defined as an excel table so I couldn’t use get table range in addition that the number of rows is dynamic. please help me with this.

Capture below screenshot

2

hi @Dina.abdelhakam
Use Read range and range give it as empty and try to do the manipulations

Thanks
Ashwin S

3

@Dina.abdelhakam

If you want to read entire excel file then specify range as " " into Read Range activity. It will give you output as ‘dataTable’. Then use For Each Row activity to iterate that dataTable. And make sure you checked “AddHeaders” option for Read Range activity.

If you want to read specific range then we have to specify range like “A1:D20”

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.