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

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.

can you share screenshot of write Range and its properties?

Thanks

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

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

Hi
Try once with Excel activities with read range and write range within excel application scope
Cheers @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.

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