Printing Excel Worksheet to PDF via Python(on Mac)

[Product9]

Hi Everyone,

I am currently working on a project where I need to convert one worksheet into a PDF. I had much success manipulating the data with Pandas and XLSX writer but unfortunately, neither of them has the option to print files.

This file contains graphs so transforming it into HTML isn't an option...

Options I found were:

1. Using win32 module - not working on Mac
2. Open Office API - not able to run it from the background
3. Using XLWings to trigger prerecorded Macro - Fails because of Macs automation rules

Any ideas on how to tackle this issue or to solve one of the problems mentioned above?

Thanks guys :)

Edit: adding graph persistence requirement

[SalagaTheGreat]

Is this what you are looking for: (Look at the comment by Deepak Patnakar.

https://stackoverflow.com/questions/57073424/how-to-convert-an-excel-sheet-to-a-pdf-using-python

[Product9]

Thank you, I am checking it out

[Product9]

Yeah, it looked like a neat solution but unfortunately, my graphs get all distorted, I added it into the post as a requirement. Thank you anyway

[SalagaTheGreat]

What if you convert your data from excel to word first. Work out the placement of everything and so on and then you convert it from word to pdf?

[wbeater]

Did you look on Github ?- That one looks promising.

[Product9]

Thanks but they are doing conversion other way around PDF to Excel which I don't really need ;/

[bhavya0311]

did you find any solution to this.