Java导出Excel通用方法,只需要一个list 集合。通用方法改进之处踊跃提出
[java] view plain copy
- package oa.common.utils;
- import java.io.OutputStream;
- import java.util.List;
- import javax.servlet.http.HttpServletResponse;
- import org.apache.struts2.ServletActionContext;
- import java.lang.reflect.Field;
- import jxl.Workbook;
- import jxl.format.Alignment;
- import jxl.format.Border;
- import jxl.format.BorderLineStyle;
- import jxl.format.VerticalAlignment;
- import jxl.write.Label;
- import jxl.write.WritableCellFormat;
- import jxl.write.WritableFont;
- import jxl.write.WritableSheet;
- import jxl.write.WritableWorkbook;
- /***
- * @author lsf
- */
- public class ExportExcel {
- /***************************************************************************
- * @param fileName EXCEL文件名称
- * @param listTitle EXCEL文件第一行列标题集合
- * @param listContent EXCEL文件正文数据集合
- * @return
- */
- public final static String exportExcel(String fileName,String[] Title, List<Object> listContent) {
- String result="系统提示:Excel文件导出成功!";
- // 以下开始输出到EXCEL
- try {
- //定义输出流,以便打开保存对话框______________________begin
- HttpServletResponse response=ServletActionContext.getResponse();
- OutputStream os = response.getOutputStream();// 取得输出流
- response.reset();// 清空输出流
- response.setHeader("Content-disposition", "attachment; filename="+ new String(fileName.getBytes("GB2312"),"ISO8859-1"));
- // 设定输出文件头
- response.setContentType("application/msexcel");// 定义输出类型
- //定义输出流,以便打开保存对话框_______________________end
- /** **********创建工作簿************ */
- WritableWorkbook workbook = Workbook.createWorkbook(os);
- /** **********创建工作表************ */