openpyxl包使用——生成excel文件

from openpyxl import *
excel_name = 'results.xlsx'
​
def creat_excel():
    # 创建并打开excel文件，以备后续数据存入
    # 创建一个Workbook对象
    wb = Workbook()
    # 获取当前活跃的sheet，默认是第一个sheet
    ws = wb.active
​
    res_vals = ['Picture uid',
                'Retrieval uid',
                'Retrieval dist',
                'Retrieval confidence',
                'Time',
                ]
    # 设置列宽
    for i in range(len(res_vals)):
        ws.column_dimensions['%c' % (i + 65)].width = 22.0
        ws['%c1' % (i + 65)] = res_vals[i]
    wb.save(excel_name)
​
​
if __name__ == "__main__":
    creat_excel()
    now_time = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time()))
    wb = load_workbook(excel_name)
    sheet = wb.worksheets[0]
    # 添加行
    sheet.append(['uid', 'result_uid', 'result_dist', 'result_confidence', now_time])
    wb.save(excel_name)