NTKO OFFICE文档控件JavaScript编程指南

参考资料:NTKO开发帮助

 

控件对象

 

  1. <object id="TANGER_OCX" classid="-----------------------------------" codebase="../../FileUpLoad/ntko/OfficeControl.cab#version=4,0,3,2" style="width:100%;height:auto !important;height:700px;min-height:700px">  
  2. <param name="Titlebar" value="false"/>  
  3. <param name="Menubar" value="true"/>  
  4. <param name="Toolbars" value="true"/>  
  5. <param name="Statusbar" value="false"/>  
  6. <param name="BorderStyle" value="0"/>  
  7. <param name="FileNew" value="false"/>  
  8. <param name="FileOpen" value="false"/>  
  9. <param name="FileClose" value="false"/>  
  10. <param name="FileSave" value="false"/>  
  11. <param name="FileSaveAs" value="false"/>  
  12. <param name="FilePrint" value="true"/>  
  13. <param name="FilePrintPreview" value="true"/>  
  14. <param name="FilePageSetup" value="false"/>  
  15. <param name="FileProperties" value="false"/>  
  16. <param name="DisplayRulers" value="false"/>  
  17. <param name="MakerCaption" value="------------------"/>  
  18. <param name="MakerKey" value="--------------------------------"/>  
  19. <param name="ProductCaption" value="------------------"/>  
  20. <param name="ProductKey" value="-----------------------------"/>  
  21. <span style="color:red">不能安装控件,请在检查浏览器的安全设置。</span>  
  22. </object>  
<object id="TANGER_OCX" classid="-----------------------------------" codebase="../../FileUpLoad/ntko/OfficeControl.cab#version=4,0,3,2" style="width:100%;height:auto !important;height:700px;min-height:700px">
<param name="Titlebar" value="false"/>
<param name="Menubar" value="true"/>
<param name="Toolbars" value="true"/>
<param name="Statusbar" value="false"/>
<param name="BorderStyle" value="0"/>
<param name="FileNew" value="false"/>
<param name="FileOpen" value="false"/>
<param name="FileClose" value="false"/>
<param name="FileSave" value="false"/>
<param name="FileSaveAs" value="false"/>
<param name="FilePrint" value="true"/>
<param name="FilePrintPreview" value="true"/>
<param name="FilePageSetup" value="false"/>
<param name="FileProperties" value="false"/>
<param name="DisplayRulers" value="false"/>
<param name="MakerCaption" value="------------------"/>
<param name="MakerKey" value="--------------------------------"/>
<param name="ProductCaption" value="------------------"/>
<param name="ProductKey" value="-----------------------------"/>
<span style="color:red">不能安装控件,请在检查浏览器的安全设置。</span>
</object>

 

editfile.aspx.cs

 

[csharp] view plain copy print ?
  1. public string SaveFile()  
  2.    {  
  3.        try  
  4.        {  
  5.            string uploadpath = Server.MapPath(@"~/FileUpLoad/");  
  6.            if (!System.IO.Directory.Exists(uploadpath))  
  7.            {  
  8.                System.IO.Directory.CreateDirectory(uploadpath);  
  9.            }  
  10.            System.Web.HttpFileCollection filesupload = Request.Files;  
  11.            System.Web.HttpPostedFile file;  
  12.            string key = filesupload.GetKey(0).ToLower();  
  13.            int i = 0;  
  14.            while (i <= filesupload.Count && "editfile" != key)  
  15.            {  
  16.                i++;  
  17.                key = filesupload.GetKey(i).ToString();  
  18.            }  
  19.            if ("editfile" == key)  
  20.            {  
  21.                file = filesupload[i];  
  22.                string filename = file.FileName;  
  23.                string[] filenames = filename.Split(new char[] { '\\' });  
  24.                filename = filenames[filenames.Length - 1];  
  25.                file.SaveAs(uploadpath + "\\" + filename+".doc");  
  26.                return "操作成功!";  
  27.            }  
  28.            else  
  29.            {  
  30.                return "尚未找到操作的文件!";  
  31.            }  
  32.        }  
  33.        catch (Exception ex)  
  34.        {  
  35.            return ex.Message.ToString();  
  36.        }  
  37.    }  

JS

 

[javascript] view plain copy print ?
  1. function SaveFile(){//保存  
  2.        var TANGER_OCX_OBJ = document.getElementById("TANGER_OCX");  
  3.        if (TANGER_OCX_OBJ === null || TANGER_OCX_OBJ === "undefined") { return false; }  
  4.        var fileName = document.getElementById("fileName").value;  
  5.        try {  
  6.            var message = TANGER_OCX_OBJ.SaveToURL("editfile.aspx?op=SaveFile","editfile","",fileName,"form1");  
  7.         }  
  8.         catch (err) {  
  9.            alert("err:" + err.number + ":" + err.description);  
  10.         } finally { }  
  11.     }  
  12.        function OpenFile(url) {//打开url为打开文档的相对路径  
  13.            var TANGER_OCX_OBJ = document.getElementById("TANGER_OCX");  
  14.            if (TANGER_OCX_OBJ === null || TANGER_OCX_OBJ === "undefined") {return false; }  
  15.            var useUTF8 = (document.charset == "utf-8");  
  16.            TANGER_OCX_OBJ.IsUseUTF8Data = useUTF8;  
  17.            try {  
  18.                TANGER_OCX_OBJ.BeginOpenFromURL(url, truefalse);  
  19.            }  
  20.            catch (err) {  
  21.                alert("错误:" + err.number + ":" + err.description);  
  22.            }  
  23.            finally {}  
  24.        }  
  25.        function PrintPreview() {//打印预览  
  26.            var TANGER_OCX_OBJ = document.getElementById("TANGER_OCX");  
  27.            TANGER_OCX_OBJ.PrintPreview();  
  28.        }  
  29.        function Print(isBackground) {//打印  
  30.            var TANGER_OCX_OBJ = document.getElementById("TANGER_OCX");  
  31.            var oldOption; try {  
  32.                var objOptions = TANGER_OCX_OBJ.ActiveDocument.Application.Options;  
  33.                oldOption = objOptions.PrintBackground; objOptions.PrintBackground = isBackground;  
  34.            } catch (err) { };  
  35.            TANGER_OCX_OBJ.printout(true); try {  
  36.                var objOptions = TANGER_OCX_OBJ.ActiveDocument.Application.Options;  
  37.                objOptions.PrintBackground = oldOption;  
  38.            } catch (err) { };  
  39.        }  
  40.        function GetRangeValue(TANGER_OCX_OBJ,RangeName) {//获得名称或索引的值(Excel)  
  41.            var str = "";  
  42.            var strTemp = "";  
  43.            try {  
  44.            var app=TANGER_OCX_OBJ.ActiveDocument.Application;  
  45.                var names = app.ActiveWorkbook.Names;//名称集合  
  46.                var nameCount = names.Count;  
  47.                var isExist = false;  
  48.                for (var count = 1; count <= nameCount; count++) {  
  49.                    if (names(count).Name === RangeName)//判断名称集合中是否存在  
  50.                    {isExist = true; }  
  51.                }  
  52.                if (!isExist) return false;//不存在,不能选择该范围及返回  
  53.                var range = app.Goto(RangeName);  
  54.                var app = TANGER_OCX_OBJ.ActiveDocument.Application;  
  55.                var rowCount = app.Selection.Rows.Count;  
  56.                var columnCount = app.Selection.Columns.Count;  
  57.                for (var i = 1; i <= rowCount; i++) {  
  58.                    for (var j = 1; j <= columnCount; j++) {  
  59.                        strTemp = app.Selection.Cells(i, j).FormulaR1C1;  
  60.                        if (strTemp != "") {  
  61.                            str = str + strTemp + "|";  
  62.                        }  
  63.                    }  
  64.                }  
  65.                str = str.substr(0, str.length - 1);  
  66.            } catch (err) {  
  67.                alert("错误:" + err.number + ":" + err.description);  
  68.                TANGER_OCX_OBJ.ActiveDocument.Application.Quit();  
  69.            }  
  70.            finally { }  
  71.            return str;  
  72.        }  
  73.  //当文档加载成功后初始化文档(Excel)  
  74. lt;script  language="JScript" for="TANGER_OCX" event="AfterOpenFromURL()">  
  75.     var TANGER_OCX_OBJ = document.getElementById("TANGER_OCX");  
  76.     var ad = TANGER_OCX_OBJ.ActiveDocument.Application.ActiveSheet;  
  77.    //初始化  
  78.    SetRangeValue(TANGER_OCX_OBJ, "定义的名称或索引","值");  
  79.       function SetRangeValue(TANGER_OCX_OBJ, RangeName,value) {  
  80.         try{  
  81.         var app=TANGER_OCX_OBJ.ActiveDocument.Application;  
  82.                var names = app.ActiveWorkbook.Names;  
  83.                var nameCount = names.Count;  
  84.                var isExist = false;  
  85.                for (var count = 1; count <= nameCount; count++) {  
  86.                    if (names(count).Name === RangeName)  
  87.                    {isExist = true; }  
  88.                }  
  89.                if (!isExist) return false;  
  90.            var range =app.Goto(RangeName);  
  91.            var app = TANGER_OCX_OBJ.ActiveDocument.Application;  
  92.            var rowCount = app.Selection.Rows.Count;  
  93.            var columnCount = app.Selection.Columns.Count;  
  94.            for (var i = 1; i <= rowCount; i++) {  
  95.                for (var j = 1; j <= columnCount; j++) {  
  96.                    app.Selection.Cells(i, j).FormulaR1C1 = value;  
  97.                }  
  98.            }  
  99.         }catch (err) {  
  100.                alert("错误:" + err.number + ":" + err.description);  
  101.            }  
  102.            finally {  
  103.             TANGER_OCX_OBJ.ActiveDocument.Application.Quit();  
  104.            }  
  105.        }  
  106.    </script>  
[javascript] view plain copy print ?
  1. <pre class="javascript" style="background-color: rgb(255, 255, 255);" name="code"><pre></pre>  
  2. <pre></pre>  
  3. <pre></pre>  
  4. <pre></pre>  
  5. <pre></pre>  
  6. <pre></pre>  
  7. <pre></pre>  
  8. <pre></pre>  
  9. <pre></pre>  
  10. <pre></pre>  
  11. </pre>  

http://wenku.baidu.com/view/654b2f214b35eefdc8d3339b.html

http://wenku.baidu.com/view/43911836a32d7375a41780b4.html

 

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值