Python openpyxl

from openpyxl import Workbook
from openpyxl.styles import Font, colors, Alignment

wb = Workbook()
    ws = wb.active

    ws['A1'] = 'ip'



    for x in cal_path(s):
        for x in xls(s,split_path(x)[1]):
            ws.append(x)


    ws.row_dimensions.height=20 #调整行高
    ws.column_dimensions.width=40 #调整列高

    wb.save(xxxxx.xls)
点赞

发表评论

电子邮件地址不会被公开。必填项已用 * 标注

17 − 3 =