//1.导出EXCEL的文件名fileName
final String fileName = "export" + System.currentTimeMillis() + ".xls";
//导出EXCEL的存放路径
final String exportPath = ServletActionContext.getServletContext().getRealPath("/"); //创建的Excel存放的目录;
final Object obj = ServletActionContext.getServletContext();
final File exportDir = new File(exportPath);
//目录不存在,则自动创建目录
if (!exportDir.exists()) {
exportDir.mkdirs();
}
//2.创建一个空的Excel文档。创建一页sheet
final HSSFWorkbook wb = new HSSFWorkbook();
final HSSFSheet sheet = wb.createSheet("sheet");
final HSSFCellStyle cellStyle = wb.createCellStyle();
cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 水平布局:居中
final String fileName = "export" + System.currentTimeMillis() + ".xls";
//导出EXCEL的存放路径
final String exportPath = ServletActionContext.getServletContext().getRealPath("/"); //创建的Excel存放的目录;
final Object obj = ServletActionContext.getServletContext();
final File exportDir = new File(exportPath);
//目录不存在,则自动创建目录
if (!exportDir.exists()) {
exportDir.mkdirs();
}
//2.创建一个空的Excel文档。创建一页sheet
final HSSFWorkbook wb = new HSSFWorkbook();
final HSSFSheet sheet = wb.createSheet("sheet");
final HSSFCellStyle cellStyle = wb.createCellStyle();
cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 水平布局:居中
cellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); //垂直居中
cellStyle.setWrapText(true);
//创建一行,创建单元格
HSSFRow row = null; //行
HSSFCell cell = null; //单元格
row = sheet.createRow(n);
cell = row.createCell(n); //第n行第n个单元格
cell.setCellStyle(style); //设置单元格样式
cell.setCellValue(value); //给单元格赋值
需要引入poi-3.8的jar包