用python合并excel问题
读取一个表的内容后，在表里加一列填充为表名，再合并。如图示：
把“张三”、“李四”表合成后面的样子，我能取出数据，但是不知道怎么添加表名到列中，请大家指教！
excel见附件。
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)):
worksheet.write(i, j, data)
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.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)):
worksheet.write(i, j, data)
workbook.close()
页:
[1]