.xlsx and xls(Latest Versions) to pdf using python

by

Link of xlsxwriter :

https://xlsxwriter.readthedocs.org/en/latest/contents.html

With the help of this you can generate excel file with .xlsx and .xls

for example excel file generated name is trial.xls

Now if you want to generate pdf of that excel file then do the following :

from win32com import client
xlApp = client.Dispatch("Excel.Application")
books = xlApp.Workbooks.Open('C:\\excel\\trial.xls')
ws = books.Worksheets[0]
ws.Visible = 1
ws.ExportAsFixedFormat(0, 'C:\\excel\\trial.pdf')

More Related Contents:

  1. .doc to pdf using python
  2. ImportError: No module named win32com.client
  3. Print chosen worksheets in excel files to pdf in python
  4. Python – Converting XLSX to PDF
  5. python-win32com excel com model started generating errors
  6. Export Charts from Excel as images using Python
  7. Merge PDF files
  8. Python convert csv to xlsx
  9. Pandas cannot open an Excel (.xlsx) file
  10. Render HTML to PDF in Django site
  11. How to create PDF files in Python [closed]
  12. Using win32com with multithreading
  13. How to concatenate three excels files xlsx using python?
  14. How to find the last row in a column using openpyxl normal workbook?
  15. IndexError: too many indices for array
  16. Adjust cell width in Excel
  17. Get Excel-Style Column Names from Column Number
  18. Converting a PDF to a series of images with Python
  19. Parse annotations from a pdf
  20. Identifying Excel Sheet cell color code using XLRD package
  21. Pandas: parse merged header columns from Excel
  22. Whitespace gone from PDF extraction, and strange word interpretation
  23. Read Tables from pdf using python [duplicate]
  24. How can I read pdf in python? [duplicate]
  25. Download pdf using urllib?
  26. PythonMagick can’t find my pdf files
  27. How to write to an existing excel file without breaking formulas with openpyxl?
  28. Search and replace for text within a pdf, in Python [duplicate]
  29. Automation Excel from Python
  30. XlsxWriter object save as http response to create download in Django

Leave a Comment