1 packagecom.java.zxf.util;2
3 importjava.io.IOException;4 importjava.io.OutputStream;5 importjava.net.URLEncoder;6 importjava.util.List;7 importjavax.servlet.http.HttpServletResponse;8 importorg.apache.poi.hssf.usermodel.HSSFCell;9 importorg.apache.poi.hssf.usermodel.HSSFRow;10 importorg.apache.poi.hssf.usermodel.HSSFSheet;11 importorg.apache.poi.hssf.usermodel.HSSFWorkbook;12 /**
13 * 用来生成xsls或xsl文件的类,生成后可以进行传输下载14 * 注意:前台请不要使用ajax方式发送下载请求,因为其不支持.15 *@authorAdministrator16 *17 */
18 public classXSLXUtil {19 /**
20 *21 *@paramresponse22 *@paramtitlelist:一个list集合,用来指定表头信息23 *@paramobjlist:一个list结合嵌套,内存list就是表头字段对应得一行数据24 *@paramfilename:一个文件名,可以自己指定25 *@throwsIOException26 */
27 public static void getbook(HttpServletResponse response,List titlelist,List> objlist,String filename) throwsIOException{28 HSSFWorkbook wb = newHSSFWorkbook();29 //建立新的sheet对象(excel的表单)
30 HSSFSheet sheet=wb.createSheet();31 //这里是指定每列的宽度256=1字符,依次类推
32 for(int x=0;x
44
45 HSSFRow row1=sheet.createRow(0);46 for(int i=0;i temp = (List) objlist.get(j);52 for(int k=0;k
58 /*OutputStream os = new FileOutputStream("c:\\"+filename);59 wb.write(os);60 os.flush();61 os.close();62 SystemOut.classSystemOut("xslx文件创建成果", "");*/
63 response.reset();64 OutputStream output=response.getOutputStream();65 response.setHeader("Content-disposition", "attachment; filename="+ URLEncoder.encode(filename, "UTF-8"));66 response.setContentType("application/msexcel");67 wb.write(output);68 output.close();69 SystemOut.classSystemOut("xslx文件创建成果", "");70 }71 }