from openpyxl.worksheet.table import Table, TableStyleInfo
from openpyxl.utils.dataframe import dataframe_to_rows
from openpyxl import Workbook
wb= openpyxl.load_workbook('1.xlsx',"",)
sheet=wb.get_sheet_by_name("5G发展及迁转清单")
ws=wb.active
for r in dataframe_to_rows(data1, index=False, header=True):
ws.append(r)
wb.save("x.xlsx")