在Python Polars生成excel中禁用负值的字体 colored颜色格式

发布于09月18日

我想禁用极点write_excel中负值的自动字体着色.有什么建议吗？

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)

这就是它所产生的-

推荐答案

column_formats={cs.numeric():'General'}或column_formats={x:'[Black]' for x in df2.columns}就行了.

import numpy as np
import polars as pl
import polars.selectors as cs
import xlsxwriter

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

with xlsxwriter.Workbook(r'C:\SUVOPAM_local\Try\_out_.xlsx') as workbook:
    df2.write_excel(workbook=workbook, worksheet='sheet1',
                    autofit=True, table_style=None,  dtype_formats=None,
                    column_formats={cs.numeric():'General'}, # column_formats={x:'[Black]' for x in df2.columns}
                    conditional_formats=False, float_precision=0, sparklines=None, formulas=None)

产生-