Using the Connector (Mule 3.8+)
The CData MuleSoft Connector for Excel Services is a native, operation-based connector that exposes SQL-based operations as well as interfaces for schema discovery.
Invoking Data Manipulation Operations
Querying Data show how to execute SQL to Excel Services tables.
Executing Parameterized and Dynamic Queries
You can use MEL (MuleSoft expression language) to create both parameterized queries and dynamic queries. The connector executes parameterized queries by default. See Parameterized Queries for configuration and usage of the different query types.
Defining Custom Views
The connector allows you to define virtual tables whose contents are decided by a pre-configured query. See Defining Custom Views for an overview of creating and configuring custom views.
Calling Stored Procedures
Stored Procedures operations enable you to access additional functionality in the Excel Services APIs.
The connector's List operations provide access to table and column information. See Schema Discovery for more information.
You can also use query the System Tables to retrieve any of the connector metadata, which includes data source information and query statistics in addition to schema information.