如果存在，则将HTML表格数据导出到现有工作簿的新工作表中，否则更新该现有工作表

from openpyxl import Workbook
from bs4 import BeautifulSoup

# 假设表格数据已经存储在名为"table.html"的HTML文件中
with open("table.html") as f:
    html_data = f.read()

# 解析HTML表格数据
soup = BeautifulSoup(html_data, "html.parser")
table = soup.find("table")

# 创建或打开现有工作簿
workbook = Workbook()
sheet = workbook.active

# 创建新工作表
new_sheet = workbook.create_sheet(title="新工作表")

# 写入表格数据
for row in table.find_all("tr"):
    sheet.append([cell.get_text(strip=True) for cell in row.find_all("td")])

# 或者写入到新工作表
for row in table.find_all("tr"):
    new_sheet.append([cell.get_text(strip=True) for cell in row.find_all("td")])

# 保存工作簿
workbook.save("existing_workbook.xlsx")