Read range activity in Excel giving error for range selected

Help Activities
, ,
1

hi friens,

Read range activity giving error in free studio edition.can someone please help me on this.

2

Hi @varun_shinde

Make sure work book / Excel is closed while running the process

Also make sure the range you have given is valid

I would recommend to
use a kill process activity before to this Read Range activity and mention the property PROCESS NAME as “EXCEL” that would close the excel before you read it.

2 Likes
3

You need to make sure you are specifying the range correctly. If you’re using Excel activities, specify the Sheet with Excel.Sheet("Sheet1"), if you want a specific range use suffix with .Range, i.e Excel.Sheet("Sheet1").Range("A1:D18")

1 Like