xlwings VS XlsxWriter

Reading the headline, I initially thought that Microsoft bought the company behind XLWings [1], which also enables you to use Excel directly within Excel, even locally. Not affiliated in any kind to that company, just used it in the past.

[1] https://www.xlwings.org/

xlWings https://www.xlwings.org/

I'm trying to automate a report and I know xlwings does not support pivot tables and slicers, as it is essentially a pywin32 wrapper. You can directly reference the COM object using .api and constants

Also you can also use xlwings library to build an excel add-on to replace or even augment VBA.

You want xlwings (my preferred) or openpyxl

You could look at using Python from Excel using xlwings.

Xlwings is superior anyway.

xlwings - open source and free - https://www.xlwings.org/

openpyxl

If you must, use xlsxwriter to write it directly into the Excel spreadsheet. This is kind of a pain. If you can get away with, say, writing the data to a CSV and then copy-pasting it into the Excel sheet, you should do that instead because it's so much more conceptually simple and works directly with the Python data structures that you parsed in Step 3. Automation doesn't have to be completely fire-and-forget to save you a ton of time!

https://xlsxwriter.readthedocs.io/ is what you are looking for most probably. Try using this library instead of pyplot for the above steps

xlsxwriter…

I've been in this situation a few times. I would just open the excel sheet in python using xlsxwriter: https://xlsxwriter.readthedocs.io/

Bam! https://xlsxwriter.readthedocs.io

For the opposite direction, I have had good luck with the XlsxWriter library

https://github.com/jmcnamara/XlsxWriter

I'm less familiar with the R ecosystem, but there are tools in the Python world to go that direction -- https://xlsxwriter.readthedocs.io/