Read range problem - how to define range

Help Studio
1

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

image
image802×319 12.5 KB

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

2

Hey!

Should be in Excel Process Scope

Just click on the + symbol then Excel->Sheet

This will give you the range

Reference:

Range
Range1282×507 26.6 KB

Regards,
NaNi

3

But I am just getting this after clicking +

image

4

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:

ModernExcel
ModernExcel786×645 19.3 KB

Regards,
NaNi

6

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

forumimage
forumimage940×756 24.7 KB

7

Thank you. It works…