Share via

1.3 Overview

This protocol is a Web service based protocol that is used to access workbooks controlled by a protocol server. The protocol specified in this document is stateful and relies on sessions (2) to maintain state. Workbooks hosted on a protocol server are used to present, store, manipulate, and calculate tabular data. For an overview of the specific implementation of a workbook server system that uses this protocol, see [MSDN-ESO].

The protocol provides the following sets of functionality that can be performed on workbooks:

  • Open existing workbooks for viewing and editing and close open workbooks.

  • Create new workbooks.

  • Save workbooks.

  • Retrieve the full contents of the current open copy.

  • Recalculation.

  • Refresh connected data.

  • Set specific values into a worksheet cell or range.

  • Get specific values from a worksheet cell or range.

  • Cancel a request.

  • Get the names of all the published items in a workbook.

  • Get a URL to an image of a chart in a workbook.

  • Get information about a session.

  • Get the version of the protocol server.