麻豆小视频在线观看_中文黄色一级片_久久久成人精品_成片免费观看视频大全_午夜精品久久久久久久99热浪潮_成人一区二区三区四区

首頁 > 編程 > JavaScript > 正文

jqgrid 表格數據導出實例

2019-11-20 21:37:12
字體:
來源:轉載
供稿:網友

首先,是一段javascript腳本:

復制代碼 代碼如下:

/**
 * 
 * 
 * @param table_id 表格的id
 * @param container_id 容器的id
 * @param form_id 提交表單的id
 * @param title 文件名
 * @param rownumbers
 */ 
function getXlsFromTbl(table_id, container_id ,form_id, title, rownumbers) { 
    try { 
        var content = ""; 

 
        if (table_id != null && table_id != "" && table_id != "null") { 
        <SPAN style="WHITE-SPACE: pre"> </SPAN>content = getTblData($('#' + table_id), $('#' + container_id), rownumbers); 
        } 
        if (content == "") { 
            alert("表格不存在"); 
            return; 
        } 
        var fileName = getExcelFileName(title); 

        doFileExport($('#' + form_id), fileName, content); 
    } 
    catch (e) { 
        alert("導出異常:" + e.name + "->" + e.description + "!"); 
    } 

function getTblData(tableobj, containerobj, rownumbers) { 

 
    var outStr = ""; 
    if (tableobj != null) { 
        var rowdata = tableobj.getRowData(); 
        var Lenr = 1; 

 
        for (i = 0; i < Lenr; i++) { 
            //var Lenc = curTbl.rows(i).cells.length;  
            var th; 
            if (rownumbers == false) { 
                th = containerobj.find('TH:not(:first-child)'); 
            } 
            else { 
                th = containerobj.find('TH'); 
            } 
            th.each(function(index, element) { 
                var j = index + 1; 
                var content = $(element).text(); 
                content = content.replace(/(^/s*)|(/s*$)/g, "");//去掉空格  
                outStr += content + ","; 
            }); 
            outStr += "+nl+"; 
        } 
        var tmp = ""; 
        for (i = 0; i < rowdata.length; i++) { 
            var row = eval(rowdata[i]); 
            for (each in row) { 
            <SPAN style="WHITE-SPACE: pre">   </SPAN>var temp = $(row[each]).text(); 
            <SPAN style="WHITE-SPACE: pre">   </SPAN>if($(row[each]).text() == null || $(row[each]).text() == ""){ 
            <SPAN style="WHITE-SPACE: pre">       </SPAN>if(row[each].charAt(0) != '<') 
            <SPAN style="WHITE-SPACE: pre">           </SPAN>outStr += row[each] + ","; 
            <SPAN style="WHITE-SPACE: pre">       </SPAN> 
            <SPAN style="WHITE-SPACE: pre">   </SPAN>} 
            <SPAN style="WHITE-SPACE: pre">   </SPAN>else 
            <SPAN style="WHITE-SPACE: pre">       </SPAN>outStr += $(row[each]).text() + ","; 
            } 
            outStr += "+nl+"; 
        } 
    } 
    else { 
        outStr = null; 
        alert(inTbl + " null!"); 
    } 
    return outStr; 

function getExcelFileName(title) { 
    var d = new Date(); 
    var curYear = d.getYear(); 
    var curMonth = "" + (d.getMonth() + 1); 
    var curDate = "" + d.getDate(); 
    var curHour = "" + d.getHours(); 
    var curMinute = "" + d.getMinutes(); 
    var curSecond = "" + d.getSeconds(); 
    if (curMonth.length == 1) { 
        curMonth = "0" + curMonth; 
    } 
    if (curDate.length == 1) { 
        curDate = "0" + curDate; 
    } 
    if (curHour.length == 1) { 
        curHour = "0" + curHour; 
    } 
    if (curMinute.length == 1) { 
        curMinute = "0" + curMinute; 
    } 
    if (curSecond.length == 1) { 
        curSecond = "0" + curSecond; 
    } 
    var fileName = title + "_" + curYear + curMonth + curDate + "_" 
            + curHour + curMinute + curSecond + ".csv"; 

 
    return fileName; 

function doFileExport(formobj, filename, content) { 
<SPAN style="WHITE-SPACE: pre"> </SPAN>formobj.html("<input id='filename' name='filename' type='text' style='display: none'><input id='content' name='content' type='text' style='display: none'>"); 
    $("#filename").val(filename); 
    $("#content").val(content); 
    formobj.submit(); 
}  

接著是頁面調用的javascript:

復制代碼 代碼如下:

<form id="download_form" method="post"  target="_blank" action="downLoadTableDataAction"> 

復制代碼 代碼如下:

<div id="table_container"> 
<SPAN style="WHITE-SPACE: pre"> </SPAN><table id="keyword_detail"></table> 
<SPAN style="WHITE-SPACE: pre"> </SPAN><div id="footer"></div> 
</div> 

復制代碼 代碼如下:

//下載  
$('#download_file').click(function() { 
    getXlsFromTbl('keyword_detail', 'table_container' ,'download_form', '關鍵詞詳細數據', true) 
}); 

發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 午夜精品视频在线 | 久久国产精品91 | 亚州视频在线 | 国产一级毛片高清 | 日本特级a一片免费观看 | 精品1| 国产一级毛片高清视频完整版 | 农村少妇吞精夜夜爽视频 | av在线免费电影 | 美女黄色影院 | 欧洲黄色一级视频 | 亚洲极色| 色综合久久久久久久久久 | 一级黄色毛片a | 羞羞的视频免费观看 | 深夜影院一级毛片 | 人与xxxxhdxxxhdxx| 男女无套免费视频 | 国产精品国产成人国产三级 | 精品一区二区三区在线观看视频 | 欧美日韩中文字幕在线 | 国产精品毛片va一区二区三区 | 免费在线观看亚洲 | 黄色免费av | 一区二区久久久久草草 | 免费看一级片 | 美女黄网站免费观看 | 欧美日韩视频在线播放 | 久久网站热最新地址 | 91午夜在线观看 | 毛片三区| 国产又白又嫩又紧又爽18p | 高清国产午夜精品久久久久久 | 桥本有菜免费av一区二区三区 | 国产精品久久久久久影院8一贰佰 | 国产视频在线免费观看 | 欧美亚州| 96视频在线免费观看 | 久久亚洲线观看视频 | 国产三级在线视频观看 | 毛片免费视频观看 |