java导出简单写法

List<SaleOrderExportDTO> list = TransferUtil.transferList(queryList, SaleOrderExportDTO.class);

//导出
PoiUtil<SaleOrderExportDTO> poiUtil = new PoiUtil<SaleOrderExportDTO>(SaleOrderExportDTO.class);
HSSFWorkbook workbook = poiUtil.exportExcel(list);

String fileName = "订单发货数据导出报表";

OutputStream output = null;
OutputStream out = null;
try {
response.setHeader("Content-disposition","attachment;filename="+ URLEncoder.encode(fileName,"UTF-8")+".xls;filename*=UTF-8''"+URLEncoder.encode(fileName,"UTF-8")+".xls");

response.setContentType("application/octet-stream;charset=UTF-8");

output = response.getOutputStream();
out = new ByteArrayOutputStream();
workbook.write(output);
out.flush();
out.close();

} catch (IOException e) {
//
} finally {
if (output != null) {
try {
output.close();
} catch (IOException e) {
//
}
}
}
原文地址:https://www.cnblogs.com/YuyuanNo1/p/8440958.html