[已解决]用python合并excel问题

苦橙汁

读取一个表的内容后，在表里加一列填充为表名，再合并。
如图示：
把“张三”、“李四”表合成后面的样子，我能取出数据，但是不知道怎么添加表名到列中，请大家指教！
excel见附件。
1.rar (6.52 KB, 下载次数: 3)

2021-7-5 09:09 上传

点击文件名下载附件

import xlrd
import xlsxwriter 

source_xls ="1.xls"
target_xls ="3.xls"
data = []
wb = xlrd.open_workbook(source_xls)
for sheet in wb.sheets():
  for rownum in range(1,sheet.nrows):
   data.append(sheet.row_values(rownum))#读取表内容
#print(data)

workbook = xlsxwriter.Workbook(target_xls)
worksheet = workbook.add_worksheet()

for i in range(len(data)):
  for j in range(len(data[i])):
   worksheet.write(i, j, data[i][j])
workbook.close()

最佳答案

月排行榜 / 总排行榜

逃兵

2021-7-5 09:27:26

import xlrd
import xlsxwriter 

source_xls ="1.xls"
target_xls ="3.xls"
data = [['姓名','地区','业绩']]
wb = xlrd.open_workbook(source_xls)
for sheet in wb.sheets():
    for rownum in range(1,sheet.nrows):
        data.append([sheet.name] + sheet.row_values(rownum))#读取表内容
#print(data)

workbook = xlsxwriter.Workbook(target_xls)
worksheet = workbook.add_worksheet()

for i in range(len(data)):
  for j in range(len(data[i])):
   worksheet.write(i, j, data[i][j])
workbook.close()

跳转到最佳答案楼层

逃兵

import xlrd
import xlsxwriter 

source_xls ="1.xls"
target_xls ="3.xls"
data = [['姓名','地区','业绩']]
wb = xlrd.open_workbook(source_xls)
for sheet in wb.sheets():
    for rownum in range(1,sheet.nrows):
        data.append([sheet.name] + sheet.row_values(rownum))#读取表内容
#print(data)

workbook = xlsxwriter.Workbook(target_xls)
worksheet = workbook.add_worksheet()

for i in range(len(data)):
  for j in range(len(data[i])):
   worksheet.write(i, j, data[i][j])
workbook.close()