Write Range Object reference not set Error

[Anil_G (Anil Gorthi)]

@DimiG

Run the file in debug…first check in the read files if data is coming…then in the main …in either of these places the datatable is missing data

Use stepinto and check the locals panel

cheers

[DimiG (Dimitris G)]

I am getting the same error

[putera.timmy]

is your out2_dtOuput from read cell?

[DimiG (Dimitris G)]

Yes it is from read cell

[DimiG (Dimitris G)]

Data don’t seem to come from Read Files on

[Anil_G (Anil Gorthi)]

@DimiG

In read range did you assign the variable at all?

If yes then check the excel if it has data in the range provided

cheers

[DimiG (Dimitris G)]

The excel has data.If i use assign all I am getting is an empty excel file.For some reason works fine without the second Write Range but then i cant copy the B2 cell

Thanks for your reply

[Anil_G (Anil Gorthi)]

@DimiG

empty

@DimiG

I see the in_Filepath itself is empty…you should send the file path

For debugging also you have to run the bot from main…I guess you ran only the read files part.

cheers

[DimiG (Dimitris G)]

I Invoke it as show below.If i debug from main i cant access Read Files in debug mode

[Anil_G (Anil Gorthi)]

@DimiG

In Main right click on read files invoke and set a break point…then use stepinto from there to check

cheers

[DimiG (Dimitris G)]

thanks for you help
yes dtOutput has data but dtOutput2 is null

[Anil_G (Anil Gorthi)]

@DimiG

Then check why it is null…you have the data…you knwo whare you are reading it and all

cheers

[DimiG (Dimitris G)]

It shouldn’t be null.The cell is not empty.I tried with different files and even different cells.
Thanks for your time and help.

[Anil_G (Anil Gorthi)]

@DimiG

Can you please share the xaml and the file

cheers

[DimiG (Dimitris G)]

Sure

Test2.zip (205.4 KB)
TestFile.xlsx (10.7 KB)

[Anil_G (Anil Gorthi)]

@DimiG

Please check this. I modified it…Read cell gives a string datatype not a datatable…not sure why you gave a datatable there. Also modified the write range to write cell.

Test2 (2).zip (14.9 KB)

cheers

[DimiG (Dimitris G)]

Thank you.
I am afraid that didn’t work.
Still getting the exact same error.

[Anil_G (Anil Gorthi)]

@DimiG

I just ran it and it did write the data…I see you hard coded the output path check the proper file

And also please check if any variable is mis placed

cheers

[DimiG (Dimitris G)]

I am afraid it’s not working.Now I am getting the error even in the first Write Range that worked fine before

[Anil_G (Anil Gorthi)]

@DimiG

Can you please show what error are you getting?

cheers