We are reviewing the Template manipulation using Aspose.cells in java.We need to know how exactly we can make use of smartmarkers while feeding the data.
These are the questions we have right now
1)How to mix static Data and Dynamic Data in the template,for Eg:To:&=To(Here exactly To: will be static in the template and &=To will be dynamic variable value).
2)How to handle the multiple row values(for eg:1 row filled with Dynamic column Headers) and multiple data row values after the header.This will be like a table structure.
3)Is it possible to maintain the style and formatting that we keep in Header and Columns for the table in consequent rows.
4)How to make use of Javabean or a POJO.
5)Can we make use of AsposeDataTable
1.Lets say i have the variable &=Header(List of dynamic headers)--Horizontal fashion
2.The row columns will be &=Columns(List of Columns data row 1..n)--Horizontal fashion and continuous till n.
Basically we need to copy the header style to all the dynamic headers same with rows too.The styles will be the same which is defined in the variable template.
Please give us some solid solutions to accomplish these features in a very efficient way.Also we would like to know whether this can be achieved entirely through smartmarkers otherwise we need to mix both markers and the worksheet cell replacement.