Katie_j
April 17, 2024, 12:11am
1
Hello, I’m getting this error when trying to run any of my write cell activity. My automation was working fine as of yesterday but now gives me this error none stop. Any ideas on how to fix it?
Here is the full error:
24.2.1-beta.15932+Branch.release-v24.2.1.Sha.3f90483a69af341308fcab9ad25ddc1395738901.3f90483a69af341308fcab9ad25ddc1395738901
Source: Write Cell Workbook
Message: Error in implicit conversion. Cannot convert null object.
Exception Type: System.InvalidOperationException
System.InvalidOperationException: Error in implicit conversion. Cannot convert null object. at UiPath.Excel.Activities.WorkbookActivity`1.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
Hi @Katie_j ,
I think there is an issue with the range mentioned,
Ideally Cell field should have something like “A4”,“G5” something like that. In the snap i could see you have an expression that extends as .T…
Katie_j
April 17, 2024, 11:20am
4
Yes it originally is that. I tried something different to see if it would work but it is just “J1” in that field and still gives the same error.
@Katie_j ,
Try opening the excel file manually once( verify if the file is fine or currupted)
Ensure the File is in the path as mentioned in the activity and the sheet name is matching as well.
If you have done all the above then try using modern activities combination,
Excel Process scope + Use Excel File + write cell
Hope this helps you out.
If you don’t have the modern activities,
Project pane → settings ->General → enable the toggle for modern activities.
And make sure UiPath.Excel.Activities dependancy is updated.
Hi @Katie_j
Check the below for reference.
Hope it helps!!
Hi @Katie_j , if it hasn’t been solved yet, could you provide your code? Or at least this part? Kind regards.
