JS操作Excel

以你之姓@ 2022-07-14 12:17 143阅读 0赞

InitExcel:

/*初始化一个Excel对象*/
    function InitExcel() {
        try {
            var app = new ActiveXObject("Excel.Application");
        } catch (ex) {
            alert("Excel对象无法创建，请开启浏览器的ActiveX控键限制，并安装Excel2003！");
        }
        var xlWork = app.Workbooks.Add();
        var xlSheet = xlWork.Worksheets(1);
    }

OpenExcel:

/*打开一个Excel模版*/
    function OpenExcel(FileName) {
        try {
            if (FileName != "") {
                var app = new ActiveXObject("Excel.Application");  
                app.Visible = true;	//excel表是否可见
                app.WorkBooks.Open(FileName);	
                var xlWork = app.ActiveWorkBook;
                var xlSheet = xlWork.Worksheets;
                xlSheet = xlWork.Worksheets(1);
            } else {
                alert("Excel文件路径错误");
            }
        } catch (ex) {
            alert("Excel对象无法创建，请开启浏览器的ActiveX控键限制，并安装Excel！");
        }  
    }

SaveAsExcel:

/\*保存一个Excel模板\*/

/*设置页面边距,_Orientation：1表示纵向，2表示横向*/ 
    function SetPage(Orientation) {  
        with (xlSheet.PageSetup) {
            Orientation = _Orientation; // 横向    
            LeftMargin = app.InchesToPoints(0.748031496062992);
            RightMargin = app.InchesToPoints(0.748031496062992);
            TopMargin = app.InchesToPoints(0.984251968503937);
            BottomMargin = app.InchesToPoints(0.984251968503937);
            HeaderMargin = app.InchesToPoints(0.511811023622047);
            FooterMargin = app.InchesToPoints(0.511811023622047);
        }  
    }

ClearExcel  :

/**清空Excel对象  */
            function ClearExcel() {
                try {
                    app = null;
                    xlWork = null; 
                    xlSheet = null;
                } catch (ex) {
                    throw ex; 
                }
            }

/** 关闭Excel对象  */
            function QuitExcel() {
                try {
                    xlWork.Close(savechanges = false);
                    app.Quit();
                    app = null;
                    xlWork = null;
                    xlSheet = null;
                } catch (ex) {
                    alert("发生错误，Excel无法退出");
                } 
            }

/**打印预览Excel对象  */
    function PrintPreviewExcel() {
        try {
            xlSheet.PrintPreview();
        } catch (ex) {
            alert("发生错误，Excel无法打印预览");
        }
    }

/* 打印Excel对象  */
    function PrintOutExcel() {
        try {
            xlSheet.PrintOut();
        } catch (ex) {
            alert("打印机未安装或发生错误，无法打印文档");
        }  
    }