Write cell : Root Element is Missing

[Ganesh_S1 (Ganesh S)]

Hello Everyone I am use write cell activity to write a value in merged cell in the excel sheet but I faced error is root element is missing. Anyone can help me to solve this issue

[Srini84 (Srinivas)]

@Ganesh_S1

Welcome to forums

Can you share a screenshot of the workflow and error message?

Thanks

[Ganesh_S1 (Ganesh S)]

Yeah sure Srinivas

Thanks

[Kah_Liang (Kah Liang Loh)]

Hi @Ganesh_S1,

Can you please try using excel application scope and write cell in the scope instead?

It may be format issue when using excel activities that don’t use excel application scope.

Regards,
Kah Liang

[Pradeep_Shiv]

Hi @Ganesh_S1,

Check the below post

Weird error with write range activity

Hi guys, I know this post could be similar at others, but no. Here is my scenario: I have a robot which write an Excel report, it worked nice until yestarday. Here is an screenshot of my report. [imagen] Well, the robot reach the write range activity and write the report. When it done 74 items correctly, in the 75th, it failed and give me this error: “The range doesn’t exist”. It never happened before. In the write range activity, I have “C”+cont.tostring where cont is defined with an…

[Srini84 (Srinivas)]

@Ganesh_S1

Check below for your reference

Read Range: Root element is missing

Hi everyone, I’m trying to write a cell in an exce file, with the workbook activitys because we don’t have office license, but i get the next errors The first run after I configured the activity write cell 19.4.4+Branch.support/v2019.4.Sha.6d308c7f5a32b559373887ae421ce7eaec8f8d24 Source: Write Cell Message: The given key was not present in the dictionary. Exception Type: System.Collections.Generic.KeyNotFoundException An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=tr…

Hope this may help you

Thanks

[Ganesh_S1 (Ganesh S)]

hi @Kah_Liang ,
I want to overwrite the excel document here we cant use the excel scope write
thank you

[Srini84 (Srinivas)]

@Ganesh_S1

Can you use Read Range activity and try to give the same sheet name

Let us know if this is reading correctly?

Thanks

[Ganesh_S1 (Ganesh S)]

Thank you…!
It is really helpful for me
Thank you So much

[Srini84 (Srinivas)]

@Ganesh_S1

Share your steps if you resolved your issue

so that others also benifit from this

Thanks

[Ganesh_S1 (Ganesh S)]

After trying this method eve

rything is collapsed.After trying this method everything is collapsed.

[Ganesh_S1 (Ganesh S)]

[Ganesh_S1 (Ganesh S)]

After try this method everything is collapsed.
Please give me an any other solution…
Thanks

[Srini84 (Srinivas)]

@Ganesh_S1

Is it due to Read Range activity?

Thanks

[Ganesh_S1 (Ganesh S)]

@Srini84
No, I didn’t use Read range activity I used only Read cell Activity