poi 复杂表头导出

import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.util.List;

import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;

import com.cddgg.lianyoulw.reconciliation.entity.ReconciliationVo;
import com.dgg.rockframework.util.DateUtil;
/**
 * POI复杂表头数据
 * @author liulei
 *
 */
public class PoiTestExcel { 
    /**
     * 导出
     * @param data 数据
     * @param response  response
     * @param session  session
     */
    public static void importExcel(List<ReconciliationVo> data,HttpServletResponse response,HttpSession session){
        //this.getServletContext().getResourceAsStream("");
        // TODO Auto-generated method stub
        try {
            
            InputStream ins=PoiTestExcel.class.getClassLoader().getResourceAsStream("workbook.xls");
            Workbook work = new HSSFWorkbook(ins);
            // 得到excel的第0张表
            Sheet sheet = work.getSheetAt(0);
            // 填充title数据
            Row row = sheet.getRow(0);
            Cell cell = row.getCell(0);
            int i = 2;//计数器
            // 得到行，并填充数据和表格样式

<span style="white-space:pre">		</span>//自己一列一列的设置
            for (;i < data.size()+2; i++) {
                row = sheet.createRow(i);// 得到行
                cell = row.createCell(0);// 得到第0个单元格
                cell.setCellValue(i-1);// 填充值
                cell = row.createCell(1);
                cell.setCellValue();

<span style="white-space:pre">		</span>
            }
            sheet.addMergedRegion(new CellRangeAddress(i,i,0,2));*/
            response.reset();
            response.setContentType("application/vnd.ms-excel");
            response.setHeader("Content-disposition", "attachment;filename="
                    + new String(("到账对账表").getBytes("gbk"), "iso8859-1")
                    + ".xls"); // 解决导出文件中文乱码问题
            OutputStream os = response.getOutputStream();
            //FileOutputStream os = new FileOutputStream("D:\\workbooks3.xls");
            work.write(os);
            os.close();
        } catch (FileNotFoundException e) {
            LoggerUtils.info("文件路径错误");
            e.printStackTrace();
        } catch (IOException e) {
            LoggerUtils.info("文件输入流错误");
            e.printStackTrace();
        }

    }
}