python pandas 多线程(携程)写入excel

不知道如何优化,写入excel文件依然很慢. 

# -*- coding: utf-8 -*-#
# python 3.6.7
# Description:  
# Author:       zzq
# Date:         2020/4/27

import math
import threadpool
import asyncio
import pandas as pd

def getdata(rows:int, cols:int):
    """
    生成数据矩阵
    :param rows:行
    :param cols:列
    :return:
    """
    array = []
    for rows in range(rows):
        row = []
        for col in range(cols):
            row.append("Row %sCol %s" % (rows, col))
        array.append(row)
    data = pd.DataFrame(array)
    return data


async def do_work_one(name: str, data: pd.DataFrame, start_row: int, writer: pd.ExcelWriter) -> None:
    """
    定义携程对象
    :param name: 线程名字
    :param data: 数据矩阵
    :param start_row: 数据写入开始的行号
    :param writer: 保存文件对象
    :return:
    """
    if start_row == 0:
        data.to_excel(writer, startrow=start_row)
    else:
        data.to_excel(w