|
@RequestMapping(params = "excelExport")
public void excelExport(TListOutFeeSumEntity tListOutFeeSum,
HttpServletRequest request, HttpServletResponse response) {
DataGrid dataGrid = new DataGrid();
tListOutFeeSumService.queryListoutFeeSum(tListOutFeeSum, dataGrid,true);
List<Map<String, Object>> results = dataGrid.getResults();
Map<String, Object> footer = (Map<String, Object>) dataGrid.getFooter();
results.add(footer);
List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
entity.add(new ExcelExportEntity("单据号", "fsPaperno",20));
entity.add(new ExcelExportEntity("序号","fiSerial"));
entity.add(new ExcelExportEntity("金额","fdAmount"));
entity.add(new ExcelExportEntity("农户卡号","fsCardno"));
entity.add(new ExcelExportEntity("农户姓名","fsName",15));
entity.add(new ExcelExportEntity("记帐机构","fsAgent"));
entity.add(new ExcelExportEntity("操作员","fsOper"));
entity.add(new ExcelExportEntity("记帐日期","fsDate"));
entity.add(new ExcelExportEntity("用途","fiAim"));
entity.add(new ExcelExportEntity("记帐标志","fiFlag"));
entity.add(new ExcelExportEntity("成本","fdCost"));
entity.add(new ExcelExportEntity("利润","fdGain"));
entity.add(new ExcelExportEntity("接收标志","fiReceive"));
entity.add(new ExcelExportEntity("发生科目","fsSubject"));
Workbook workbook = ExcelExportUtil.exportExcel(
new ExportParams("收费费用单张汇总表", "收费费用单张汇总表"), entity, results);
OutputStream fOut = null;
try {
String newtitle = new String("收费单张汇总表".getBytes("UTF-8"),"ISO8859-1");
response.setHeader("content-disposition","attachment;filename="+newtitle+".xls");
fOut = response.getOutputStream();
workbook.write(fOut);
} catch (IOException e) {
e.printStackTrace();
}finally {
try {
fOut.flush();
fOut.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
}
这里的用途 导出来的是0 ,代表棉花, 但是在导出工具实体类ExcelExportEntity中如何替换呢?如果能替换改如何解决呢?望有经验的人士帮我想想办法
|
-
|