java 更新Excel中的数据

java 更新Excel中的数据(如将测试结果写入测试用例)

import java.io.File;

import java.io.IOException;

import jxl.CellType;

import jxl.Workbook;

import jxl.read.biff.BiffException;

import https://www.360docs.net/doc/887942552.html,bel;

import jxl.write.WritableCell;

import jxl.write.WritableSheet;

import jxl.write.WritableWorkbook;

import jxl.write.WriteException;

import jxl.write.biff.RowsExceededException;

public class WriteExcle {

// private static int column = 9;

/*

*id:用于相对定位，result:要写入的内容

*/

public static void writeExcle(String id,String result) throws BiffException, RowsExceededException, WriteException, IOException {

// 创建只读的Excel工作薄的对象，即Excel模板（已存在）

Workbook workbook = Workbook.getWorkbook(new File(

"D:\\MobileConnector测试用例.xls"));

//创建新的Excel文件，用于将模板中内容复制到其中并用于更新

File file = new File("D:\\MobileConnector测试结果.xls");

// 创建可写入的Excel工作薄对象，即将模板内容复制到新的Excel文件

WritableWorkbook wwb = Workbook.createWorkbook(file, workbook);

/*

*设置格式

*/

// WritableFont wf = new WritableFont(WritableFont.ARIAL, 10,

// WritableFont.NO_BOLD, false, UnderlineStyle.NO_UNDERLINE,

// jxl.format.Colour.BLUE);

// WritableCellFormat wcf = new WritableCellFormat(wf);

// 读取第一张工作表

WritableSheet ws = wwb.getSheet(0);

// 获得对应单元格对象,相对定位

WritableCell wc=(WritableCell) ws.findCell(id);

/*

*绝对定位

*/

// WritableCell wc = ws.getWritableCell(column, row); // 判断单元格的类型, 做出相应的转化

if (wc.getType() == https://www.360docs.net/doc/887942552.html,BEL) {

// Label label = new Label(0, 0, "dddd", wcf);

// ws.addCell(label);

Label label = (Label) wc;

label.setString(result);

}

// 写入Excel对象

wwb.write();

System.out.println(id+"：测试结果写入成功");

// 关闭可写入的Excel对象

wwb.close();

// 关闭只读的Excel对象

workbook.close();

}

}