I accept that this question might be a bit outside the scope of this page, but please bear with me!
At work I'm going to set up a framework for generating some pretty basic reports, which could be on a monthly or quarterly basis. The data source is an online reporting system which generates
Of course, this could be done quite manually by making a simple Excel file with input for numbers and output for results, and then copy-paste the results into a Word document template. Quite frankly, it feels like this procedure could and should be completely automated. I would therefore like to use this opportunity to learn how to build a more thorough tool, which should of course generate a latex'ed PDF. However, I find myself in the lack of understanding how to attack this problem. There are several questions about automatically generate LaTeX documents on this site, but I don't find that they answer my questions regarding a fully automated procedure.
My needs are as follows:
- A simple interface to set monthly or quarterly basis for the data manipulations
- including the latex distribution "in the program" or call an online generator (I'm not guaranteed that future users of the program will even know about LaTeX)
- Do some simple calculations with the data source numbers
- Insert these numbers in a
.texfile, compile and make the PDF available to the user.
Example of workflow:
The user will, in a simple GUI, chose to generate report for january2016. Press "generate report" which make the program import jan16 numbers from a
.csv file, do some very basic calculations, and push the results into a premade LaTeX template, compile and output the PDF.
I have some very concrete questions with respect to this:
- Is there a programming language/tool I could use as a basis? For instance a templating language such as Cheeta, or do I need something completely different, like Excel?
- Is it possible to include a basic latex engine with a few, carefully selected packages included, in such a program, call an online compiler, or similar? It is important that the tex distribution doesn't need to be installed on the computer where the program is run from. I assume that the program will be located in a folder on a server.