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

Question

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.

Answer 1

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

Answer 2

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