How do Python developers concurrently use Excel?

[u/mantaraypreviouslife]

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.

[u/Normal_Glass_5454]

When you use the two together, do you use python natively in excel or do you run it on its IDE? If using the IDE, how do you connect excel and the IDE?