Error: Object reference not set to an instance of an object while reading excel sheets

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.

Please assign a value to Workbook property

1 Like

Please refer this workflow

Main.xaml (7.6 KB)

1 Like

ok let me try this.



it was because i was not using the wrokbook variable in the excel application scope.


1 Like

@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.