Skip to Main Content

Enhanced Grid Pro

An Excel spreadsheet user experience for APEX.

If you've ever wanted an Excel-like user experience in an Interactive Grid, this plug-in is for you.

Enhanced Grid Pro is built on the Handsontable library - a JavaScript data grid that looks and feels like a spreadsheet.

Excel-like Editing

Edit data as if you were in Excel.
Easier and quicker than with the native APEX Interactive Grid.
Multi-line Copy & Paste

Use Ctrl+C to copy values. Use Ctrl+V to paste them.
It works with Lists of Values too.
Undo & Redo

Use Ctrl+Z to Undo actions.
Use Ctrl+Y to Redo them.
API Included
With the included API, you can:

get/set values

reload/save data

make rows/columns/cells readonly

...
Events
Enhanced Grid Pro triggers multiple events, enabling you to customize and interact with your data/grid. Events supported:

Before/after refresh

Change

After Save

...
Column Types
Multiple column types supported:

Plain Text

Number

Date

Checkbox

Select List (LOV)

HTML
Validate Data

You can use a procedure to validate your data.
A simple API to define validation errors is included.
Save Data
Saving data is possible in two ways:

Automatic row processing

Using a procedure
Copy from Excel

Copy data from Excel directly to Grid.
If there are not enough rows in Grid, additional rows are added automatically.
Translatable

You can define your own translations for each component/message in Enhanced Grid Pro.