pip install Spire.XLS

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

def ConvertExcelToPDF():
    """將 Excel 工作簿轉換為 PDF"""
    inputFile = "/input/Population.xlsx"
    outputFile = "/output/ToPDF.pdf"
    
    # 創(chuàng)建工作簿對象
    workbook = Workbook()
    
    # 加載 Excel 文件
    workbook.LoadFromFile(inputFile)
    
    # 設置工作表適配頁面（確保內容完整顯示）
    workbook.ConverterSetting.SheetFitToPage = True
    
    # 保存為 PDF 格式
    workbook.SaveToFile(outputFile, FileFormat.PDF)
    workbook.Dispose()
    
if __name__ == "__main__":
    ConvertExcelToPDF()

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

def FitWidthWhenConvertToPDF():
    """轉換時讓內容寬度適配到一頁"""
    inputFile = "./Demos/Data/SampleB_2.xlsx"
    outputFile = "FitWidthWhenConvertToPDF.pdf"
    
    # 加載 Excel 文件
    workbook = Workbook()
    workbook.LoadFromFile(inputFile)
    
    # 遍歷所有工作表，設置頁面適配
    for sheet in workbook.Worksheets:
        # 設置高度不限制（0 表示自動）
        sheet.PageSetup.FitToPagesTall = 0
        # 設置寬度適配到 1 頁
        sheet.PageSetup.FitToPagesWide = 1
    
    # 保存為 PDF
    workbook.SaveToFile(outputFile, FileFormat.PDF)
    workbook.Dispose()
    
    print(f"寬度適配轉換完成，PDF 文件已保存至: {outputFile}")

if __name__ == "__main__":
    FitWidthWhenConvertToPDF()

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

def ConvertSelectedRangeToPDF():
    inputFile = "/input/Population.xlsx"
    outputFile = "/output/SelectedRangeToPDF.pdf"
    
    # 加載原始 Excel 文件
    source_workbook = Workbook()
    source_workbook.LoadFromFile(inputFile)
    source_sheet = source_workbook.Worksheets[0] # 獲取第一個工作表
    
    # 創(chuàng)建一個全新的、干凈的臨時 Workbook
    target_workbook = Workbook()
    target_workbook.CreateEmptySheets(1) # 嚴格控制：只創(chuàng)建 1 個工作表
    target_sheet = target_workbook.Worksheets[0]
    
    # 復制指定區(qū)域 (A4:E9) 到新 Workbook 的 A4:E9
    source_sheet.Range["A4:E9"].Copy(
        target_sheet.Range["A4:E9"], 
        False,  # 不復制公式
        True    # 復制格式
    )
    
    # 自動調整列寬
    target_sheet.Range["A4:E9"].AutoFitColumns()
    
    # 保存這個單獨的 Workbook 為 PDF
    target_workbook.SaveToFile(outputFile, FileFormat.PDF)
    
    source_workbook.Dispose()
    target_workbook.Dispose()

if __name__ == "__main__":
    ConvertSelectedRangeToPDF()

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

def ConvertEachWorksheetToSeparatePDF():
    """將每個工作表轉換為獨立的 PDF 文件"""
    inputFile = "./Demos/Data/EachWorksheetToDifferentPDFSample.xlsx"
    
    # 加載 Excel 文件
    workbook = Workbook()
    workbook.LoadFromFile(inputFile)
    
    # 遍歷所有工作表
    for sheet in workbook.Worksheets:
        # 使用工作表名稱作為 PDF 文件名
        FileName = sheet.Name + ".pdf"
        
        # 將當前工作表單獨保存為 PDF
        sheet.SaveToPdf(FileName)
        
        print(f"工作表 '{sheet.Name}' 已轉換為 {FileName}")
    
    workbook.Dispose()
    print("所有工作表轉換完成")

if __name__ == "__main__":
    ConvertEachWorksheetToSeparatePDF()

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

def ConvertToPDFA1B():
    """將 Excel 轉換為 PDF/A-1B 標準格式"""
    inputFile = "./Demos/Data/ToPDF_A1BExample.xlsx"
    outputFile = "ToPDFA1B.pdf"
    
    # 創(chuàng)建工作簿并加載文件
    workbook = Workbook()
    workbook.LoadFromFile(inputFile)
    
    # 設置 PDF 一致性級別為 PDF/A-1B
    workbook.ConverterSetting.PdfConformanceLevel = PdfConformanceLevel.Pdf_A1B
    
    # 保存為 PDF
    workbook.SaveToFile(outputFile, FileFormat.PDF)
    workbook.Dispose()
    
    print(f"PDF/A-1B 文件已保存至: {outputFile}")

if __name__ == "__main__":
    ConvertToPDFA1B()

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

def ConvertCSVToPDF():
    """將 CSV 文件轉換為 PDF"""
    inputFile = "./Demos/Data/CSVSample.csv"
    outputFile = "CSVToPDF.pdf"
    
    # 創(chuàng)建工作簿并加載 CSV 文件
    workbook = Workbook()
    # 加載 CSV，指定分隔符為逗號，起始行為 1，起始列為 1
    workbook.LoadFromFile(inputFile, ",", 1, 1)
    
    # 設置工作表適配頁面
    workbook.ConverterSetting.SheetFitToPage = True
    
    # 獲取第一個工作表
    sheet = workbook.Worksheets[0]
    
    # 自動調整所有列的寬度
    i = 1
    while i < sheet.Columns.Length:
        sheet.AutoFitColumn(i)
        i += 1
    
    # 保存為 PDF
    workbook.SaveToFile(outputFile, FileFormat.PDF)
    workbook.Dispose()
    
    print(f"CSV 轉 PDF 完成，文件已保存至: {outputFile}")

if __name__ == "__main__":
    ConvertCSVToPDF()

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

class ExcelToPdfConverter:
    """Excel 轉 PDF 批量轉換器"""
    
    def __init__(self, output_folder=None):
        self.output_folder = output_folder or "./PDF_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, fit_to_page=True):
        """轉換單個 Excel 文件為 PDF"""
        try:
            workbook = Workbook()
            workbook.LoadFromFile(input_file)
            
            if fit_to_page:
                workbook.ConverterSetting.SheetFitToPage = True
            
            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}.pdf")
            
            workbook.SaveToFile(output_file, FileFormat.PDF)
            workbook.Dispose()
            
            print(f"? 轉換成功: {os.path.basename(input_file)}")
            return True
            
        except Exception as e:
            print(f"? 轉換失敗 {os.path.basename(input_file)}: {str(e)}")
            return False
    
    def batch_convert(self, input_folder, file_extension=".xlsx"):
        """批量轉換文件夾中的所有 Excel 文件"""
        excel_files = []
        
        # 查找所有 Excel 文件
        for filename in os.listdir(input_folder):
            if filename.lower().endswith(file_extension):
                excel_files.append(os.path.join(input_folder, filename))
        
        if not excel_files:
            print(f"在 {input_folder} 中未找到 {file_extension} 文件")
            return
        
        print(f"找到 {len(excel_files)} 個文件，開始轉換...")
        
        success_count = 0
        fail_count = 0
        
        for excel_file in excel_files:
            if self.convert_single_file(excel_file):
                success_count += 1
            else:
                fail_count += 1
        
        print(f"\n轉換完成!")
        print(f"成功: {success_count} 個文件")
        print(f"失敗: {fail_count} 個文件")
        print(f"輸出目錄: {self.output_folder}")
    
    def convert_with_custom_settings(self, input_file, output_file, 
                                     fit_wide=True, fit_tall=0):
        """使用自定義頁面設置進行轉換"""
        workbook = Workbook()
        workbook.LoadFromFile(input_file)
        
        # 設置頁面適配
        for sheet in workbook.Worksheets:
            sheet.PageSetup.FitToPagesWide = 1 if fit_wide else 0
            sheet.PageSetup.FitToPagesTall = fit_tall
        
        workbook.SaveToFile(output_file, FileFormat.PDF)
        workbook.Dispose()
        
        print(f"自定義設置轉換完成: {output_file}")

def main():
    # 示例 1: 批量轉換
    converter = ExcelToPdfConverter("./PDF_Output")
    converter.batch_convert("./Excel_Files", ".xlsx")
    
    # 示例 2: 單個文件轉換
    # converter.convert_single_file("./Data/Report.xlsx")
    
    # 示例 3: 自定義設置轉換
    # converter.convert_with_custom_settings(
    #     "./Data/WideTable.xlsx",
    #     "./Output/WideTable.pdf",
    #     fit_wide=True,
    #     fit_tall=0
    # )

if __name__ == "__main__":
    main()