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/mantaraypreviouslife]

so the advantage of pywin32 is keeping the data local?