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)
April 8, 2021, 5:15am
2
@Ganesh_S1
Welcome to forums
Can you share a screenshot of the workflow and error message?
Thanks
1 Like
Kah_Liang
(Kah Liang Loh)
April 8, 2021, 5:28am
4
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
Srini84
(Srinivas)
April 8, 2021, 5:33am
6
@Ganesh_S1
Check below for your reference
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
1 Like
hi @Kah_Liang ,
I want to overwrite the excel document here we cant use the excel scope write
thank you
Srini84
(Srinivas)
April 8, 2021, 5:39am
8
@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
Thank you…!
It is really helpful for me
Thank you So much
1 Like
Srini84
(Srinivas)
April 8, 2021, 5:53am
10
@Ganesh_S1
Share your steps if you resolved your issue
so that others also benifit from this
Thanks
1 Like
Ganesh_S1
(Ganesh S)
April 8, 2021, 6:41am
11
After trying this method eve
rything is collapsed.After trying this method everything is collapsed.
Ganesh_S1
(Ganesh S)
April 8, 2021, 6:45am
13
After try this method everything is collapsed.
Please give me an any other solution…
Thanks
Srini84
(Srinivas)
April 8, 2021, 7:20am
14
@Ganesh_S1
Is it due to Read Range activity?
Thanks
Ganesh_S1
(Ganesh S)
April 8, 2021, 7:23am
15
@Srini84
No, I didn’t use Read range activity I used only Read cell Activity