import xlrd
import xlsxwriter
import os
Excel_path="F:/python/Excel文件夹"
source_excel_name_list=os.listdir(Excel_path)
target_excel_name="信息统计.xls"
source_excel=[Excel_path+"/"+i for i in source_excel_name_list]
target_excel = Excel_path+"/"+target_excel_name
Excel_data = []
flag=0
for i in source_excel:
fr = xlrd.open_workbook(i)
for sheet in fr.sheets():
for rownum in range(sheet.nrows):
if ((flag>0)&(rownum<2)):
continue
Excel_data.append(sheet.row_values(rownum))
flag+=1
fw = xlsxwriter.Workbook(target_excel)
worksheet = fw.add_worksheet()
font = fw.add_format({"font_size":14})
for i in range(len(Excel_data)):
for j in range(len(Excel_data[i])):
worksheet.write(i, j, Excel_data[i][j], font)
fw.close()