文件解析告警数据导出

lxw

2023-05-17 da6d99eb782523d15634fc72d2ab0fb24293f92e

文件解析告警数据导出

 src/main/java/com/whyc/service/ExcelExportService.java

@@ -330,7 +330,6 @@
        List<Fbs5100Alarm> list=data.alarms;
        //当前日期
        String excelName ="alm-"+new SimpleDateFormat("yyyyMMddHHmmss").format(new Date());

        XSSFWorkbook wb = new XSSFWorkbook();
        XSSFSheet sheet = wb.createSheet("数据总表");
        int rowNumSheet = 0;
@@ -345,10 +344,10 @@
        sheet.createRow(rowNumSheet);
        sheet.getRow(rowNumSheet).createCell(0).setCellValue("交流电压上限值:"+alarmParam.AC_VOL_H);
        sheet.getRow(rowNumSheet).createCell(1).setCellValue("交流电压下限值:"+alarmParam.AC_VOL_L);
        rowNumSheet+=4;
        rowNumSheet++;

        //从文件中获取数据
        String testName="测试数据";
        String testName="测试数据:";
        //抬头
        sheet.createRow(rowNumSheet).createCell(0).setCellValue(testName);
        rowNumSheet++;