package com.jikexueyuan.util;
import java.io.File;
import java.io.IOException;
import java.lang.reflect.Field;
import java.util.ArrayList;
import com.jikexueyuan.bean.Book;
import jxl.Sheet;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
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, "d:/jikexueyuan/bookw.xls");
ArrayList<Book> ar = ExcleUtil.excleIn(Book.class, "d:/jikexueyuan/bookw.xls");
for(Book bo : ar){
System.out.println(bo.getName()+bo.getType());
}
}
}
反射实现通用excel导入导出
最新推荐文章于 2024-07-24 23:57:40 发布