读书人

Java jxl中 importSheet的例证

发布时间: 2013-02-02 12:27:16 作者: rapoo

Java jxl中 importSheet的例子

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 directorytry {// Get a writable workbookWritableWorkbook 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);}}}

读书人网 >开源软件

热点推荐