Excel ReadRange

Help Studio
, ,
1

I have a given Data File filled with some formulas. I am trying to read the Excel. If I give column range like “A2:C5” it is giving data. But if I specify range as “A2” to get all rows, it is just hanging without any data. Header starting in row2, that is why I am giving A2. How can I read the data in this Excel? It has about 200 rows. Thank you,

2

@A_Learner

Try to not given any range and check if it works

When you say it hangs is it not reading anything? Or the process is not moving forward?

Did you try with read range workbook?

Also in use excel file you need not use read range instead use assignn with dt = Excel.Sheet("SheetName").DataTableOutValue

Cheers

3

Thank you @Anil_G
I tried with no range “”. Same thing. It is not returning back.

So with this the assign provided, I am getting “Excel” not defined error.

Thanks,

4

@A_Learner

You need to use this inside use excel file activity and I hope the value of reference as is excel…please check the same

Also try with workbook read range

Cheers

5

Thank you, it worked.

1 Like
6

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