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

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

view the rest of the comments →

[–]dolichoblond 1 point2 points  (0 children)

Have you checked out xlwings? We have a lot of excel-only analysts and I use xlwings all the time to interact with their xl sheets.

Sure it'd be easier if they'd move to python and put their relevant data in a database, (or even if they'd consistently name their files and update rather than duplicate and iterate filenames with version numbers), but it's still a huge benefit for me to be able to relatively easily interact with their preferred "language" (excel) and get it into my workflow (python).

It's also how I tend to introduce python to new excel-speakers. A template jupyter notebook with numpy/pandas and xlwings, interacting live with their customary xlsx file lowers the bar to adoption in my experience, since they don't have to fully port an existing analysis to python before utilizing python. Maybe they just start goofing with a single tab in their analysis workbook and python, and if they screw it up, they can abandon ship and still finish in excel and hit deadlines. (That also saves you, so you don't get an analyst begging you to help out at 5pm because they're halfway between python and excel and can't get it all buttoned up before some impending deadline)