updatexls.java

来自「才用java技术开发的程序」· Java 代码 · 共 31 行

import java.io.*;
import jxl.*;
import jxl.write.*;

public class UpdateXLS
{
        public static void main(String args[])
        {
           try
           {//Excel获得文件
            Workbook wb=Workbook.getWorkbook(new File("hongyuke.xls"));
            //打开一个文件的副本，并且指定数据写回到原文件
            WritableWorkbook book=Workbook.createWorkbook(new File("hongyuke.xls"),wb);
            //添加一个工作表
            WritableSheet sheet=book.createSheet("sfdsdfsd第二页",1);
            WritableSheet sheet1=book.createSheet("  dfgsdfghongyue",2);

            sheet.addCell(new Label(10,10,"第二页的测试数据"));
            sheet1.addCell(new Label(10,10,"第二页的测试数据"));
            sheet1.mergeCells(1,1,10,10);
            sheet.mergeCells(1,1,100,100);
            book.write();
            book.close();
          }
          catch(Exception e)
          {
            System.out.println(e);
          }
        }
}