How to convert an excel sheet to a pdf using python?

Question

I have an excel sheet which i want to convert to Python. Need recommendation in suggesting package or a module for above query.

i have tried with PDFWriter. I am using pandas to read my excel file and inputing that dataset to PDFwriter to create pdf file. The output pdf seems blank.

import pandas as pd
from pdfrw import PdfWriter

wb = pd.read_excel('excel file path')

wb=PdfWriter()

wb.write('result.pdf')

The pdf file created in of 1kb only..

I have generated invoices with reportlab which has a nice `Table` class to build tables. — Louis Saglio, Jul 17 '19 at 10:17
Perhaps this may help: https://stackoverflow.com/questions/52326782/python-converting-xlsx-to-pdf — Stoner, Jul 17 '19 at 10:18
Possible duplicate of [Python - Converting XLSX to PDF](https://stackoverflow.com/questions/52326782/python-converting-xlsx-to-pdf) — Vikramaditya Gaonkar, Jul 17 '19 at 10:19

score 2 · Answer 1 · answered Jun 08 '20 at 01:32

2

import pandas as pd
import pdfkit
df = pd.read_excel("file.xlsx")#input
df.to_html("file.html")#to html
pdfkit.from_file("file.html", "file.pdf")#to pdf

answered Jun 08 '20 at 01:32

Nematillo Ochilov

362
2
11

Please edit your answer to explain how it answers the question. – Dragonthoughts Jun 08 '20 at 08:05

score 0 · Answer 2 · answered Jul 17 '19 at 10:22

Here are few points :

You are reading the DataFrame in a variable wb in first line and overwriting the same variable in next line. The values read from the excel sheet will be lost.
You have to use addpage() function to add content to your page.

You can also try this link.

How to convert an excel sheet to a pdf using python?

2 Answers2