拷贝sheet(从一个Excel表拷贝到另一个Excel表中),貌似不支持所有类型的数据,经常出错,但是简单的excel表拷贝没问题
Test.java
import java.io.File;
import jxl.Sheet;
import jxl.Workbook;
import jxl.write.WritableWorkbook;
public class toExcel {
public toExcel(String path){
Workbook wb =null;
WritableWorkbook wwb =null;
try {
wb = Workbook.getWorkbook(new File("d:/excel/source.xls"));
Sheet sheet = wb.getSheet(0);
Sheet sheet2 = wb.getSheet(10);
// wwb = Workbook.createWorkbook(new File(path),wb); 拷贝整个Excel
wwb = Workbook.createWorkbook(new File(path));
wwb.importSheet("aa", 0,sheet);
wwb.write();
wwb.close();
wb.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public static void main(String[] ars){
new toExcel("d:/excel/des.xls");
}
}