Basic excel Automation program to "read row"


I am trying the basic level program in excel automation using “read row”, but getting the errorexcel%20-%20runtime%20error

Kindly help on this and make me understand what mistake i did, so that I can correct it going forward.

Kindly let me know if any information needed!


1 Like

Hi @Hariprasad,

If you are using excel application scope for reading excel data’s and then for each activity under this you tried to use read row from workbook not from excel.
Hence You should use the read row activity from excel not from workbook in order to not getting above error.


Hello Mohanraj,

I think am using the correct workbook. Please find the attached xaml file for your reference.

my Excel eg.xaml (7.4 KB)

Could you please help me now. Thanks!


The error occurs in “Close” workbook activity?
using Excel Scope Application could solve this.

Hi @Hariprasad,

I have created a workflow based on your requirement and same will resolve your issue.
Please make sure that create a variable for excel application Scope for Workbook option in the Output and Same you need to pass to the close workbook it will work.
my Excel eg.xaml (6.9 KB)




Buddy @Hariprasad

You know something, you were almost done…
Its very simple buddy in the close workbook activity you must have a passed a variable say for example out_workbook, great you have passed a variable, but does that have a value in it, there comes the question, if a variable is used in a activity and if it does not have any value in it, this error will occur, that is what it implies object has no reference, means no value,
so now we need to create a reference for our object out_workbook…
how…? buddy @Hariprasad
when we use a excel application scope activity, we can get a output variable from that activity of type workbook like this, mention the output variable by clicking ctrl+K in the output field and name it as out_workbook…use the same as input to close workbook activity buddy… @Hariprasad

Thats all buddy you are done…
Cheers @Hariprasad

@Mohansadaiyapillai @asesor-rpa @Palaniyappan

Thank you all for your time!!

But bad luck for me :frowning:
my Excel eg.xaml (6.7 KB)

Please help!


1 Like

Its done buddy @Hariprasad
Kindly check the change and run the workflow buddy
my Excel eg.xaml (7.6 KB)

the change was this

Cheers @Hariprasad


Did as advised by you, but still the same error!!
Where am I going wrong?? :frowning:my Excel eg.xaml (6.8 KB)


No Worries buddy @Hariprasad
run this buddy just by changing the filepath alone
my Excel eg (1).xaml (7.7 KB)

you will see it how it works lively buddy


Thanks you so much, Worked now :slight_smile:

Thanks for your time buddy :innocent:

1 Like

Thats great buddy
Keep going @Hariprasad

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.