javascript导出EXCEL的两种方法
代码
//方法1:
function exportExcel() {
//var ActiveSheet = new ActiveXObject("OWC.Spreadsheet");
var atblData = document.getElementById("tblist");
return;
if (typeof (EXPORT_OBJECT) != "object") {
document.body.insertAdjacentHTML("afterBegin", "<OBJECT style='display:none' classid=clsid:0002E510-0000-0000-C000-000000000046 id=EXPORT_OBJECT></Object>");
}
with (EXPORT_OBJECT) {
DataType = "HTMLData";
HTMLData = atblData.outerHTML;
try {
ActiveSheet.Export("C:\\Documents and Settings\\Administrator\\桌面\\月度预算表.xls", 0);
alert('已经导出到你的桌面');
}
catch (e) {
alert(e.message);
alert('汇出Excel表失败,请确定已安装Excel2000(或更高版本),并且没打开同名xls文件');
}
}
}
function exportExcel() {
//var ActiveSheet = new ActiveXObject("OWC.Spreadsheet");
var atblData = document.getElementById("tblist");
return;
if (typeof (EXPORT_OBJECT) != "object") {
document.body.insertAdjacentHTML("afterBegin", "<OBJECT style='display:none' classid=clsid:0002E510-0000-0000-C000-000000000046 id=EXPORT_OBJECT></Object>");
}
with (EXPORT_OBJECT) {
DataType = "HTMLData";
HTMLData = atblData.outerHTML;
try {
ActiveSheet.Export("C:\\Documents and Settings\\Administrator\\桌面\\月度预算表.xls", 0);
alert('已经导出到你的桌面');
}
catch (e) {
alert(e.message);
alert('汇出Excel表失败,请确定已安装Excel2000(或更高版本),并且没打开同名xls文件');
}
}
}
代码
//方法2:
function exportExcel() {
var XL = new ActiveXObject("Excel.Application");
var WB = XL.Workbooks.Add();
var Sheet = WB.ActiveSheet;
var sel = document.body.createTextRange();
sel.moveToElementText(document.getElementById("tblist"));
sel.select();
sel.execCommand("Copy");
Sheet.Paste();
XL.Visible = true;
}
function exportExcel() {
var XL = new ActiveXObject("Excel.Application");
var WB = XL.Workbooks.Add();
var Sheet = WB.ActiveSheet;
var sel = document.body.createTextRange();
sel.moveToElementText(document.getElementById("tblist"));
sel.select();
sel.execCommand("Copy");
Sheet.Paste();
XL.Visible = true;
}
浙公网安备 33010602011771号