Java Web使用POI导出Excel的方法详解

本文实例讲述了Java Web使用POI导出Excel的方法。分享给大家供大家参考，具体如下：

采用Spring mvc架构：

Controller层代码如下

@Controller

public class StudentExportController{

@Autowired

private StudentExportService studentExportService;

@RequestMapping(value = "/excel/export")

public void exportExcel(HttpServletRequest request, HttpServletResponse response)

throws Exception {

List<Student> list = new ArrayList<Student>();

list.add(new Student(1000,"zhangsan","20"));

list.add(new Student(1001,"lisi","23"));

list.add(new Student(1002,"wangwu","25"));

HSSFWorkbook wb = studentExportService.export(list);

response.setContentType("application/vnd.ms-excel");

response.setHeader("Content-disposition", "attachment;filename=student.xls");

OutputStream ouputStream = response.getOutputStream();

wb.write(ouputStream);

ouputStream.flush();

ouputStream.close();

}

Service层代码如下：

@Service

public class StudentExportService {

String[] excelHeader = { "Sno", "Name", "Age"};

public HSSFWorkbook export(List<Campaign> list) {

HSSFWorkbook wb = new HSSFWorkbook();

HSSFSheet sheet = wb.createSheet("Campaign");

HSSFRow row = sheet.createRow((int) 0);

HSSFCellStyle style = wb.createCellStyle();

style.setAlignment(HSSFCellStyle.ALIGN_CENTER);

for (int i = 0; i < excelHeader.length; i++) {

HSSFCell cell = row.createCell(i);

cell.setCellValue(excelHeader[i]);

cell.setCellStyle(style);

sheet.autoSizeColumn(i);

}

for (int i = 0; i < list.size(); i++) {

row = sheet.createRow(i + 1);

Student student = list.get(i);

row.createCell(0).setCellValue(student.getSno());

row.createCell(1).setCellValue(student.getName());

row.createCell(2).setCellValue(student.getAge());

}

return wb;

}

前台的js代码如下：

Java Web使用POI导出Excel的方法详解

相关文章

快网idc优惠网

相关文章

微信

快网idc优惠网

QQ交流群