python 读写操作excel表

def sync_goods_producer(path):
    # doc_data = pandas.read_excel(path, skiprows=44, engine='xlrd')
    doc_data = pandas.read_excel(path,engine='xlrd')
    doc_data = doc_data.where(doc_data.notnull(), '')
    columns = list(doc_data.columns)
    with redis_connect_online.pipeline() as pipe:
        for rank,doc in enumerate(doc_data.values):
            goods_task = dict(zip(columns, doc))
            goods_task['file_name'] = path
            goods_task['rank'] = rank +1
            try:
                url_params = UrlHelper.url_parse(goods_task['商品链接'])
            except KeyError:
                continue
            goods_id=url_params.get('id')
            goods__detail_task = {
                "sta_date": time.strftime(