java程序导出Excel

package com.excel; import java.io.File; import java.lang.reflect.Field; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import jxl.Workbook; import jxl.format.Alignment; import jxl.format.Border; import jxl.format.BorderLineStyle; import jxl.format.CellFormat; import jxl.format.Colour; import jxl.format.UnderlineStyle; import jxl.format.VerticalAlignment; import jxl.write.Label; import jxl.write.WritableCell; import jxl.write.WritableCellFormat; import jxl.write.WritableFont; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; import jxl.write.WriteException; public class ExcelFileExport implements IFileExport { private String fileName = "export_data"; private String fileSaveDir = "C:/" ; int a; @Override public void export(String fileName, Header[] header, List<Object> dataSource,String name) { this.fileName = fileName != null ? fileName : this.fileName; String fileDir = fileSaveDir + this.fileName + ".xls"; WritableWorkbook book = null; WritableSheet sheet = null; try { // create xls book //生成一个表格 book = Workbook.createWorkbook(new File(fileDir)); //该方法的作用是创建一个WorkSheet放在指定的位置 sheet = book.createSheet(name, 0); // create report header if(header != null && header.length > 0){ List<WritableCell> returnHead = createHeader(header); for(WritableCell label : returnHead){ //该方法的作用是添加单元格,需要注意的是一个Cell/Label只能使用一次 sheet.addCell(label); } } // create report body if(dataSource != null && dataSource.size() > 0){ List<WritableCell> returnBody = createBody(header, dataSource); for(WritableCell label : returnBody){ sheet.addCell(label); } } //给sheet电子版中所有的列设置默认的列的宽度; sheet.getSettings().setDefaultColumnWidth(30); //设置第一行高（标题） sheet.setRowView(0, 600, false); Label labe; WritableFont font = new WritableFont(WritableFont.createFont("Arial"), 20, WritableFont.BOLD); WritableCellFormat format = new WritableCellFormat(font); format.setAlignment(Alignment.CENTRE); format.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.THIN); sheet.mergeCells(0,0,a-1,0); labe = new Label(0,0,name,format); sheet.addCell(labe); //生成一个文档 book.write(); } catch (Exception ex) { ex.printStackTrace(); } finally{ if(book != null){ try { //该方法非常重要，在最后需要调用这个方法，才能使生成的Excel有效  //生成，否则，不写此句的话将会导致生成的Excel文件在打开时提示“文 件的格式与扩展名指定的格式不一致” book.close(); } catch (Exception e) { e.printStackTrace(); } } } } private List<WritableCell> createHeader(Header[] header) throws WriteException { List<WritableCell> result = new ArrayList<WritableCell>(); WritableFont font = new WritableFont(WritableFont.createFont("Arial"), 10, WritableFont.BOLD); WritableCellFormat format = new WritableCellFormat(font); format.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.THIN); format.setAlignment(Alignment.CENTRE); for(a=0;a<header.length;a++){ Label label = new Label(a,1,header[a].getText(),format); result.add(label); } return result; } private List<WritableCell> createBody(Header[] header, List<Object> dataSource) throws IllegalArgumentException, IllegalAccessException, WriteException { List<WritableCell> result = new ArrayList<WritableCell>(); WritableFont font = new WritableFont(WritableFont.createFont("Arial")); WritableCellFormat format = new WritableCellFormat(font); format.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.THIN); format.setAlignment(Alignment.CENTRE); Map<String,Integer> headerLocationMap = header != null ? createHeaderLocationMap(header) : new HashMap<String,Integer>(); int rowCount = dataSource.size(); for(int i=1;i<=rowCount;i++){ Object row = dataSource.get(i-1); Field[] fields = row.getClass().getDeclaredFields(); int columnCount = 0; for(int j=0;j<fields.length;j++){ Field field = fields[j]; field.setAccessible(true); String type = field.getType().getName(); if (! TypeUtils.isBaseType(type)) { continue; } WritableCell cell = null; Integer columnLocation = headerLocationMap.get(field.getName()); columnLocation = columnLocation != null ? columnLocation : columnCount; if(TypeUtils.isBooleanType(type)) { cell = new jxl.write.Boolean(columnLocation, i+1, java.lang.Boolean.valueOf(TypeUtils.simpleTypeToStr(field.get(row))),format); } else if(TypeUtils.isNumberType(type)) { cell = new jxl.write.Number(columnLocation, i+1, java.lang.Double.valueOf(TypeUtils.simpleTypeToStr(field.get(row))),format); } else { cell = new Label(columnLocation, i+1, TypeUtils.simpleTypeToStr(field.get(row)),format); } result.add(cell); columnCount++; } } return result; } private Map<String, String> createExcludeMap(String[] exclude) { Map<String,String> map = new HashMap<String,String>(); for(String e: exclude){ map.put(e, e); } return map; } private Map<String, Integer> createHeaderLocationMap(Header[] header) { Map<String,Integer> map = new HashMap<String,Integer>(); for(int i=0;i<header.length;i++){ map.put(header[i].getFieldName(), i); } return map; } }