大侠们.你们能见死不救吗?帮个忙吧.祝你找个好媳妇儿.

Question

本帖最后由 jujucats 于 2010-05-28 02:32:35 编辑

Answer 1

jxl里面有demo。这个问题不用发出来问！

Answer 2

恩，有demo就看demo就可以了，里面的例子是最全的

Answer 3

我也没看到图， 存入excel文件是吧，行间注入动作有特殊逻辑需要分别处理吗 要不怎么会需要逻辑分支呢？

Answer 4

虽然没有搞过jxl,但是如果要我现搞的话我绝对是照个demo改改.!
到jar包里面去找demo这个方法貌似是最好的学习方式

Answer 5

用一个数组来接收list中的对象，再循环插入到单元格中
public class ExcelHandle {
        public void createExcelFile(){
            DataBase  source = new DataBase();
            ArrayList<Excel> list =source.getInfo();
              try{
            WritableWorkbook  book = Workbook.createWorkbook(new File("d:\\myexcel.xls"));    
            WritableSheet sheet=book.createSheet("第一页",0);
            Excel[] excel = new Excel[list.size()];
            for(int i = 0;i<list.size();i++){
               excel[i] =list.get(i);
              if(i==0){  
                 sheet.addCell(new Label(0,1+i,String.valueOf(excel.getId())));
                 sheet.addCell(new Label(1,1+i,excel.getUserName()));
                 sheet.addCell(new Label(2,1+i,String.valueOf(excel.getUserAge())));
                 sheet.addCell(new Label(3,1+i,excel.getUserAddress().toString()));
                 sheet.addCell(new Label(4,1+i,String.valueOf(excel.getUserScor())));
                 sheet.addCell(new Label(5,1+i,String.valueOf(excel.getUserCour())));
                         }     
                    }
                    book.write();
                    book.close();
                } catch (Exception e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
        }

Answer 6

刚才有个地方没改到，重新贴下更改后的代码public class ExcelHandle {
    public void createExcelFile(){
        DataBase  source = new DataBase();
        ArrayList<Excel> list =source.getInfo();
          try{
        WritableWorkbook  book = Workbook.createWorkbook(new File("d:\\myexcel.xls"));    
        WritableSheet sheet=book.createSheet("第一页",0);
        Excel[] excel = new Excel[list.size()];
        for(int i = 0;i<list.size();i++){
           excel[i] =list.get(i);
          if(i==0){  
             sheet.addCell(new Label(0,1+i,String.valueOf(excel[i].getId())));
             sheet.addCell(new Label(1,1+i,excel.getUserName()));
             sheet.addCell(new Label(2,1+i,String.valueOf(excel[i].getUserAge())));
             sheet.addCell(new Label(3,1+i,excel[i].getUserAddress().toString()));
             sheet.addCell(new Label(4,1+i,String.valueOf(excel[i].getUserScore())));
             sheet.addCell(new Label(5,1+i,String.valueOf(excel[i].getUserCours())));
                     }     
                }
                book.write();
                book.close();
            } catch (Exception e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
    }