jxl创建excel

个人认为 jxl没有poi好用，闲话不谝了看看用法再说吧

package com.manager.util;

import java.io.File;
import java.io.IOException;

import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;

public class Test4 {

  /**
   * @param args
   * @author julong 2015-6-3 上午09:27:56
   */
  public static void main(String[] args) {
    // TODO Auto-generated method stub
    //File file = new File("C：\VehExcel.xls");
    WritableWorkbook workbook;
    try {
      File file = new File("C:/VehExcel.xls");
      //FileOutputStream fileOutputStream = new FileOutputStream(file);
      workbook = Workbook.createWorkbook(file);
      WritableSheet writableSheet = workbook.createSheet("机动车档案数量统计", 0);
      //列  行 名称
      Label label=new Label(0,0,"序号");
      Label label1=new Label(1,0,"管理部门");
      Label label2=new Label(2,0,"录入人");
      Label label3=new Label(3,0,"录入数量");
      //添加单元格
      writableSheet.addCell(label);
      writableSheet.addCell(label1);
      writableSheet.addCell(label2);
      writableSheet.addCell(label3);
      for (int i = 1; i < 10; i++) {
        //列  行 名称
        Label labela=new Label(0,i,"序号"+i);
        Label labelb=new Label(1,i,"管理部门"+i);
        Label labelc=new Label(2,i,"录入人"+i);
        Label labeld=new Label(3,i,"录入数量"+i);
        //添加单元格
        writableSheet.addCell(labela);
        writableSheet.addCell(labelb);
        writableSheet.addCell(labelc);
        writableSheet.addCell(labeld);
      }

      workbook.write();
      workbook.close();
      System.out.println("创建成功");
    } catch (IOException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } catch (RowsExceededException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } catch (WriteException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }

  }

}

这是一个导出到本地的测试只需要一个jxl.jar就够了