hello guys
Facing issue when trying to read the multiple excel sheets one by one in a Workbook.
using these values like given below.
hello guys
Facing issue when trying to read the multiple excel sheets one by one in a Workbook.
using these values like given below.
@AryanSingh You are getting this exception because one of the variable value is empty please check it.
Which variable! I am not sure about it though.
I used an example. from uipath forum for this.
Can u help me out with this??
@AryanSingh Is it possible to attach your workflow and excel
ok wait. giving u.
xaml and excel are given below:
AP.xaml (9.3 KB)
Dummy Sheet.xlsx (51.7 KB)
the real name for the sheet is “P02 Subsid May19_ AP report.xlsx”
take this sheet as an example.
@indra
Please assign a value to Workbook property
Please refer this workflow
Main.xaml (7.6 KB)
ok let me try this.
Thanx
@Uthraa
thanx
it was because i was not using the wrokbook variable in the excel application scope.
Solved.
@AryanSingh You dint assign wb in workbook properties. Refer this for more info
since this was my first time experimenting with the multiple sheets in an workbook…thus was confused.
Solved now.
Thank you both
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.