MSDN Documentation correction – Direct linking the Excel Web Services assembly does not work in SharePoint workflow

Direct Linking allows developers to get better performance and compatibility when interfacing with Excel Services via the Excel Web Services interface.

The MSDN Article that discusses it contains an error. It says that:

If you are writing code within Microsoft Windows SharePoint Services 3.0, for example, a custom Web Part, custom workflow, custom aspx page, and so on, you should make direct calls to Microsoft.Office.Excel.Server.WebServices.dll.

This comment is not accurate. Custom Workflow does not support Direct Linking. If you try to do it, you will get the following exception:

Microsoft.Office.Excel.Server.WebServices.ExcelServerApiException: Excel Web Services could not determine the Windows SharePoint Services site context of the calling process.

Comments (2)

  1. AndersR says:

    I get the same error you specify if i try doung a loop-back call in a console application.

    Are console apps not supported either, or is there a way to establish context of the ExcelService class?


  2. Shahar Prish says:

    DirectLinking ONLY works inside a Sharepoint context. No other way is supported with Direct Linking. So console MUST use the Web-Service route.