}//文件上传的路径String path = params.get("path").toString()//异步导出executorService.execute(newKQChannelStatisticExport(oemAsnyReportResultService, couponChannelStatisticService, logger, params,path)); } } 下面是要执行导出功能的线程 publicclassKQChannelStatisticExportimplementsRunnable {publicKQChannelSt...
最先开始的思路就是通过接口获取到订单信息之后通过页面Response进行输出一个Excel. 新建一个aspx页面。然后写一个方法如下: ////// 导出Excel /////////private void ExportExcel(List<OrdersItemDetailInfo>lst, string loginId) { string name = string.Format("{0}{1}订单报表.xls", loginId, DateTime...
* 报表导出 */@DatapublicclassOrderDeatilVOimplementsSerializable{/** * 数据ID */// 主键id@ExcelIgnore// 生成报表时忽略,不生成次字段privateInteger id;/** * 订单id */@ExcelProperty(value="订单编号",index=0)// 定义表头名称和位置,0代表第一列privateString orderNo;/** * 消费的用户 */@Exce...
}// 获取表头信息private List getHeaderInfo() {return Arrays.asList(new ExcelHeaderInfo(1, 1, 0, 0, "id"),new ExcelHeaderInfo(1, 1, 1, 1, "商品名称"),new ExcelHeaderInfo(0, 0, 2, 3, "分类"),new ExcelHeaderInfo(1, 1, 2, 2, "类型ID"),new ExcelHeaderInfo(1, 1, 3, 3...