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();
}
}
}