A Play! framework plugin to help generate Excel file (using predefined Excel file as template)
JavaScript Java
Switch branches/tags
Nothing to show
Pull request Compare This branch is 3 commits behind greenlaw110:master.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Failed to load latest commit information.


Excel module

The Excel module allows you to render Excel document. It is rather simple to use as it only requires to import a static file.

This module helps web developer to generate Excel report. The tool uses the jxls library.

In order to use the Excel module, you need to create an Excel based template – see http://jxls.sourceforge.net for details instruction.

What’s New in v1.0a

  • support Play 1.1-RC1
  • jxls update to 1.0-RC1 along with it’s dependencies
    • POI 3.6
    • Jexl 2.0

Enable the Excel module for the application

In the /conf/application.conf file, enable the Excel module by adding this line:

# The Excel module

note, please change the excel.template.root from app/views to some where else when you use excel module with Play version 1.02 or before. Otherwise your application will not be able to startup on product mode.

Using the Excel module

The renderExcel() method:

import static play.modules.excel.Excel.*;

And then use the renderExcel() method as you would use the render() method.

The renderExcel() behavior is almost the same as that of render() except the following differences:

  1. the template should be an excel file with “.xls” suffix rather than a text file with “.html”
  2. You can use renderArgs.put(“fileName”, “your-file.xls”) to indicate the name of the excel file to be generated

Known Issue

  • While using chrome and IE, the filename is not the one specified by “fileName” but the last string in the url. E.g. if the url is http://localhost:9000/1/namecard, the file name will be namecard instead of 1.xls which is specified in the program. There is not such problem in FF.

Please refer to the sample for an example.