Using an Excel file from onedrive in c#

BaconBotMK1 0
Viewed 41

So I'm trying to make a program that uses an excel file to get some data.

I'm trying to make it so i can update data while the application is running, but i have no clue on how to get the file from onedrive.

The application is running c# .net 6. Reading the data from a local path is no issue.

I want to know if there is a better way than onedrive, or how i would read the excel data.

Scenario: The application will run on a remote server. I need to update the excel file from my own pc. I would rather have the file locally and have onedrive automatically syncing it on the machine, than having to remote desktop to the server.

UPDATE: I've now tried troubleshooting and it seems like the path can't be found. I've written the path in console to see if it uses the correct path on the server as well, when using path in file explorer, i go directly to the file.

c#
1 Answers

So having this issue i was not thinking about the posibility of not having the rights to access the file.

To fix the issue i had to go into application pools and then edit the application pool i was using, for that service, to a user having rights to the folder it tried to access.

BaconBotMK10
Related