pandas_excel_等笔记

# def frameToSheet(df, sheet)

def frameToSheet(df, sheet):
    def set_style(name, height, colorIndx, bold=False, center=False, border=False):
        style = xlwt.XFStyle()
        font = xlwt.Font()
        font.name = name
        font.bold = bold  # 加粗
        font.colour_index = colorIndx
        font.height = height
        style.font = font
        if center:
            alm = xlwt.Alignment()
            alm.horz = xlwt.Alignment.HORZ_CENTER
            style.alignment = alm
        if border:
            borders = xlwt.Borders()  # 边框
            borders.left = 1
            borders.right = 1
            borders.bottom = 1
            borders.top = 1
            style.borders = borders
        return style
    style_column = set_style('Arial', 200, 0, bold=True, center=True, border=True)
    style_red = set_style('Arial', 200, 2)
    style = set_style('Arial', 200, 0)

    cols = df.columns.tolist()
    for col in range(len(cols)):
        sheet.write(0, col, str(cols[col]), style_column)

    for i in range(int(df.shape[0])):
        for j in range(int(df.shape[1])):
            sheet.write(i + 1, j, df.iat[i, j])