Java XLSTransformer生成excel文件

article/2025/11/5 3:06:45

把页面的数据导出excel 数据

然后进入 struts2 action

          <action name="generateExcel" class="com.xx.emidas.activity.activity.ajax.XLSTransformerGenerateExcelAction"></action>

package com.xx.emidas.activity.activity.ajax;import com.xx.combiz.spring.util.LionConfigUtils;
import com.xx.emidas.activity.external.util.XLSTransformerGenerateExcelUtil;
import com.xx.emidas.activity.picture.BaseAction;import org.apache.http.HttpEntity;
import org.apache.http.HttpResponse;
import org.apache.http.client.ClientProtocolException;
import org.apache.http.client.methods.HttpGet;
import org.apache.http.impl.client.CloseableHttpClient;
import org.apache.http.impl.client.HttpClients;
import org.apache.http.util.EntityUtils;
import org.apache.struts2.ServletActionContext;import java.io.File;
import java.io.IOException;
import java.io.Writer;
import java.util.*;import javax.servlet.http.HttpServletResponse;public class XLSTransformerGenerateExcelAction extends BaseAction {private String url;private String name;/**活动ID*/private int activityId;/**查询起始日期*/private String queryStart;/**查询结束日期*/private String queryend;/*** */private static final long serialVersionUID = 2058361031969467470L;@Overridepublic String execute() throws Exception {try {//url="http://localhost:8080/activities/activity/newClickdate"+"?activityId="+activityId+"&queryStart="+queryStart+"&queryend="+queryend;url = LionConfigUtils.getProperty("emidas-event.activity.data.excelExport", "0");url+="?activityId="+activityId+"&queryStart="+queryStart+"&queryend="+queryend;XLSTransformerGenerateExcelUtil.ExportExcel(url, name);} catch (Exception e) {}return null;}public String getUrl() {return url;}public void setUrl(String url) {this.url = url;}public String getName() {return name;}public void setName(String name) {this.name = name;}public int getActivityId() {return activityId;}public void setActivityId(int activityId) {this.activityId = activityId;}public String getQueryStart() {return queryStart;}public void setQueryStart(String queryStart) {this.queryStart = queryStart;}public String getQueryend() {return queryend;}public void setQueryend(String queryend) {this.queryend = queryend;}}

这里的 url 是你的需要数据的页面或者 action 图片也可以显示的

这里是我自己封装的XLSTransformer的工具类

package com.xx.emidas.activity.external.util;import java.io.IOException;
import java.io.Writer;import javax.servlet.http.HttpServletResponse;import org.apache.http.HttpEntity;
import org.apache.http.HttpResponse;
import org.apache.http.client.ClientProtocolException;
import org.apache.http.client.methods.HttpGet;
import org.apache.http.impl.client.CloseableHttpClient;
import org.apache.http.impl.client.HttpClients;
import org.apache.http.util.EntityUtils;
import org.apache.struts2.ServletActionContext;
public class XLSTransformerGenerateExcelUtil {/*** 导出页面数据生成 xlsx* @author hongwang.zhang* @date 20150826* @param path  url路径* @param name  excel名称*/public static void  ExportExcel( String path,String name){CloseableHttpClient httpClient = HttpClients.createDefault();HttpGet httppost = new HttpGet(path);try {// 发送请求，返回响应HttpResponse response = httpClient.execute(httppost);// 打印响应信息HttpEntity entity = response.getEntity();HttpServletResponse x = ServletActionContext.getResponse();x.setContentType("application/vnd.ms-excel");  String titlename="data"; if(null!=name){titlename=name;}x.setHeader("Content-Disposition", "attachment;filename="+new String((titlename).getBytes("gbk"),"iso8859-1")+".xlsx");  Writer w = null;w = x.getWriter();w.write(EntityUtils.toString(entity));w.flush();EntityUtils.consume(entity);//} catch (ClientProtocolException e) {// 协议错误e.printStackTrace();} catch (IOException e) {// 网络异常e.printStackTrace();}}}

导出来的基本会和页面上的数据样式一样的，这里我自己做了一个独立的页面对样式做了一些修改导出的excel 和页面上的一模一样