jxl操作Excel学习总结一个范例

package mypackage;

 

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

import jxl.Sheet;
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 CreateExcel {
 public static void main(String[] args) {
  try {
   //1、打开文件
   WritableWorkbook book = Workbook.createWorkbook(new File("E://测试.xls"));

   //2、生成一张Excel表
   WritableSheet sheet = book.createSheet("第一页", 0);

   //3、生成含字符串的单元格
   Label label = new Label(0,0,"中国");

   //4、生成含数字的单元格
   jxl.write.Number number = new jxl.write.Number(1,0,3.1415);

   try {

    //5、向Excel表中加入字串单元格和数字单元格
    sheet.addCell(label);
    sheet.addCell(number);
   } catch (RowsExceededException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   } catch (WriteException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }finally{
    try {

     //6、写出数据，关闭文件
     book.write();
     book.close();
    } catch (WriteException e) {
     // TODO Auto-generated catch block
     e.printStackTrace();
    }
   }
  } catch (IOException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
 }
}