excelpage.java

Spring2.0宝典

package lee;

import javax.servlet.http.*;
import java.util.*;
import org.springframework.web.servlet.view.document.AbstractExcelView;
import org.apache.poi.hssf.usermodel.*;


/**
 * @author  yeeku.H.lee [e-mail]
 * @version  1.0
 * <br>Copyright (C), 2005-2008, yeeku.H.Lee
 * <br>This program is protected by copyright laws.
 * <br>Program Name:
 * <br>Date: 
 */
public class ExcelPage extends AbstractExcelView
{
    protected void buildExcelDocument(Map model,HSSFWorkbook wb,
		HttpServletRequest req,HttpServletResponse resp)throws Exception 
	{
    
        HSSFSheet sheet;
        HSSFRow sheetRow;
        HSSFCell cell;
        // 进入第一个页面
        // getSheetAt: 方法用于从已经存在的文档开始
        //sheet = wb.getSheetAt( 0 );
        sheet = wb.createSheet("Spring");
        sheet.setDefaultColumnWidth((short)12);

        //在A1处输入一些文本
        cell = getCell( sheet, 0, 0 );
		//设置支持中文
		cell.setEncoding(HSSFCell.ENCODING_UTF_16);
        setText(cell,"Spring-Excel测试");

		//遍历模型，将其插入到excel文档中
        List words = (List ) model.get("wordList");
        for (int i=0; i < words.size(); i++)
		{
            cell = getCell( sheet, 2+i, 0 );
            setText(cell, (String) words.get(i));
        }
    }
}