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文件');
                }
            }
        }

 

代码
        //方法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;

        }

 

 

posted @ 2010-01-06 15:56  瞭望者  阅读(1958)  评论(0)    收藏  举报