[阅读: 423] 2006-10-19 06:15:33
public class ExcelModifying {
public static void main(String[] args) throws BiffException, IOException,
WriteException {
// 创建只读的Excel工作薄的对象
Workbook rw = jxl.Workbook.getWorkbook(new File("d:/222.xls"));
// 创建可写入的Excel工作薄对象
WritableWorkbook wwb = Workbook.createWorkbook(new File("d:/111.xls"), rw);
// 读取第一张工作表
WritableSheet ws = wwb.getSheet(0);
// 获得第一个单元格对象
WritableCell wc = ws.getWritableCell(0, 0);
// 判断单元格的类型, 做出相应的转化
if (wc.getType() == CellType.LABEL) {
Label l = (Label) wc;
l.setString("The value has been modified.");
}
// 写入Excel对象
wwb.write();
// 关闭可写入的Excel对象
wwb.close();
// 关闭只读的Excel对象
rw.close();
}
}
奏刀騞然,莫不中音。合於桑林之舞,乃中经首之会。