excel导入java-jxl导出.docxVIP

创建一个实体import java.io.serializable;public class datapojo implements serializable {private static final long serialversionuid = 6230244466642061219l;/*** 序号*/private string dataid;/*** 公司中文名*/private string cnname;/*** 开户帐号*/private string bankaccount;/*** 结算总额*/private string settlefee;public string getdataid() {return dataid;}public void setdataid(string dataid) {this.dataid = dataid;}public string getcnname() {return cnname;}public void setcnname(string cnname) {this.cnname = cnname;}public string getbankaccount() {return bankaccount;}public void setbankaccount(string bankaccount) {this.bankaccount = bankaccount;}public string getsettlefee() {return settlefee;}public void setsettlefee(string settlefee) {this.settlefee = settlefee;}}读取excel的一个类import java.io.*;import java.util.arraylist;import java.util.list;import jxl.*;public class readexcel {public static listdatapojo readexcel() {listdatapojo list = new arraylistdatapojo();try {workbook book = workbook.getworkbook(new file(1000条测试数据.xls));// 获得第一个工作表对象sheet sheet = book.getsheet(0);int cols = sheet.getcolumns(); // 获取excel 列数int rows = sheet.getrows();// 获取excel行数// 循环打印excel中的数据// 如果excel中有标题如果不用读取标题的时候则根据要读取的行开始// 在开发中一搬我们都会给用户一个固定的模板上传数据// 所以excel中的哪一列是啥数据我们很清楚for (int i = 2; i rows; i++) {datapojo pojo = new datapojo();cell cell1 = sheet.getcell(0, i);string dataid = cell1.getcontents();pojo.setdataid(dataid);cell cell2 = sheet.getcell(1, i);string cnname = cell2.getcontents();pojo.setcnname(cnname);cell cell3 = sheet.getcell(2, i);string bankaccount = cell3.getcontents();pojo.setbankaccount(bankaccount);cell cell4 = sheet.getcell(3, i);string settlefee = cell4.getcontents();pojo.setsettlefee(settlefee);list.add(pojo);}book.close();} catch (exception e) {system.out.println(e);}return list;}public static void main(string args[]) {readexcel();}}导出类import jxl.format.border;import jxl.format.borderlinestyle;import jxl.format.colour;import jxl.format.underlinestyle;import jxl.write.writablecellformat;import jxl.