I need your help please, I want to automize my everyday tasks with python code. I need to open an existing excel document, modify some information in it(ex: date) then save it as pdf and print it.
Is it possible to do all these via python?
I have tried to do this with openpyxl, I can open and modify the sheets, but' I can't save as pdf only one sheet of the workbook and print it then.
Why you need to use Python?
I think easiest way is write macro in VBA excel (which can updating values in your sheet) and than print it out as PDF or .
How to Modify an excel document, save as pdf and print it with Python