Python读取Excel和写入Excel

import pandas as pd

bidList = []

# 读取第一列
df = pd.read_excel('read_excel.xlsx', sheet_name='sheet1', usecols=[0])
data = df.values
num = 0
for bookId in data:
    for bid in bookId:
        num = num + 1
        print("序号："+str(num))
        bidList.append(bid)

writer = pd.ExcelWriter('write_excel.xlsx')
data_df = pd.DataFrame(data=list(bidList))
data_df.to_excel(writer, float_format='%.5f', index=False)
writer.save()