向先原来就有数据的Excel写数据是不会覆盖原有的数据,只是在追加数据。
public class Excel {
public Excel() {
}
public void CreateWorkbook(File file, double[] a) {
try {
if (!file.exists()) { //判断文件是否已存在,如果没有存在则创建新文件
jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(new
File("result.xls"
));
jxl.write.WritableSheet ws = wwb.createSheet("Test Sheet 1", 0);
int i = 0;
ws.setColumnView(0, 20); //设置列宽
jxl.write.NumberFormat nf = new jxl.write.NumberFormat(
"0.0000000000000000"); //定义数值格式
WritableCellFormat wcfN = new WritableCellFormat(nf);
String str2 = "第" + 1 + "次试验";
Label label = new Label(0, 0, str2);
ws.addCell(label);
while (i < a.length) {
jxl.write.Number num =