java文件处理相关技术
来源:互联网 发布:手机做字素的软件 编辑:程序博客网 时间:2024/04/30 15:37
1、使用spring自带功能导出excel
public ModelAndView exportPurchasellReportInfo(HttpServletResponse response, @Json PurchaseSellReportQueryVo purchaseSellReportQueryVo) {
ModelAndView modelAndView = null;
try {
response.reset();// 清空输出流
response.setHeader("Content-disposition", "attachment; filename=" + new String("库存采购和售卖报表.xls".getBytes("GB2312"), "ISO8859-1"));
modelAndView = purchaseSellReportBusiness.queryPurchasellReportInfo(purchaseSellReportQueryVo);
} catch (Exception e) {
LOGGER.error("Export report failed. Param" + JsonUtil.toString(purchaseSellReportQueryVo), e);
Map<String, Object> exportMap = new HashMap<String, Object>();
List<ExportPurchaseSellReportVo> exportPurchaseSellReportList = new ArrayList<ExportPurchaseSellReportVo>();
exportPurchaseSellReportList.add(new ExportPurchaseSellReportVo());
exportMap.put(ExcelExportView.MODEL_KEY_ROWBEAN, exportPurchaseSellReportList);
exportMap.put(ExcelExportView.MODEL_KEY_SHEETNAME, "库存采购和售卖报表");
excelExportView.setAttributesMap(exportMap);
modelAndView = new ModelAndView(excelExportView);
}
return modelAndView;
}
public class ExcelExportView extends AbstractExcelView {
private static final Logger logger = LoggerFactory.getLogger(ExcelExportView.class);
private static final ExcelExportParser excelParser = new ExcelExportParser();
public static final String MODEL_KEY_ROWBEAN = "ROWBEAN";
public static final String MODEL_KEY_SHEETNAME = "SHEETNAME";
static {
try {
ConfigurableConversionService converService = new DefaultFormattingConversionService();
converService.addConverter(new NumberToStringConverter());
excelParser.setConverService(converService);
} catch (Exception e) {
logger.error("鍒濆鍖杄xcelParser鍑洪敊锛�", e);
}
}
@Override
protected void buildExcelDocument(Map<String, Object> model, HSSFWorkbook workbook, HttpServletRequest request,
HttpServletResponse response) throws Exception {
excelParser.writeWorkbook((List) model.get(MODEL_KEY_ROWBEAN), (Workbook) workbook,
(String) model.get(MODEL_KEY_SHEETNAME));
}
}
- java文件处理相关技术
- Java常用工具类五 -- 文件处理相关
- c#--异常处理相关技术
- 大文件处理【java以及数据清洗相关】
- Java中文相关技术
- Java中文相关技术
- Java相关技术
- java 一些相关技术
- Java相关技术
- Java相关技术
- Java技术相关名词
- Java常用相关技术
- JAVA-相关技术超链接
- Java加密技术相关
- 文件处理技术
- JAVA缓存技术-JNI静态文件的处理
- JAVA日期处理相关
- java异常处理相关
- 由appcampat 的思考
- linux动态链接
- java String 和 int 相互转换
- bash background tasks
- 汇编语言编写的Hello World
- java文件处理相关技术
- 红黑树
- Python面向对象(二)
- SDUT 1208 C语言实验——温度转换
- Ubuntu14.04/win7 双系统,Ubuntu不能连网
- LeetCode---Merge Two Sorted Lists
- 记录1
- mac下tomcat的安装与配置
- C++Primer---模板与泛型编程(一)