I have created PDF reports, including some with calculations fully automated before. I used Python to create the tex file and then call the texcompiler from within the Python script to compile the tex file to a pdf.  I, in my case, skipped the Excel step completely, since there was no reason for a user to intervene. Since tex files are written in plain text, this is not too difficult.