1.所需jar包
commons-logging-1.0.4.jar
junit-4.7.jar
log4j-1.2.16.jar
org\apache\poi\poi\3.9
2.Util工具类
ExcelEntity.java
package com.httc.base.web.api.util;
import java.util.List;
/**
* 代表要打印的Excel表格,用于存放要导出为Excel的相关数据
* @author zhrb@cec.jmu
*
* @param <T> 代表要打印的数据实体,如User等
*/
public class ExcelEntity<T> {
private String sheetName = "Sheet1";//默认生成的sheet名称
private String header="";//题头
private String footer="";//脚注
//底下是必须具备的属性
private String fileName;
private String[] columnNames;//列名
private String[] methodNames;//与列名对应的方法名
private List<T> entities;//数据实体
public ExcelEntity(String fileName, String[] columnNames, String[] methodNames, List<T> entities) {
this("sheet1","","",fileName,columnNames,methodNames,entities);
}
public ExcelEntity(String sheetName, String header, String footer, String fileName, String[] columnNames,
String[] methodNames, List<T> entities) {
this.sheetName = sheetName;
this.header = header;
this.footer = footer;
this.fileName = fileName;
this.columnNames = columnNames;
this.methodNames = methodNames;
this.entities = entities;
}
public String getHeader() {
return header;
}
public void setHeader(String header) {
this.header = header;
}
public String getSheetName() {
return sheetName;
}
public void setSheetName(String sheetName) {
this.sheetName = sheetName;
}
public List<T> getEntities() {
return entities;
}
/**
*
* @param entities 用于导出Excel的实体集合
*/
public void setEntities(List<T> entities) {
this.entities = entities;
}
public String getFooter() {
return footer;
}
public void setFooter(String footer) {
this.footer = footer;
}
public String[] getColumnNames() {
return columnNames;
}
public void setColumnNames(String[] columnNames) {
this.columnNames = columnNames;
}
public String getFileName() {
return fileName;
}
public void setFileName(String fileName) {
this.fileName = fileName;
}
public String[] getMethodNames() {
return methodNames;
}
public void setMethodNames(String[] metho