保存到Excel中:
# coding:utf-8
import pandas as pd
try:
df = pd.read_excel('data.xlsx')
except FileNotFoundError:
df = pd.DataFrame()
new_data = [['new item 1', 'CR12-2023-540003-17', '公开招标', '2023-04-03 09:00'], ['new item 2', 'CRCC-441-12-1155', '公开招标', '2023-04-03 09:00']]
for row in new_data:
df = df.append(
{'项目名称': row[0], '招标编号': row[1], '招标方式': row[2], '开标时间': row[3]},
ignore_index=True)
df.to_excel('data.xlsx', index=False)
print('新数据已添加到data.xlsx文件中。')
保存到scv中:
new_data = [['new item 1', 'CR12-2023-540003-17', '公开招标', '2023-04-03 09:00'], ['new item 2', 'CRCC-441-12-1155', '公开招标', '2023-04-03 09:00']]
with open('data.csv', 'a', newline='',encoding='utf-8') as file:
writer = csv.writer(file)
writer.writerow(['Title', 'Code', 'Type', 'Date'])
for row in new_data :
writer.writerow(row)