silverlight 客户端Excel操作

 //动态生成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控件”设为启用");
            }

}