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();
}
}
}
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();
}
}
}