Microsoft Excel is one of the most popular spreadsheet formats. An Excel sheet can be used as a data source for creating data services in WSO2 Data Services ServerEnterprise Integrator (WSO2 EI).
| Table of Contents | ||||
|---|---|---|---|---|
|
...
The Products.xls file, stored in the <DSS<EI_HOME>/samples/data-services/resources/ folder is used as the datasource to demonstrate this sample data service. This datasource contains details of the products manufactured in an automobile company. Products refer to cars/motorocyles. The data table has the following columns: "ID", "Name", "Classification" and "Price" (same as in the CSV Sample). This sample data service contains two operations:
...
The sample data service named ExcelSampleService should be deployed using the instructions in Samples Setup.
Running the sample
The sample service can be run using the TryIt tool, which is bundled with the WSO2 Data Services ServerEI, or a code-generated java client sample as discussed in the Data Services Clients section.
Follow the steps below to demonstrate this functionality using the TryIt tool:
...