This part describes object property access syntax that must be used in XLS template to be correctly processed by jXLS engine.
Department department; ... //initialization Map beans = new HashMap(); beans.put("department", department); XLSTransformer transformer = new XLSTransformer(); transformer.transformXLS(xlsTemplateFileName, beans, outputFileName);
To access simple bean property in Excel cell following notation should be used
jXLS engine will search for the bean under the key
department in the current bean map and then will try to get the value of its
name property and put it into the corresponding Excel cell.
In the same way we can access more complex property. For example to output the name of the chief of the department we can use
Any object property graph depth is possible. For example,