按照此方法,肯定不会报错,如果报错,请检查数据或者列名是否有问题(列名千万不要重复,否则肯定报错)
Styler(bg_color=None, bold=False, font=utils.fonts.arial, font_size=12, font_color=None, number_format=utils.number_formats.general, protection=False,
underline=None, border_type=utils.borders.thin, horizontal_alignment=utils.horizontal_alignments.center, vertical_alignment=utils.vertical_alignments.center,
wrap_text=True, shrink_to_fit=True, fill_pattern_type=utils.fill_pattern_types.solid, indent=0, comment_author=None, comment_text=None, text_rotation=0)
import pandas as pd
from styleframe import StyleFrame, Styler, utils
a=[1,2,3]
b=[4,5,6]
c=zip(a,b)
d=["时间",
"电流"]
data=pd.DataFrame(c, columns=d)
df = pd.read_excel('wendang6.xlsx')
print(type(df))
sf = StyleFrame(df)
sf.apply_column_style(cols_to_style=column,
styler_obj=Styler(font="Times New Roman",font_color='red',shrink_to_fit=True,wrap_text=True),
style_header=False)
sf.set_column_width(columns = d,width=20)
sf.set_column_width_dict(col_width_dict={"时间": 10, "电流": 10})
sf.to_excel("235.xlsx").save()
至于其他的就看这个网址把