How to update the value in excel column in sharepoint?

Hi,

I need to update the value in particular column of excel(In SharePoint) based data in other column.
We should not download the excel since that is requirement.

Can someone help me with this?

Thanks

Hi @manjuts689,

As per my understanding, you have an Excel file stored in a SharePoint Library, and your objective is to update a specific column based on certain conditions without the need to download the file. Could you please confirm if my understanding aligns with your query? If so, I’d be happy to explore potential solutions for this scenario.

@MFK Yes your undestanding correct

  1. Install Packages:
  • Ensure that you have the necessary packages installed. Go to the Package Manager and install or update the “UiPath.MicrosoftOffice365.Activities” package.
  1. Use Microsoft 365 Scope:
  • Drag the “Microsoft 365 Scope” activity to your workflow.
  • Configure it with the necessary authentication (e.g., use an App ID and App Secret or other available authentication methods).
  1. Use Excel Activities:
  • Inside the “Microsoft 365 Scope,” use the “Excel Application Scope” activity.
  • Set the workbook URL to the SharePoint location of your Excel file.
  1. Update Excel Values:
  • Use the “Write Cell” or “Write Range” activity to update the value in the desired column based on the data in another column.
  • Use “Read Range” to get the data from the Excel file.
  • Use DataTable activities or LINQ to filter and update the specific value.