[問題] Excel多檔案取分頁集中至新Excel各分頁
不好意思想請教各位先進,小弟初學,試著寫出問題上的內容
但寫出來卻會將所有內容套進每個分頁,如下:
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://www.ptt.cc/bbs/Python/M.1557325538.A.059.html
→
05/10 11:08,
5年前
, 1F
05/10 11:08, 1F