9月26日

主要工作内容

9月23日在网上找到了一个Java写Excel样式的例子，我便急匆匆得到就用上了。每日导出我能够很好的用上：

时间	开机时间	作业时间	用电量
2019-8-10

代码实现：

public void dailyExport(EfficiencyWorkTimeOutVo outVo,HttpServletResponse response){
   

        //创建表头内容
        List<ExcelExportEntity> colList = new ArrayList<ExcelExportEntity>();
        ExcelExportEntity colEntity = new ExcelExportEntity("时间", "dataDate");
        colList.add(colEntity);
        colEntity = new ExcelExportEntity("开机时长（s）", "startupTimeSec",40);
        colList.add(colEntity);
        colEntity = new ExcelExportEntity("作业时长（s）", "workingTimeSec",40);
        colList.add(colEntity);
        colEntity = new ExcelExportEntity("用电量（度）", "powerConsumption",40);
        colList.add(colEntity);

        List<Map<String, Object>> dataList = new ArrayList<Map<String, Object>>();
        Map<String,Object > map = convertToMap(outVo);
        dataList.add(map);

        Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams("分析表表头Name", "分析表sheetName"),colList, dataList);
	
	//通用的文件导出方法
        try {
   
            String fileName = URLEncoder.encode("导出表文件名.xls", "UTF-8");
            response.setContentType("application/octet-stream;;charset=UTF-8");
            response.setHeader("Content-Disposition", "attachment;filename*=utf-8'zh_cn'" + fileName);
            response.flushBuffer();
            workbook.write(response.getOutputStream());
        }
        catch (FileNotFoundException e) {
   
            e.printStackTrace();
        } catch <