import os
import xlrd
import xlwt
from xlutils.copy import copy
import re

root0 = os.getcwd()
libznames = os.listdir(root0+'/'+'待处理表格存放')
# print ('请输入标准号：')
# bzname = input()
# xlcreate = xlwt.Workbook(encoding='utf-8')
i=0
xlw = xlwt.Workbook()
shw = xlw.add_sheet('已处理', True)
for bzname in libznames:
        bzname = re.sub('.xlsx', '', bzname)
        print(bzname)
        xl = root0 + '/'+'待处理表格存放'+'/' + bzname + '.xlsx'
        xlopen = xlrd.open_workbook(xl)
        sh= xlopen.sheet_by_name('table1')
        nrows = sh.nrows
        ncols = sh.ncols
        lir0info = sh.row_values(0, 0, ncols)
        for a in range(ncols):
                        if lir0info[a] == '分类名称':
                                liFL = sh.col_values(a)
        flname = liFL[1]
        shw.write(i,0,bzname)
        shw.write(i,2,flname)
        i=i+1
xlw.save(root0+'/'+ '产品分类名称.xls')
print ('产品分类获取完成')