Using Microsoft Teams to update value in excel sheet

Help Studio
, ,
1

I am given a link to the excel sheet that is in Microsoft teams and I do all the proper changes in the excel sheet and when I save the sheet it does not save the changes in the excel sheet in Microsoft teams. It only saves the changes to my downloaded version of the sheet and not the actual sheet that is in Microsoft teams. Is there a way to make these changes apply to the sheet in Microsoft teams.

2

Hi,

what activity you are using for writing/changing to Excel file?

If you use “Microsoft Office 365 scope” with Excel activities save every change immediately.

image

Something like this:

image
image835×706 17.6 KB

Hope it helps!

Gio

3

Hi,

Unfortunately, I cannot use any external libraries for this project as per the clients request. Do you know if it is possible to edit a excel file if it is not saved to your hard drive?

4

Hi,

this is an official library, instead, can you use Microsoft Graph API?
It is a bit more difficult but you can create by yourself the interaction with the file to update. Working with Excel in Microsoft Graph - Microsoft Graph v1.0 | Microsoft Docs

Regards, Gio