How Can I Access Excel Data on OneDrive or SharePoint with Python?

0
0
Asked By SkywardRover47 On

Hey everyone! I developed a fancy filter using Tkinter for my Excel work, and my boss thinks it would benefit the whole team. However, I'm running into an issue accessing the data through Python when it's on OneDrive or SharePoint because of permissions restrictions. Locally, everything works fine, but with these platforms, I'm stuck. Should I just use a different database altogether since I know Excel isn't the best option for this? Any suggestions?

3 Answers

Answered By ExcelsiorWhiz On

It sounds like the .exe extension might be causing the permissions issues rather than Python itself. You might want to check if your IT can help exempt your .exe from these restrictions.

Answered By QueryQueen On

This might not be a Python-centric answer, but if you're looking for alternatives, you could do your filtering in Power Query. This could sidestep a lot of the SharePoint file access problems, especially if you're logged in under an account that has the necessary permissions.

Answered By TechieJedi87 On

It’s a bit unclear how you're using Python with Excel. Have you considered using Python directly within Excel? Microsoft has rolled out a feature for that. Plus, there are Python APIs for SharePoint which you can use to access files. You might need to create a dedicated robot user for these tasks.

Related Questions

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.