作者monsterbird (Nomar)
看板Python
标题[问题] Excel多档案取分页集中至新Excel各分页
时间Wed May 8 22:25:36 2019
不好意思想请教各位先进,小弟初学,试着写出问题上的内容
但写出来却会将所有内容套进每个分页,如下:
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()
主要是想将各档案内的同一命名分页撷取至新档案的各分页并分别命名,想请教各位先进我脑洞在哪
--
※ 发信站: 批踢踢实业坊(ptt.cc), 来自: 59.124.3.247
※ 文章网址: https://webptt.com/cn.aspx?n=bbs/Python/M.1557325538.A.059.html
1F：→ bookstar07: 把for j in sh:拔出来不要写在for i in source_xls:内 05/10 11:08