| | |
| | | Ld9testdata data=montestdata.get(i); |
| | | if(currCel>=maxcol){ |
| | | monNum=0; |
| | | currRow=currRow+7; |
| | | currRow=currRow+8; |
| | | } |
| | | if(monNum!=data.getMonNum()){ |
| | | if(monNum!=0){ |
| | | currRow=currRow+7; |
| | | currRow=currRow+8; |
| | | } |
| | | currCel=0; |
| | | monNum=data.getMonNum(); |
| | |
| | | sheet.createRow(currRow+3); //创建行 |
| | | sheet.createRow(currRow+4); //创建行 |
| | | sheet.createRow(currRow+5); //创建行 |
| | | sheet.getRow(currRow).createCell(currCel).setCellValue("时间(HH:MM:SS)"); |
| | | sheet.getRow(currRow+1).createCell(currCel).setCellValue("组端电压(V)"); |
| | | sheet.getRow(currRow+2).createCell(currCel).setCellValue("在线电压(V)"); |
| | | sheet.getRow(currRow+3).createCell(currCel).setCellValue("电流(A)"); |
| | | sheet.getRow(currRow+4).createCell(currCel).setCellValue("测试容量(AH)"); |
| | | sheet.getRow(currRow+5).createCell(currCel).setCellValue("单体电压"+monNum+"(V)"); |
| | | sheet.createRow(currRow+6); //创建行 |
| | | sheet.getRow(currRow).createCell(currCel).setCellValue(monNum+"#放电数据"); |
| | | sheet.getRow(currRow+1).createCell(currCel).setCellValue("时间(HH:MM:SS)"); |
| | | sheet.getRow(currRow+2).createCell(currCel).setCellValue("组端电压(V)"); |
| | | sheet.getRow(currRow+3).createCell(currCel).setCellValue("在线电压(V)"); |
| | | sheet.getRow(currRow+4).createCell(currCel).setCellValue("电流(A)"); |
| | | sheet.getRow(currRow+5).createCell(currCel).setCellValue("测试容量(AH)"); |
| | | sheet.getRow(currRow+6).createCell(currCel).setCellValue("单体电压"+monNum+"(V)"); |
| | | } |
| | | currCel++; |
| | | sheet.getRow(currRow).createCell(currCel).setCellValue(formatTestLong(data.getTestTimelong())); |
| | | sheet.getRow(currRow+1).createCell(currCel).setCellValue(formartDouble(data.getGroupVol(),1)); |
| | | sheet.getRow(currRow+2).createCell(currCel).setCellValue(formartDouble(data.getOnlineVol(),1)); |
| | | sheet.getRow(currRow+3).createCell(currCel).setCellValue(formartDouble(data.getTestCurr(),3)); |
| | | sheet.getRow(currRow+4).createCell(currCel).setCellValue(formartDouble(data.getTestCap(),1)); |
| | | sheet.getRow(currRow+5).createCell(currCel).setCellValue(formartDouble(data.getMonVol(),3)); |
| | | sheet.getRow(currRow+1).createCell(currCel).setCellValue(formatTestLong(data.getTestTimelong())); |
| | | sheet.getRow(currRow+2).createCell(currCel).setCellValue(formartDouble(data.getGroupVol(),1)); |
| | | sheet.getRow(currRow+3).createCell(currCel).setCellValue(formartDouble(data.getOnlineVol(),1)); |
| | | sheet.getRow(currRow+4).createCell(currCel).setCellValue(formartDouble(data.getTestCurr(),3)); |
| | | sheet.getRow(currRow+5).createCell(currCel).setCellValue(formartDouble(data.getTestCap(),1)); |
| | | sheet.getRow(currRow+6).createCell(currCel).setCellValue(formartDouble(data.getMonVol(),3)); |
| | | } |
| | | } |
| | | } |