| | |
|---|
| | | int battGroupId = Integer.valueOf(req.getParameter("battGroupId")); //电池组编号 |
|---|
| | | int testRecordCount = Integer.valueOf(req.getParameter("testRecordCount")); //测试编号 |
|---|
| | | String stateFlag = req.getParameter("stateFlag");//第几次放电 |
|---|
| | | stateFlag = "第1次放电"; |
|---|
| | | //stateFlag = "2022-02-10-第1次放电"; |
|---|
| | | |
|---|
| | | List<FBOTestData> list = fboservice.getList(battGroupId, testRecordCount); //查询4059充放电数据 |
|---|
| | | |
|---|
| | |
|---|
| | | rowNum+=2; |
|---|
| | | |
|---|
| | | //excel文件名 |
|---|
| | | String testTime = new SimpleDateFormat("yyyy-MM-dd").format(test_starttime); |
|---|
| | | excelName = excelName+"-"+testTime; |
|---|
| | | /*String testTime = new SimpleDateFormat("yyyy-MM-dd").format(test_starttime); |
|---|
| | | excelName = excelName+"-"+testTime;*/ |
|---|
| | | String regEx="[\n`~!@#$%^&*()+=|{}':;',\\[\\].<>/?~！@#￥%……&*（）——+|{}【】‘；：”“’。， 、？]"; |
|---|
| | | excelName = excelName.replace(regEx,""); |
|---|
| | | |
|---|
| | |
|---|
| | | HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 512, 255,(short) 0, rowNum, (short) 10, rowNum+rowNumAdd); |
|---|
| | | anchor.setAnchorType(3); |
|---|
| | | patriarch.createPicture(anchor,wb.addPicture(bytes.get(picNum),HSSFWorkbook.PICTURE_TYPE_PNG)).resize(1); |
|---|
| | | picNum ++;rowNum+=rowNumAdd; |
|---|
| | | picNum++; |
|---|
| | | rowNum += rowNumAdd; |
|---|
| | | } |
|---|
| | | |
|---|
| | | rowNum++; |
|---|
