Converting Excel Files to PDF Using Python

• Horizontal consistency: All columns appear on a single page width, eliminating horizontal scrolling

• Vertical flexibility: Rows can span multiple pages as needed, accommodating large datasets

• Improved readability: Readers can follow data columns without interruption

Setting FitToPagesTall to 0 means "no limit," allowing the content to extend vertically across as many pages as necessary while maintaining the one-page-width constraint.

Converting Selected Range to PDF

Sometimes you only need to export a specific portion of a worksheet rather than the entire document. Spire.XLS allows you to copy a selected range to a new sheet and convert only that section to PDF, providing precise control over the exported content.

The following example demonstrates how to export a specific cell range:

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

# Define input and output file paths
inputFile = "./Demos/Data/ConversionSample1.xlsx"
outputFile = "SelectedRangeToPDF.pdf"

# Create a workbook and load the document
workbook = Workbook()
workbook.LoadFromFile(inputFile)

# Add a new worksheet to hold the selected range
workbook.Worksheets.Add("newsheet")

# Copy the desired range (A9:E15) from the first sheet to the new sheet
workbook.Worksheets[0].Range["A9:E15"].Copy(
    workbook.Worksheets[1].Range["A9:E15"], 
    False,  # Don't copy column widths
    True    # Copy formatting
)

# Auto-fit column widths for optimal display
workbook.Worksheets[1].Range["A9:E15"].AutoFitColumns()

# Save only the new sheet to PDF
workbook.Worksheets[1].SaveToPdf(outputFile)

# Release resources
workbook.Dispose()

This approach involves several steps:

1. Load the original Excel file

2. Create a new worksheet to hold the selected data

3. Copy the specific range to the new sheet, preserving formatting

4. Auto-fit column widths to ensure content displays properly

5. Use SaveToPdf on the specific worksheet instead of the entire workbook

This technique is particularly useful for extracting summary tables, key metrics, or specific sections from larger spreadsheets.

Converting Each Worksheet to Separate PDFs

When working with workbooks containing multiple independent worksheets, you might want to generate separate PDF files for each sheet. This approach allows recipients to focus on relevant sections without navigating through unrelated content.

Here's how to iterate through all worksheets and save each as an individual PDF:

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

# Define input file path
inputFile = "./Demos/Data/EachWorksheetToDifferentPDFSample.xlsx"

# Load the document from disk
workbook = Workbook()
workbook.LoadFromFile(inputFile)

# Process each worksheet individually
for sheet in workbook.Worksheets:
    # Generate filename based on worksheet name
    FileName = sheet.Name + ".pdf"
    
    # Save the individual sheet to PDF
    sheet.SaveToPdf(FileName)

# Release resources
workbook.Dispose()

This loop-based approach offers several advantages:

• Modular output: Each worksheet becomes a standalone PDF file

• Automatic naming: PDF filenames correspond to worksheet names for easy identification

• Selective distribution: Share only relevant sheets with specific stakeholders

This method is ideal for monthly reports where each worksheet represents a different department, region, or time period.

Practical Applications

Converting Excel to PDF finds numerous applications across different domains:

Financial Reporting

Finance teams regularly convert Excel-based financial statements to PDF for board meetings and investor presentations. The PDF format ensures that numbers, charts, and formatting remain intact during distribution. A batch processing function might look like this:

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

def ConvertExcelReportsToPDF(input_folder: str, output_folder: str):
    """Convert all Excel files in a folder to PDF with optimized settings"""
    
    # Create output folder if it doesn't exist
    if not os.path.exists(output_folder):
        os.makedirs(output_folder)
    
    # Process all Excel files in the input folder
    for filename in os.listdir(input_folder):
        if filename.endswith(".xlsx") or filename.endswith(".xls"):
            # Build full file paths
            input_path = os.path.join(input_folder, filename)
            output_filename = os.path.splitext(filename)[0] + ".pdf"
            output_path = os.path.join(output_folder, output_filename)
            
            # Convert the file with optimized settings
            workbook = Workbook()
            workbook.LoadFromFile(input_path)
            workbook.ConverterSetting.SheetFitToPage = True
            workbook.SaveToFile(output_path, FileFormat.PDF)
            workbook.Dispose()
            
            print(f"Converted: {filename} -> {output_filename}")

# Example usage
input_folder = "./Financial_Reports"
output_folder = "./PDF_Reports"
ConvertExcelReportsToPDF(input_folder, output_folder)

Invoice Generation

Businesses can automate invoice delivery by converting Excel invoice templates to PDF, ensuring professional presentation and preventing unauthorized modifications to billing amounts.

Data Export for Compliance

Regulated industries often require data exports in non-editable formats for audit trails. Converting Excel data to PDF/A format satisfies these regulatory requirements while maintaining data integrity.

Best Practices

To optimize your Excel to PDF conversions, keep the following recommendations in mind:

• Page orientation: Set landscape orientation for wide spreadsheets to improve readability

• Print areas: Define print areas in Excel before conversion to control what gets exported

• Scaling options: Use FitToPagesWide and FitToPagesTall to control content flow across pages

• Font embedding: Ensure all fonts are available or embedded for consistent rendering

• Testing: Always review the generated PDF to verify page breaks and formatting

Conclusion

Converting Excel files to PDF using Python and Spire.XLS provides a powerful solution for generating professional, shareable documents from spreadsheet data. Whether you need simple format conversion, archival-compliant PDF/A output, selective range export, or per-worksheet PDF generation, these techniques enable efficient automation of document transformation tasks.

We have explored:

• Basic Excel to PDF conversion using SaveToFile

• Creating PDF/A-1B files for long-term archival

• Fitting content to page width for improved readability

• Exporting selected cell ranges to focused PDF documents

• Converting each worksheet to separate PDF files

• Practical applications including financial reporting and invoice generation

By mastering these techniques, you will be able to automate your Excel-to-PDF workflows effectively, improving productivity and ensuring consistent, professional-quality PDF output for all your business documentation needs.