import jxl.Workbook;
import java.io.File;
import jxl.write.Label;
import java.io.IOException;
import jxl.write.WritableSheet;
import jxl.write.WriteException;
import jxl.write.WritableWorkbook;
import jxl.read.biff.BiffException;public class UpdateXLS { public static void main(String args[]) { WritableWorkbook book = null; try {
//Excel获得文件
Workbook wb = Workbook.getWorkbook(new File("测试.xls")); //打开一个文件的副本,并且指定数据写回到原文件
book = Workbook.createWorkbook(new File("测试.xls"), wb); //添加一个工作表
WritableSheet sheet = book.getSheet("第二页"); sheet.addCell(new Label(0, 0, "234")); book.write();
}
catch (IOException ioe) {
ioe.printStackTrace();
}
catch (BiffException be) {
be.printStackTrace();
}
catch (WriteException we) {
we.printStackTrace();
}
finally { try {
if (book != null) {
book.close();
}
}
catch (IOException ioe) {
ioe.printStackTrace();
}
catch (WriteException we) {
we.printStackTrace();
}
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货