1 ） 新建实体类Book
[Java]view plaincopypackagecom.bean;publicclassBook{privateIntegerid;privateStringname;privateStringauthor;publicIntegergetId(){returnid;}publicvoidsetId(Integerid){this.id=id;}publicStringgetName(){returnname;}publicvoidsetName(Stringname){this.name=name;}publicStringgetAuthor(){returnauthor;}publicvoidsetAuthor(Stringauthor){this.author=author;}}
2 ） 实现导入与导出方法
[Java]view plaincopypackagecom.main;importjava.io.File;importjava.io.IOException;importjava.util.ArrayList;importjava.util.List;importcom.bean.Book;importjxl.Cell;importjxl.Sheet;importjxl.Workbook;importjxl.write.Label;importjxl.write.WritableSheet;importjxl.write.WritableWorkbook;importjxl.write.WriteException;publicclassExcleBook{/***针对Book类进行导出的操作*@paramlist*/publicvoidexcleOut(List<book>list){WritableWorkbookbook=null;try{//创建一个excle对象book=Workbook.createWorkbook(newFile("h:/excleTest/book.xls"));//通过excle对象创建一个选项卡对象WritableSheetsheet=book.createSheet("sheet1",0);//创建一个单元格对象列行值//Labellabel=newLabel(0,2,"test");for(inti=0;i<list.size();i++){Bookbook2=list.get(i);Labellabel1=newLabel(0,i,String.valueOf(book2.getId()));Labellabel2=newLabel(1,i,book2.getName());Labellabel3=newLabel(2,i,book2.getAuthor());//将创建好的单元格对象放入选项卡中sheet.addCell(label1);sheet.addCell(label2);sheet.addCell(label3);}//写入目标路径book.write();}catch(Exceptione){e.printStackTrace();}finally{try{book.close();}catch(WriteException|IOExceptione){//TODOAuto-generatedcatchblocke.printStackTrace();}}}/***针对Book类进行导入的操作*@return*/publicList<book>excleIn(){List<book>list=newArrayList<>();Workbookworkbook=null;try{//获取Ecle对象workbook=Workbook.getWorkbook(newFile("h:/excleTest/book.xls"));//获取选项卡对象第0个选项卡Sheetsheet=workbook.getSheet(0);//循环选项卡中的值for(inti=0;i<sheet.getRows();i++){Bookbook=newBook();//获取单元格对象Cellcell0=sheet.getCell(0,i);//取得单元格的值,并设置到对象中book.setId(Integer.valueOf(cell0.getContents()));//获取单元格对象，然后取得单元格的值,并设置到对象中book.setName(sheet.getCell(1,i).getContents());book.setAuthor(sheet.getCell(2,i).getContents());list.add(book);}}catch(Exceptione){e.printStackTrace();}finally{workbook.close();}returnlist;}publicstaticvoidmain(String[]args){ExcleBookbook=newExcleBook();List<book>list=newArrayList<>();Bookbook2=newBook();book2.setId(1);book2.setName("书本名1");book2.setAuthor("张三");Bookbook3=newBook();book3.setId(2);book3.setName("书本名2");book3.setAuthor("李四");list.add(book2);list.add(book3);book.excleOut(list);List<book>books=book.excleIn();for(Bookbo:books){System.out.println(bo.getId()+""+bo.getName()+""+bo.getAuthor());}}}
在这当中需要加入jxl.jar这个包，自己在网上下载，如果你使用Mavne,进行对应的配置就可以了。
源地址 ：/nieguohui94/article/details/78011813
