Import Excel data from Sharepoint

1

Hi - is there anyway I can import Excel file data from a Sharepoint location? Trying a simple request using DynaWeb gives me a 403 Forbidden so I would need some way to use my credentials there.

Thanks

2

Looks like there is a rest API for requesting files. You’ll need to build your own node (via C# or perhaps Python) or utilize a 3rd party package - DynaWeb might do the trick.

3

Thanks - I have only minimal Python skills so this will be out of my league. Thanks anyway - I’ll resort to saving local versions of the file for now.

1 Like