Overview

jXLS allows direct access to key POI objects in XLS template. They are available under special bean keys in the bean context map.

  • workbook - gives an access to current HSSFWorkbook instance
  • sheet - provides an access to current HSSFSheet object being processed
  • hssfRow - provides an access to current HSSFRow object being processed
Having access to these objects you can invoke different methods to manipulate current template transformation. Next sections show some examples of tasks that can be performed using this approach.

Setting Header and Footer Messages

Setting of header and footer messages is easy because HSSFSheet provides an access to header and footer with getHeader() and getFooter() methods. So the next code 

                ${sheet.getHeader().setLeft('Left Header')}

sets left header of the sheet to 'Left Header' string. Dynamic bean properties also can be used as parameters 

                ${sheet.getFooter().setCenter(msgBean.footer)}

This sample sets center footer message to the value of footer property of msgBean bean.

Renaming Sheet

Sheet name can be set using setSheetName method of HSSFWorkbook class.

                ${workbook.setSheetName(0, department.name)}

Above sample sets the name of the first sheet to the value of name property of department bean