java导出excel的方式_java 三种excel导出方式

1，EXCELUTILS所需的JAR包：excelutils.jar poi-2.5.1.jar commons-logging.jar commons-digester.jar commons-beanutils.jar，加外可能还需加添加osh.jar包。将上述jar包加入自己的web工程的classpath中。

2，定义自己的excel模板：

在excel中添加excelutils的自定义标签，常用标签如下：

#foreach detail in ${list}

${detail.name}  ${detail.qty} ...

#end

迭代输出list中数据

另外一些标签：

${printDate}

${model.name}#formula SUM(C${detailStartRowNo}:C${detailEndRowNo})

#each ${model}

#each ${model} on ${keys}

#each ${model} ${width1},${width2}... on ${keys}

#sum qty on ${list} where name=test

#sum qty on ${list} where name like test

#sum qty on ${list} where name like ${value}

#call service.getStr("str",${aaa})

#call service.getModel("str",${aaa}).name

#formula SUM(C${currentRowNo}:F${currentRowNo})

3，编写JAVA代码：

List list= new ArrayList();

Model model  = new Model();

.list.add(model)

ExcelUtils.addValue("list", list);

ExcelUtils.addSerivce("service", service);

String config = "/WEB-INF/xls/demo.xls";

response.reset();

response.setContentType("application/vnd.ms-excel");

response.setHeader("Content-Disposition", "attachment; filename=\""

+ System.currentTimeMillis() + ".xls\"");

//filename中文乱码问题处理///

public  String toUtf8String(String fileNameSrc){//处理导出文件名的中文乱码问题

String fileName;

try {

fileName = java.net.URLEncoder.encode(fileNameSrc,"UTF-8");

if(fileName.length()>150)//解决IE 6.0 bug

fileName=new String(fileNameSrc.getBytes("GBK"),"ISO-8859-1");

return fileName;

} catch (UnsupportedEncodingException e) {

e.printStackTrace();

}

return ""+System.currentTimeMillis();

}

///

ExcelUtils.export(getServlet().getServletContext(),

config,response.getOutputStream());

return null;