ExcelJS VS XlsxWriter

For exporting to Excel from Javascript, I use ExcelJS

ExcelJS and XLSX (SheetJS) are great libraries to work with XLSX files. The former I've found a bit easier to work with but less efficient in general.

If you want to go the JavaScript route on the client-side, there is ExcelJS.

I personally have used https://github.com/exceljs/exceljs in the past.

It looks like exceljs is able to word directly with buffers: https://github.com/exceljs/exceljs#reading-xlsx

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/