How to convert excel to PDF using Python

Question

I have a primary folder with a few subfolders and files ending in.xlsx,.ipynb, and.jpeg. I now want to create PDF versions of every.xlsx file in my main folder.

I have to perform this routine task every day, so I would appreciate it if you could show me how to accomplish it in Python.

Answer 1

Specify your whole output path instead of only output.csv

df = ("./Downloads/folder/myfile.pdf")
output = "./Downloads/folder/test.csv"
tabula.convert_into(df, output, output_format="csv", stream=True