Cannot Append to Excel

Help Activities
, , ,
1

Hello,

I started having problems with Excel yesterday after updating few packages (including Excel Activity package). I am running a project that basically reads an Excel table, manipulate the data in a data table, and then append the rows to a dedicated sheet on the same Excel file.

The project and all activities were working perfect for months until yesterday when I did the update to the UiPath.Excel.Activities to the latest version.

I am getting this error below:

System.ArgumentException: Unable to set cell value to CREATIVE STYLE W.L.L at UiPath.Excel.Activities.WorkbookActivity`1.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

Note: I tried creaeting new Excel sheet, and I even re-installed UiPath StudioX but the problem was not solved.

Appreciate if anyone can help.

Best regards to all.

2

Hi @Anwar_Mirza

  1. Revert to the Previous Version: If you believe the issue was caused by the package update, you can try reverting to the previous version of the UiPath.Excel.Activities package that was working fine.
  2. Check Excel File: Ensure that your Excel file is not corrupted or locked by another process. Make sure it’s accessible and writable.
  3. Check Variable Values: Double-check the variable values you’re using in your workflow, especially the one you’re trying to set as “CREATIVE STYLE W.L.L.” Ensure that they are valid and in the correct format.
3

Thank you Praveen, I have already done the suggested points, with no luck.

4

1.Ensure that you have the necessary permissions to read and write to the Excel file and the specific sheet you’re trying to work with.

2.Sometimes, package updates introduce dependencies on other packages or libraries. Make sure all the dependencies are up to date.

3.Downgrade Excel Package: If the issue started after updating the Excel package, consider downgrading to a previous version that was known to work.

@Anwar_Mirza

5

Great Praveen, it seems to be one of the dependenies, I updated them all and it did work. THANK YOU so much for the help bro.

1 Like
6

Cheers… :slightly_smiling_face: Brother

@Anwar_Mirza

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.