Read and update excel file in sharepoint directly

[Mahesh_Bandi1 (Mahesh Bandi)]

I have a requirement to read excel data from a sharepoint file and update it during the run.
I am doing below approach but it is not accepted. so can you suggest any?

My Approach:
Download it, use it like a normal excel file and then upload it again to SharePoint and overwrite the old file.

[Anil_G (Anil Gorthi)]

@Mahesh_Bandi1

Use office 365 activities…which work on sharepoint directly

Cheers

[ashokkarale]

@Mahesh_Bandi1,

The approach you are proposing have possible issues like:

1. It’s disconnected approach means when you download the file and make the changes, while you are doing changes, something got updated on the online version, your copy of the file will miss this data and it will be incorrect.
2. When you try to overwrite the file and if the file is open by someone else in edit mode, bot will not be able to overwrite the file.

Best Practice:
Use O365 Online activities like these.