Java利用反射导入导出Excle

package util; import java.io.File; import java.lang.reflect.Field; import java.util.ArrayList; import jxl.Sheet; import jxl.Workbook; import jxl.write.Label; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; import bean.Book; public class ExcleUtil { //如果有一个项目 图书馆管理系统 要求你实现 // 图书信息导入导出 用户信息导入导出 借阅信息导入导出 // 维护信息导入导出 管理员信息导入导出。。。。。。。 public static void excleOut(ArrayList ar,String str){ WritableWorkbook book = null; try { book = Workbook.createWorkbook(new File(str)); WritableSheet sheet = book.createSheet("sheet", 0); for(int i = 0;i<ar.size();i++){ Object ob = ar.get(i); Class cl = ob.getClass(); Field[] fi = cl.getDeclaredFields(); for(int j = 0;j<fi.length;j++){ fi[j].setAccessible(true); Label la = new Label(j, i, String.valueOf(fi[j].get(ob))); sheet.addCell(la); } } book.write(); } catch (Exception e) { e.printStackTrace(); }finally{ try { book.close(); } catch (Exception e) { e.printStackTrace(); } } } public static ArrayList excleIn(Class cl,String str){ ArrayList ar = new ArrayList(); Workbook book = null; try { book = Workbook.getWorkbook(new File(str)); Sheet sheet = book.getSheet(0); Field[] fi = cl.getDeclaredFields(); for(int i = 0;i<sheet.getRows();i++){ Object ob = cl.newInstance();//创建实例化对象 for(int j = 0;j<fi.length;j++){ fi[j].setAccessible(true); String con = sheet.getCell(j,i).getContents(); if(fi[j].getType().toString().equals("class java.lang.String")){ fi[j].set(ob, con); }else if(fi[j].getType().toString().equals("int")){ fi[j].setInt(ob, Integer.valueOf(con)); }else if(fi[j].getType().toString().equals("class java.lang.Integer")){ fi[j].setInt(ob, Integer.valueOf(con)); } } ar.add(ob); } } catch (Exception e) { e.printStackTrace(); }finally{ book.close(); } return ar; } public static void main(String[] args) { ArrayList<Book> ar = new ArrayList<Book>(); Book bo = new Book(); bo.setId(1); bo.setName("月子"); bo.setType("生活"); Book bo1 = new Book(); bo1.setId(2); bo1.setName("日子"); bo1.setType("生活"); ar.add(bo); ar.add(bo1); ExcleUtil.excleOut(ar, "e:/bookw.xls"); // ArrayList<Book> ar = ExcleUtil.excleIn(Book.class, "d:/jikexueyuan/bookw.xls"); // // for(Book bo : ar){ // System.out.println(bo.getName()+bo.getType()); // } } }