pip install Spire.XLS

from spire.xls import *
from spire.xls.common import *

def ConvertHtmlToExcel():
    """將 HTML 文件轉(zhuǎn)換為 Excel"""
    inputFile = "/input/表格.html"
    outputFile = "/output/Html轉(zhuǎn)Excel.xlsx"
    
    # 創(chuàng)建工作簿對(duì)象
    workbook = Workbook()
    
    # 從 HTML 文件加載內(nèi)容
    workbook.LoadFromHtml(inputFile)
    
    # 保存為 Excel 格式（Excel 2013）
    workbook.SaveToFile(outputFile, ExcelVersion.Version2013)

if __name__ == "__main__":
    ConvertHtmlToExcel()

from spire.xls import *
from spire.xls.common import *

def InsertHtmlIntoCell():
    """將 HTML 字符串插入 Excel 單元格"""
    outputFile = "InsertHtmlStringIntoCell.xlsx"
    
    # 創(chuàng)建工作簿
    workbook = Workbook()
    
    # 獲取第一個(gè)工作表
    sheet = workbook.Worksheets[0]
    
    # 定義 HTML 字符串
    htmlCode = "<div>第一行<strong>第二行（加粗）</strong>第三行</div>"
    
    # 將 HTML 字符串插入到 A1 單元格
    cell_range = sheet["A1"]
    cell_range.HtmlString = htmlCode
    
    # 保存文件
    workbook.SaveToFile(outputFile, ExcelVersion.Version2013)
    workbook.Dispose()
    
    print(f"HTML 字符串已插入，Excel 文件已保存至: {outputFile}")

if __name__ == "__main__":
    InsertHtmlIntoCell()

from spire.xls import *
from spire.xls.common import *

def ConvertMultiTableHtml():
    """轉(zhuǎn)換包含多個(gè)表格的 HTML 文件"""
    inputFile = "./Demos/Data/MultiTable.html"
    outputFile = "MultiTableExcel.xlsx"
    
    # 創(chuàng)建工作簿并加載 HTML
    workbook = Workbook()
    workbook.LoadFromHtml(inputFile)
    
    # 遍歷所有工作表并重命名
    for i in range(workbook.Worksheets.Count):
        sheet = workbook.Worksheets[i]
        sheet.Name = f"表格_{i + 1}"
        
        # 自動(dòng)調(diào)整列寬以適應(yīng)內(nèi)容
        sheet.AllocatedRange.AutoFitColumns()
    
    # 保存文件
    workbook.SaveToFile(outputFile, ExcelVersion.Version2013)
    workbook.Dispose()
    
    print(f"多表格 HTML 轉(zhuǎn)換完成，文件已保存至: {outputFile}")

if __name__ == "__main__":
    ConvertMultiTableHtml()

import urllib.request
from spire.xls import *
from spire.xls.common import *
import tempfile
import os

def ConvertUrlToExcel(url, output_file):
    """從 URL 加載 HTML 并轉(zhuǎn)換為 Excel"""
    
    # 下載 HTML 內(nèi)容
    print(f"正在下載: {url}")
    response = urllib.request.urlopen(url)
    html_content = response.read().decode('utf-8')
    
    # 創(chuàng)建臨時(shí) HTML 文件
    with tempfile.NamedTemporaryFile(mode='w', suffix='.html', delete=False, encoding='utf-8') as temp_file:
        temp_file.write(html_content)
        temp_html_path = temp_file.name
    
    try:
        # 創(chuàng)建工作簿并加載 HTML
        workbook = Workbook()
        workbook.LoadFromHtml(temp_html_path)
        
        # 自動(dòng)調(diào)整所有工作表的列寬
        for sheet in workbook.Worksheets:
            sheet.AllocatedRange.AutoFitColumns()
        
        # 保存為 Excel
        workbook.SaveToFile(output_file, ExcelVersion.Version2013)
        workbook.Dispose()
        
        print(f"轉(zhuǎn)換完成，Excel 文件已保存至: {output_file}")
        
    finally:
        # 清理臨時(shí)文件
        if os.path.exists(temp_html_path):
            os.remove(temp_html_path)

def main():
    # 示例：從網(wǎng)頁(yè)轉(zhuǎn)換（請(qǐng)?zhí)鎿Q為實(shí)際 URL）
    # ConvertUrlToExcel(
    #     "https://example.com/data-table.html",
    #     "WebData.xlsx"
    # )
    print("URL 轉(zhuǎn)換函數(shù)已定義，取消注釋 main() 中的代碼即可使用")

if __name__ == "__main__":
    main()

import os
from spire.xls import *
from spire.xls.common import *

class HtmlToExcelConverter:
    """HTML 轉(zhuǎn) Excel 批量轉(zhuǎn)換器"""
    
    def __init__(self, output_folder=None):
        self.output_folder = output_folder or "./Excel_Output"
        
        # 創(chuàng)建輸出文件夾
        if not os.path.exists(self.output_folder):
            os.makedirs(self.output_folder)
    
    def convert_single_file(self, input_file, output_file=None):
        """轉(zhuǎn)換單個(gè) HTML 文件為 Excel"""
        try:
            workbook = Workbook()
            workbook.LoadFromHtml(input_file)
            
            # 自動(dòng)調(diào)整所有工作表的列寬
            for sheet in workbook.Worksheets:
                sheet.AllocatedRange.AutoFitColumns()
            
            if output_file is None:
                base_name = os.path.splitext(os.path.basename(input_file))[0]
                output_file = os.path.join(self.output_folder, f"{base_name}.xlsx")
            
            workbook.SaveToFile(output_file, ExcelVersion.Version2013)
            workbook.Dispose()
            
            print(f"? 轉(zhuǎn)換成功: {os.path.basename(input_file)}")
            return True
            
        except Exception as e:
            print(f"? 轉(zhuǎn)換失敗 {os.path.basename(input_file)}: {str(e)}")
            return False
    
    def batch_convert(self, input_folder):
        """批量轉(zhuǎn)換文件夾中的所有 HTML 文件"""
        html_files = []
        
        # 查找所有 HTML 文件
        for filename in os.listdir(input_folder):
            if filename.lower().endswith(('.html', '.htm')):
                html_files.append(os.path.join(input_folder, filename))
        
        if not html_files:
            print(f"在 {input_folder} 中未找到 HTML 文件")
            return
        
        print(f"找到 {len(html_files)} 個(gè) HTML 文件，開(kāi)始轉(zhuǎn)換...")
        
        success_count = 0
        fail_count = 0
        
        for html_file in html_files:
            if self.convert_single_file(html_file):
                success_count += 1
            else:
                fail_count += 1
        
        print(f"\n轉(zhuǎn)換完成!")
        print(f"成功: {success_count} 個(gè)文件")
        print(f"失敗: {fail_count} 個(gè)文件")
        print(f"輸出目錄: {self.output_folder}")

def main():
    # 創(chuàng)建轉(zhuǎn)換器實(shí)例
    converter = HtmlToExcelConverter("./Excel_Output")
    
    # 批量轉(zhuǎn)換
    converter.batch_convert("./HTML_Files")
    
    # 或者轉(zhuǎn)換單個(gè)文件
    # converter.convert_single_file("./Data/Table.html")

if __name__ == "__main__":
    main()