Write Cell: Object reference not set to an instance of an object. Error

Help Activities
, ,
1

I was able to extract the data I wanted which is the variable taxi distance. However, when I write cell, it shows the error of this topic.

image
image532Ă—607 22 KB

The expected result is that the taxi distance (in yellow) will be filled, as well as other figures that will match according to the month.

image
image1879Ă—545 18.8 KB

2

Hi @HENG_JUN_YING_AARON

Please mention the cell value properly.
Try to print the cell value excelRange.Substring(0,1)+Index in a message box and check if you can get the correct output.

regards

3

Hi @HENG_JUN_YING_AARON,

An Object Reference error normally means the variable you’re referring to is empty or not initialised. Put a breakpoint in your code, run your code in debug and check the Locals panel see which variable is empty. I imagine it’ll be either your cell value as you haven’t included it in your screenshot, or your LookUp Range activity as you’ve not specified a range to lookup against.

4

Hi @HENG_JUN_YING_AARON

Once check what is printing the excelRange.Substring(0,1) in message box

5

My excelrange, which comes from my lookup is null

6

I actually get the same error for the message box as well

7

Hi @HENG_JUN_YING_AARON,

Is there a specific range you can use on your Lookup? You could try specifying one and seeing if that changes excelRange’s value.

8

@HENG_JUN_YING_AARON

so the cell value is not correct please correct the cell value syntax.

regards

9

@HENG_JUN_YING_AARON

Does the excelRange variable contains the expected value. Try to print the excelRange varaible in a message box.

Regards

10

@HENG_JUN_YING_AARON

What are you look in look up activity can yous how…looks liek its not returning anything or is not able to find the value you want to lookup

cheers

11

Hi Anil, I am trying to look up based on my variable called input excel, which gives me Apr’ 23. Based on this month and year I extracted, I want to lookup the specific then write the distance that I have also extracted into the month I found

image

Intended outcome
image

Could it be a difference in the position of ’ in the months?

12

@HENG_JUN_YING_AARON

Are you using excel look up?

if so in excel Apr’23 might have a different value as well like fulldate…check by opening excel manually or by reading the excel data into a datatable…

cheers

13

Yes Anil I am trying to use the lookup function. This is how my date is formatted in excel.
image

I do think that there is something wrong with my lookup activity though as the output of the lookup I placed in the message box (excelrange) is blank
image

14

@HENG_JUN_YING_AARON

Having excelrange blank is the issue right…you should be getting a cell value I believe…

How you format and how the data is present in the cell might be different is what I am trying to say…

Cheers

15

Hi Anil you are right,
I found out that this is my excel cell is formatted by MM/DD/YYYY hh:mm:ss
image

But I am not sure how to change my extracted data to this format

16

Hi @HENG_JUN_YING_AARON ,

If you would require to write on that particular column, you would need the Excel Column Letter Z and not the Column Header name as you are directly writing in Excel cell.

So the Range that you would need to get is Z.

Could you let us know how are you getting the Column Name Apr'23, we can modify that to get the required Excel Column Letter.

Let us know if the above is understandable and if it is the step required.

17

@HENG_JUN_YING_AARON

From where are you extracting it? Are you not getting the complete date? …time I believe is 00:00:00 always

Cheers

18

Hi @supermanPunch ,

I get actually get the month from text/left right on some invoices.
image

In this format
image

However, in the excel I was provided, the month of column z is in this format after writing line 04/30/2021 00:00:00. At the point of my post I only tried to change the format to what I saw in the excel which was Apr’ 23.

I’m not sure if this information is helpful to you :sweat_smile:

19

@HENG_JUN_YING_AARON ,

Could you also show us How the Excel Range is calculated ? And Does the Excel Range value give null as value ?

20

I believe I may have filtered out the full date using text left right activity, I have since retrieved it back and it is now in DD/MM/YYYY format
image

@supermanPunch Sorry, do you mean the spreadsheet itself, or the variable? The variable is just the output of my lookup function and it returns null.

Here is my current workflow and a sample of the excel I have so you can see how my workflow roughly works

DelGro.xaml (15.1 KB)

Sample.xlsx (11.4 KB)