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

Help
,
1

hello guys

Facing issue when trying to read the multiple excel sheets one by one in a Workbook.

image
image1920×1080 172 KB

using these values like given below.

image
image1920×1080 158 KB

2

@AryanSingh You are getting this exception because one of the variable value is empty please check it.

3

@indra

Which variable! I am not sure about it though.

I used an example. from uipath forum for this.

4

Can u help me out with this??

@indra

5

@AryanSingh Is it possible to attach your workflow and excel

6

ok wait. giving u.

7

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”

8

take this sheet as an example.
@indra

9

Please assign a value to Workbook property
tt

10

Please refer this workflow

Main.xaml (7.6 KB)

11

ok let me try this.
Thanx
@Uthraa

12

thanx

@Uthraa
@indra

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

Solved.

13

@AryanSingh You dint assign wb in workbook properties. Refer this for more info

14

since this was my first time experimenting with the multiple sheets in an workbook…thus was confused.

Solved now.
Thank you both

@indra
@Uthraa