如果存在多个excel,应该会改为最后读到的excel中的指定位置的名字。这儿没做判断和筛选。
import os
import xlrd
dir_1='D:\\sample\\0103\\modify_name'
for fileName in os.listdir(dir_1):
if not os.path.isfile(fileName):
#print fileName
#print dir_1+"\\"+fileName
for sub_fileName in os.listdir(dir_1+"\\"+fileName):
print sub_fileName
try:
data = xlrd.open_workbook(dir_1+"\\"+fileName+"\\"+sub_fileName)
table = data.sheet_by_name(u'Sheet1')
cell_A1 = table.cell(3,1).value
os.rename(fileName,cell_A1)
print cell_A1
except:
print 111
continue
# if not os.path.isfile(sub_fileName):
# print sub_fileName