Share via

2.5.2.1.3 Interact with a Workbook by Using an Application

This use case describes how an application uses Excel Services to interact with a workbook that has been published to SharePoint Products and Technologies.

The following diagram illustrates this process.

Process for interacting with a workbook by using an application

Figure 12: Process for interacting with a workbook by using an application

Preconditions

  • Excel Services is enabled on a farm running SharePoint Products and Technologies.

  • The user who is running the application has permissions for the requested workbook.

Steps

  1. The application requests the workbook by using the URL of the file.

  2. The application can get a range of data from the workbook.

  3. The application can set a range of data in the workbook.

  4. The application can refresh external data in the workbook.

  5. The application can recalculate the workbook.

  6. The application can save changes made to the workbook back to the file that is stored in SharePoint Products and Technologies.

  7. The application can close the workbook.

Errors

  • If the user who is running the application does not have permissions for the workbook, an error will be returned.

  • If the workbook contains unsupported features that prevent it from opening, an error will be returned.

  • If the workbook is connected to external data for which the current user does not have permissions, an error will be returned.

Post-conditions

  • The application has retrieved any necessary data from the workbook.

  • The workbook has been updated as requested by the application.

  • The workbook has not been updated, because an error occurred.