Range does not exist error

Help Studio
, , , , ,
1

Hi,

I am trying to write message in excel by creating new sheet in excel but, it is giving error like range not exist.According to me range is correct and it is creating new sheet also but while writing message it is giving eror.
Please help me to solve this.
here are the screenshots.
screenshot of script.
error1
screenshot of error.
error2

Thanks

2

@Mathkar_kunal

Check whether the sheet name is correct, any spaces means you have to mention the same

also check is this file is completely open to write?

You can check by giving a delay before write cell if it is a heavy file

Hope this helps you

Follow Link

Thanks

3

i am creating new sheet as sheet 2 so sheet name is correct and file is completely empty at first to write message, so not heavy and opening too

4

@Mathkar_kunal

Can you share a sample file which you are getting this error, so it would be great to debug your issue

Thanks

5

here is the file
Reporting.7z (5.8 KB)

before this i am opening this file to write in first sheet .

6

@Mathkar_kunal

Can you share the properties of excel application scope?

As per the available resource i believe it is not finding the sheet thats why you are getting the error

Thanks

7

By writing sheet 2 in write cell , i am creating new sheet in same excel.
here are the properties.
error3

8

@Mathkar_kunal

I tried to replicate the same, and it was successful without any issue

image
image1067×558 26 KB

pass a sample string value as above and can check

Hope this helps you

Thanks

9

Yes, passed sample string but same error is showing

10

@Mathkar_kunal

Then check the type of the variable you are passing into

also try to give CProjectName.ToString + “is already exist”

Hope this helps you

Thanks

11

yes tried with tostring also as u shown but same error is showing.

12

@Mathkar_kunal

Can you check what is the type of the CProjectName Variable?

Is that string only? also you can debug by placing a message box before the write cell and give the CProjectName

check any duplicates also

Thanks

13

Yes, i changed datatype to sting and even in write line it showing project name.
check this
error5

error6

14

@Mathkar_kunal

I see the scope of the variable is restricted to Body, can you make the scope to entire sequence also check for the duplicates with same name

If possible can you share the workflow or you can place a breakpoint and debug

Hope this helps you

Thanks

15

Scope is correct.i am attaching the workflow please go through and let me know if u find something.
May be it will not run at ur end but still just go through the process
Process.xaml (111.9 KB)

16

@Mathkar_kunal

I am unable to open your flow in my system

anyway you can always test with a test sequence and let us know

Thanks

17

I tried same logic which i have written with new excel sheet.now working.
but dont know why it not worked when i am creating sheet 2
Thanks for ur suggetions

18

Hey, I had run into this issue so was looking around briefly. But, I also figured out what the problem may have been for me. Some of the data was not structured with the other columns, and I think the Excel Write Range didn’t like that.

Maybe it’s a bug which should be fixed, but for now I suggest finding what rows is not structured (such as Total Amount -type rows or empty rows) and remove them before writing. A simple way is to use linq, for example dt1.AsEnumerable.Skip(0).Take(dt1.Rows.Count - 3).CopyToDataTable

EDIT: for me, it was a row that consisted of many '='s in each column

1 Like