silverlight 客户端Excel操作

来源：互联网发布：淘宝网店申请注册编辑：程序博客网时间：2024/06/08 04:59

//动态生成JavaScript Excel操作代码

private void createJavaScript()
        {
            HtmlElement heScript = HtmlPage.Document.CreateElement("script");
            heScript.SetAttribute("type", "text/javascript");
            string scriptStr = "function exportExcel(reslutList){ "+
           " var oXL = new ActiveXObject('Excel.Application');var oWB = oXL.Workbooks.Add(); var oSheet = oWB.ActiveSheet; " +
                " var lineArr=reslutList.split(';'); "+
            "var cellvalue; " +
            "for(k=1;k<13;k++){oSheet.Cells(1, k+1).value=k;} oSheet.Cells(1,1).value='名称';oSheet.Cells(1,14).value='总计';" +
              " for(i=0; i<lineArr.length; i++) {" +

                "cellvalue=lineArr[i].split(','); for(j=0;j<cellvalue.length;j++) { "+
           " oSheet.Cells(i + 2, j + 1).value=cellvalue[j];}" +

           "}" +
        "oXL.Visible = true;"+
           "}";
            heScript.SetProperty("text",scriptStr );
            HtmlPage.Document.Body.AppendChild(heScript);

        }

//调用JavaScript Excel操作

private void ExportExcel(string sourceStr)

{

try
{
ScriptObject excelSO = HtmlPage.Window.GetProperty("exportExcel") as ScriptObject;

                                excelSO.InvokeSelf(sourceStr);
            }
            catch
            {
                ScriptObject alertSO = HtmlPage.Window.GetProperty("alert") as ScriptObject;

alertSO.InvokeSelf("请将IE的安全设置“不允许运行未标记为安全的activeX控件”设为启用");
}

}