Write Range: Error in implicit conversion. Cannot convert null object

[pjaiphak]

Hi Developer,
i found issue regarding write range activities.
Write Range: Error in implicit conversion. Cannot convert null object
i use
1 Read Range
2 Write Range
2 activities not in excel application scope
could you please help to advise.

Thank you.

[Srini84 (Srinivas)]

can you share screenshot of write Range and its properties?

Thanks

[pjaiphak]

Hi @Srini84
i can write to another workbook but not to template. i’m not sure what happen? it’s last step to completed.

[Srini84 (Srinivas)]

can you check using log, whether the DataTable has the values? because the error is that null reference if possible share the excel file and xaml file

Thanks

[Palaniyappan (Forum Leader)]

@pjaiphak

Error in implicit conversion. Cannot convert null object

Hi
Try once with Excel activities with read range and write range within excel application scope
Cheers @pjaiphak

[pjaiphak]

Hi @Palaniyappan
Yes, as you advice i has already to try but after writing to new sheet. Number from 03456 change value to 3456.
i need to keep format number in new sheet too.

Thank you so much.

[Palaniyappan (Forum Leader)]

Concatenate single quotes before the string
Like this using a assign activity
“‘“ + tow(“yourcolumnname”).ToString
Inside the for each row loop
And then write that datatable to excel
Cheers @pjaiphak