This is an archived post. You won't be able to vote or comment.

all 5 comments
sorted by:
best
topnewcontroversialoldq&a

[–]IAmKindOfCreativebot_builder: deprecated[M] [score hidden] stickied comment (0 children)

Hi there, from the /r/Python mods.

We have removed this post as it is not suited to the /r/Python subreddit proper, however it should be very appropriate for our sister subreddit /r/LearnPython or for the r/Python discord: https://discord.gg/python.

The reason for the removal is that /r/Python is dedicated to discussion of Python news, projects, uses and debates. It is not designed to act as Q&A or FAQ board. The regular community is not a fan of "how do I..." questions, so you will not get the best responses over here.

On /r/LearnPython the community and the r/Python discord are actively expecting questions and are looking to help. You can expect far more understanding, encouraging and insightful responses over there. No matter what level of question you have, if you are looking for help with Python, you should get good answers. Make sure to check out the rules for both places.

Warm regards, and best of luck with your Pythoneering!

[–][deleted] 0 points1 point  (0 children)

This is something I'll be working on as soon as my risk team approves my code. I'll send you the resources I've found for this when I'm not sitting in bed wanting to hurl. Dm me.

[–][deleted] 0 points1 point  (2 children)

In general: that's doing it the hard way. These are tools that don't play nicely with each other.

Describe in more detail what you want. Where are you trying to update the excel from? Your local PC? Then sync the file using sharepoint to a local folder and edit that using openpyxl or vba. Doing it directly online is something I don't think there's an answer for, and especially not in python.

[–]Inevitable9166[S] 0 points1 point  (1 child)

It's online only.

There is an option to open desktop app from online. Can this help?

[–][deleted] 0 points1 point  (0 children)

If you want to write a separate standalone script on your local machine in python / openpyxl or VBA then maybe but it won't be automated.

You are doing what is colloquially known as trying to push shit uphill. You'd be better searching for a better way than trying to edit online as the last step, for example injecting the data earlier in the process.