jxl创建excel

import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;

/**
 * @author msq
 * @date 2010-3-30
 * @ClassName JxlCreateForExcel.java
 * @param 创建excel
 * @param 
 */
public class JxlCreateForExcel {
 
 public static  void createExcel(){
  String targetfile = "src/out.xls";// 输出的excel文件名
  String worksheet = "List";// 输出的excel文件工作表名
  String[] title = {"ID","NAME","DESCRIB"};// excel工作表的标题
  WritableWorkbook workbook = null;
  try {
   OutputStream os=new FileOutputStream(targetfile);
   workbook=Workbook.createWorkbook(os);      
   WritableSheet sheet = workbook.createSheet(worksheet, 0); // 添加第一个工作表
   Label label = null;     
   for (int i=0; i<title.length; i++){
   // Label(列号,行号 ,内容 )
   label = new Label(i, 0, title[i]); //把标题放到第一行
   sheet.addCell(label);
   }
   workbook.write();
  } catch (FileNotFoundException e) {
   e.printStackTrace();
  } catch (RowsExceededException e) {
   e.printStackTrace();
  } catch (WriteException e) {
   e.printStackTrace();
  } catch (IOException e) {
   e.printStackTrace();
  }finally{
   try {
    if(workbook != null){
     workbook.close();
    }
   } catch (WriteException e) {
    e.printStackTrace();
   } catch (IOException e) {
    e.printStackTrace();
   }
  }
 }
 /**
  *  设置sheet样式
  * @param sheet
  */
 public static void setSheet(WritableSheet sheet){
  //sheet.getSettings().setProtected(true); //设置xls的保护，单元格为只读的  
        sheet.getSettings().setDefaultColumnWidth(20); //设置列的默认宽度  
        //sheet.setRowView(2,false);//行高自动扩展   
        //setRowView(int row, int height);--行高   
        //setColumnView(int  col,int width); --列宽  
        sheet.setColumnView(0,20);//设置第一列宽度
        //定义字体
        // WritableFont font = new WritableFont(WritableFont.TIMES,24,WritableFont.BOLD);
        //font.setColour(Colour.BLUE);
 }
 /**
  *  插入内容
  * @param label
  * @param sheet
  */
 public static void insertSheet(Label label,WritableSheet sheet){
  try {
   label = new Label(0,2,"姓名");
   sheet.addCell(label);
   label = new Label(1,2,"电话");
   sheet.addCell(label);
   label = new Label(2,2,"地址");
   sheet.addCell(label);
  } catch (RowsExceededException e) {
   e.printStackTrace();
  } catch (WriteException e) {
   e.printStackTrace();
  }
 }
 public static void main(String...args){
  JxlCreateForExcel.createExcel();
 }
}

/* 在网上找的..
//添加数字     
jxl.write.Number number = new jxl.write.Number(3, 4, 3.14159); //put the number 3.14159 in cell D5     
sheet.addCell(number);     
  
//添加带有字型Formatting的对象      
jxl.write.WritableFont wf = new jxl.write.WritableFont(WritableFont.TIMES,10,WritableFont.BOLD,true);      
jxl.write.WritableCellFormat wcfF = new jxl.write.WritableCellFormat(wf);      
jxl.write.Label labelCF = new jxl.write.Label(4,4,"文本",wcfF);      
sheet.addCell(labelCF);      
  
//添加带有字体颜色,带背景颜色 Formatting的对象      
jxl.write.WritableFont wfc = new jxl.write.WritableFont(WritableFont.ARIAL,10,WritableFont.BOLD,false,jxl.format.UnderlineStyle.NO_UNDERLINE,jxl.format.Colour.RED);      
jxl.write.WritableCellFormat wcfFC = new jxl.write.WritableCellFormat(wfc);      
wcfFC.setBackground(jxl.format.Colour.BLUE);     
jxl.write.Label labelCFC = new jxl.write.Label(1,5,"带颜色",wcfFC);      
sheet.addCell(labelCFC);      
  
//添加带有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);      
sheet.addCell(labelNF);      
  
//3.添加Boolean对象      
jxl.write.Boolean labelB = new jxl.write.Boolean(0,2,false);      
sheet.addCell(labelB);      
  
//4.添加DateTime对象      
jxl.write.DateTime labelDT = new jxl.write.DateTime(0,3,new java.util.Date());      
sheet.addCell(labelDT);      
  
//添加带有formatting的DateFormat对象      
jxl.write.DateFormat df = new jxl.write.DateFormat("ddMMyyyyhh: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);      
sheet.addCell(labelDTF);      
  
//和宾单元格     
//sheet.mergeCells(int col1,int row1,int col2,int row2);//左上角到右下角     
sheet.mergeCells(4,5,8,10);//左上角到右下角     
wfc = new jxl.write.WritableFont(WritableFont.ARIAL,40,WritableFont.BOLD,false,jxl.format.UnderlineStyle.NO_UNDERLINE,jxl.format.Colour.GREEN);      
jxl.write.WritableCellFormat wchB = new jxl.write.WritableCellFormat(wfc);      
wchB.setAlignment(jxl.format.Alignment.CENTRE);     
labelCFC = new jxl.write.Label(4,5,"单元合并",wchB);      
sheet.addCell(labelCFC); //     
  
//设置边框     
jxl.write.WritableCellFormat wcsB = new jxl.write.WritableCellFormat();      
wcsB.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.THICK);     
labelCFC = new jxl.write.Label(0,6,"边框设置",wcsB);      
sheet.addCell(labelCFC);