POI 导出exlce 操作

package com.test.util;

import java.util.List;

import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;


/**
* <操作excle公共类 service>
* <功能详细描述>
* @author  * @version  [版本号, 2012-5-9]
* @see  [相关类/方法]
* @since  [产品/模块版本]
*/
public class ExportExcelUtil
{
    /**
     * <导出活跃告警信息>
     * <功能详细描述>
     * @param list
     * @return
     * @see [类、类#方法、类#成员]
     */
    public XSSFWorkbook exportActive(List<ActiveAlarmInfo> list)
    {
        // 声明一个工作薄
        XSSFWorkbook workBook = new XSSFWorkbook();
       
        // 生成一个工作表
        XSSFSheet sheet = workBook.createSheet();
       
        //给sheet赋值
        workBook.setSheetName(0, "active");
       
        //生成一行
        XSSFRow row = sheet.createRow(0);
       
        //锁定0行一列
        sheet.createFreezePane(0, 1);
       
        //设置4列单元格宽度（根据创建的单元格多少来设定多少列）
        for (int i = 0; i < 2; ++i)
        {
            sheet.setColumnWidth(i, 7200);
        }
       
        //给exlce表格头的字段赋值
        cteateCell(row, 0, "标识");
        cteateCell(row, 1, "名称");
              
        //如果list不为空进行excle写入操作
        if ((null != list) && (list.size() > 0))
        {
            int i = 0;
           
            XSSFRow row2 = null;
           
            //遍历list把结果写入excle表格
            for (ActiveAlarmInfo active : list)
            {
                i++;
               
                row2 = sheet.createRow(i);
               
                cteateCell(row2, 0, active.getHnbID());
                cteateCell(row2, 1, active.getHnbName());
              }
        }
       
        return workBook;
    }
   
       
    /**
     * <创建表格公共方法>
     * <功能详细描述>
     * @param row
     * @param col
     * @param value
     * @see [类、类#方法、类#成员]
     */
    private void cteateCell(XSSFRow row, int col, String value)
    {
        //创建单元格
        XSSFCell cell = row.createCell(col);
       
        //给单元格赋值
        cell.setCellValue(value);
    }
   
}


/**
     * <活跃告警信息exlce导出 controller>
     * <功能详细描述>
     * @param request
     * @param response
     * @see [类、类#方法、类#成员]
     */
    @RequestMapping("/exportActive")
    public void exportActive(HttpServletRequest request, HttpServletResponse response, ActiveAlarmInfo active)
    {
        try
        {
            //取得request范围内的参数类型
            String type = request.getParameter("type");
           
            //获取用户权限
            HttpSession session = request.getSession();
            UserInfo user = (UserInfo)session.getAttribute("user");
            String roleBank = user.getRoleRank();
            List<ActiveAlarmInfo> activeList = null;
          
            //设置excle表格的名称
            response.setHeader("Content-disposition", "attachment; filename=exportAllActive.xlsx");
           
    //获取数据
            ActiveAlarmInfo actives = new ActiveAlarmInfo();
            activeList = activeService.getAllActiveInfo(actives);

            //定义输出流
            OutputStream os = null;
           
            ExportExcelUtil excle = new ExportExcelUtil();
           
            //创建exlce表格类，调用导出方法
            XSSFWorkbook workBook = excle.exportActive(activeList);
           
            //写出文件
            os = response.getOutputStream();
            workBook.write(os);
           
        }
        catch (Exception e)
        {
            logger.error(Global.LOG_EXCEPTION_NAME, e);
        }
    }