Hey everyone! I've created a pretty cool Python program using Tkinter that acts like an advanced filter for Excel files. My boss really liked it and thinks it could benefit the whole team. The problem I'm facing now is accessing Excel files stored on OneDrive or SharePoint. When the files are local, everything works fine, but I'm running into issues with permissions when trying to access them through Python. It seems like maybe Excel isn't the best tool for this, so I'm considering using a different type of database. Anyone have any suggestions on how I might solve this?
1 Answer
While this might not be a Python solution, have you considered doing your filtering in Power Query? This approach could help you avoid a lot of issues with SharePoint, and as long as you're logged in to an account with access, it should make things much smoother.
That's an interesting idea, but I built my tool to simplify backend tasks for the user, so it skips all the nitty-gritty. I wanted to make it as user-friendly as possible!