java 写入 xlsx_JAVA创建并写入内容到xlsx文件

首先需要在web项目中导入jxl.jar 包

//action中代码

public String downloadReport(){

String path = System.getProperty("java.io.tmpdir") + "\xlsx"+ (new java.util.Date().getTime());

List users=new ArrayList();//查询结果集

users.add(new User(1, "屌丝1", 18, "男"));

users.add(new User(2, "妹子2", 19, "女"));

users.add(new User(3, "屌丝3", 20, "男"));

users.add(new User(4, "妹子4", 21, "女"));

users.add(new User(5, "屌丝5", 22, "男"));

try {

createExcel(path,List users);//方法代码在下面

//下载文件

response().setContentType("application/x-msdownload;charset=UTF-8"); // 设置响应类型为下载

response().setCharacterEncoding("UTF-8");//页面乱码问题

String docName = java.net.URLEncoder.encode("report_case.xls", "UTF-8");//文件名称设置

response().setHeader("Content-Disposition", "attachment; filename="+ new String(docName.getBytes("UTF-8"), "UTF-8"));

BufferedInputStream br = new BufferedInputStream(new FileInputStream(path));

byte[] buf = new byte[1024];

int len = 0;

OutputStream out = response().getOutputStream();

while ((len = br.read(buf