Data You can create data sources to expose data in Microsoft Excel 97-2007 can be exposed as services using the WSO2 Data Services Server.
For demonstration, we use an excel sheet containing three columns, namely, ID, Model and Classification. The sheet is then filled with mock data. Note that the column names should appear in separate cells. For example,
...
- Excel Data Sources in Non-Query Mode : The ' Non-Query ' mode allows to simply directly expose the content of an Excel sheet as a service.
- Excel Data Sources in Query Mode : The ' Query Mode ' allows users to query an Excel sheet in a familiar, SQL-like manner, and expose it the results set as a service.
Excel Data Sources in Non-Query Mode
Anchor | ||||
---|---|---|---|---|
|
Follow the instructions below to create a data service using this excel sheet in non-query mode.
1. Log on to the product's management console and select "Data Service -> Create" under the "Main" menu.
2. The "Create Data Service" page appears. Fill in the fields and click "Next." The Data Service name is mandatory.
Info |
---|
For more information on advanced configurations, refer to Advanced Data Service Configurations. |
3. The "Data Sources" page appears. Click on the " Add New Data Source" link and add your Data Source details.
Select the data source type as EXCEL. For example,steps in Creating Data Sources. When you select Excel as the data source type at the time a data source is created, the Excel-specific options appear. For example:
4. After saving, the added data source page appears. You can edit or delete the Data Source. To proceed click "Next."
...