# 党史学习教育我为群众办实事各类数据汇总

import os
import openpyxl as opx
import xlwings as xw
import csv


# dir='E:\市直数据统计'

dir='E:\市直数据统计'
list_dir=os.listdir(dir)
list_name=[]
list_all=[]
print(list_dir)
for name in list_dir:
    name=name.split('.',1)[0]
    print(name)
    list_name.append(name)
for book in list_dir:
    app=xw.App(visible=True,add_book=False)
    book_dir=os.path.join(dir,book)
    book_name=book.split('.',1)[0]
    print(book_dir)
    wb=app.books.open(book_dir)
    ws=wb.sheets[0]
    value_list=ws.range('c8:o8').value
    value_list.insert(0,book_name)
    print(value_list)
    list_all.append(value_list)
    # open('')
    wb.app.quit()
print(list_all)
# # ws.append([1,2,3])#以行的形式添加数据
the_wb=opx.Workbook()
ws=the_wb._sheets[0]
for row in list_all:
    ws.append(row)

the_wb.save('c1.xlsx')