Share via

How to read an Excel table from OneDrive using code (Typescript)

Mateus F Poletto 0 Reputation points
2023-07-07T12:54:24.23+00:00

In a project I'm working on, I need to read an Excel table from OneDrive based on a shared link, how can I do this? I'm having trouble doing it. I was previously able to read using a code flow provided in tutorials, but that flow requires me to first log in with an account and authorize through the browser with the code to access, but after a while, access is already expired. How can I read the table with the shared link or in some other way that can automate this, without having to authorize something or some code every time I run it?

The code flow tutorial i was using was this one:
https://developer.microsoft.com/en-us/graph/quick-start

But i don´t think is a good flow to make my thing automated.

Microsoft 365 and Office | OneDrive | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sukanya Mukherjee 90 Reputation points
    2023-07-14T08:05:10.39+00:00

    HI !

    Mateus

    The simplest way to read an Excel table from OneDrive based on a shared link, is firstly subscribe for Microsoft 365 , where you will get your own OneDrive space , you can save any file that were shared through OneDrive.

    Then you can view unlimited no. of times.

    Hope this way helps you.

    Sukanya

    Was this answer helpful?

    0 comments
  2. Sukanya Mukherjee 90 Reputation points
    2023-07-09T15:14:42.74+00:00

    HI !

    Mateus

    The simplest way to read an Excel table from OneDrive based on a shared link, is firstly subscribe for Microsoft 365 , where you will get your own OneDrive space , you can save any file that were shared through OneDrive.

    Then you can view unlimited no. of times.

    Hope this way helps you.

    Sukanya

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.