[Download] | [Documentation Home] | [Release Note]
One of the most often used spreadsheet format is Microsoft Excel, here with WSO2 Data Services Server, an Excel file can be given as a data source in creating data services.
The sample data service "ExcelSampleService" should be deployed as per the instructions mentioned in Deploying Samples section.
The sample service can be run using the "tryit" tool, which is bundled with WSO2 Data Services Server, or a code-generated java client sample using this service is demonstrated in the Data Services Clients Sample section.
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" to list all the products that are manufactured in the company, each result record will contain "ID" and "Name" fields. And "getProductClassifications" where to list all the products along with the classifications, which contains two result records which are "Name" and "classification".