| | |
| | | HSSFPatriarch patriarch = sheet1.createDrawingPatriarch(); |
| | | int rownum = 1; |
| | | //钱煜要求电流计算出来(测试容量*3600/测试时长) |
| | | float testCurr = 0f; |
| | | String testCurr = "0.0"; |
| | | if (bmd.getSdata().getTestTimelong() != 0) { |
| | | testCurr = (bmd.getSdata().getTestCap() * 3600) / bmd.getSdata().getTestTimelong(); |
| | | float curr = (bmd.getSdata().getTestCap() * 3600) / bmd.getSdata().getTestTimelong(); |
| | | testCurr = new Formatter().format("%.1f", curr).toString(); |
| | | } |
| | | if (lang.contains("zh")) { |
| | | sheet1.createRow(rownum); |
| | |
| | | sheet1.getRow(rownum).createCell(1).setCellValue("测试类型:" + BattTestData.battState(bmd.getSdata().getTestType())); |
| | | sheet1.getRow(rownum).createCell(2).setCellValue("测试时间:" + formartDate(bmd.getSdata().getTestStarttime(), "yyyy-MM-dd HH:mm:ss")); |
| | | //sheet1.getRow(rownum).createCell(3).setCellValue("测试电流:" + bmd.getSdata().getTestCurr() + "A"); |
| | | sheet1.getRow(rownum).createCell(3).setCellValue("测试电流:" + new Formatter().format("%.1f", testCurr) + "A"); |
| | | sheet1.getRow(rownum).createCell(3).setCellValue("测试电流:" + bmd.getSdata().getTestCurr() + "A"); |
| | | sheet1.getRow(rownum).createCell(3).setCellValue("测试电流:" + testCurr + "A"); |
| | | sheet1.getRow(rownum).createCell(4).setCellValue("测试时长:" + formatTestLong(bmd.getSdata().getTestTimelong())); |
| | | sheet1.getRow(rownum).createCell(5).setCellValue("结束时间:" + formartDate(new Date(bmd.getSdata().getTestStarttime().getTime() + bmd.getSdata().getTestTimelong() * 1000), "yyyy-MM-dd HH:mm:ss")); |
| | | sheet1.getRow(rownum).createCell(6).setCellValue("测试容量:" + formartDouble(bmd.getSdata().getTestCap(), 0) + "AH"); |
| | |
| | | sheet1.createRow(rownum); |
| | | sheet1.getRow(rownum).createCell(1).setCellValue("Test Type:" + BattTestData.battState(bmd.getSdata().getTestType())); |
| | | sheet1.getRow(rownum).createCell(2).setCellValue("Test Time:" + formartDate(bmd.getSdata().getTestStarttime(), "yyyy-MM-dd HH:mm:ss")); |
| | | sheet1.getRow(rownum).createCell(3).setCellValue("Test Curr:" + new Formatter().format("%.1f", testCurr) + "A"); |
| | | sheet1.getRow(rownum).createCell(3).setCellValue("Test Curr:" + testCurr + "A"); |
| | | sheet1.getRow(rownum).createCell(4).setCellValue("Test TimeLong:" + formatTestLong(bmd.getSdata().getTestTimelong())); |
| | | sheet1.getRow(rownum).createCell(5).setCellValue("Stop Time:" + formartDate(new Date(bmd.getSdata().getTestStarttime().getTime() + bmd.getSdata().getTestTimelong() * 1000), "yyyy-MM-dd HH:mm:ss")); |
| | | sheet1.getRow(rownum).createCell(6).setCellValue("Test Cap:" + formartDouble(bmd.getSdata().getTestCap(), 0) + "AH"); |