<rt id="bn8ez"></rt>
<label id="bn8ez"></label>

  • <span id="bn8ez"></span>

    <label id="bn8ez"><meter id="bn8ez"></meter></label>

    如何學好java

    如何學好java,其實很簡單,只要用心體會,慢慢積累!
    posts - 106, comments - 7, trackbacks - 0, articles - 3
      BlogJava :: 首頁 :: 新隨筆 :: 聯(lián)系 :: 聚合  :: 管理

    jxl.jar 導出excel

    Posted on 2012-08-23 21:21 哈希 閱讀(267) 評論(0)  編輯  收藏 所屬分類: java 代碼
    <%@ page pageEncoding="utf-8" %> <%@ page language="java" contentType="text/html; charset=GBK" %><%@ page import="java.util.*" %> <%@ page import="java.io.OutputStream" %> <%@ page import="jxl.Workbook" %> <%@ page import="jxl.write.WritableCellFormat" %> <%@ page import="jxl.write.WritableSheet" %> <%@ page import="jxl.write.WritableWorkbook" %> <%@ page import="jxl.write.WriteException" %> <%@ page import="java.text.SimpleDateFormat" %> <% response.reset(); response.setContentType("application/vnd.ms-excel"); response.setHeader("Content-Disposition", "filename=Member.xls");//attachment// WritableWorkbook是JexcelApi的一個類。 // 以下可以理解為創(chuàng)建一個excel文件,然后在excel里面創(chuàng)建一個表 OutputStream os = response.getOutputStream();//取得輸出流 WritableWorkbook workbook = Workbook.createWorkbook(os); WritableSheet sheet = workbook.createSheet("First Sheet", 0);// 組織excel文件的內容 jxl.write.Label label = null; int excelCol = 0; int row = 0; try { label = new jxl.write.Label(excelCol++, row, "帳號"); sheet.addCell(label); label = new jxl.write.Label(excelCol++, row, "姓名"); sheet.addCell(label); label = new jxl.write.Label(excelCol++, row, "身份證"); sheet.addCell(label); label = new jxl.write.Label(excelCol++, row, "聯(lián)系電話"); sheet.addCell(label); label = new jxl.write.Label(excelCol++, row, "生日"); sheet.addCell(label); label = new jxl.write.Label(excelCol++, row, "城市"); sheet.addCell(label); label = new jxl.write.Label(excelCol++, row, "職業(yè)"); sheet.addCell(label); label = new jxl.write.Label(excelCol++, row, "已購音箱型號"); sheet.addCell(label); label = new jxl.write.Label(excelCol++, row, "試聽與否"); sheet.addCell(label); label = new jxl.write.Label(excelCol++, row, "郵箱"); sheet.addCell(label); label = new jxl.write.Label(excelCol, row, "注冊時間"); sheet.addCell(label); //jxl.write.Number number = null; jxl.write.DateTime dateTime; jxl.write.DateFormat customDateFormat = new jxl.write.DateFormat("yyyy-MM-dd");//時間格式 WritableCellFormat dateFormat = new WritableCellFormat(customDateFormat); for(int i=0;i<10;i++){ excelCol = 0; row = i + 1; SimpleDateFormat formatDate = new SimpleDateFormat("yyyy-MM-dd"); sheet.addCell(label); label = new jxl.write.Label(excelCol++, row, "100"); sheet.addCell(label); label = new jxl.write.Label(excelCol++, row, "100"); sheet.addCell(label); label = new jxl.write.Label(excelCol++, row, "100"); sheet.addCell(label); /*字串格式*/ try{ label = new jxl.write.Label(excelCol++, row, formatDate.format("100")); sheet.addCell(label); }catch (Exception e){ //Maybe somebody fogot to input his birthday ,I need do nothing here! } label = new jxl.write.Label(excelCol++, row, "100"); sheet.addCell(label); label = new jxl.write.Label(excelCol++, row, "100"); sheet.addCell(label); label = new jxl.write.Label(excelCol++, row, "100"); sheet.addCell(label); label = new jxl.write.Label(excelCol++, row, "100"); sheet.addCell(label); label = new jxl.write.Label(excelCol++, row, "100"); sheet.addCell(label); /*時間格式*/ //label = new jxl.write.Label(excelCol, row, formatDate.format(rr.getCreateTime())); //sheet.addCell(label); } } catch (Exception e) { e.printStackTrace(); } finally{ // 生成excel文件 workbook.write(); workbook.close(); os.close(); } %>
    主站蜘蛛池模板: 亚洲熟妇AV乱码在线观看| 亚洲国产人成精品| 中文字幕在线免费看线人| 三年片免费观看大全国语| 最近中文字幕2019高清免费| 亚洲日韩国产精品第一页一区| 久久精品国产亚洲AV高清热 | 亚洲国产视频一区| 69av免费视频| 亚洲香蕉久久一区二区三区四区| 无码国产精品一区二区免费虚拟VR | 免费看成人AA片无码视频羞羞网| 亚洲一区二区三区深夜天堂| 美女黄色免费网站| 免费在线观看你懂的| 久久亚洲国产欧洲精品一| 毛片免费在线观看| 亚洲最大在线观看| 日本不卡高清中文字幕免费| 老外毛片免费视频播放| 伊人亚洲综合青草青草久热| 欧洲人免费视频网站在线| 免费中文字幕在线观看| 9i9精品国产免费久久| 亚洲日本在线观看| 四虎免费大片aⅴ入口| 亚洲精品黄色视频在线观看免费资源 | 亚洲人成电影在在线观看网色| 亚州免费一级毛片| 亚洲AV成人无码久久WWW| 1000部啪啪未满十八勿入免费| 亚洲国产最大av| 亚洲AV网站在线观看| 国产精品亚洲精品| 亚洲AV永久无码精品一区二区国产| 99在线热播精品免费99热| 亚洲人成电影网站| 亚洲国产专区一区| 永久免费视频网站在线观看| 羞羞视频免费网站含羞草| 色播亚洲视频在线观看|