```python
import pandas as pd
import datetime
import numpy as pd
def generate_column_names(start_date, end_date):
column_names = []
date = start_date
while date <= end_date:
column_name = date.strftime("%Y.%m.%d晚")
column_names.append(column_name)
date += datetime.timedelta(days=1)
return column_names
def extract_columns_to_excel(file_path, sheet_name, column_names_func, output_file_path):
# 读取Excel文件
df = pd.read_excel(file_path, sheet_name=sheet_name)
# 使用自定义函数生成列名列表
column_names = column_names_func()
# 提取指定列的数据
extracted_data = df[column_names]
# 将提取的数据保存到新的Excel文件
extracted_data.to_excel(output_file_path, index=False)
# 传入Excel文件路径、工作表名称、自定义列名函数和输出文件路径
file_path = r"D:\附件2 第二年三餐消费数据.xlsx"
sheet_name = "Sheet1"
导入excel数据
import pandas as pd
df = pd.DataFrame()
df.to_excel("D:/Python 集合附件/output.xlsx", index=False)
df2= pd.DataFrame({'STU.ID':[1,2,3,4,5,6],
'name':['张三','张三','张三','张三','张三','张三'],
'class':['一班','二班','三班','一班','二班','一班']})
df2.to_excel("D:/Python 集合附件/output.xlsx", index=False)
print(df2)