java 复制excel jxl_java通过jxl修改excel | 学步园

package com.mdcl.bgctv.fileManage.action;

import java.io.File;

import java.io.IOException;

import jxl.Workbook;

import jxl.read.biff.BiffException;

import jxl.write.Label;

import jxl.write.WritableSheet;

import jxl.write.WritableWorkbook;

import jxl.write.WriteException;

import jxl.write.biff.RowsExceededException;

public class UpdateExcel {

public static void main(String args[]){

try {

//获得Excel文件

Workbook wb = Workbook.getWorkbook(new File("D://test.xls"));

//打开一个文件副本，并且指定数据写回到原文件

WritableWorkbook book = Workbook.createWorkbook(new File("D://test.xls"), wb);

//添加一个工作表

WritableSheet sheet = book.createSheet("第二页", 1);

sheet.addCell(new Label(0,0,"第二页数据"));

book.write();

book.close();

} catch (BiffException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (RowsExceededException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (WriteException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}