Hello,
I am trying the basic level program in excel automation using “read row”, but getting the error
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!
Thanks!
Regards,
Hari
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.
regards,
Mohanraj.s
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!
Regards,
Hari
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)
Thanks
Mohansadaiyapillai
Buddy @Hariprasad
You know something, you were almost done…
yes…
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 
my Excel eg.xaml (6.7 KB)
Please help!
Regards,
Hari
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?? my Excel eg.xaml (6.8 KB)
Regards,
Hari
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
Cheers
Thats great buddy
Cheers
Keep going @Hariprasad
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
Anil_G
Quan.Mai
ashokkarale
sudster
Povilas_Jonikas
ijanszen1
Yoichi
dai_y
sven.wullum1
bhuvangates