Edit and append data in SharePoint Excel

Help Studio
1

I have a situation where I need do operation on SharePoint Excel. We don’t want to download and upload a new Excel file. As per the requirement we need to edit, delete, append data in already opened SharePoint Excel.

Please review and suggest.

1 Like
2

Hi @Rrupam13 ,

What is the challenge.

Thanks

3

I have to access data from SharePoint Excel and do some validation, after validation I need to update one “Status” column as Processed however i am not able to do these Excel operations directly on SharePoint Excel.

4

What kind of operation are u willing to perform?

5

Read range, write cell, for each row etc

6

Hi,

Try to use Excel Application Scope and give the path from sharepoint file.
Then in the Do Container use any Activities needed (under the Excel section) like Append Range or Read Range.