玩转SharePoint 2007(四十八):实现Excel Service(3)——调用Excel

    1 using System;

    2 using System.Data;

    3 using System.Configuration;

    4 using System.Collections;

    5 using System.Web;

    6 using System.Web.Security;

    7 using System.Web.UI;

    8 using System.Web.UI.WebControls;

    9 using System.Web.UI.WebControls.WebParts;

   10 using System.Web.UI.HtmlControls;

   11 

   12 using System.Net;

   13 

   14 using Eallies.ExcelServices.Demo.WebService;

   15 

   16 namespace Eallies.ExcelServices.Demo

   17 {

   18     public partial class _Default : System.Web.UI.Page

   19     {

   20         protected void Page_Load(object sender, EventArgs e)

   21         {

   22 

   23         }

   24 

   25         protected void btnCalculate_Click(object sender, EventArgs e)

   26         {

   27             string strWorkbookPath = @"http://denny:9001/sites/Wodeweb/Docs/ExcelServices/工资计算.xlsx";

   28             string strSheetName = "Sheet1";

   29             string strCultureName = "zh-cn";

   30             Status[] status = default(Status[]);

   31 

   32             ExcelService es = new ExcelService();

   33             es.Credentials = CredentialCache.DefaultCredentials;

   34 

   35             string strSessionId = es.OpenWorkbook(strWorkbookPath, strCultureName, strCultureName, out status);

   36 

   37             es.SetCellA1(strSessionId, strSheetName, "C2", this.txtC2.Text);

   38             es.SetCellA1(strSessionId, strSheetName, "C3", this.txtC3.Text);

   39             es.SetCellA1(strSessionId, strSheetName, "C4", this.txtC4.Text);

   40 

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

   42 

   43             if (string.IsNullOrEmpty(strResult) == false)

   44             {

   45                 this.lblC6.Text = strResult;

   46             }

   47         }

   48     }

   49 }