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
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.
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.
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
How To: Running Codex CLI on Windows with Azure OpenAI
Set Wordpress Featured Image Using Javascript
How To Fix PHP Random Being The Same
Why no WebP Support with Wordpress
Replace Wordpress Cron With Linux Cron
Customize Yoast Canonical URL Programmatically