java 复制excel jxl_JXL复制并修改Excel（Excel2003）

import java.io.File;

import java.text.SimpleDateFormat;

import java.util.TimeZone;

import jxl.Cell;

import jxl.CellType;

import jxl.DateCell;

import jxl.Workbook;

import jxl.write.Label;

import jxl.write.NumberFormat;

import jxl.write.WritableCell;

import jxl.write.WritableCellFormat;

import jxl.write.WritableSheet;

import jxl.write.WritableWorkbook;

public class CopyExcel {

/**

* 复制Excel后，进行修改

*

* @throws Exception

*/

public static void copyXSL() throws Exception{

//xls文件

Workbook workbook = Workbook.getWorkbook(new File("导出文件.xls"));

//创建xls文件

WritableWorkbook copy=Workbook.createWorkbook(new File("copy.xls"),workbook);

//------------------------------------------------------//

WritableSheet sheet1=copy.getSheet(0);

WritableCell cell = sheet1.getWritableCell(1, 2);

//判断类型

if(cell.getType()==CellType.LABEL){

Label l = (Label) cell;

l.setString("modified cell");

}

//数字

WritableCell cell2_4 = sheet1.getWritableCell(2, 4);

NumberFormat fivedps = new NumberFormat("#.#####");

WritableCellFormat cellFormat = new WritableCellFormat(fivedps);

cell2_4.setCellFormat(cellFormat);

//字符串类型

Label label = new Label(0, 2, "New label record");

sheet1.addCell(label);

//数字类型

jxl.write.Number number = new jxl.write.Number(3, 4, 3.1459);

sheet1.addCell(number);

//时间类型

TimeZone gmtZone=TimeZone.getTimeZone("GMT");

SimpleDateFormat format = new SimpleDateFormat("dd MMM yyyy");

format.setTimeZone(gmtZone);

Cell dateCell=sheet1.getWritableCell(0, 3);

if(dateCell.getType()==CellType.DATE){

DateCell dc = (DateCell) dateCell;

String dateString=format.format(dc.getDate());

System.out.println(dateString);

}

//-----------------------------------------------//

copy.write();

copy.close();

}

/**

* @param args

*/

public static void main(String[] args) {

try {

copyXSL();

} catch (Exception e) {

e.printStackTrace();

}

}

}