poi导出Excel

package controller;

import java.security.NoSuchAlgorithmException; import java.util.List; import javax.servlet.http.HttpServletRequest; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.multipart.MultipartFile; import entity.User; import service.UserService; @Controller public class UserController { @Autowired private UserService service;

        /**

* 导出 * @param request * @return */ @RequestMapping("out") public String out(HttpServletRequest request){

HSSFWorkbook workbook = new HSSFWorkbook();

                //创建工作表

HSSFSheet sheet = workbook.createSheet(); sheet.setColumnWidth(2, 45*256); sheet.setColumnWidth(5, 20*256);

sheet.setColumnWidth(6, 10*256);

                //创建第一行

HSSFRow row1 = sheet.createRow(0);

                //设置列名

row1.createCell(0).setCellValue("姓名"); row1.createCell(1).setCellValue("性别"); row1.createCell(2).setCellValue("密码"); row1.createCell(3).setCellValue("手机号"); row1.createCell(4).setCellValue("电子邮件"); row1.createCell(5).setCellValue("身份证号");

row1.createCell(6).setCellValue("图片");

                //查询要导出的数据

List<User> list=service.findAll();

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

                        //从第二行开始

HSSFRow row = sheet.createRow(i+1);

User user = list.get(i);

                        //设置每一行的每个单元格数据

row.createCell(0).setCellValue(user.getName()); row.createCell(1).setCellValue(user.getSex()); row.createCell(2).setCellValue(user.getPass()); row.createCell(3).setCellValue(user.getIp()); row.createCell(4).setCellValue(user.getEmail()); row.createCell(5).setCellValue(user.getIdcard()); row.createCell(6).setCellValue(user.getPic()); } FileOutputStream outputStream;

try {

                        //输出流  

outputStream = new FileOutputStream(new File("D:/a.xls"));

                        //写出

workbook.write(outputStream);

                        //关闭输出流

outputStream.close(); } catch (FileNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } request.setAttribute("msg", "导出成功"); return "forward:findAll.do";

}

}