jxl读取Excel

import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.OutputStream;

import jxl.Cell;
import jxl.CellType;
import jxl.Sheet;
import jxl.Workbook;
import jxl.format.UnderlineStyle;
import jxl.write.DateFormat;
import jxl.write.DateTime;
import jxl.write.Label;
import jxl.write.NumberFormat;
import jxl.write.WritableCell;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableImage;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

/*
 * 从excel文件F:\红楼人物.xls读取数据；生成新的excel文件F:\红楼人物2.xls；修改原excel一个单元并输出为F:\红楼人物3.xls。
 * */
public class ExcelHandle {
 public ExcelHandle(){}
 /*
  * 读取Excel
  * */
 public static void readExcel(String filePath){
  try{
   InputStream is = new FileInputStream(filePath);
   Workbook rwb = Workbook.getWorkbook(is);
   //两种方法获取sheet表：名字和下标(从0开始)
   //Sheet st = rwb.getSheet("original");
   Sheet rst = rwb.getSheet(0);
   //获取Sheet表中所包含的总列数
   int rsColumns = rst.getColumns();
   //获取Sheet表中所包含的总行数
   int rsRows = rst.getRows();
   //获取指定单元格的对象引用
   for(int i = 0;i<rsRows;i++){
    for(int j = 0;j<rsColumns;j++){
     Cell cell = rst.getCell(j,i);//对单元进行处理
     System.out.print("====="+cell.getContents());
    }
    System.out.println();
   }
  }catch(Exception e){
   e.printStackTrace();
  }
 }
 /*
  * 输出excel
  * */
 public static void writeExcel(OutputStream os){
  try{
   /** 只能通过API提供的工厂方法来创建Workbook，而不能使用WritableWorkbook的构造函数，
    * 因为类WritableWorkbook的构造函数为protected类型：
    * 方法一：直接从目标文件中读取
    * WritableWorkbook wwb = Workbook.createWorkbook(new File(targetfile));
    * 方法二：如下实例所示 将WritableWorkbook直接写入到输出流
    * */  
   WritableWorkbook wwb = Workbook.createWorkbook(os);
   //创建Excel工作表，指定位置和名称
   WritableSheet ws = wwb.createSheet("Test Sheet1", 0);
   /*===============往工作表中添加数据=================*/
   Label label = new Label(0,0,"测试");
   ws.addCell(label);
   //添加带有字型Formatting对象
   WritableFont wf = new WritableFont(WritableFont.TIMES,18,WritableFont.BOLD,true);
   WritableCellFormat wcf = new WritableCellFormat(wf);
   Label labelcf = new Label(1,0,"this is a label test",wcf);
   ws.addCell(labelcf);
   //添加带有字体颜色的formatting对象
   WritableFont wfc = new WritableFont(WritableFont.ARIAL,10,WritableFont.NO_BOLD,false,UnderlineStyle.NO_UNDERLINE,jxl.format.Colour.DARK_YELLOW);
   WritableCellFormat wcfFC = new WritableCellFormat(wfc);
   Label labelCF = new Label(1,0,"ok",wcfFC);
   ws.addCell(labelCF);
   //添加number对象
   jxl.write.Number number = new jxl.write.Number(0,1,3.1415926);
   ws.addCell(number);
   //添加带有formatting的Number对象      
            NumberFormat nf = new NumberFormat("#.##");
            WritableCellFormat wcfN = new WritableCellFormat(nf);
            jxl.write.Number labelNF = new jxl.write.Number(1,1,3.14,wcfN);   
            ws.addCell(labelNF);   
            //3.添加Boolean对象   
            jxl.write.Boolean labelB = new jxl.write.Boolean(0,2,true);   
            ws.addCell(labelB);  
            jxl.write.Boolean labelB1 = new jxl.write.Boolean(1,2,false);
            ws.addCell(labelB1);     
            //4.添加DateTime对象   
            jxl.write.DateTime labelDT = new jxl.write.DateTime(0,3,new java.util.Date());   
            ws.addCell(labelDT);   
            //5.添加带有formatting的DateFormat对象   
      DateFormat df = new DateFormat("dd MM yyyy hh:mm:ss");   
      WritableCellFormat wcfDF = new WritableCellFormat(df);   
      DateTime labelDTF = new DateTime(1,3,new java.util.Date(),wcfDF);   
      ws.addCell(labelDTF);   
      //6.添加图片对象,jxl只支持png格式图片   
      File image = new File("C:\\Documents and Settings\\sunflower\\桌面\\图片\\1.png");   
      WritableImage wimage = new WritableImage(0,4,6,17,image);   
      ws.addImage(wimage);   

      //写入到工作表
      wwb.write();
      wwb.close();
  }catch(Exception r){
   r.getStackTrace();
  }
 }
  /** 将file1拷贝后,进行修改并创建输出对象file2  
  
     * 单元格原有的格式化修饰不能去掉，但仍可将新的单元格修饰加上去，  
 
     * 以使单元格的内容以不同的形式表现  
 
     */  
  public static void modifyExcel(File file1,File file2){
   try{
    Workbook rwb = Workbook.getWorkbook(file1);   
    WritableWorkbook wwb = Workbook.createWorkbook(file2,rwb);//copy   
    WritableFont wfc = new WritableFont(WritableFont.ARIAL,10,WritableFont.NO_BOLD,false,   
    UnderlineStyle.NO_UNDERLINE,jxl.format.Colour.BLUE);   
       WritableCellFormat wcfFC = new WritableCellFormat(wfc);    
       WritableSheet ws = wwb.getSheet(0);   
       WritableCell wc = ws.getWritableCell(0,0);   
       //判断单元格的类型,做出相应的转换   
       if(wc.getType() == CellType.LABEL)  {   
          Label labelCF =new Label(0,0,"人物（新）",wcfFC);   
          ws.addCell(labelCF);
          }   
   
           wwb.write();   
        wwb.close();   
        rwb.close();   

   }catch(Exception e){
    e.printStackTrace();
   }
  }
  //测试
 public static void main(String[] args) {
 try{
  //读Excel
  ExcelHandle.readExcel("E:/红楼人物.xls");
  //输出Excel
  File file = new File("E:/红楼人物2.xls");
  file.createNewFile();
  OutputStream os = new FileOutputStream(file);
  ExcelHandle.writeExcel(os);
  //修改Excel
  ExcelHandle.modifyExcel(new File("E:/红楼人物.xls"),new File("E:/红楼人物3.xls"));
 }catch(Exception e){
  e.printStackTrace();
 }
}
}