How could I read a range in Excel from this scenary

Help Studio
, ,
1

Hello.

I’m trying to read since A8:to the last one value ( AM44). I’d like to automate this activity but I’m getting mistakes.

I could use Excel.Sheet(“Sheet1”).Range(“A8:AMX”) but I need to know what’s the last value with value.

Could you help me,please?
Main.xaml (9.6 KB)

testrt.xlsx (30.3 KB)

2

@pprin001

Did you try giving only A8 …if you are using rwad range activity

Cheers

3

Hi @pprin001

Try this
image

Regards,