Write Range Workbook: Object reference not set to an instance of an object

Help Studio
, ,
1

Hey,

I’m getting the following error using the write range workbook, idk why !

22.10.3+Branch.master.Sha.def2351dc828ccfbcddb6e9e07c9cf71b5bf55da

Source: Write Range Workbook

Message: Object reference not set to an instance of an object.

Exception Type: System.NullReferenceException

System.NullReferenceException: Object reference not set to an instance of an object. at UiPath.Excel.Activities.WorkbookActivity`1.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

The excel file has all the data needed, I have used before and never faced such issue…

2

Hello,

Are you trying to access a non initialized var ?
This message happens when you are using a variable with Nothing

Are you using an existing workbook when you try to open this one ?

3

HI @MHarakeh

Can you check the DataTable variable is assigned correctly in the process?

Can you share the screenshot of your workflow?

Regards
Gokul

4

Hi @Yamatendo @Gokul001

This is a screenshot
image

The ReadDT variable is declared as DataTable, nothing wrong here

5

The workbook path seems to wrong. Try reading the filename with log message to ensure it’s correct.

6

can you use output data table activity to check ReadDT has some values?

7

Then why do have the issue @MHarakeh ? Before write range activity take the dt count

Use message box and check it

ReadDT.Rows.Count

Regards
Gokul

8

I advise you to use a excel application scope and use the write range inside, there is two write range activity and the other one don’t need the path because it’s used in the scope.
If you’re stuck with no reason you can try to use this. I remember someone the tolds me to not use this write range, but i don’t have experienced problem myself so it’s just a supposition

9

Hi @mayur.pawanikar

When debugging the DataTable value is showing as Null.
ReadDT isn’t being passed there…
Although it’s declared

10

Yes, since the DataTable has null value, its not getting written into the Excel file.
Please check the activity where you are adding values to the ReadDT

11

Maybe you have declared two variables with the same name

12

Hi @MHarakeh

You can try with Try catch activity

In the catch block use Assign activity

ReadDT = New DataTable

Regards
Gokul

13

Thanks Guys,

Figured it out I reused an excel scope activity and then the read range activity…

14

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