python合并多个表格（没有表头）

首先需要安装python环境

见本人发表的：python及pycharm安装python及pycharm安装_susan花雨的博客-CSDN博客

用pip install 安装

pip install xlrd

pip install xlwt
pip install xlsxwriter

pip list查看

python合并多个表格：可以将每个表的不同sheet中的内容合并到一个表中

代码：

————————————————————————

import xlrd
import xlsxwriter

source_xls = ["1.xlsx", "2.xlsx"]
target_xls = "3.xlsx"

# 读取数据
data = []
for i in source_xls:
    wb = xlrd.open_workbook(i)
    for sheet in wb.sheets():
        for rownum in range(sheet.nrows):
            data.append(sheet.row_values(rownum))
print(data)
# 写入数据
workbook = xlsxwriter.Workbook(target_xls)
worksheet = workbook.add_worksheet()
font = workbook.add_format({"font_size":14})
for i in range(len(data)):
    for j in range(len(data[i])):
        worksheet.write(i, j, data[i][j], font)
# 关闭文件流
workbook.close()

——————————————————————

其中1.xlsx，2.xlsx是要合并的表格，3.xlsx是运行程序后的表格