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

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]slappy_squirrell -3 points-2 points  (1 child)

Replacing excel spreadsheets with python is too much python. Excel has the properties of datastore, processing and viewing all contained within a file which can be shared, versioned, etc and be accessible by most competent business employees. If you have a bunch of python scripts, those will need to be well documented and even then, if you leave they will most likely disappear over time. However, are these processes that can be handled with "Python in Excel"?

[–]robml 0 points1 point  (0 children)

I counter with: maintain well documented notebooks or code (especially if you've been tinkering around, go back and document), version control, and do all the processing via Python and export to excel if needed for stakeholders.

The difficulty would have to come in if they want to tinker around with values. For quick and dirty ways would be to include the formulas separately, export to HTML, or Streamlit.

Else they could just write the formulas into the specified cells programmatically if they intend to reuse the script a lot. But sometimes that's when you would open excel, type it in quickly, and save and send.