We have the license for Aspose.cell (java) and we are using it in our project to create the excel files programmatically. Application is in uat and results are impressive so far.
Now we have a new requirement where we need to be able to define the templates in Excel and Pdf. Module should be able to take the template and the data (name/value pair) as parameter and do the simple replacement. All code is java based. We have tried the followign so far:
Create the simple xls file with place holder $Variable1$, $Variable2$ and at runtime take the xls and replace place holders with values coming in. It seems to work for the Excel. Initial idea was to just do it for Excel and use the Aspose.pdf ( http://www.aspose.com/Wiki/default.aspx/Aspose.Cells/ConvertingToPdfFile.html) to converted the generated Excel to Pdf. Pdf coming out is no where close to what we were expecting, as excel is pretty complex with images and lot of formatting. We would like to create the separate template for both pdf and excel, and modify them using the Aspose.pdf and Aspose.cell. We have the following questions.
1. Is this approach reasonable or it is totally off base.
2. Is it the appropriate use of Aspose product or we should be looking at something else. I f Aspose can support it, which product we need.
3. How do I create the pdf template in first place to be manipulated using the Aspose.pdf
4. Runtime environment is linux, template can be created on pc using the excel etc.
If you need more information please let us know.
We would appreciate any ideas.