How to update specfic cell of an Excel on Sharepoint

Help Activities
, ,
1

I am using an excel file which is placed on Sharepoint, I want to update the excel file with specific cell without downloading the file. Can anyone suggest a best method for doing this?

2

Hi @projectrpa

Check the below thread:

Regards

3

But, the path of the excel is dynamic. Means I have to update multiple files, everyday. How we get the path of excel?

4

Okay @projectrpa

In that case, you can use the For each file\folder activity to loop throught the each file in a folder in share point.

Install the Microsoft Office 365 Package in Manage Packages, then search for Office 365 in activities panel under file you can find these activities.

Check the below image for better understanding,

image
image377×590 12.4 KB

Hope it helps!!

1 Like
5

@projectrpa

Welcome to the community

  1. First use find files/folders and get the required file as drive item.
  2. Once you have the drive item the item can be passed to the excel activities under office 365 and you can update

To get files dynamicaly use a variable in the query field of find files/folders…so as the name changes the returned driveitems will change

Cheers

1 Like