Not a Spreadsheet

DataGridXL is a JavaScript data grid component with a spreadsheet-like interface. It is not a spreadsheet.

This means that DataGridXL does not offer:

• Formulas (Cell input like "=A1+B1" is ignored)
• Merged Cells
• Visual Basic

DataGridXL is for you:

If your (web) application requires a data grid that is able to display, transform, import and export tabular data (whether it's CSV, XLXS, SQL, JSON)

Link: What is Tabular Data?

DataGridXL is *not* for you:

If you're creating an Excel competitor