Convert Excel to PDF with Python: Step‑by‑Step Guide Using Spire.XLS

Converting Excel files to PDF makes it easy to store spreadsheet data and ensures consistent layout when printing or sharing across devices and operating systems.

Steps to convert Excel to PDF in Python

1. Install the required library via pip: pip install Spire.XLS 2. Import the necessary modules:

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

3. Load the Excel document and use Workbook.SaveToFile() or Worksheet.SaveToPdf() to convert the workbook or a specific worksheet to PDF.

4. Optional page settings can be adjusted through the PageSetup class.

Example 1: Convert an entire Excel file to a single PDF (each worksheet on a separate page)

from spire.xls import *
from spire.common import *
# Create Workbook object
workbook = Workbook()
# Load Excel file
workbook.LoadFromFile("data.xlsx")
# Fit each sheet to page
workbook.ConverterSetting.SheetFitToPage = True
# Save as PDF
workbook.SaveToFile("ToPDF.pdf", FileFormat.PDF)
workbook.Dispose()

Example 2: Convert each worksheet to a separate PDF file

from spire.xls import *
from spire.common import *
workbook = Workbook()
workbook.LoadFromFile("data.xlsx")
for sheet in workbook.Worksheets:
    fileName = sheet.Name + ".pdf"
    sheet.SaveToPdf(fileName)
workbook.Dispose()

Example 3: Convert a specific worksheet to PDF with custom page settings

from spire.xls import *
from spire.common import *
workbook = Workbook()
workbook.LoadFromFile("data.xlsx")
sheet = workbook.Worksheets[1]
pageSetup = sheet.PageSetup
pageSetup.TopMargin = 0.3
pageSetup.BottomMargin = 0.3
pageSetup.LeftMargin = 0.3
pageSetup.RightMargin = 0.3
pageSetup.PaperSize = PaperSizeType.PaperA3
workbook.ConverterSetting.SheetFitToPage = True
sheet.SaveToPdf("ExcelWorksheetToPDF.pdf")
workbook.Dispose()