xlsxwriter python API

I’ve lately been doing a real deep dive into the xlsxwriter python API.

It’s great – you can take any PANDAS data frame and convert it into a Microsoft Excel spreadsheet with formulas and full formatting, including merged cells, number formats, page layout, headers and footers – it looks like one had created the final output in Excel – but done programmatically so the computer does all the work and you could potentially crank out hundreds of nicely formatted, customized Excel files in a few seconds.

Leave a Reply

Your email address will not be published. Required fields are marked *