java poi demo_POI小demo

1 packagecom.zto.branchaging.web.controller;2

3 importjava.io.IOException;4 importjava.io.OutputStream;5 importjava.lang.reflect.Field;6 importjava.lang.reflect.InvocationTargetException;7 importjava.lang.reflect.Method;8 importjava.util.ArrayList;9 importjava.util.Arrays;10 importjava.util.Collection;11 importjava.util.Iterator;12 importjava.util.List;13

14 importorg.apache.poi.hssf.usermodel.HSSFCell;15 importorg.apache.poi.hssf.usermodel.HSSFCellStyle;16 importorg.apache.poi.hssf.usermodel.HSSFRichTextString;17 importorg.apache.poi.hssf.usermodel.HSSFRow;18 importorg.apache.poi.hssf.usermodel.HSSFSheet;19 importorg.apache.poi.hssf.usermodel.HSSFWorkbook;20

21 /**

22 *23 *24 *@authorleno25 *@versionv1.026 *@param27 * 应用泛型，代表任意一个符合javabean风格的类28 * 注意这里为了简单起见，boolean型的属性xxx的get器方式为getXxx(),而不是isXxx()29 * byte[]表jpg格式的图片数据30 */

31 public class PoiUtil{32

33 public void exportExcel(Collectiondataset, OutputStream out) {34 exportExcel("POI导出EXCEL文档", null, dataset, out, "yyyy-MM-dd");35 }36

37 public void exportExcel(String[] headers, Collectiondataset,38 OutputStream out) {39 exportExcel("POI导出EXCEL文档", headers, dataset, out, "yyyy-MM-dd");40 }41

42 public void exportExcel(String[] headers, Collectiondataset,43 OutputStream out, String pattern) {44 exportExcel("POI导出EXCEL文档", headers, dataset, out, pattern);45 }46

47 /**

48 * 这是一个通用的方法，利用了JAVA的反射机制，可以将放置在JAVA集合中并且符号一定条件的数据以EXCEL 的形式输出到指定IO设备上49 *50 *@paramtitle51 * 表格标题名52 *@paramheaders53 * 表格属性列名数组54 *@paramdataset55 * 需要显示的数据集合,集合中一定要放置符合javabean风格的类的对象。此方法支持的56 * javabean属性的数据类型有基本数据类型及String,Date,byte[](图片数据)57 *@paramout58 * 与输出设备关联的流对象，可以将EXCEL文档导出到本地文件或者网络中59 *@parampattern60 * 如果有时间数据，设定输出格式。默认为"yyy-MM-dd"61 */

62 @SuppressWarnings("unchecked")63 public voidexportExcel(String title, String[] headers,64 Collectiondataset, OutputStream out, String pattern) {65

66 List result = newArrayList();67 List paramterList =Arrays.asList(dataset.toArray());68 //声明一个工作薄

69 HSSFWorkbook workbook = newHSSFWorkbook();70

71 //设定每个sheet存储的数据量为五万，不能超过六万五

72 int pageCount = (int)Math.ceil(dataset.size()/50000)+1;//需要创建的sheet个数

73 if(dataset.size()<=50000){74 result = paramterList.subList(0, dataset.size());75 }76

77 //生成一个样式

78 HSSFCellStyle style =workbook.createCellStyle();79 style.setAlignment(HSSFCellStyle.ALIGN_CENTER); //居中

80

81 for(int j=0;j

89 HSSFSheet sheet = workbook.createSheet(title+"-"+String.valueOf(j+1));90 //设置表格默认列宽度为15个字节

91 sheet.setDefaultColumnWidth((short) 15);92 sheet.setColumnWidth(1, 24*256); //设置列宽，第二列24个字符宽93 //产生表格标题行

94 HSSFRow row = sheet.createRow(0);95 for (short i = 0; i < headers.length; i++) {96 HSSFCell cell =row.createCell(i);97 cell.setCellStyle(style);98 HSSFRichTextString text = newHSSFRichTextString(headers[i]);99 cell.setCellValue(text);100 }101 //遍历集合数据，产生数据行

102 Iterator it =result.iterator();103 int index = 0;104 while(it.hasNext()) {105 index++;106 row =sheet.createRow(index);107 T t =(T) it.next();108 //利用反射，根据javabean属性的先后顺序，动态调用getXxx()方法得到属性值

109 Field[] fields =t.getClass().getDeclaredFields();110 for (short i = 0; i < fields.length; i++) {111 HSSFCell cell =row.createCell(i);112 cell.setCellStyle(style);113 Field field =fields[i];114 String fieldName =field.getName();115 String getMethodName = "get"

116 + fieldName.substring(0, 1).toUpperCase()117 + fieldName.substring(1);118 try{119 Class tCls =t.getClass();120 Method getMethod =tCls.getMethod(getMethodName,121 newClass[] {});122 Object value = getMethod.invoke(t, newObject[] {});123

124 //数据类型都当作字符串简单处理

125 String textValue = String.valueOf(null==value?"":value);126

127 if (textValue != null) {128 cell.setCellValue(textValue);129 }130 } catch(SecurityException e) {131 //TODO Auto-generated catch block

132 e.printStackTrace();133 } catch(NoSuchMethodException e) {134 //TODO Auto-generated catch block

135 e.printStackTrace();136 } catch(IllegalArgumentException e) {137 //TODO Auto-generated catch block

138 e.printStackTrace();139 } catch(IllegalAccessException e) {140 //TODO Auto-generated catch block

141 e.printStackTrace();142 } catch(InvocationTargetException e) {143 //TODO Auto-generated catch block

144 e.printStackTrace();145 } finally{146 //清理资源

147 }148 }149

150 }151

152 }153 try{154 workbook.write(out);155 } catch(IOException e) {156 //TODO Auto-generated catch block

157 e.printStackTrace();158 }159

160 }161

162 }