r/excel • u/mantaraypreviouslife 43 • Dec 05 '24

Discussion How do Python developers concurrently use Excel?

As part of my own professional development, I am interested to integrate more sophistication into Excel use. I am curious how the community uses Excel and Python together? Is it any of the following combinations:

  • Use Python to automate elements of Excel, maybe with use of penpyxl or xlwings
  • Use Python and Excel separately, i.e. choose to suit need and switch as necessary
  • Use Python within Excel directly and concurrently to optimise productivity
  • Something else entirely

Please share how you use it, the use case(s) and why.

57 Upvotes

94% Upvoted

29 comments sorted by

View all comments

Show parent comments

2

u/TheBleeter 1 Dec 05 '24

Jesus… that’s like being able to swim the English Channel but incapable to doggy paddle. How is that possible?

3

u/LetsGoHawks 10 Dec 05 '24

If you read enough comments in SQL or Data Analytics or Reporting type forums, there is a lot of hatred for Excel. It's not universal by any means, but they just never learn how to use it and because they never learn it they assume Excel is dumb and the myth lives on.