Recently I had to integrate an application with a javascript (client-side) excel-like grid. After some research I found out that ag-grid is (at least for me) the best javascript grid library. It has an open source version with a MIT license so it can safely be used by all your projects and a commercial, enteprise version that includes a bunch of extra features. The open source version should be sufficient for most projects however I really recommend buying the commercial version to support this very useful library.
The greatest characteristic of ag-grid in my opinion is its openess and API that enables you to extend it to support all your needs! An example of this API will be presented in this article where I will implement two components that can be included in your grid:
- An array editor through which you will be able to create cells that can be used to insert a list of values. For example, if you have a grid of employees, you will be able to add a “children” cell that will contain the names of each employee’s children properly separated (one line per child)
- An object editor through which you will be able to create cells that can be used to insert flat objects. For example, for the grid of employees, you may add an “address” cell that, when edited will be expanded to seperate fields for Address, City, Zip code and Country.
A common ground
First of all, let’s create a simple example that will act as a common ground for our components:
As you can see, I have defined a bunch of columns for the grid and then create a new grid passing it the myGrid div and the gridOptions (which are kept to a minimum). Finally, there’s an event handler for button click that adds an empty row:
var columns = [
{
headerName: 'ID', field: 'id', width: 50, editable: true
}, {
headerName: 'Name', field: 'name', width: 100, editable: true
}, {
headerName: "Address", field: "address", width: 200, editable: true
}, {
headerName: "Children", field: "children", width: 200, editable: true
}
];
var gridOptions = {
columnDefs: columns,
rowData: []
};
new agGrid.Grid(document.querySelector('#myGrid'), gridOptions);
document.querySelector('#addRow').addEventListener("click", function() {
gridOptions.api.addItems([{}]);
});
You may be able to edit both the address and the children of each employee in the above example however this is not intuitive. The editors will be able to enter any kind of address they want and add the children seperated by commas, spaces, dashes or whatever they want. Of course you could add validators to enforce some formatting for these fields however I think that using custom components has a much better user experience.
Please notice that the above example along with the following components will be implemented in pure (no-framework) javascript. Integrating ag-grid with a javascript framework like angular or react in an SPA should not be difficult however I find it easier to adjust my SPA so that the grid component is seperate and does not need interoperability with other SPA components since all components like renderers and editors will be integrated to the grid!
Also, using pure javascript for your custom components makes them faster than adding another layer of indirection through react as can be seen on the on ag-grid react integration:
If you do use React, be aware that you are adding an extra layer of indirection into ag-Grid. ag-Grid’s internal framework is already highly tuned to work incredibly fast and does not require React or anything else to make it faster. If you are looking for a lightning fast grid, even if you are using React and the ag-grid-react component, consider using plain ag-Grid Components (as explained on the pages for rendering etc) inside ag-Grid instead of creating React counterparts.
Editors and renderers
A custom column in ag-grid actually has two distinctive parts: An object that is used for rendering and an object that is used for editing the cell value. You can have columns with the built in editor and a custom renderer, columns with the built in renderer and a custom editor and cells with custom editors and rendererers. I urge you to read the documentation on both renderers and editors in order to understand most of the decisions I have made for the implemented components.
A renderer can be:
- a function that receives the value of the cell and returns either an HTML string or a complete DOM object
- a class that provides methods for returning the HTML string or DOM object for the cell
The function is much easier to use however biting the bullet and providing a renderer class is better for non-trivial rendering. This is because the function will be called each time the cell needs to be refreshed (refer to the docs on what refreshing means) while, the class provides a specific refresh() method that is called instead. This way, using the class you can generate the DOM structure for the cell once, when it is first created and then when its value changes you’ll only call its refresh method to update the value. We’ll see how this works later.
An editor is a class that should provide methods for returning the DOM structure for the cell editing (for example an <input> field) and the current value of the field.
Both renderer and editor classes can be attached to columns using cellEditor and cellRenderer column properties. You also may pass per-column properties to each cell using the cellEditorParams and cellRendererParams propertie. For example, you may have a renderer for booleans that displays icons for true/false and you want to use different icons depending on the column type, or you may want to create a validation-editor that receives a function and accepts the value you enter only if the function returns true - the valid function could be different for different column types.
Creating the object cell editor
The first component we’ll present here is an object renderer/editor. This component will receiver a list of fields and will allow the user to edit them in a popup grouped together. Here’s a fiddle with the Address of each employee using the object editing component:
To integrate it with the ag-grid I’ve added an addressFields list containg the fields of the object like this:
var addressFields = [
{'name': 'address', 'label': 'Address' },
{'name': 'zip', 'label': 'ZIP' },
{'name': 'city', 'label': 'City' },
]
and then passed this as a parameter to both the renderer and editor for the address field:
{
headerName: "Address", field: "address", width: 200, editable: true,
cellRenderer: ObjectCellRenderer,
cellEditor: ObjectEditor,
cellEditorParams: {
fields: addressFields
},
cellRendererParams: {
fields: addressFields
}
}
The ObjectEditor and ObjectCellRenderer are the actual editor and renderer of the component. I will start by representing the renderer first:
function ObjectCellRenderer() {}
ObjectCellRenderer.prototype.init = function (params) {
// Create the DOM element to display
this.span = document.createElement('span');
this.span.innerHTML='';
this.refresh(params)
};
The ObjectCellRender is an javascript object to which we define an init method. This method will be called by ag-grid when the component is first created, passing it a params object with various useful params, like the user-defined parameters (from cellRendererParams) and the actual value of othe cell. We just create an empty span DOM element that will be used to display the value of the object and call refresh.
ObjectCellRenderer.prototype.refresh = function(params) {
var res = ''
if(params.value) {
// If we have a value build the representation
for(var i=0;i<params.fields.length;i++) {
res += params.fields[i].label + ': ';
res += params.value[params.fields[i].name] + ' ';
}
}
// Put representation to the DOM element
this.span.innerHTML=res;
}
ObjectCellRenderer.prototype.getGui = function () {
return this.span;
};
The refresh method generates the text value of the cell (that will be put inside the span we created in init). It first checks if the value attribute of params is defined and if yes, it appends the label of each object attribute (which we pass through cellRendererParams.fields.label) along with its value (which is retrieved from the params.value using cellRendererParams.fields.name). Notice ag-grid puts the result of the getGui method in the cell - so we just return the span we create. Also, we created the span element in init but filled it in refresh - to avoid it creating the same element lots of times (this would be more imporntant of course on more expensive operations).
Now let’s continue with ObjectEditor:
function ObjectEditor() {}
// Surpress some keypresses
var onKeyDown = function(event) {
var key = event.which || event.keyCode;
if (key == 37 || // left
key == 39 || // right
key == 9 ) { // tab
event.stopPropagation();
}
}
ObjectEditor.prototype.init = function (params) {
// Create the container DOM element
this.container = document.createElement('div');
this.container.style = "border-radius: 15px; border: 1px solid grey;background: #e6e6e6;padding: 10px; ";
this.container.onkeydown = onKeyDown
// Create the object-editing form
for(i=0;i<params.fields.length;i++) {
var field = params.fields[i];
var label = document.createElement('label');
label.innerHTML = field.label+': ';
var input = document.createElement('input');
input.name = field.name;
if (params.value) {
input.value = params.value[field.name];
}
this.container.appendChild(label);
this.container.appendChild(input);
this.container.appendChild(document.createElement('br'));
}
// Create a save button
var saveButton = document.createElement('button');
saveButton.appendChild(document.createTextNode('Ok'))
saveButton.addEventListener('click', function (event) {
params.stopEditing();
});
this.container.appendChild(saveButton);
};
The init function of ObjectEditor ise used to create a container div element that will hold the actual input elements. Then, using the fields that were passed as a parameter to the editor it creates a label, an input and a br element and inserts them one by one to the container div. The input is instantiated with the current value of each attribute while its name is taken from the name of the corresponding field (from the fields parameter). Finally, a saveButton is created that will stop the editing when clicked.
ObjectEditor.prototype.getGui = function () {
return this.container;
};
ObjectEditor.prototype.afterGuiAttached = function () {
var inputs = this.container.getElementsByTagName('input');
inputs[0].focus();
};
ObjectEditor.prototype.getValue = function () {
var res = {};
// Create the cell value (an object) from the inputs values
var inputs = this.container.getElementsByTagName('input');
for(j=0;j<inputs.length;j++) {
res[inputs[j].name] = inputs[j].value.replace(/^\s+|\s+$/g, "");
}
return res;
};
ObjectEditor.prototype.destroy = function () {
};
ObjectEditor.prototype.isPopup = function () {
return true;
};
The other methods of ObjectEditor are simpler: getGui actually returns the container we built in the init, afterGuiAttached is called when the component is attached to the DOM and focuses on the first input element, getValue enumerates the input elements, takes their value (and names) and return an object with the name/value pairs, destroy dosn’t do anything however it must be defined and can be used for cleaning up if needed and isPopup returns true to display the container as a popup instead of inline.
Creating the array-like cell editor
The multi-line renderer/editor will allow a cell to contain a list of values. Here’s the complete fiddle where the “children” column is using the multi-line component:
To integrate it with ag-grid we just need to use the corresponding editor and renderer:
{
headerName: "Children", field: "children", width: 200, editable: true,
cellRenderer: MultiLineCellRenderer,
cellEditor: MultiLineEditor
}
The MultiLineCellRenderer is similar to the ObjectCellRenderer. A span/container element is created at the init method and the refresh method is called to fill it. The refresh method outputs the number of items in the list (i.e it writes N items) and uses the span’s title to display a tooltip with the values of the items:
function MultiLineCellRenderer() {}
MultiLineCellRenderer.prototype.init = function (params) {
this.span = document.createElement('span');
this.span.title=''
this.span.innerHTML='';
this.refresh(params);
}
MultiLineCellRenderer.prototype.refresh = function (params) {
if (params.value === "" || params.value === undefined || params.value === null) {
this.span.innerHTML = '0 items';
} else {
var res = ''
// Create the tooltip for the cell
for(var i=0;i<params.value.length;i++) {
res += (i+1)+': ' + params.value[i]
res+='\n';
}
this.span.title = res;
this.span.innerHTML = params.value.length + ' item' + (params.value.length==1?"":"s");
}
};
MultiLineCellRenderer.prototype.getGui = function () {
return this.span;
};
The logic of the MultiLineEditor is also similar to the ObjectEditor:
function MultiLineEditor() {}
MultiLineEditor.prototype.onKeyDown = function (event) {
var key = event.which || event.keyCode;
if (key == 37 || // left
key == 39 || // right
key == 9 ) { // tab
event.stopPropagation();
}
};
// Used to append list items (their value along with the remove button)
MultiLineEditor.prototype.addLine = function(val) {
var li = document.createElement('li');
var span = document.createElement('span');
var removeButton = document.createElement('button');
removeButton.style='margin-left: 5px; text-align: right; '
removeButton.innerHTML = 'Remove'
span.innerHTML = val;
li.appendChild(span)
li.appendChild(removeButton)
this.ul.appendChild(li);
var that = this;
removeButton.addEventListener('click', function(event) {
that.ul.removeChild(this.parentElement);
});
}
MultiLineEditor.prototype.init = function (params) {
var that = this;
this.container = document.createElement('div');
this.container.style = "border-radius: 15px; border: 1px solid grey;background: #e6e6e6;padding: 10px;";
this.ul = document.createElement('ol');
if (params.value) {
for(i=0;i<params.value.length;i++) {
this.addLine(params.value[i]);
}
}
this.container.appendChild(this.ul);
this.input = document.createElement('input');
this.container.appendChild(this.input);
this.addButton = document.createElement('button');
this.addButton.innerHTML = 'Add';
this.addButton.addEventListener('click', function (event) {
var val = that.input.value;
if(!val || val==undefined || val=='') return;
that.addLine(val, that.ul);
that.input.value='';
});
this.container.appendChild(this.addButton);
this.saveButton = document.createElement('button');
this.saveButton.innerHTML = 'Ok';
this.saveButton.addEventListener('click', function (event) {
params.stopEditing();
});
this.container.appendChild(this.saveButton);
};
A div element that will display the popup editor is created first. In this container we add a ol element and then, if there are values in the list they will be appended in that ol using the addLine method. This method creates a li element the value of each list item along with a remove button which removes the corresponding li element when clicked (that that=this is needed because the click callback function of the button has a different this than the addLine method so that needs to be used instead).
After the list of the items, there’s an input whose value will be inserted to the list when clicking the add button. The same addLine function we used when initializing the component is used here to append the input’s value to the ol. Finally the save button stops the list editing:
MultiLineEditor.prototype.getGui = function () {
return this.container;
};
MultiLineEditor.prototype.afterGuiAttached = function () {
var inputs = this.container.getElementsByTagName('input');
inputs[0].focus();
};
MultiLineEditor.prototype.getValue = function () {
var res = [];
// The value is the text of all the span items of the li items
var items = this.ul.getElementsByTagName('span');
for(var i=0;i<items.length;i++) {
res.push(items[i].innerHTML);
}
return res;
};
MultiLineEditor.prototype.destroy = function () {
};
MultiLineEditor.prototype.isPopup = function () {
return true;
};
For the value of this component, we just enumerate through the li span items of the list we created through addLine and add it to a normal javascript array.
Some more discussion about the components
The above components can be used as they are however I think that their greatest value is that they should show-off some of the capabilities of ag-grid and used as templates to build up your own stuff. Beyond styling or changing the layout of the multi-line and the object editor, I can think of a great number of extensions for them. Some examples, left as an excerise to the reader:
- The renderer components are rather simple, you may create any DOM structure you want in them
- Pass a function as a parameter to the object or multi-line editor that will be used as a validator for the values (i.e not allow nulls or enforce a specific format) - then you can add another “error” span that will be displayed if the validation does not pass
- Make the object editor smarter by passing the type of each attribute (i.e text, number, boolean, date) and check that each input corresponds to that type
- Pass a min/max number of list items for the multi-line editor
- The multi-line editor doesn’t really need to have only text values for each item. You could combine the multi-line editor with the object editor so that each line has a specific, object-like structure. For example, for each child we may have two attributes, name and date of birth