Exontrol's eXPivot component offers powerful data summarization through an intuitive pivot table interface. It enables automatic sorting, counting, totaling, and averaging of data stored within tables or spreadsheets. Users can effortlessly configure and modify the summary structure via drag-and-drop of fields, making data analysis simple and dynamic. Additionally, eXPivot supports customizable skins, allowing users to change the component's visual style easily, enhancing the user experience with visually appealing themes that can be applied to any part of the control.

Features include:

1. Visual & Interface

• Skinnable Interface support (ability to apply a skin to any background part)
• Easy visual appearance definition in design mode using XP-Theme elements or EBN objects
• Interactive context menu for formatting (colors, fonts, etc.)
• Built-in HTML, Decorative Text, Tooltip, Mouse Wheel, Icons, Pictures support

2. Data Management & Operations

• Summarizes data by Drag & Drop or by code
• Undo / Redo support
• Import data from ADO/DAO data sources, TXT, XML, or by drag & drop
• Export data as TXT, CSV, XML, EMF, or by drag & drop

3. Pivot & Aggregation Features

• Drag/filter column values to the pivot bar to display associated functions
• SUM, AVG, COUNT, MIN, MAX for numbers, strings, or dates
• Ability to add new aggregate functions using predefined operators
• Total / Subtotal rows support
• Computed fields support
• Conditional formatting support

4. Layout & Customization

• Easy saving/restoring of control’s layout (column positions, size, sorting, filtering, scrolling)
• Ability to define content of column/row context menus
• Compact or Expanded mode support
• FilterBar / FilterPrompt support
• Automatically updates Total/Subtotal rows when filters are applied

5. Printing & Export

• Print and Print Preview support, including Fit-To-Page
• Export/save control content to PDF, BMP, JPG, GIF, PNG, TIFF, EMF formats

 

 

® ExPivot is a trademark of Exontrol. All Rights Reserved.