Dynamic Outlines

To have some collection items outlined in rows you can use public void groupCollection(String collectionName) method of XLSTransformer class. For example to outline staff in department object we can use code like

				Department department = new Department("IT");
				//...  initialization is skipped here
			        Map beans = new HashMap();
			        beans.put("department", department);
			        XLSTransformer transformer = new XLSTransformer();
			        // set outlines for rows of "department.staff" collection
			        transformer.transformXLS(templateFileName, beans, destFileName);

So here we invoke transformer.groupCollection("department.staff") to group/outline rows of exported collection.

Take a look at Complex Bean Export sample for real example.