import xlrd
import xlwt
import xlutils
import re
import datetime
import os
i=0
for j in range(1,13):
# address_list = os.listdir(r"D:\Asiastar\test\2015\4月\回执")
address_list = os.listdir(r"D:\Asiastar\test\2014"+"\\"+str(j)+r"月\回执")
# workbook = xlwt.Workbook(encoding='utf-8')
# worksheet = workbook.add_sheet('2016'+str(j))
for address in address_list:
workbook = xlwt.Workbook(encoding='utf-8')
worksheet = workbook.add_sheet('2014' + str(j))
end_address = r"D:\Asiastar\test\2014"+"\\"+str(j)+r"月\回执" + "\\" + address
print(end_address, os.getcwd())
data = xlrd.open_workbook(str(end_address))
table = data.sheet_by_index(1)
total_amount = table.cell_value(41, 3)
date = xlrd.xldate_as_tuple(table.cell_value(3, 2), 0)
# print(date)
name = table.cell_value(5, 2)
# worksheet.write(i, 0, label=name)
# workbook.save('Excel.xls')
date1 = "".join('%s' % id for id in date)
datex = date1[:6]
worksheet.write(i, 0, label=name)
worksheet.write(i, 1, label=datex)
worksheet.write(i, 2, label=total_amount)
workbook.save("2014"+str(j)+'Excel.xls')
i += 1
print(name,datex,total_amount)
# print(total_amount,date,name)
# print(address_list)
其中问题就出在for j in range(1,13)这里。如果改成单个的j=1啥的就可以正常输出到Excel。
pycharm中输出如下图:
请各位大佬帮帮我啊啊啊啊啊啊~~~