I want to read from the column H3 to end of H Column in read range act6

Suggest a method to read the column from H3 to end of H column in read range activity. Suggest the correct Range value we have to put.

Hello,

Do you need to Dynamically check in excel with still the Datas available or U need to check full H column?

Data is their in excel I want to select the range from H3 to full H column until data is their.

Hi @Gopi_Krishna1

If you will have from from H3 cell then give the below syntax:

Excel.Sheet("Sheet1").Range("H3:H")

Hope it helps!!

Using clasic read range activity is it possible. I am trying in that

Hi @Gopi_Krishna1

image
Give "H3:H" in Range.

Regards

Try this

Provide only H3 in range

image

Hi @Gopi_Krishna1

Just use Read range cell as “H3:H” it will read all your data in Full H column

Its taking whole excel from H3 range

Hi @Gopi_Krishna1

Try this. This should work.

Regards

Throwing error in read range activity: Could not read range H3:H

Hi @Gopi_Krishna1

Do you have an idea how many rows will be there approximately.

Regards

Please share sample file. We will help you