Excel_Write_openpyxl.py 文件源码

def excel_write(file = 'write_pyxl.xlsx', sheel_name = 'Sheet1', write_dict = dict_excel):
    wb = Workbook()
    ws = wb.active
    #ws = wb.create_sheet()
    #ws.title = "QYT PyXL"
    ws['A1'] = '??'
    ws['B1'] = '??'
    ws['C1'] = '??'
    row_location = 2 
    for x,y in write_dict.items():
        user_locatin = 'A' + str(row_location)
        pass_locatin = 'B' + str(row_location)
        priv_locatin = 'C' + str(row_location)
        ws[user_locatin] = x
        ws[pass_locatin] = y[0]
        ws[priv_locatin] = y[1]
        row_location += 1 
    wb.save(file)