This documentation is for WSO2 Data Services Server 3.0.1. View documentation for the latest release.

Skip to end of metadata
Go to start of metadata

One of the most often used spreadsheet format is Microsoft Excel. An Excel sheet can be used as a data source in creating data services in the WSO2 Data Services Server.

The sample data service ExcelSampleService should be deployed using the instructions in Deploying Data Services section.

Running the Sample

The sample service can be run using the TryIt tool, which is bundled with the WSO2 Data Services Server, or a code-generated java client sample as discussed in the Data Services Clients section.

File and Service Description

The Excel file (CARBON_HOME/samples/resources/Products.xls) uses the same structure and data used in the CSV Sample which contains automobile information.

The Excel sample data service contains two operations:

  • getProducts - Lists all the products that are manufactured in the company. Each result record will contain "ID" and "Name" fields.
  • getProductClassifications - Lists all the products along with the classifications, which contain two result records named "Name" and "classification".

Sample Run

Sample run of the service using the TryIt tool is shown below.

  • No labels