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

苦橙汁

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

2021-7-5 09:09 上传

点击文件名下载附件

1. import xlrd
   
2. import xlsxwriter
   
3. 
   
4. source_xls ="1.xls"
   
5. target_xls ="3.xls"
   
6. data = []
   
7. wb = xlrd.open_workbook(source_xls)
   
8. for sheet in wb.sheets():
   
9.   for rownum in range(1,sheet.nrows):
   
10.    data.append(sheet.row_values(rownum))#读取表内容
    
11. #print(data)
    
12. 
    
13. workbook = xlsxwriter.Workbook(target_xls)
    
14. worksheet = workbook.add_worksheet()
    
15. 
    
16. for i in range(len(data)):
    
17.   for j in range(len(data[i])):
    
18.    worksheet.write(i, j, data[i][j])
    
19. workbook.close()

复制代码

最佳答案

月排行榜 / 总排行榜

逃兵

2021-7-5 09:27:26

1. import xlrd
   
2. import xlsxwriter
   
3. 
   
4. source_xls ="1.xls"
   
5. target_xls ="3.xls"
   
6. data = [['姓名','地区','业绩']]
   
7. wb = xlrd.open_workbook(source_xls)
   
8. for sheet in wb.sheets():
   
9.     for rownum in range(1,sheet.nrows):
   
10.         data.append([sheet.name] + sheet.row_values(rownum))#读取表内容
    
11. #print(data)
    
12. 
    
13. workbook = xlsxwriter.Workbook(target_xls)
    
14. worksheet = workbook.add_worksheet()
    
15. 
    
16. for i in range(len(data)):
    
17.   for j in range(len(data[i])):
    
18.    worksheet.write(i, j, data[i][j])
    
19. workbook.close()
    

复制代码

跳转到最佳答案楼层

逃兵

1. import xlrd
   
2. import xlsxwriter
   
3. 
   
4. source_xls ="1.xls"
   
5. target_xls ="3.xls"
   
6. data = [['姓名','地区','业绩']]
   
7. wb = xlrd.open_workbook(source_xls)
   
8. for sheet in wb.sheets():
   
9.     for rownum in range(1,sheet.nrows):
   
10.         data.append([sheet.name] + sheet.row_values(rownum))#读取表内容
    
11. #print(data)
    
12. 
    
13. workbook = xlsxwriter.Workbook(target_xls)
    
14. worksheet = workbook.add_worksheet()
    
15. 
    
16. for i in range(len(data)):
    
17.   for j in range(len(data[i])):
    
18.    worksheet.write(i, j, data[i][j])
    
19. workbook.close()
    

复制代码