Designer Template And Smart Markers

Aspose.Cells Product Family
1

We are currently evaluating Aspose.Cells for Java to replace our current Excel reporting tool. We would like to be able to reuse our existing Excel templates as much as possible. I have looked at the demo code provided for Smart Markers and it seems to provide a lot of the functionality we need. We also need to be able to repeat header information throughout the output Excel sheet, I’m not sure if this can be done with Smart Markers? I’ve attached a sample designer template and also what the output Excel file should ideally look like. For each product we would like to repeat the headers that appear in the Excel sheet. The header row for each product consists of three rows, the first is static data: “Product Components”, the second contains both static and dynamic data: “Product = &=Product.name” and the third header row is static data describing the product property names. After the header row we will list all the components (1 row per component, dynamic data) for that specific product. We would then like to repeat the header + data rows for each subsequent product. Is this possible to achieve with Smart markers? I’ve created a new class which implements the AsposeDataTable interface to display the list of product components data.

2

Hi,

Thank you for providing the template files.

We will check the feasibility of your requirement and will get back to you soon.

Thank You & Best Regards,

3

Hi,

Thank you for considering Aspose.

I am afraid you have to change the Smart Markers in your template and write some manual code in your application to fit your requirement. We have created a sample project that implements your requirement. Please see attached archive. In the archive, “ProductComponentTemplateNew.xls” is the new template file rebuilt from your original template “ProductComponentTemplate.xls”. “AsposeDataTableDemo.java” is an implementation of AsposeDataTable to provide data for the marker “Component”. “ProductReport.java” is the main application to process template and create the resultant file as per your requirement. Hopefully it can fit your needs.

Thank You & Best Regards,

4

Thanks for the prompt reply and the detail provided.