Print chosen worksheets in excel files to pdf in python

by

This seems like the place to put this answer.

In the simplest form:

import win32com.client

o = win32com.client.Dispatch("Excel.Application")

o.Visible = False

wb_path = r'c:\user\desktop\sample.xls'

wb = o.Workbooks.Open(wb_path)



ws_index_list = [1,4,5] #say you want to print these sheets

path_to_pdf = r'C:\user\desktop\sample.pdf'



wb.WorkSheets(ws_index_list).Select()

wb.ActiveSheet.ExportAsFixedFormat(0, path_to_pdf)

Including a little formatting magic that scales to fit to a single page and sets the print area:

import win32com.client

o = win32com.client.Dispatch("Excel.Application")

o.Visible = False

wb_path = r'c:\user\desktop\sample.xls'

wb = o.Workbooks.Open(wb_path)



ws_index_list = [1,4,5] #say you want to print these sheets

path_to_pdf = r'C:\user\desktop\sample.pdf'

print_area="A1:G50"



for index in ws_index_list:

    #off-by-one so the user can start numbering the worksheets at 1

    ws = wb.Worksheets[index - 1]

    ws.PageSetup.Zoom = False

    ws.PageSetup.FitToPagesTall = 1

    ws.PageSetup.FitToPagesWide = 1

    ws.PageSetup.PrintArea = print_area



wb.WorkSheets(ws_index_list).Select()

wb.ActiveSheet.ExportAsFixedFormat(0, path_to_pdf)

I have also started a module over a github if you want to look at that: https://github.com/spottedzebra/excel/blob/master/excel_to_pdf.py

More Related Contents:

  1. .xlsx and xls(Latest Versions) to pdf using python
  2. Silent printing of a PDF in Python
  3. Python silent print PDF to specific printer
  4. multiple prints on the same line in Python
  5. Rewrite multiple lines in the console
  6. Merge PDF files
  7. Python convert csv to xlsx
  8. Pandas cannot open an Excel (.xlsx) file
  9. Render HTML to PDF in Django site
  10. How to create PDF files in Python [closed]
  11. Difference between returns and printing in python? [duplicate]
  12. Display special characters when using print statement
  13. Easy pretty printing of floats?
  14. How to concatenate three excels files xlsx using python?
  15. How to find the last row in a column using openpyxl normal workbook?
  16. python 3 print generator
  17. Python – Converting XLSX to PDF
  18. How to apply __str__ function when printing a list of objects in Python [duplicate]
  19. IndexError: too many indices for array
  20. Adjust cell width in Excel
  21. Get Excel-Style Column Names from Column Number
  22. Converting a PDF to a series of images with Python
  23. Parse annotations from a pdf
  24. Pandas: parse merged header columns from Excel
  25. Whitespace gone from PDF extraction, and strange word interpretation
  26. Read Tables from pdf using python [duplicate]
  27. Find text position in PDF file
  28. Print PDF document with python’s win32print module?
  29. How to return and download Excel file using FastAPI?
  30. Using openpyxl to read file from memory

Leave a Comment