The images in our Excel export post show a user interface that looks like Excel. They were built using two controls:
But those are just examples. You have complete flexibility to combine the controls in the Wijmo Olap module to build interfaces that meet your application’s requirements.
Full Wijmo OLAP series:
This simple UI shows a list of pre-defined views on the left and a PivotGrid on the right. It is easy to use on desktop or mobile devices:
The PivotGrid control extends the FlexGrid, so you can customize the display of the grid cells using the formatItem event and modifying the content of each cell with complete flexibility. For example, the PivotGrid below uses colors and icons similar to the ones in Excel's icon sets to show how sales changed from quarter to quarter:
The Wijmo Olap controls can be combined with any other HTML elements or controls on the page, providing complete flexibility when building user interfaces that are tailored for specific purposes. The example below uses Google’s Material Design Lite for the page layout and tabs. A column on the left of the page contains the PivotPanel used to customize the pivot view. A column on the right contains tabs that allow users to select between a PivotGrid, PivotChart, or the raw data: