修改已经存在的EXCEL文件(lcl.xls存在于当前目录):
import java.io.*;
import jxl.*;
import jxl.write.*;public class RewriteExcel {
public static void main(String args[]) {
try {
Workbook wb = Workbook.getWorkbook(new File("lcl.xls"));
WritableWorkbook book = Workbook.createWorkbook(
new File("lcl.xls"), wb);
// WritableSheet sheet=book.createSheet("page2",1);
WritableSheet sheet = book.getSheet("TestSheet2");
sheet.addCell(new Label(5, 0, "mytest---------ok"));book.write();
book.close();
} catch (Exception e) {
System.out.println(e);
}
}
}
转载请注明:观测者 » Java修改已经存在的Excel文件