Microsoft Office Tutorials and References
In Depth Information
Web Service API Methods
FullWorkbook — Maps to the entire workbook that was published to the server,
taking into account the caller’s permissions. This does not return the private state
view of the workbook.
PublishedItemsSnapshot — Maps to the items that were marked as viewable
when the workbook was published, and returns those items in their current state,
including the private state view if one exists.
Status (out) — See the “Status Class” section, earlier in this chapter, for an explanation of
this ( out ) parameter.
A byte array is returned that represents the workbook content based on the specified WorkbookType .
The file format loaded into the session is used.
The following example makes a GetWorkbook call using the PublishedItemsSnapshot enumerator:
xlSessionId = xlEcsApi.OpenWorkbook(
bits = xlEcsApi.GetWorkbook(
Chapter 13 described how you can leverage Excel Services to offload calculations from the client. This
method is used primarily for workbooks that take a significant amount of time to calculate. Because
there is no Excel Services out-of-the-box functionality for offloading such workbooks to the server, a
custom solution is needed.
This section provides a sample application that enables the scenario described at the end of Chapter 13.
It makes use of the Excel Services web service presented in this chapter.
The sample illustrates how you can use Excel Services to offload calculations from the client to the server.
With this program, users of calculation-intensive workbooks can save those workbooks to the target
folder, the workbooks are calculated on the server, and the updated workbooks are made available to the
users in an output folder.