1 package excel;
2
3
4 import java.io.File;
5
6 import jxl.Workbook;
7 import jxl.write.Label;
8 import jxl.write.WritableSheet;
9 import jxl.write.WritableWorkbook;
10
11 public class UpdateExcel {
12 public static void main(String args[]) {
13 try {
14 // Excel获得文件
15 Workbook wb = Workbook.getWorkbook( new File( " test.xls " ));
16 // 打开一个文件的副本，并且指定数据写回到原文件
17 WritableWorkbook book = Workbook.createWorkbook( new File( " test.xls " ),
18 wb);
19 // 添加一个工作表
20 WritableSheet sheet = book.createSheet( " 第二页 " , 1 );
21 sheet.addCell( new Label( 0 , 0 , " 第二页的测试数据 " ));
22 book.write();
23 book.close();
24 } catch (Exception e) {
25 System.out.println(e);
26 }
27 }
28 }
29
