JXL拷贝sheet

来源：互联网发布：大学综测知乎编辑：程序博客网时间：2024/04/29 04:20

拷贝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");        }  }

0 0