private static void beginMergerColumn(){
try {
InputStream fis1 = new FileInputStream("D:/合并文件/4/营业务汇总表.xls");
InputStream fis2 = new FileInputStream("D:/合并文件/4/产权抵押融资汇总表.xls");
Workbook wb1 = Workbook.getWorkbook(fis1);
Workbook wb2 = Workbook.getWorkbook(fis2);
WritableWorkbook newWb = Workbook.createWorkbook(new File("D:/合并文件/4/jxl_6.xls"));
newWb.importSheet("NewSheet0", 0, wb1.getSheet(0));
newWb.importSheet("NewSheet1", 1, wb2.getSheet(0));
fis1.close();
fis2.close();
wb1.close();
wb2.close();
newWb.write();
newWb.close();
} catch (BiffException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} catch (WriteException e) {
e.printStackTrace();
}
try {
InputStream fis1 = new FileInputStream("D:/合并文件/4/营业务汇总表.xls");
InputStream fis2 = new FileInputStream("D:/合并文件/4/产权抵押融资汇总表.xls");
Workbook wb1 = Workbook.getWorkbook(fis1);
Workbook wb2 = Workbook.getWorkbook(fis2);
WritableWorkbook newWb = Workbook.createWorkbook(new File("D:/合并文件/4/jxl_6.xls"));
newWb.importSheet("NewSheet0", 0, wb1.getSheet(0));
newWb.importSheet("NewSheet1", 1, wb2.getSheet(0));
fis1.close();
fis2.close();
wb1.close();
wb2.close();
newWb.write();
newWb.close();
} catch (BiffException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} catch (WriteException e) {
e.printStackTrace();
}
}
jxl.jar 一定要注意使用的版本