[Python] Disable font colour formatting for negetive values in python Polars generated excel

Discussão em 'Python' iniciado por Stack, Julho 7, 2025.

  1. Stack

    Stack Membro Participativo

    I would like to disable automatic font colouring of negetive values in polars write_excel. Any tip?

    import polars as pl
    import xlsxwriter

    df2 = pl.DataFrame(data=np.random.randint(-10, 10, 5*3).reshape(-1, 3), schema=['x', 'y', 'z'])

    with xlsxwriter.Workbook(r'_out_.xlsx') as workbook:
    df2.write_excel(workbook=workbook, worksheet='sheet1',
    autofit=True, table_style=None, column_formats=None,
    conditional_formats=False, float_precision=0, sparklines=None, formulas=None)


    This is what it generates -

    [​IMG]

    Continue reading...

Compartilhe esta Página