(Official Java development engineer QQ group (27163376), please enter your ID for verification. Resources include used XLS files and JAR packages, as well as JAVA source code. The source code is fully marked to ensure that you can understand it at a glance. HkSfaStatBCbc=newHkSfaStatBCImpl();//Background implementation class--result calculation HkSfaActivityBCabc=newHkSfaActivityBCImpl();//Background implementation class--Statistical flow Stringactivitypk=request.getParameter(activitypk);//Flow PKListchildGroups=abc.getChildgroup(activitypk) ;//Get all groups of this flow double[][]data=bc.problemCollect(activitypk);//Get the result of calculation, a two-dimensional array org.apache.poi.hssf.usermodel.HSSFRowrow=sheet.createRow(11 );//Create a row in the first worksheet (line 12) for(intk=0;klt;childGroups.size();k ){ApSfaGroupactivityactivityGroup=(ApSfaGroupactivity)childGroups.get(k);//ApSfaGroupactivity Pojoorg.apache.poi.hssf.usermodel.HSSFCellcell=row.createCell((short)(k 1));//Create a cell in row cell.setEncoding(HSSFCell.ENCODING_UTF_16);//Set Code cell.setCellValue(activityGroup.getName());//Set the value to the cell......
Export Excel\needed xls file\PicStat.xls
Export Excel\needed xls file\statPic.xls
Export Excel\Jar package used for requirements\commons-io-1.1.jar
Export Excel\Jar package for requirements\excelutils.jar
Export Excel\Jar package used for requirements\poi-3.0.1.jar
Export Excel\Jar package used for requirements\tm-extractors-0.4.jar
ExportExcel\picExcel.java)