Microsoft Office Tutorials and References
In Depth Information
{
string session = es.OpenWorkbook(excelFilePath, "en-US", "en-US", out status);
for (int i = 3; i <= 13; i++)
{
Console.WriteLine("Remaining hours for the task " +
es.GetCell(session, sheet, i, 5, false, out status) +
" is: " + es.GetCell(session, sheet, i, 12, false, out status));
}
Console.Read();
}
catch (SoapException soapException)
{
Console.WriteLine(soapException.Message);
}
13.
Call the GetData method from the Main method:
static void Main(string[] args)
{
GetData();
}
14.
Open the app.config file, and modify the security section under basicHttpBinding,
as shown here:
<security mode="TransportCredentialOnly">
<transport clientCredentialType="Ntlm" proxyCredentialType="Ntlm"
realm="" />
<message clientCredentialType="UserName" algorithmSuite="Default" />
</security>
15.
press F5 to view the output of the application as shown in Figure 5-24 .
Figure 5-24. Displaying Excel workbook output using SOAP and Excel Services
 
Search JabSto ::




Custom Search