RPA Express unable to do Switch to Sheet Action

Hi WF,

The workflow is getting exception while performing “Switch to Sheet” Excel Action. Kindly help with this error.

Thanks,
Narendra

Which option do you use in the action: by index or by name?

Hi,

I tried with both the options. Here is the list of actions performed

Open excel - set value in sheet 1 from variable
Switch to sheet 2 - set value in sheet 2 from variable
Save spreadsheet

Thanks,
Narendra

Please post your recording here.

Hi,

Please see the recordings.

Thanks,
Narendratest.zip (757 Bytes)

@narendra_purTG sheet numbering starts with 0, so you should change the index to 1.

1 Like

Hi @ashapkina,

Please correct the documentation in https://kb.workfusion.com/display/RPAe/Excel#Excel-SwitchtoSheet. This does states the index starts for 1.

Thanks

1 Like

Hi,

Im still not able to see the working model. Could you please upload your recordings. I can refer the same.

Thanks,
Narendra

Do you get the error on step 3 or another step?
Here is a sample recording.
excel.zip (555 Bytes)

Most likely, it happens on step 2, because of the variable name - new.
New is one groovy specials words and cannot be used to name a variable. Try changing the name of the variable to new_cell, for example.

Just did. Thanks a lot for noticing.