The Excel Import builder lets you import an Excel file and use it for things like tables and charts. The builder creates a schema for the data and an operation to read the data. In the builder you can specify the range of data that you want to import.
The Excel Export builder provides support for downloading any application data as Excel data. Note that the data for downloading can come from any data source or service, and does not have to come from Excel initially.
Note that the WebSphere® Dashboard Framework includes enhanced support for Excel import, using the "Excel Import - Enhanced" builder. That builder includes support for categorization, and for retrieving detail information based on row index or column value.
This sample demonstrates the following techniques:
- Using the Excel Import builder to import an Excel spreadsheet, and creating a service provider model that exposes the data as a service. Note that in this example, the data is retrieved without preserving cell formatting, so that the data can be easily graphed with the Web Charts builder. This service provider model is samples/excel_service/ExcelRevenueService.
- Displaying the Excel service data as a simple chart and table. This is the samples/excel_service/RevenueSummary model.
- Using the Page Tabs builder to provide tab navigation between two pages.
- Specifying chart labels in a resource bundle. The resource bundle is made available with the Localized Resource builder, and the Web Charts builder references the LocaleData variable created by Localized Resource builder.
- Using the Excel Export builder to support downloading data to Excel. Note that this functionality can work with data from any data source.
This shows a page displaying the Excel service results as a table, with a link for downloading to Excel.
This shows a chart created with the Web Charts builder.
Notes on running the sample and prerequisites
This sample requires the Excel Extension feature set and the Charting feature set.
Import the attached zip file into your project using the Import WebSphere Portlet Factory Archive command.