Sometimes your customer wants to see some data analysis results in Excel. You could do this with a CSV export, but it’s really handy to deliver one Excel file with multiple worksheets and proper column headers.

Also the type of customers that want Excel exports usually have weird configurations that make CSV files work incorrectly, like requiring semicolons instead of colons.

And if you did data analysis, chances are you’ve already used Pandas. So instead of saving a CSV file, you can just save an Excel file.

Dependencies

You need to have odfpy and pandas installed. This can be done as follows.

python -m pip install odfpy pandas

Code example

Here’s a quick example.

import pandas as pd

excel_writer = pd.ExcelWriter("output.ods")

col1 = [1, 2, 3]
col2 = [4, 5, 6]

df = pd.DataFrame({
    "Col1": col1,
    "Col2": col2,
})

df.to_excel(excel_writer, index=False, sheet_name="Sheet one")

excel_writer.close()

You can call to_excel with different sheet names to get multiple worksheets in the Excel file. Or call to_excel multiple times with the same sheet name to get multiple tables written in the same page.