pip install Spire.XLS

pip install Spire.XLS.Free

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

# 加載 Excel
workbook = Workbook()
workbook.LoadFromFile("sample.xlsx")

# 設(shè)置工作表自適應(yīng)頁面
workbook.ConverterSetting.SheetFitToPage = True

# 轉(zhuǎn)換為 PDF
workbook.SaveToFile("ToPdf.pdf", FileFormat.PDF)
workbook.Dispose()

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

# 加載 Excel
workbook = Workbook()
workbook.LoadFromFile("C:\Users\Administrator\Desktop\input.xlsx")

# 獲取指定工作表
sheet = workbook.Worksheets[1]

# 設(shè)置工作表自適應(yīng)頁面
workbook.ConverterSetting.SheetFitToPage = True

# 轉(zhuǎn)換為 PDF
sheet.SaveToPdf("WorksheetToPdf.pdf")
workbook.Dispose()

# 獲取 PageSetup 對象
pageSetup = sheet.PageSetup

# 設(shè)置頁面方向
pageSetup.Orientation = PageOrientationType.Landscape;

# 設(shè)置頁面大小
pageSetup.PaperSize = PaperSizeType.PaperA4;

# 設(shè)置頁邊距
pageSetup.TopMargin = 0.3
pageSetup.BottomMargin = 0.3
pageSetup.LeftMargin = 0.3
pageSetup.RightMargin = 0.3

# 顯示網(wǎng)格線
pageSetup.IsPrintGridlines = true;

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

def batch_excel_to_pdf(input_dir, output_dir):
    """
    批量轉(zhuǎn)換指定目錄下的所有 Excel 文件為 PDF
    
    參數(shù):
        input_dir: 包含 Excel 文件的目錄
        output_dir: 輸出 PDF 文件的目錄
    """
    # 確保輸出目錄存在
    if not os.path.exists(output_dir):
        os.makedirs(output_dir)
    
    # 獲取目錄下所有 Excel 文件
    excel_extensions = ('.xls', '.xlsx', '.xlsm', '.xlsb')
    excel_files = [f for f in os.listdir(input_dir) 
                  if f.lower().endswith(excel_extensions)]
    
    if not excel_files:
        print(f"在 {input_dir} 中未找到 Excel 文件")
        return
    
    workbook = Workbook()
    
    try:
        for i, filename in enumerate(excel_files, 1):
            excel_path = os.path.join(input_dir, filename)
            # 生成輸出 PDF 文件名
            pdf_filename = os.path.splitext(filename)[0] + '.pdf'
            pdf_path = os.path.join(output_dir, pdf_filename)
            
            print(f"正在轉(zhuǎn)換 {i}/{len(excel_files)}: {filename}")
            
            # 加載并轉(zhuǎn)換
            workbook.LoadFromFile(excel_path)
            workbook.SaveToFile(pdf_path, FileFormat.PDF)
            
            # 清空工作簿，準(zhǔn)備下一個文件
            workbook.Dispose()
            workbook = Workbook()
            
            print(f"已保存: {pdf_filename}")
            
        print(f"批量轉(zhuǎn)換完成，共處理 {len(excel_files)} 個文件")
        
    except Exception as e:
        print(f"轉(zhuǎn)換過程中出錯: {str(e)}")
        
    finally:
        workbook.Dispose()

# 使用示例
if __name__ == "__main__":
    input_directory = "需要轉(zhuǎn)換的Excel文件"  # 存放Excel文件的目錄
    output_directory = "轉(zhuǎn)換后的PDF文件"    # 輸出PDF的目錄
    batch_excel_to_pdf(input_directory, output_directory)