Java编辑表

1. java 表格操作

我现在刚用的就是jxl的东西。不过，我里面的文件path没有弄好，设了个死的进去啦 package com.jin.comm.share; import java.io.File; import java.util.ArrayList;import jxl.Workbook; import jxl.write.Label; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; import com.jin.beans.CustomerInfor;public class ExportFile { public void expToXSL(ArrayList datalist, String path)throws Exception{ WritableWorkbook book = Workbook.createWorkbook(new File(path)); // 设置表名 WritableSheet sheet = book.createSheet("客户信息",0); // 生成表格题头 Label labe1 = new Label(0, 0, "编码" ); Label labe2 = new Label(1, 0, "旅行社简称"); Label labe3 = new Label(2, 0, "销售代表"); Label labe4 = new Label(3, 0, "客户级别"); Label labe5 = new Label(4, 0, "合作情况"); Label labe6 = new Label(5, 0, "类型"); Label labe7 = new Label(6, 0, "可信任值"); Label labe8 = new Label(7, 0, "开始合作日期" ); Label labe9 = new Label(8, 0, "终止合作日期"); Label labe10 = new Label(9, 0, "付款方式"); Label labe11 = new Label(10, 0, "旅行社全称"); Label labe12 = new Label(11, 0, "国家/地区"); Label labe13 = new Label(12, 0, "省/直辖市"); Label labe14 = new Label(13, 0, "城市"); Label labe15 = new Label(14, 0, "街道" ); Label labe16 = new Label(15, 0, "邮政编码"); Label labe17 = new Label(16, 0, "电话"); Label labe18 = new Label(17, 0, "传真"); Label labe19 = new Label(18, 0, "电子邮件"); Label labe20 = new Label(19, 0, "web页地址"); Label labe21 = new Label(20, 0, "开户银行"); Label labe22 = new Label(21, 0, "银行账号" ); Label labe23 = new Label(22, 0, "所属机构"); Label labe24 = new Label(23, 0, "所属部门"); Label labe25 = new Label(24, 0, "维护人"); Label labe26 = new Label(25, 0, "维护时间"); Label labe27 = new Label(26, 0, "备注"); //将生成的单元格添加到工作表中 sheet.addCell(labe1); sheet.addCell(labe2); sheet.addCell(labe3); sheet.addCell(labe4); sheet.addCell(labe5); sheet.addCell(labe6); sheet.addCell(labe7); sheet.addCell(labe8); sheet.addCell(labe9); sheet.addCell(labe10); sheet.addCell(labe11); sheet.addCell(labe12); sheet.addCell(labe13); sheet.addCell(labe14); sheet.addCell(labe15); sheet.addCell(labe16); sheet.addCell(labe17); sheet.addCell(labe18); sheet.addCell(labe19); sheet.addCell(labe20); sheet.addCell(labe21); sheet.addCell(labe22); sheet.addCell(labe23); sheet.addCell(labe24); sheet.addCell(labe25); sheet.addCell(labe26); sheet.addCell(labe27); for(int i=1; i<=datalist.size(); i++){ CustomerInfor infor = (CustomerInfor)datalist.get(i-1); Label label1=new Label(0,i,infor.getCode()); Label label2=new Label(1,i,infor.getDepartment()); Label label3=new Label(2,i,infor.getSales()); Label label4=new Label(3,i,infor.getLevel()); Label label5=new Label(4,i,infor.getTecase()); Label label6=new Label(5,i,infor.getTetype()); Label label7=new Label(6,i,infor.getTrust()); Label label8=new Label(7,i,infor.getStarttime()==null ? null : infor.getStarttime().toString()); Label label9=new Label(8,i,infor.getEndtime()==null ? null : infor.getEndtime().toString()); Label label10=new Label(9,i,infor.getPaytype() ); Label label11=new Label(10,i,infor.getFullname() ); Label label12=new Label(11,i,infor.getCountry() ); Label label13=new Label(12,i,infor.getProvince() ); Label label14=new Label(13,i,infor.getLocality() ); Label label15=new Label(14,i,infor.getStreet() ); Label label16=new Label(15,i,infor.getPostal() ); Label label17=new Label(16,i,infor.getPhone() ); Label label18=new Label(17,i,infor.getFax() ); Label label19=new Label(18,i,infor.getEmail() ); Label label20=new Label(19,i,infor.getWebsite() ); Label label21=new Label(20,i,infor.getBankname() ); Label label22=new Label(21,i,infor.getBanknum() ); Label label23=new Label(22,i,infor.getInstitution() ); Label label24=new Label(23,i,infor.getIndepart() ); Label label25=new Label(24,i,infor.getKeepby() ); Label label26=new Label(25,i,infor.getKeepday()==null ? null :infor.getKeepday().toString()); Label label27=new Label(26,i,infor.getComment() ); //将生成的单元格添加到工作表中 sheet.addCell(label1); sheet.addCell(label2); sheet.addCell(label3); sheet.addCell(label4); sheet.addCell(label5); sheet.addCell(label6); sheet.addCell(label7); sheet.addCell(label8); sheet.addCell(label9); sheet.addCell(label10); sheet.addCell(label11); sheet.addCell(label12); sheet.addCell(label13); sheet.addCell(label14); sheet.addCell(label15); sheet.addCell(label16); sheet.addCell(label17); sheet.addCell(label18); sheet.addCell(label19); sheet.addCell(label20); sheet.addCell(label21); sheet.addCell(label22); sheet.addCell(label23); sheet.addCell(label24); sheet.addCell(label25); sheet.addCell(label26); sheet.addCell(label27); } book.write(); book.close(); }