不好意思想请教各位先进,小弟初学,试着写出问题上的内容
但写出来却会将所有内容套进每个分页,如下:
import xlrd
import xlsxwriter
source_xls = ["1.xlsx", "2.xlsx"]
target_xls = "Final.xlsx"
data = []
sh = ["1", "2", "3", "4", "5", "6"]
for i in source_xls:
rwb = xlrd.open_workbook(i)
rws = rwb.sheet_by_name("2019")
print (rws.name,rws.nrows,rws.ncols)
for rownum in range(rws.nrows):
data.append(rws.row_values(rownum))
wwb = xlsxwriter.Workbook(target_xls)
for j in sh:
wws = wwb.add_worksheet(j)
font = wwb.add_format({"font_size":10})
for k in range(len(data)):
for l in range(len(data[k])):
wws.write(k, l, data[k][l], font)
data.clear()
wwb.close()
主要是想将各档案内的同一命名分页撷取至新档案的各分页并分别命名,想请教各位先进我脑洞在哪