JAVA——18.excel导出

标签：写入usermodresponseattributedirstr位置directoryrip

后台导出excel

1.导入jar包

链接：http://pan.baidu.com/s/1c2L70lE 密码：nvhh

2.获取绝对路径

2.源码：

package com.action;

import java.io.File;
import java.io.FileOutputStream;
import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import net.sf.json.JSONArray;
import net.sf.json.JSONObject;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.struts2.ServletActionContext;

import com.bean.AccountByDay;
import com.bean.Qcash;
import com.opensymphony.xwork2.ActionSupport;
import com.util.UrlUtil;

/**
* 棋牌室提现excel导出
* @author Administrator
*
*/
public class QpsCashExcelAction extends ActionSupport{

private List<Qcash> qcash;

public List<Qcash> getQcash() {
return qcash;
}

public void setQcash(List<Qcash> qcash) {
this.qcash = qcash;
}
@Override
public String execute() throws Exception {
// TODO Auto-generated method stub
HttpServletResponse response=null;
response=ServletActionContext.getResponse();

HttpServletRequest request=ServletActionContext.getRequest();

response.setContentType(\”text/html;charset=UTF-8\”);
response.setCharacterEncoding(\”UTF-8\”);
PrintWriter out=response.getWriter();
//创建session对象
HttpSession session=ServletActionContext.getRequest().getSession();
if