Python – Converting XLSX to PDF

by

As my original answer was deleted and is eventually a bit useful, I repost it here.

You could do it in 3 steps:

  1. excel to pandas: pandas.read_excel
  2. pandas to HTML: pandas.DataFrame.to_html
  3. HTML to pdf: python-pdfkit (git), python-pdfkit (pypi.org)
import pandas as pd
import pdfkit

df = pd.read_excel("file.xlsx")
df.to_html("file.html")
pdfkit.from_file("file.html", "file.pdf")

install:

sudo pip3.6 install pandas xlrd pdfkit
sudo apt-get install wkhtmltopdf

More Related Contents:

  1. .doc to pdf using python
  2. Render HTML to PDF in Django site
  3. .xlsx and xls(Latest Versions) to pdf using python
  4. How to show a PDF file in a Django view?
  5. Check if a dictionary contain data true of false, then send a response back
  6. Iterate over model instance field names and values in template
  7. Add text to Existing PDF using Python
  8. Django Passing Custom Form Parameters to Formset
  9. When to use get, get_queryset, get_context_data in Django?
  10. Best way to make Django’s login_required the default
  11. django template system, calling a function inside a model
  12. How do I get the object if it exists, or None if it does not exist in Django?
  13. Find object in list that has attribute equal to some value (that meets any condition)
  14. django-rest-framework 3.0 create or update in nested serializer
  15. Django model inheritance: create sub-instance of existing instance (downcast)?
  16. django change default runserver port
  17. Access django models inside of Scrapy
  18. Django, template context processors
  19. django-debug-toolbar not showing up
  20. gunicorn.errors.HaltServer: django
  21. Django Admin Page missing CSS
  22. What’s the purpose of Django setting ‘SECRET_KEY’?
  23. Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events
  24. Good ways to sort a queryset? – Django
  25. Why django urls end with a slash?
  26. Permission to view, but not to change! – Django
  27. Django: app level variables
  28. How do I access dictionary keys that contain hyphens from within a Django template?
  29. CSRF validation does not work on Django using HTTPS
  30. How to use custom AdminSite class?

Leave a Comment