navigation
Python

How to convert csv to pdf using pdfkit python

| | python

In this tutorial I will show you how to convert csv to pdf using pdfkit python.

CODE:

import pandas as pd

import pdfkit

df1 = pd.read_csv('shampoo_sales.csv')
html_string = df1.to_html()
pdfkit.from_string(html_string, "output_file.pdf")
print("PDF file saved.")

OSERROR ERROR:

I got this following error while running the program to convert csv to pdf using python. 

 OSError: No wkhtmltopdf executable found:

 OSError: No wkhtmltopdf executable found: "b''"
If this file exists please check that this process can read it or you can pass path to it manually in method call, check README. Otherwise please install wkhtmltopdf - https://github.com/JazzCore/python-pdfkit/wiki/Installing-wkhtmltopdf

SOLUTION:

Download wkhtmltopdf.exe from https://wkhtmltopdf.org/ and install it. Then specify the path to wkhtmltopdf executable.
config=pdfkit.configuration(wkhtmltopdf=r'C:\Program Files\wkhtmltopdf\bin\wkhtmltopdf.exe')

CODE:

import pandas as pd

import pdfkit

df1 = pd.read_csv('shampoo_sales.csv')
html_string = df1.to_html()
config=pdfkit.configuration(wkhtmltopdf=r'C:\Program Files\wkhtmltopdf\bin\wkhtmltopdf.exe')
pdfkit.from_string(html_string, "output_file.pdf",configuration=config)
print("PDF file saved.")

VIDEO GUIDE: