Hi,
I have an excel file where i need to update couple cell with data after finishing processing data.
Im getting this error regularly but not constantly.
This is how the workflow looks:
I tried using newest version of excel packages and i tried using older version of excel.
I tried using vba to update excel file.
i cant use write range because i will lose the formatting/ style in the file.
Any advice/tips?
Hi @mahamud ,
I do not believe you would require to use the Excel Process Scope activity as I do not see the Excel activities being used, the Write Cell activity used is the Workbook Write Cell activity.
Are there Excel activities used in the later Steps ? Or within the Excel Process Scope ?
You shouldn’t be using the workbook Write Cell inside the Excel Process Scope. Excel Process Scope would need a Use Excel File inside it, then the Excel Write Cell inside it. Or just get rid of the Excel Process scope and use only the workbook Write Cell on its own.
Not really but i will try to remove excel scope and see what will happens.
I did have excel file inside but didn’t fix the problem. As i said above i will remove Excel scope and see what happens.
That’s because you’re using the workbook Write Cell not the Excel Write Cell. Search “Write Cell” in your activities pane and you’ll see that there are two.
