package test;
import java.io.File;
import java.io.IOException;
import jxl.*;
import jxl.read.biff.BiffException;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
public class Test {
public static void main(String[] args) throws WriteException, BiffException, IOException {
File inputfile = new File("G:/lib/jexcel/source.xls");
File inputfile1 = new File("G:/lib/jexcel/source1.xls");
File inputfile2 = new File("G:/lib/jexcel/source2.xls");
File outputfile = new File("G:/lib/jexcel/des.xls");
if (!outputfile.exists()) {
outputfile.createNewFile();
}
// Read all files from directory
try {
// Get a writable workbook
WritableWorkbook writableworkbook = Workbook.createWorkbook(outputfile);
Workbook sourceworkbook = Workbook.getWorkbook(inputfile);
Workbook workbook1 = Workbook.getWorkbook(inputfile1);
Workbook workbook2 = Workbook.getWorkbook(inputfile2);
Sheet readablesheet = sourceworkbook.getSheet(0);
Sheet sheet1 = workbook1.getSheet(0);
Sheet sheet2 = workbook2.getSheet(0);
writableworkbook.importSheet(readablesheet.getName(), 0, readablesheet);
writableworkbook.importSheet("good", 1, sheet1);
writableworkbook.importSheet("better", 2, sheet2);
writableworkbook.write();
writableworkbook.close();
} catch (IOException e) {
System.err.println("I/O error." + e);
}
}
}
Java jxl中 importSheet的例子
最新推荐文章于 2021-03-06 16:39:33 发布