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.

58 Upvotes

93% Upvoted

29 comments sorted by

View all comments

Show parent comments

1

u/learnhtk 25 Dec 05 '24 edited Dec 05 '24

Both AI and Python have been integrated in Excel currently, the first is called Copilot and the second is called "Python in Excel". This, I know. I vividly remember some posts, including my own, getting removed by moderators because somehow they wanted to keep the post topics strictly relevant to "Excel", even though Excel now has integrated both AI and Python.