[Solved] Formatting cells of a pandas dataframe into an OpenDocument ods spreadsheet

[Calab]

I am generating an OpenDocument spreadsheet file. I can create the file without issue, but without any formatting.

I would like to add formatting, such as bolding the top row and changing the color of negative cells.

Using documentation I found online, I found code that works with an Excel spreadsheet, but not an OpenDoc spreadsheet.

My code:

    with pd.ExcelWriter(path=odf_file,
                        engine='odf',
                        ) as writer:
        df_new_data.to_excel(writer, 
                             index=False, 
                             sheet_name=sheet_name,)
        workbook = writer.book
        worksheet = writer.sheets[sheet_name]
                
        bold_format = workbook.add_format({'bold': True})
        worksheet.set_row(0,0, bold_format)

This fails with the following error:
AttributeError: 'OpenDocument' object has no attribute 'add_format'

So, it looks like the odf engine works differently than the xlsxwriter engine. I can't find any documentation for the odf engine, so I don't know how to apply formatting.

I would just use the xlsxwriter engine, but I need to be able to open the file with OpenOffice, which doesn't seem to work.

Can someone point me in the right direction?

[Calab]

I am generating an OpenDocument spreadsheet file. I can create the file without issue, but without any formatting.

I would like to add formatting, such as bolding the top row and changing the color of negative cells.

I was unable to find any way to format an .ods file so I switched to the openpyxl engine and will use LibreOffice to work on the resulting file as it supports the .xlsx file format for reading and writing, unlike OpenOffice.