Teams Excel Controls

Hello I need some advice.
I want to open Excel in Teams, import data, and enter data.
Is there a way to work in Teams itself other than downloading Excel?

HI @bbbb ,

Not very sure but try with Integration services available in orchestrator.

Thanks,
Pallavi.

@bbbb , if you check there is a SharePoint folder for excel in teams. Each file will connect in a SharePoint folder. If you get that link then you can use it as a data source to update.

This is how you can populate updated data in Teams.

@bbbb,

That’s hard to achieve and not reliable from front end. Use Office 365 activities and interact with the file though OneDrive activities.

Thanks,
Ashok :slight_smile:

Well that’s not complex.
image

in every teams channel we can find Files, just click and open files and you can find any file. On the right hand side of the file name you can find 3 dots.
image
if you click those 3 dots then a menu will show up as above fig. Click on Copy Link and paste that link in a browser. you will get full path.

Edit that link and get the root folder of file location in SharePoint and use the same URL to post your new documents. That’s it! it’s a one time effort and BOT will start posting documents in teams channel. (Make sure BOT account should have access to that channel)