org.springframework.web.servlet.view.document
Class AbstractExcelView

java.lang.Object
  org.springframework.context.support.ApplicationObjectSupport
      org.springframework.web.context.support.WebApplicationObjectSupport
          org.springframework.web.servlet.view.AbstractView
              org.springframework.web.servlet.view.document.AbstractExcelView

All Implemented Interfaces:

ApplicationContextAware, BeanNameAware, View

public abstract class AbstractExcelView

extends AbstractView

Convenient superclass for Excel document views.

Properties:

• url (optional): The url of an existing Excel document to pick as a starting point. It is done without localization part nor the .xls extension.

The file will be searched with names in the following order:

• [url]_[language]_[country].xls
• [url]_[language].xls
• [url].xls

For working with the workbook in the subclass, see Jakarta's POI site

As an example, you can try this snippet:

 protected void buildExcelDocument(
     Map model,
     HSSFWorkbook workbook,
     HttpServletRequest request,
     HttpServletResponse response )
 {
     // AModel aModel = ( AModel ) model.get( "amodel" );

     HSSFSheet sheet;
     HSSFRow   sheetRow;
     HSSFCell  cell;

     // Go to the first sheet
     // getSheetAt: only if workbook is created from an existing document
 	   //sheet = workbook.getSheetAt( 0 );
 	   sheet = workbook.createSheet("Spring");
 	   sheet.setDefaultColumnWidth((short)12);

     // write a text at A1
     cell = getCell( sheet, 0, 0 );
     setText(cell,"Spring POI test");

     // Write the current date at A2
     HSSFCellStyle dateStyle = workbook.createCellStyle(  );
     dateStyle.setDataFormat( HSSFDataFormat.getBuiltinFormat( "m/d/yy" ) );
     cell = getCell( sheet, 1, 0 );
     cell.setCellValue( new Date() );
     cell.setCellStyle( dateStyle );

     // Write a number at A3
     getCell( sheet, 2, 0 ).setCellValue( 458 );

     // Write a range of numbers
     sheetRow = sheet.createRow( 3 );
     for (short i = 0; i<10; i++) {
         sheetRow.createCell(i).setCellValue( i*10 );
     }
 }

The use of this view is close to the AbstractPdfView class.

Author:

Jean-Pierre Pawlak

See Also:

AbstractPdfView

Field Summary

Fields inherited from class org.springframework.web.servlet.view.AbstractView

DEFAULT_CONTENT_TYPE

Fields inherited from class org.springframework.context.support.ApplicationObjectSupport

logger

Constructor Summary

AbstractExcelView()

Method Summary

protected abstract void	buildExcelDocument(Map model, HSSFWorkbook workbook, HttpServletRequest request, HttpServletResponse response) Subclasses must implement this method to create an Excel HSSFWorkbook document, given the model.
protected HSSFCell	getCell(HSSFSheet sheet, int row, int col) Convenient method to obtain the cell in the given sheet, row and column.
protected HSSFWorkbook	getTemplateSource(String url, HttpServletRequest request) Creates the workbook from an existing XLS document.
protected void	renderMergedOutputModel(Map model, HttpServletRequest request, HttpServletResponse response) Renders the view given the specified model.
protected void	setText(HSSFCell cell, String text) Convenient method to set a String as text content in a cell.
void	setUrl(String url) Sets the url of the Excel workbook source without localization part nor extension.

Methods inherited from class org.springframework.web.servlet.view.AbstractView

addStaticAttribute, createRequestContext, getAttributesMap, getBeanName, getContentType, getRequestContextAttribute, getStaticAttributes, render, setAttributes, setAttributesCSV, setAttributesMap, setBeanName, setContentType, setRequestContextAttribute, toString

Methods inherited from class org.springframework.web.context.support.WebApplicationObjectSupport

getServletContext, getTempDir, getWebApplicationContext, isContextRequired

Methods inherited from class org.springframework.context.support.ApplicationObjectSupport

getApplicationContext, getMessageSourceAccessor, initApplicationContext, requiredContextClass, setApplicationContext

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

AbstractExcelView

public AbstractExcelView()

Method Detail

setUrl

public void setUrl(String url)

Sets the url of the Excel workbook source without localization part nor extension.

renderMergedOutputModel

protected final void renderMergedOutputModel(Map model,
                                             HttpServletRequest request,
                                             HttpServletResponse response)
                                      throws Exception

Renders the view given the specified model.

Specified by:

renderMergedOutputModel in class AbstractView

Parameters:

model - combined output Map (never null), with dynamic values taking precedence over static attributes

request - current HTTP request

response - current HTTP response

Throws:

Exception - if rendering failed

getTemplateSource

protected HSSFWorkbook getTemplateSource(String url,
                                         HttpServletRequest request)
                                  throws ServletException,
                                         IOException

Creates the workbook from an existing XLS document.

Parameters:

url - URL of the Excel template without localization part nor extension

request - current HTTP request

Returns:

the HSSFWorkbook

Throws:

ServletException

IOException

buildExcelDocument

protected abstract void buildExcelDocument(Map model,
                                           HSSFWorkbook workbook,
                                           HttpServletRequest request,
                                           HttpServletResponse response)
                                    throws Exception

Subclasses must implement this method to create an Excel HSSFWorkbook document, given the model.

Parameters:

model - the model Map

workbook - the Excel workbook to complete

request - in case we need locale etc. Shouldn't look at attributes.

response - in case we need to set cookies. Shouldn't write to it.

Throws:

Exception

getCell

protected HSSFCell getCell(HSSFSheet sheet,
                           int row,
                           int col)

Convenient method to obtain the cell in the given sheet, row and column.

Creates the row and the cell if they still doesn't already exist. Thus, the column can be passed as an int, the method making the needed downcasts.

Parameters:

sheet - a sheet object. The first sheet is usually obtained by workbook.getSheetAt(0)

row - thr row number

col - the column number

Returns:

the HSSFCell

setText

protected void setText(HSSFCell cell,
                       String text)

Convenient method to set a String as text content in a cell.

Parameters:

cell - the cell in which the text must be put

text - the text to put in the cell