好贷网好贷款

jxl excel 导出

发布时间:2016-12-5 8:38:12 编辑:www.fx114.net 分享查询网我要评论
本篇文章主要介绍了"jxl excel 导出",主要涉及到jxl excel 导出方面的内容,对于jxl excel 导出感兴趣的同学可以参考一下。

//生成Excel类 import java.io.File; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.List; import jxl.Workbook; import jxl.write.Label; import jxl.write.WritableCellFormat; import jxl.write.WritableFont; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; public class ExpExcl { /** * 初始化数据 * @return */ public List getData(){ ResultSet rs = null; List list = new ArrayList(); Datathplyyvch data = new Datathplyyvch(); data.setAreano("地区号111"); data.setNetdotno("网点111"); Datathplyyvch data1 = new Datathplyyvch(); data1.setAreano("地区号222"); data1.setNetdotno("网点222"); list.add(data); list.add(data1); return list; } public void expExcel(){ try { SimpleDateFormat dateFormat = new SimpleDateFormat("yyyyMMddHHmmss");//设置文件名 SimpleDateFormat date2Format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//导出日期        java.util.Date date = new java.util.Date();        String dateStr = dateFormat.format(date); WritableWorkbook book = Workbook.createWorkbook(new File("d:/测试"+dateStr+".xls"));  WritableSheet sheet = book.createSheet("影印日志", 0);   //标题行格式化 WritableFont wf = new WritableFont(WritableFont.TIMES,16, WritableFont.BOLD,false);    WritableCellFormat   wcf = new WritableCellFormat(wf);//实例化文字格式化  wcf.setAlignment(jxl.format.Alignment.CENTRE);//左右居中 wcf.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);//上下居中   //打印日期行格式化 WritableFont wf2 = new WritableFont(WritableFont.TIMES,10, WritableFont.NO_BOLD,false);    WritableCellFormat   wcf2 = new WritableCellFormat(wf2);//实例化文字格式化  wcf2.setAlignment(jxl.format.Alignment.LEFT);//左右居中 // wcf2.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);//上下居中   //列名格式化 WritableFont wf3 = new WritableFont(WritableFont.TIMES,13, WritableFont.BOLD,false);    WritableCellFormat   wcf3 = new WritableCellFormat(wf3);//实例化文字格式化  wcf2.setAlignment(jxl.format.Alignment.CENTRE);//左右居中 // wcf2.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);//上下居中 sheet.insertRow(0); sheet.mergeCells(0, 0, 18, 0);//合并单元格  sheet.addCell(new Label(0, 0, "批量验印日志",wcf));  sheet.setRowView(0, 800);//设置高度 sheet.insertRow(1); sheet.mergeCells(0, 1, 18, 1); sheet.addCell(new Label(0, 1, "导出日期:"+date2Format.format(date),wcf2)); sheet.insertRow(2); sheet.addCell(new Label(0,2,"地区号",wcf3)); sheet.setColumnView(0, 10);//设置列宽度 sheet.addCell(new Label(1,2,"网点",wcf3)); List list = this.getData(); for(int i=3;i<list.size()+3;i++){ Datathplyyvch data = (Datathplyyvch)list.get(i-3); sheet.insertRow(i); sheet.addCell(new Label(0, i, data.getAreano())); sheet.addCell(new Label(1, i, data.getNetdotno())); } book.write();   book.close(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }  } /** * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub ExpExcl ee = new ExpExcl(); ee.expExcel(); } } //实体类 public class Datathplyyvch { private String areano;       // VARCHAR2(8)                  NOT NULL,  --地区号 private String netdotno;      //VARCHAR2(8)                  NOT NULL,  --网点 public String getAreano() { return areano; } public void setAreano(String areano) { this.areano = areano; } public String getNetdotno() { return netdotno; } public void setNetdotno(String netdotno) { this.netdotno = netdotno; } }

上一篇:IOS MKMapView 地图视图
下一篇:Opencv2.4.3在vs2010下的配置

相关文章

关键词: jxl excel 导出

相关评论