I have some data in an Excel file from which I have to generate a report. I repeat this task fairly regularly and am looking to automate it. I have a LaTeX project into which I usually just copy data by hand, export the necessary worksheets as pdfs and add them to my LaTeX project and compile with
It has occurred to me that there must be a way to automate this process. Is there an efficient way to export the data from Excel and into a LaTeX project, possibly a VBA script in excel could run the process? Also, it doesn't have to be LaTeX, I'm not all that experienced with MS Office's more advanced features is there some way akin to a mail merge that I could achieve this with? In some ways this might be better in case I have to pass the work on to someone who doesn't know LaTeX.