package com.demo.common;
import java.io.File;
import java.io.IOException;
import jxl.CellType;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import jxl.write.Label;
import jxl.write.WritableCell;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
/**
* @文件名:UpdateExcelTest.java
* @作者: 花非花雾非雾
* @生成日期: 2008-10-20
* @功能描述:测试java中主要是下面二步操作,第一步是构造只读的Excel工作薄,第二步是利用已经创建的Excel工作薄创建新的可写入的Excel工作薄更新excel
*/
public class UpdateExcelTest {
public static void main(String[] args) {
try {
//创建只读的Excel工作薄的对象
Workbook wb = Workbook.getWorkbook(new File("d:/a.xls"));
//创建可写入的Excel工作薄对象
WritableWorkbook wwb = Workbook.createWorkbook(new File("d:/b.xls"), wb);
//读取第一张工作表
WritableSheet ws = wwb.getSheet(0);
//获得第一个单元格对象
WritableCell wc = ws.getWritableCell(0, 0);
//判断单元格的类型, 做出相应的转化
if(wc.getType()==CellType.LABEL){
Label l = (Label)wc;
l.setString("好好学习,天天向上");
}
//写入Excel对象
wwb.write();
//关闭可写入的Excel对象
wwb.close();
//关闭只读的Excel对象
wb.close();
} catch (BiffException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} catch (WriteException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}