您好,欢迎访问一九零五行业门户网

jqgrid 表格数据导出实例_javascript技巧

首先,是一段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) { 
        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             //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             var row = eval(rowdata[i]); 
            for (each in row) { 
               var temp = $(row[each]).text(); 
               if($(row[each]).text() == null || $(row[each]).text() == ){ 
                   if(row[each].charat(0) != '                       outstr += row[each] + ,;

               else 
                   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) { 
formobj.html(); 
    $(#filename).val(filename); 
    $(#content).val(content); 
    formobj.submit(); 
}
接着是页面调用的javascript:
复制代码 代码如下:
复制代码 代码如下:
复制代码 代码如下:
//下载  
$('#download_file').click(function() { 
    getxlsfromtbl('keyword_detail', 'table_container' ,'download_form', '关键词详细数据', true) 
});
其它类似信息

推荐信息