论坛首页 Java企业应用论坛

将树节点以列方式导出EXCEL

浏览 10823 次
精华帖 (0) :: 良好帖 (0) :: 新手帖 (0) :: 隐藏帖 (1)
作者 正文
   发表时间:2011-10-08  
终于搞定了,将成果展示一下。。。
/**
     * 导出业务线下的模板信息
     * @return
     */
    public String exportServiceLine(){
        try {
            Integer parentId = serviceLineh.getId();
            List<ServiceLined> lineds = mgr.selectAllChild(parentId, true);
            
            List<ServiceLined> plineds=new ArrayList<ServiceLined>();
            List<ServiceLined> slineds=new ArrayList<ServiceLined>();
            List<ServiceLined> llineds=new ArrayList<ServiceLined>();
            
            if(lineds!=null&&lineds.size()>0){
                logger.debug("lineds**********************"+lineds.size());
                ServiceLined param = new ServiceLined();
                param.setParentid(parentId);
                param.setOther(Constant.IS_ROOT);
                ServiceLined rlined = mgr.findRootLined(param);
                logger.debug("rlined.id*****************************"+rlined.getId());
                
                for (int i = 1; i < lineds.size(); i++) {
                    ServiceLined lined = lineds.get(i);
                    logger.debug("equals**************"+lined.getParentid().equals(rlined.getId()));
                    if (lined.getParentid().equals(rlined.getId())) {
                        //int countSub = mgr.findCountSubLined(lined);
                        plineds.add(lined);
                        
                    }
                }
                
                logger.debug("plineds**********************"+plineds.size());
                if (plineds.size()>0) {
                    for (int i = 0; i < plineds.size(); i++) {
                        for (int j = 1; j < lineds.size(); j++) {
                            ServiceLined lined = lineds.get(j);
                            if(plineds.get(i).getId().equals(lined.getParentid())){
                                slineds.add(lined);
                            }
                        }
                    }
                    
                    logger.debug("slineds**********************"+slineds.size());
                    logger.debug("lineds**********************"+lineds.size());
                    
                    if(slineds.size()>0){
                        for (int i = 0; i < slineds.size(); i++) {
                            for (int j = 0; j < lineds.size(); j++) {
                                ServiceLined lined = lineds.get(j);
                                if (slineds.get(i).getId().equals(lined.getParentid())) {
                                    llineds.add(lined);
                                }
                            }
                        }
                    }
                    
                    logger.debug("llineds**********************"+llineds.size());
                }
                                
                OutputStream os = new FileOutputStream(new File("f://test.xls"));
                WritableWorkbook book = Workbook.createWorkbook(os);
                WritableSheet sheet=book.createSheet("test", 0);
                sheet.setColumnView(0, 20);
                sheet.setColumnView(1, 20);
                sheet.setColumnView(2, 60);
                sheet.setRowView(0, 500);
                WritableCellFormat wcff= new WritableCellFormat();
                wcff.setWrap(true);
                wcff.setShrinkToFit(true);
                
                Label lableBuh=new Label(0,0,"父节点信息",wcff);
                Label lableBuh2=new Label(1,0,"子节点信息",wcff);
                Label lableBuh3=new Label(2,0,"叶节点信息",wcff);
                
                sheet.addCell(lableBuh);
                sheet.addCell(lableBuh2);
                sheet.addCell(lableBuh3);
                
                int count = 1;    
                
                Label lableBu=new Label(0,count,"",wcff);
                Label lableBu2=new Label(1,count,"",wcff);
                Label lableBu3=new Label(2,count,"",wcff);
                
                boolean flag = false;
                if (plineds.size()>0) {
                    for (int i = 0; i < plineds.size(); i++) {
                        lableBu = new Label(0,count,plineds.get(i).getNode(),wcff);
                        
                        int countSubject = mgr.findCountSubLined(plineds.get(i));
                        
                        sheet.addCell(lableBu);
                        if (countSubject>1) {
                            sheet.mergeCells(0, count, 0, count+countSubject-1);
                        }
                        
                        if(slineds.size()>0){
                            for (int j = 0; j < slineds.size(); j++) {
                                if (plineds.get(i).getId().equals(slineds.get(j).getParentid())) {
                                    lableBu2=new Label(1,count,slineds.get(j).getNode(),wcff);
                                    
                                    sheet.addCell(lableBu2);
                                    
                                    if(llineds.size()>0){
                                        String nodeName = "";
                                        for (int k = 0; k < llineds.size(); k++) {
                                            if (slineds.get(j).getId().equals(llineds.get(k).getParentid())) {
                                                nodeName += llineds.get(k).getNode()+"    ";
                                                
                                                int countSub = mgr.findCountSubLined(llineds.get(k));
                                                if (countSub>0) {
                                                    for (int l = 0; l < lineds.size(); l++) {
                                                        if (llineds.get(k).getId().equals(lineds.get(l).getParentid())) {
                                                            nodeName += "\n  "+lineds.get(l).getNode();
                                                            
                                                            countSub = mgr.findCountSubLined(lineds.get(l));
                                                            
                                                            if (countSub>0) {
                                                                for (int m = 0; m < lineds.size(); m++) {
                                                                    if (lineds.get(l).getId().equals(lineds.get(m).getParentid())) {
                                                                        nodeName += "\n    "+lineds.get(m).getNode()+"    ";
                                                                    }
                                                                }
                                                            }
                                                        }
                                                    }
                                                }
                                                
                                                
                                                lableBu3 = new Label(2,count,nodeName,wcff);
                                                sheet.addCell(lableBu3);
                                                
                                                //count++;
                                            } 
                                        }
                                    }
                                    
                                    count++;
                                    flag = true;
                                }
                            }
                        } 
                        
                        if (!flag) {
                            count++;
                        }
                        
                    }
                }
                
                book.write();
                book.close();
                os.close();
                
                //getResponse().setContentType("text/html;charset=utf-8");
                //getResponse().getWriter().print("导出业务线模板信息成功!");
            }
            
        } catch (Exception e) {
            logger.error(e);
        }
        
        return null;
    }
0 请登录后投票
论坛首页 Java企业应用版

跳转论坛:
Global site tag (gtag.js) - Google Analytics