Excel to PDF: Convert .xlsx Spreadsheets to PDF (Free)

Sub ExportToPDF()
    ActiveSheet.ExportAsFixedFormat _
        Type:=xlTypePDF, _
        Filename:="C:\output\report.pdf", _
        Quality:=xlQualityStandard, _
        IncludeDocProperties:=True, _
        IgnorePrintAreas:=False, _
        OpenAfterPublish:=False
End Sub
 
' Export entire workbook (all sheets)
Sub ExportWorkbookToPDF()
    ThisWorkbook.ExportAsFixedFormat _
        Type:=xlTypePDF, _
        Filename:="C:\output\workbook.pdf"
End Sub

$excel = New-Object -ComObject Excel.Application
$excel.Visible = $false
$wb = $excel.Workbooks.Open("C:\path\to\report.xlsx")
$wb.ExportAsFixedFormat(0, "C:\path\to\report.pdf")   # 0 = xlTypePDF
$wb.Close($false)
$excel.Quit()

# Convert single .xlsx file to PDF
libreoffice --headless --convert-to pdf report.xlsx
 
# Output to specific directory
libreoffice --headless --convert-to pdf --outdir ./pdfs report.xlsx
 
# Batch: all Excel files in directory
libreoffice --headless --convert-to pdf --outdir ./pdfs *.xlsx *.xls
 
# Install on Linux
sudo apt-get install libreoffice-calc

import subprocess
from pathlib import Path
 
def excel_to_pdf(xlsx_path: str, output_dir: str = None) -> str:
    input_path = Path(xlsx_path).resolve()
    out_dir = Path(output_dir) if output_dir else input_path.parent
    out_dir.mkdir(parents=True, exist_ok=True)
 
    result = subprocess.run(
        [
            "libreoffice",
            "--headless",
            "--convert-to", "pdf",
            "--outdir", str(out_dir),
            str(input_path),
        ],
        capture_output=True,
        text=True,
        timeout=60,
    )
 
    if result.returncode != 0:
        raise RuntimeError(f"LibreOffice conversion failed: {result.stderr}")
 
    pdf_path = out_dir / (input_path.stem + ".pdf")
    return str(pdf_path)
 
 
def batch_excel_to_pdf(input_dir: str, output_dir: str):
    files = list(Path(input_dir).glob("*.xlsx")) + list(Path(input_dir).glob("*.xls"))
    print(f"Converting {len(files)} files...")
 
    for i, xlsx_path in enumerate(files, start=1):
        try:
            pdf = excel_to_pdf(str(xlsx_path), output_dir)
            print(f"  [{i}/{len(files)}] ✓ {Path(pdf).name}")
        except Exception as e:
            print(f"  [{i}/{len(files)}] ✗ {xlsx_path.name}: {e}")

from openpyxl import load_workbook
 
def set_print_area(xlsx_path: str, sheet_name: str, cell_range: str, output_path: str = None):
    """
    Set print area before conversion.
    cell_range example: "A1:H50"
    """
    wb = load_workbook(xlsx_path)
    ws = wb[sheet_name]
    ws.print_area = cell_range
 
    # Fit to page width
    ws.page_setup.fitToWidth = 1
    ws.page_setup.fitToHeight = 0   # 0 = as many pages as needed
 
    # Set landscape for wide sheets
    ws.page_setup.orientation = ws.page_setup.orientationLandscape
 
    out = output_path or xlsx_path
    wb.save(out)
    return out
 
# Then convert the modified file
set_print_area("report.xlsx", "Sheet1", "A1:H50", "report_print.xlsx")
excel_to_pdf("report_print.xlsx", "./pdfs")

from openpyxl import load_workbook
from reportlab.lib.pagesizes import A4, landscape
from reportlab.lib.styles import getSampleStyleSheet
from reportlab.platypus import SimpleDocTemplate, Table, TableStyle, Spacer
from reportlab.lib import colors
from reportlab.lib.units import cm
 
def excel_to_pdf_reportlab(xlsx_path: str, pdf_path: str, sheet_name: str = None):
    wb = load_workbook(xlsx_path, data_only=True)
    ws = wb[sheet_name] if sheet_name else wb.active
 
    # Extract all rows
    data = []
    for row in ws.iter_rows(values_only=True):
        data.append([str(cell) if cell is not None else "" for cell in row])
 
    if not data:
        print("No data found")
        return
 
    doc = SimpleDocTemplate(pdf_path, pagesize=landscape(A4), 
                            leftMargin=1*cm, rightMargin=1*cm,
                            topMargin=1.5*cm, bottomMargin=1.5*cm)
 
    table = Table(data, repeatRows=1)   # repeatRows=1 repeats header on each page
    table.setStyle(TableStyle([
        ("BACKGROUND", (0, 0), (-1, 0), colors.HexColor("#15803d")),
        ("TEXTCOLOR",  (0, 0), (-1, 0), colors.white),
        ("FONTNAME",   (0, 0), (-1, 0), "Helvetica-Bold"),
        ("FONTSIZE",   (0, 0), (-1, -1), 8),
        ("ROWBACKGROUNDS", (0, 1), (-1, -1), [colors.white, colors.HexColor("#f0fdf4")]),
        ("GRID",       (0, 0), (-1, -1), 0.5, colors.HexColor("#d1d5db")),
        ("ALIGN",      (0, 0), (-1, -1), "LEFT"),
        ("VALIGN",     (0, 0), (-1, -1), "MIDDLE"),
        ("TOPPADDING", (0, 0), (-1, -1), 4),
        ("BOTTOMPADDING", (0, 0), (-1, -1), 4),
    ]))
 
    doc.build([table])
    print(f"Saved: {pdf_path}")
 
excel_to_pdf_reportlab("data.xlsx", "data.pdf", sheet_name="Q4 Report")