JAVA读写EXCEL

注意jxl.jar版本，最好最新的

最先运行 

package com.yuhaibin;

import jxl.*;
import jxl.write.*;
import jxl.write.biff.RowsExceededException;
import java.io.*;
public class CreateXLS {
 public static void main(String[] args) {
  try {// 打开文件
   WritableWorkbook book = Workbook.createWorkbook(new File(
     "F:/JAVA/测试.xls"));
   // 生成名为“第一页”的工作表，参数0表示这是第一页
   WritableSheet sheet = book.createSheet("第一页", 0);
   // 在Label对象的构造子中指名单元格位置是第一列第一行(0,0)
   // 以及单元格内容为test
   Label label = new Label(0, 0, "test");
   // 将定义好的单元格添加到工作表中

   sheet.addCell(label);
   /*
    * 生成一个保存数字的单元格 必须使用Number的完整包路径，否则有语法歧义 单元格位置是第二列，第一行，值为789.123
    */
   jxl.write.Number number = new jxl.write.Number(1, 0, 212.05);
   sheet.addCell(number);
   // 写入数据并关闭文件
   book.write();
   book.close();
  } catch (IOException e) {
   e.printStackTrace();
  } catch (RowsExceededException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (WriteException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
 }
}
再运行

package com.yuhaibin;

import java.io.*;

import jxl.*;
import jxl.format.UnderlineStyle;
import jxl.read.biff.BiffException;
import jxl.write.Label;
import jxl.write.WritableFont;
import jxl.write.WritableImage;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;

public class ReadXLS {
 public static void main(String[] args) {
  try {
   Workbook wb = Workbook.getWorkbook(new File("F:/JAVA/测试.xls"));
   // 打开一个文件的副本，并且指定数据写回到原文件
   WritableWorkbook book = Workbook.createWorkbook(new File(
     "F:/java/测试.xls"), wb);
   // 添加一个工作表
   WritableSheet sheet = book.createSheet("第二页", 1);
   // 添加带有字体颜色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(3, 0, "书店", wcfFC);
   sheet.addCell(labelCFC);
   // 普通单元格
   Label label = new Label(2, 0, "积跬步");
   sheet.addCell(label);
   // 3.添加Boolean对象
   jxl.write.Boolean labelB = new jxl.write.Boolean(4, 0, false);
   sheet.addCell(labelB);
   // 4.添加DateTime对象
   jxl.write.DateTime labelDT = new jxl.write.DateTime(0, 1,
     new java.util.Date());
   sheet.addCell(labelDT);
   // 添加带有formatting的DateFormat对象
   jxl.write.DateFormat df = new jxl.write.DateFormat(
     "yyyy MM dd hh:mm:ss");
   jxl.write.WritableCellFormat wcfDF = new jxl.write.WritableCellFormat(
     df);
   jxl.write.DateTime labelDTF = new jxl.write.DateTime(1, 1,
     new java.util.Date(), wcfDF);
   sheet.addCell(labelDTF);

   // 添加图片对象,jxl只支持png格式图片
   WritableImage wimage = new WritableImage(3, 3, 2, 4, new File(
     "F:/JAVA/2.png"));
   sheet.addImage(wimage);
   // try{
   //
   // Thread.currentThread();
   //
   // Thread.sleep(1000); //延时一秒执行下一句，1000毫秒=1秒
   //
   // //System.exit(0);
   //
   // }catch(Exception e){}
   book.write();
   try {
    book.close();
    wb.close();
   } catch (WriteException e1) {
    e1.printStackTrace();
   }

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

 }
}