package com.fh.util;
import java.io.BufferedInputStream;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.util.Map;
import javax.servlet.http.HttpServletResponse;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.ss.usermodel.Workbook;
import net.sf.jxls.transformer.XLSTransformer;
public class ExportExcelUtil {
public static void doDownload(String path, String destFileName, HttpServletResponse response,Map<String, Object> map) {
XLSTransformer transformer = new XLSTransformer();
InputStream in = null;
OutputStream out = null;
response.reset();
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-Disposition", "attachment;filename=" + destFileName);
System.out.println("destFileName:"+destFileName);
try {
in = new BufferedInputStream(new FileInputStream(path));
Workbook workbook = transformer.transformXLS(in, map);
out = response.getOutputStream();
workbook.write(out);
out.flush();
} catch (InvalidFormatException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} finally {
if (in != null) {
try {
in.close();
} catch (IOException e) {
}
}
if (out != null) {
try {
out.close();
} catch (IOException e) {
}
}
}
}
import java.io.BufferedInputStream;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.util.Map;
import javax.servlet.http.HttpServletResponse;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.ss.usermodel.Workbook;
import net.sf.jxls.transformer.XLSTransformer;
public class ExportExcelUtil {
public static void doDownload(String path, String destFileName, HttpServletResponse response,Map<String, Object> map) {
XLSTransformer transformer = new XLSTransformer();
InputStream in = null;
OutputStream out = null;
response.reset();
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-Disposition", "attachment;filename=" + destFileName);
System.out.println("destFileName:"+destFileName);
try {
in = new BufferedInputStream(new FileInputStream(path));
Workbook workbook = transformer.transformXLS(in, map);
out = response.getOutputStream();
workbook.write(out);
out.flush();
} catch (InvalidFormatException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} finally {
if (in != null) {
try {
in.close();
} catch (IOException e) {
}
}
if (out != null) {
try {
out.close();
} catch (IOException e) {
}
}
}
}
}
//调用方法
@RequestMapping("/exportReport")
public void exportArriveOnTimeRateReport(HttpServletRequest request,HttpServletResponse response) throws Exception{
Map<String, Object> map = new HashMap<String, Object>();
String path = PathUtil.getClasspath() + "exportReport.xls", //模板地址
destFileName = "exportReport.xls";//导出文件名
List<PageData> orders=new ArrayList<PageData>();//要显示的数据
map.put("orders", orders);
ExportExcelUtil.doDownload(path, destFileName, response, map);
}
//模板