给excel表中追加内容

特别注意：

excel_name = "D:/gamble/gamble_ysf.xlsx"   ——————不能写成  excel_name = "D:\gamble\gamble_ysf.xlsx"

content_list——————是一个多维列表

主要用的是numpy和pandas
datafram要转换成array
在把array转成list
这样就比较容易操作了



import os
import time
import pandas as pd
import numpy as np

def append_excel(df, content_list):
    """
    excel文件中追加内容
    :return:
    """

    print("开始存入")
    ds = pd.DataFrame(content_list)
    print(ds)
    df = df.append(ds, ignore_index=True)
    excel_name = "/gamble_ysf.xlsx"
    excel_path = os.path.dirname(os.path.abspath(__file__)) + excel_name
    df.to_excel(excel_path, index=False, header=False)
if __name__ == ‘__main__‘:
    io = r‘D:\gamble\gamble_ysf1.xlsx‘
    data = pd.read_excel(io,sheet_name="cood",usecols=[0,1,3]).drop_duplicates()
    dataSet=np.array(data.dropna())    #datafram转numpy.array
    dataSet=dataSet.tolist()     #numpy.array转list
    excel_name = "/gamble_ysf.xlsx"
    excel_path = os.path.dirname(os.path.abspath(__file__)) + excel_name
    time_array = time.localtime(time.time())
    time_str = time.strftime("%Y-%m-%d", time_array)
    df = pd.read_excel(excel_path, header=None)
    b=[]
    for i in dataSet:
        a = []
        url = i[0]
        time = time_str
        tel = ""
        bank_card = i[2]
        code_uel = ""
        a.append(url)
        a.append(time)
        a.append(tel)
        a.append(str(bank_card))
        a.append(code_uel)
        b.append(a)
        print(url,time,bank_card)
        da = append_excel(df, b)
        print(da)

给excel表中追加内容

原文：https://www.cnblogs.com/zhu-lin-11211/p/13188050.html