Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the server beyond simple SELECT/INSERT/UPDATE/DELETE operations with Microsoft Excel.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Microsoft Excel, along with an indication of whether the procedure succeeded or failed.
CData MCP Server for Microsoft Excel Stored Procedures
| Name | Description |
| CreateSchema | Generates a schema file that defines the structure of data within an Excel resource, including table layouts, column types, and metadata. This is typically used to initialize or validate workbook content against a defined schema. |
| CreateWorksheet | Creates a new worksheet within a specified Excel workbook. If the target workbook does not already exist, this procedure will create the workbook first and then add the new worksheet. |
| DeleteFile | Delete a file from a local or cloud storage. |
| DownloadFile | Download a file. |
| FreezePanes | Locks specific rows and/or columns in an Excel worksheet so they remain visible while a user scrolls through the rest of the data. This feature enhances readability and is used for header rows or important reference columns in large datasets. |
| GetOAuthAccessToken | Fetches the OAuth Access Token, which is used to authenticate and authorize API calls made to Excel. |
| GetOAuthAuthorizationURL | Retrieves the OAuth Authorization URL, allowing the client to direct the user's browser to the authorization server and initiate the OAuth process. |
| RefreshOAuthAccessToken | Refreshes an expired OAuth Access Token to maintain continuous authenticated access to Excel resources without requiring reauthorization from the user. |
| UploadFile | Upload file to destination. |