Forum Discussion
Teams App that reads Excel File from Sharepoint site
Hi guys, i'm new to Teams App Development. My team leader at work asked me to start studying this technology to extend our Teams Channel (no one in my team knows how to do it).
What i need are two things:
1) A better documentation and guides to Teams App, Teams Toolkit, SharePoint Framework etc. outside of official Microsoft documentation.
2) I need help to know how to go on with my project:
- my goal is to make a Tab App (unfortunately i cannot make any bot 'cause of privileges problems) that reads an Excel file from a SharePoint page, extracts data from that and uses them to do XYZ operations. I started by creating a Tab with sharepoint framework, but ther's nothing i know about it.
How can i do this, and which modules i need to use?
thanks.
Hi RedFra497,
To build a Teams App that reads an Excel File from Sharepoint site, you can follow these steps:
Create a new Teams App project using the Teams Toolkit.
- Documentation: Creating a new Teams App project with the Teams Toolkit: https://learn.microsoft.com/en-us/microsoftteams/platform/toolkit/create-new-project
Add a SharePoint web part that reads the Excel file and extracts the data you need.
- Documentation: Creating a SharePoint Framework web part: https://learn.microsoft.com/en-us/sharepoint/dev/spfx/web-parts/get-started/build-a-hello-world-web-part
- Example: SharePoint web part that reads an Excel file: https://m.youtube.com/watch?v=nye-_LyP_Sg
Deploy the SharePoint web part to your SharePoint site.
- Documentation: Deploying a SharePoint Framework web part: https://learn.microsoft.com/en-us/sharepoint/dev/spfx/web-parts/get-started/serve-your-web-part-in-a-sharepoint-page
Add a Teams Tab that embeds the SharePoint web part.
- Documentation: Adding a Teams Tab: https://learn.microsoft.com/en-us/microsoftteams/platform/tabs/what-are-tabs
- Example: Creating a Teams Tab that embeds a SharePoint web part: https://learn.microsoft.com/en-us/sharepoint/dev/spfx/web-parts/get-started/using-web-part-as-ms-teams-tab
Here are some more useful links:
- Developing Teams apps with the Teams Toolkit: https://learn.microsoft.com/en-us/microsoftteams/platform/toolkit/teams-toolkit-fundamentals
- Creating a SharePoint Framework web part: https://learn.microsoft.com/en-us/sharepoint/dev/spfx/web-parts/get-started/build-a-hello-world-web-part
- Deploying a SharePoint Framework web part: https://learn.microsoft.com/en-us/sharepoint/dev/spfx/web-parts/get-started/serve-your-web-part-in-a-sharepoint-page
- Adding a Teams Tab: https://learn.microsoft.com/en-us/microsoftteams/platform/tabs/what-are-tabs
- Creating a Teams Tab that embeds a SharePoint web part: https://learn.microsoft.com/en-us/sharepoint/dev/spfx/web-parts/get-started/using-web-part-as-ms-teams-tab
Please click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.If the post was useful in other ways, please consider giving it Like.
Kindest regards,
Leon Pavesic
(LinkedIn)
