python写数据到excel

def wirte_to_excel(sug_rs, search_rs, statistics_rs, filename):  # openpyxl库储存数据到excel
    wb = op.Workbook()  # 创建工作簿对象
    sug_sheet = wb.active  #获取第一个默认的sheet
    sug_sheet.title = 'aa' #修改第一个默认sheet的名字
    for row in sug_rs:
        sug_sheet.append(row)
    search_sheet = wb.create_sheet('bb')  # 创建子表
    for row in search_rs:
        search_sheet.append(row)
    statistics_sheet = wb.create_sheet('cc')  # 创建子表
    for row in statistics_rs:
        statistics_sheet.append(row)
    wb.save(filename)