首先,是一段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)
});