导出

whyclxw

2024-09-11 f7a31eb39041a26b56dc5fd4c50926f550cf1474

导出

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

@@ -36,29 +36,31 @@
        }
        rowNum++;
        List<BatttestdataId> list=subService.getTdataById(devId,testRecordCount);
        //数据栏
        for (int i = 0; i < list.size(); i++) {
            sheet.createRow(rowNum);  //创建行
            BatttestdataId tdata=list.get(i);
            for(int j=0;j<titiles.length;j++){
                sheet.getRow(rowNum).createCell(0 ).setCellValue(ActionUtil.secToTime(tdata.getTestTimelong()));
                sheet.getRow(rowNum).createCell(1).setCellValue(tdata.getBattIdx()+1);
                sheet.getRow(rowNum).createCell(2 ).setCellValue(tdata.getMonNum());
                sheet.getRow(rowNum).createCell(3).setCellValue(tdata.getTestRecordCount());
                sheet.getRow(rowNum).createCell(4).setCellValue(tdata.getTestType());
                sheet.getRow(rowNum).createCell(5).setCellValue(tdata.getRecordNum());
                sheet.getRow(rowNum).createCell(6).setCellValue(tdata.getGroupVol());
                sheet.getRow(rowNum).createCell(7).setCellValue(tdata.getTestCurr());
                sheet.getRow(rowNum).createCell(8).setCellValue(tdata.getTestCap());
                sheet.getRow(rowNum).createCell(9 ).setCellValue(tdata.getMonVol());
                sheet.getRow(rowNum).createCell(10 ).setCellValue(tdata.getMonTmp());
                sheet.getRow(rowNum).createCell(11 ).setCellValue(tdata.getMonCurr());
                sheet.getRow(rowNum).createCell(12 ).setCellValue(tdata.getMonCap());
                sheet.getRow(rowNum).createCell(13 ).setCellValue(tdata.getMonWh());
                sheet.getRow(rowNum).createCell(14 ).setCellValue(tdata.getMonState());
                sheet.getRow(rowNum).createCell(15 ).setCellValue(tdata.getMonFault());
        if(list!=null){
            //数据栏
            for (int i = 0; i < list.size(); i++) {
                sheet.createRow(rowNum);  //创建行
                BatttestdataId tdata=list.get(i);
                for(int j=0;j<titiles.length;j++){
                    sheet.getRow(rowNum).createCell(0 ).setCellValue(ActionUtil.secToTime(tdata.getTestTimelong()));
                    sheet.getRow(rowNum).createCell(1).setCellValue(tdata.getBattIdx()+1);
                    sheet.getRow(rowNum).createCell(2 ).setCellValue(tdata.getMonNum());
                    sheet.getRow(rowNum).createCell(3).setCellValue(tdata.getTestRecordCount());
                    sheet.getRow(rowNum).createCell(4).setCellValue(tdata.getTestType());
                    sheet.getRow(rowNum).createCell(5).setCellValue(tdata.getRecordNum());
                    sheet.getRow(rowNum).createCell(6).setCellValue(tdata.getGroupVol());
                    sheet.getRow(rowNum).createCell(7).setCellValue(tdata.getTestCurr());
                    sheet.getRow(rowNum).createCell(8).setCellValue(tdata.getTestCap());
                    sheet.getRow(rowNum).createCell(9 ).setCellValue(tdata.getMonVol());
                    sheet.getRow(rowNum).createCell(10 ).setCellValue(tdata.getMonTmp());
                    sheet.getRow(rowNum).createCell(11 ).setCellValue(tdata.getMonCurr());
                    sheet.getRow(rowNum).createCell(12 ).setCellValue(tdata.getMonCap());
                    sheet.getRow(rowNum).createCell(13 ).setCellValue(tdata.getMonWh());
                    sheet.getRow(rowNum).createCell(14 ).setCellValue(tdata.getMonState());
                    sheet.getRow(rowNum).createCell(15 ).setCellValue(tdata.getMonFault());
                }
                rowNum++;
            }
            rowNum++;
        }
        try {
            // 写入到输出流