Dynamic excel sheet with Predefined Formatting in NPrinting 17.2

[#1]

Hi,

I have the following requirement. I have 9 Categories and 10-20 subcategories in each of them.

1. I need to create one sheet with tables for each category.

2. I need to create sheets for 4 fixed categories, with tables for their sub categories. And another sheet with remaining categories.

For these I have the above  format.

I have tried using Levels, however this hampers formatting.

Overall I have near about 100 tables.  I can make the report, if can create all the tables hard-coded using set analysis.

Even this does not keep the source template format. I have to format the tables manually. Moreover for any addition or change in category/Subcategory I would have to modify tables in App. 

Is there a way to create these tables dynamically keeping formats?

[Stephen_Jasionowski]

If you uncheck "Keep source formatting" from the table properties in NPrinting before you drag-and-drop into the template, the template source formatting should be preserved.

[#3]

I have tried that. But could not keep the format.