在java中用jxl创建Excel文件

package com.demo.common;

import java.io.File;
import java.io.IOException;
import jxl.Workbook;
import jxl.format.UnderlineStyle;
import jxl.write.Label;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;

/**
 * @文件名：ExcelTest.java
 * @作者: 李云锋
 * @生成日期: 2008-10-20
 * @功能描述：测试java中操作excel
 */

public class ExcelTest {

 public static void main(String[] args) {
  try {
   //创建可写入的Excel工作薄
   WritableWorkbook wb = Workbook.createWorkbook(new File("d:/a.xls"));
   //创建Excel工作表
   WritableSheet ws = wb.createSheet("测试一下", 0);  
   
   //添加Label对象
   Label label1 = new Label(0,0,"我爱安徽");
   ws.addCell(label1);
   
   //添加带有字型Formatting的对象
   jxl.write.WritableFont wf = new jxl.write.WritableFont(WritableFont.TIMES, 18, WritableFont.BOLD, true);
   jxl.write.WritableCellFormat wcfF = new jxl.write.WritableCellFormat(wf);
   jxl.write.Label labelCF = new jxl.write.Label(1, 0, "This is a Label Cell", wcfF);
   ws.addCell(labelCF);
   
   //添加带有字体颜色Formatting的对象
   jxl.write.WritableFont wfc = new jxl.write.WritableFont(WritableFont.ARIAL, 10, WritableFont.NO_BOLD, false,
   UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.RED);
   jxl.write.WritableCellFormat wcfFC = new jxl.write.WritableCellFormat(wfc);
   jxl.write.Label labelCFC = new jxl.write.Label(1, 0, "This is a Label Cell", wcfFC);
   ws.addCell(labelCFC);
   
   //添加Number对象
   jxl.write.Number labelN = new jxl.write.Number(0, 1, 3.1415926);
   ws.addCell(labelN);
   
   //添加带有formatting的Number对象
   jxl.write.NumberFormat nf = new jxl.write.NumberFormat("#.##");
   jxl.write.WritableCellFormat wcfN = new jxl.write.WritableCellFormat(nf);
   jxl.write.Number labelNF = new jxl.write.Number(1, 1, 3.1415926, wcfN);
   ws.addCell(labelNF);
   
   //添加Boolean对象
   jxl.write.Boolean labelB = new jxl.write.Boolean(0, 2, false);
   ws.addCell(labelB);
   
   //添加DateTime对象
   jxl.write.DateTime labelDT = new jxl.write.DateTime(0, 3, new java.util.Date());
   ws.addCell(labelDT);
   
   //添加带有formatting的DateFormat对象
   jxl.write.DateFormat df = new jxl.write.DateFormat("dd MM yyyy hh:mm:ss");
   jxl.write.WritableCellFormat wcfDF = new jxl.write.WritableCellFormat(df);
   jxl.write.DateTime labelDTF = new jxl.write.DateTime(1, 3, new java.util.Date(), wcfDF);
   ws.addCell(labelDTF);
   
   wb.write();   //写入Exel工作表
   wb.close();   //关闭Excel工作薄对象

  } catch (IOException e) {
   e.printStackTrace();
  }catch (RowsExceededException e) {
   e.printStackTrace();
  } catch (WriteException e) {
   e.printStackTrace();
  }
 }
}