python保存文件到vsc ，Excel中

保存到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)