How to Embed Editable Excel File in Angular 10 App with .NET Core 3 Backend and OAuth Token...

Title:
How to Embed Editable Excel File in Angular 10 App with .NET Core 3 Backend and OAuth Token Authentication?

Body:
I am developing an Angular 10 application that needs to incorporate an editable Excel file, allowing users to interact and modify it directly within the app. The backend of the application is built with .NET Core 3, and authentication is managed through OAuth tokens via Azure AD.

What I have tried:

1. Accessing Excel files through the Microsoft Graph API, with OAuth tokens handled by the .NET Core 3 backend.
2. Attempting to embed Excel Online in an iframe, managing authentication with access tokens.
3. Exploring the use of the Office JavaScript API and other third-party libraries to facilitate Excel file manipulation.

Requirements:

• Users must be able to edit Excel files seamlessly within the Angular 10 application.
• Authentication must be secured using OAuth tokens, integrated between the Angular front-end and the .NET Core 3 backend.
• The Excel file changes should be savable in real-time or based on user actions.

Questions:

1. What are the best practices for embedding an editable Excel file in an Angular 10 app, with .NET Core 3 backend authentication using OAuth tokens?
2. Are there specific libraries or APIs particularly well-suited for this combination of technologies?
3. Tips for managing OAuth tokens securely in this context would also be valuable.

Additional Information:

• Angular version: 10
• Backend: .NET Core 3
• Authentication: Handled by Azure AD with OAuth tokens via MSAL.js

I am looking for any guidance or references that could help streamline this integration, especially regarding secure token handling and embedding functionalities. Any pointers would be greatly appreciated.

Continue reading...