http://www-900.ibm.com/developerWorks/cn/java/l-javaExcel/index.shtml

解决方案 »

  1.   

    -----------包
    import jxl.Workbook;
    import jxl.write.Label;
    import jxl.write.WritableSheet;
    import jxl.write.WritableWorkbook;-----------测试函数
      protected static void TestJxl(int s) {
        try {
          WritableWorkbook wbook = null;
          WritableSheet wsheet = null;
          Label label = null;
          InputStream fis = new FileInputStream(new File("C:\\DzxhFile\\excel.xls"));
          Workbook wb = Workbook.getWorkbook(fis);
          OutputStream fos = new FileOutputStream(new File("C:\\DzxhFile\\excel.xls"));
          wbook = Workbook.createWorkbook(fos,wb);
          if(wbook.getNumberOfSheets()==0){
            wsheet = wbook.createSheet("Sheet0", 0);
          }else{
            wsheet = wbook.getSheet(0);
          }      for (int i = s; i < 5000+s; i++) {        label = new Label(0,i,"0-"+i);
            wsheet.addCell(label);
            label = new Label(1,i,"1-"+i);
            wsheet.addCell(label);
            label = new Label(2,i,"2-"+i);
            wsheet.addCell(label);
            label = new Label(3,i,"3-"+i);
            wsheet.addCell(label);
            label = new Label(4,i,"4-"+i);
            wsheet.addCell(label);
            label = new Label(5,i,"5-"+i);
            wsheet.addCell(label);
            label = new Label(6,i,"6-"+i);
            wsheet.addCell(label);
            label = new Label(7,i,"7-"+i);
            wsheet.addCell(label);
            label = new Label(8,i,"8-"+i);
            wsheet.addCell(label);
            label = new Label(9,i,"9-"+i);
            wsheet.addCell(label);
            label = new Label(10,i,"10-"+i);
            wsheet.addCell(label);
            label = new Label(11,i,"11-"+i);
            wsheet.addCell(label);
            label = new Label(12,i,"12-"+i);
            wsheet.addCell(label);
            label = new Label(13,i,"13-"+i);
            wsheet.addCell(label);
            label = new Label(14,i,"14-"+i);
            wsheet.addCell(label);
          }
          wbook.write();
          wbook.close();
          fos.flush();
          fos.close();
          fis.close();
          wb.close();
        }
        catch (Exception e) {
          e.printStackTrace();
          return;
        }
    }