Read range problem - how to define range

[Olivera_Kalinic (Olivera Kalinić)]

What is right way to define range inside Read range activity?

Should it be inside Excel Process Scope or some other container?

[THIRU_NANI (NaNi)]

Hey!

Should be in Excel Process Scope

Just click on the + symbol then Excel->Sheet

This will give you the range

Reference:

Regards,
NaNi

[Olivera_Kalinic (Olivera Kalinić)]

But I am just getting this after clicking +

[THIRU_NANI (NaNi)]

Hey!

Take one Excel Process Scope

Then

Take one Use Excel Activity

Then

Take one Read range

Now you can select the Sheet

OR

Try this:

Excel.Sheet("SheetName").Range("Range")

Reference:

Regards,
NaNi

[sreejith.ss]

Hi @Olivera_Kalinic
In the modern activity you can define the range as Excel.Sheet(yoursheetname).Range(“A7:B23”)
For your reference adding the ss below

[Olivera_Kalinic (Olivera Kalinić)]

Thank you. It works…