unoconv VS XlsxWriter

I personally view it in google docs, their is the unoconv utility for libreoffice which converts odt to pdf and you can be view it zathura.

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/