Ps:给自己留的备份,以后不想写不想查不想百度不想问了。
import openpyxl
wb_ini = openpyxl.load_workbook('source.xlsx')
ws_ini = wb_ini.active
#逐行读取source文件的数据
content = []
for row in ws_ini.rows:
tmp_list = []
for cell in row:
tmp_list.append(cell.value)
content.append(tmp_list)
wb_wrt = openpyxl.Workbook()
ws_wrt = wb_wrt.active
for item in content:
ws_wrt.append(item)
wb_wrt.save('target.xlsx')