python实现excel文件合并
时间: 2023-11-24 20:51:09 浏览: 44
以下是Python实现Excel文件合并的代码示例:
```python
import os
import xlrd
import xlsxwriter
# 定义要合并的Excel文件所在文件夹路径
folder_path = r'C:\Users\Administrator\Desktop\excel_files'
# 定义要合并的Excel文件后缀名
file_extension = 'xls'
# 获取文件夹中所有后缀名为file_extension的文件名
file_names = [file_name for file_name in os.listdir(folder_path) if file_name.endswith(file_extension)]
# 定义一个空列表,用于存储所有Excel文件中的数据
data_list = []
# 遍历所有Excel文件,将每个文件中的所有sheet的数据存储到data_list中
for file_name in file_names:
file_path = os.path.join(folder_path, file_name)
workbook = xlrd.open_workbook(file_path)
for sheet_name in workbook.sheet_names():
sheet = workbook.sheet_by_name(sheet_name)
for row_num in range(sheet.nrows):
row_data = sheet.row_values(row_num)
data_list.append(row_data)
# 将所有数据写入到一个新的Excel文件中
output_file_path = os.path.join(folder_path, 'final.xlsx')
workbook = xlsxwriter.Workbook(output_file_path)
worksheet = workbook.add_worksheet()
for row_num, row_data in enumerate(data_list):
for col_num, col_data in enumerate(row_data):
worksheet.write(row_num, col_num, col_data)
workbook.close()
```