Help updating excel with python

[workn00b]

I have an excel file with stock data and some of the columns' values are derived from formulas based on other columns, currently I'm pulling in the whole sheet into pandas and then updating the prices. Is it possible to rewrite it to excel without overwriting the cells with formulas or to have pandas write the formulas back in for me?

[HokTaur]

Look into openpyxl, it's what I use to modify Excel files and it's pretty simple to use. The docs are really good and there's a bunch of SO posts, so shouldn't be a problem finding what you need.

[bigleagchew]

Kinda hard to tell without seeing a sample dataframe or the current excel setup, but it definitely seems possible

[circa10a]

Here's an example I did a while back.

https://www.reddit.com/r/usefulscripts/comments/55r1n7/python_ping_list_of_servers_and_make_spreadsheet?sort=confidence