|
最近写了一个前台浏览器csv导出实例，csv导出需要传入字节，以“，”分割
@ApiOperation(value = "导出订单详情", notes = "导出订单详情", produces = MediaType.APPLICATION_JSON_UTF8_VALUE)
@RequestMapping(value = "/api/order/query/exportOrderDetail", method = RequestMethod.GET)
public ResponseEntity export(@RequestParam String orderNoList) throws Exception {
if(StringUtil.isEmpty(orderNoList)){
return null;
}
String []array=orderNoList.split(",");
List<UserOrderDto> list=allianceService.exportOrderDetail(array);
HttpHeaders headers = new HttpHeaders();
headers.add("Pragma", "public");
headers.add("Cache-Control", "max-age=30");
headers.add("Content-Disposition","attachment;filename="+System.currentTimeMillis()+".csv");
headers.setContentType(MediaType.valueOf("application/vnd.ms-excel;charset=UTF-8"));
String[] sTitles = new String[]{"订单号","商品名称","商品规格","商品数量","商品下单时间","商品价格","佣金比例","佣金","订单状态","收货人","收货人联系方式","收货人地址"};
StringBuffer buf = new StringBuffer();
// 完成数据csv文件的封装
// 输出列头
for (int i = 0; i < sTitles.length; i++) {
buf.append(sTitles[i]).append(",");
}
buf.append("\r\n");
if (null != list) { // 输出数据
for (int i = 0; i < list.size(); i++) {
buf.append("\t"+list.get(i).getOrderNo()).append(",");
buf.append(list.get(i).getItemTitle()).append(",");
buf.append(list.get(i).getSkuName()).append(",");
buf.append(list.get(i).getItemNumber()).append(",");
buf.append(DateUtil.format(list.get(i).getOrderTime(),DateUtil.FORMAT_DATE_DEFAULT)).append(",");
buf.append(list.get(i).getPayPrice()).append(",");
buf.append(list.get(i).getRuleText()).append(",");
buf.append(list.get(i).getBonusAmount()).append(",");
buf.append(list.get(i).getOrderStatus()).append(",");
buf.append(list.get(i).getReceiverName()).append(",");
buf.append("\t\t"+list.get(i).getReceiverTelephone()).append(",");
buf.append(list.get(i).getAddress()).append(",");
buf.append("\r\n");
}
}
//防止导出乱码
byte[] uft8bom={(byte)0xef,(byte)0xbb,(byte)0xbf};
// 写出响应
ByteArrayOutputStream os = new ByteArrayOutputStream();
os.write(uft8bom);
os.write(buf.toString().getBytes("utf-8"));
os.flush();
os.close();
return ResponseEntity.ok().headers(headers).body(os.toByteArray());
}
| 
转播
