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.
