[办公软件] 一步一步SharePoint 2007之四十八：实现Excel Service(3)——调用E...

using System;
 using System.Data;
 using System.Configuration;
 using System.Collections;
 using System.Web;
 using System.Web.Security;
 using System.Web.UI;
 using System.Web.UI.WebControls;
 using System.Web.UI.WebControls.WebParts;
 using System.Web.UI.HtmlControls;
 
 using System.Net;
 
 using Eallies.ExcelServices.Demo.WebService;
 
 namespace Eallies.ExcelServices.Demo
 {
   public partial class _Default : System.Web.UI.Page
   {
    protected void Page_Load(object sender, EventArgs e)
     {

    }

     protected void btnCalculate_Click(object sender, EventArgs e)
     {
      string strWorkbookPath = @"http://denny:9001/sites/Wodeweb/Docs/ExcelServices/工资计算.xlsx";
      string strSheetName = "Sheet1";
      string strCultureName = "zh-cn";
      Status[] status = default(Status[]);

       ExcelService es = new ExcelService();
       es.Credentials = CredentialCache.DefaultCredentials;

      string strSessionId = es.OpenWorkbook(strWorkbookPath, strCultureName, strCultureName, out status);
 
       es.SetCellA1(strSessionId, strSheetName, "C2", this.txtC2.Text);
      es.SetCellA1(strSessionId, strSheetName, "C3", this.txtC3.Text);
      es.SetCellA1(strSessionId, strSheetName, "C4", this.txtC4.Text);

      string strResult = (string)es.GetCellA1(strSessionId, strSheetName, "C6", true, out status);

       if (string.IsNullOrEmpty(strResult) == false)
      {
         this.lblC6.Text = strResult;
      }
    }
   }
}