java导出excel表格 jxl_基于springMvc的maven项目,使用jxl导出excel表格

jxl架包maven的pom.xml配置

net.sourceforge.jexcelapi

jxl

2.6.12

java代码 导出主要类(修改了时间转换和根据字段名导出对应字段)

package mon.util;

import java.io.OutputStream;

import java.lang.reflect.Method;

import java.text.SimpleDateFormat;

import java.util.Date;

import java.util.List;

import java.util.Map;

import javax.servlet.http.HttpServletResponse;

import org.apache.log4j.Logger;

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;

public class ExportExcelUtil {

private final static Logger logger = Logger.getLogger(ExportExcelUtil.class);

private final static SimpleDateFormat dateFormat=new SimpleDateFormat("yyyy.MM.dd HH:mm:ss");

/**

* 导出excel

*

* @param fileName

* @param exportMap

* @param listContent

* @param response

* @return

*/

@SuppressWarnings("rawtypes")

public final static String exportExcel(String fileName, Map exportMap,

List extends Object> listContent, HttpServletResponse response) {

String result = "success";

// 以下开始输出到EXCEL

try {

// 定义输出流，以便打开保存对话框______________________begin