TOAST UI Grid is a powerful component for viewing and editing data. Experience the ultimate data converter!

dynamic spreadsheet-like data grid jexcel, feature-rich data table, jquery editable table like excel, javascript crud table, jquery datagrid example, jquery dynamic grid

Provides custom editing elements

To edit the data, you don’t need to use HTML to create the editing elements yourself. It supports various input elements such as text, select box, checkbox, and radio button. You can adjust the way the data is edited only by selecting options. You can also show editing items that you want through a dedicated editor.

Simple and easy-to-use themes

It has three themes: default, outline (zebra style), and clean theme. You can easily add your desired design to the themes provided through the Themes API. The Themes API has been improved since version 3, allowing you to easily control the background color of the header/body area and vertical/horizontal border lines without modifying CSS styles directly. Use the theme to customize your network.

Features

• More Diverse Input Types (checkbox, radio, select, password, etc.)
• Full Keyboard Navigation (move, select, copy, paste, delete, etc.)
• Copy & Paste using a clipboard with 3rd party application (Like MS-Excel or Google-spreadsheet)
• Multi-column headers
• Picking date
• Relational Structure Between Columns
• Data Source
• Summarize all values of each column
• Customizing styles (Three basic themes)
• Tree Data Representation
• Custom cell renderer
• Pagination
• Frozen(Pinned) columns
• Enhanced Virtual Scroll (Handling Large Dataset Without Performance Loss)
• Column resize & reorder & show & hide
• Validation
• Selection
• Sorting
• Merging cell

How to make use of it:

1. Install tui.grid with NPM.

# NPM
$ npm install tui-grid --save

2. Import the tui.grid files into the document.

// ES module
import Grid from 'tui-grid';

<!-- Browser -->
<link rel="stylesheet" href="/dist/tui-grid.css" />
<script src="/dist/tui-grid.js"></script>

3. Create a container in which the data network will be placed.

<div id="myGrid"></div>

4. Define your data in a javascript array.

var myData = [
    {
      id: 549731,
      name: 'Beautiful Lies',
      artist: 'Birdy',
      release: '2016.03.26',
      type: 'Deluxe',
      typeCode: '1',
      genre: 'Pop',
      genreCode: '1',
      grade: '4',
      price: 10000,
      downloadCount: 1000,
      listenCount: 5000
    },
    // more data here
]

5. Present a basic data network inside the placeholder.

var gridInstance = new tui.Grid({
    el: document.getElementById('myGrid'),
    data: myData,
    columns: [
      {
          title: 'Name',
          name: 'name'
      },
      {
          title: 'Artist',
          name: 'artist'
      },
      {
          title: 'Type',
          name: 'type'
      },
      {
          title: 'Release',
          name: 'release'
      },
      {
          title: 'Genre',
          name: 'genre'
      }
    ]
});

6. Add a custom context menu for the data grid.

var gridInstance = new tui.Grid({
    contextMenu:  () => [
    [
      {
        name: 'id1',
        label: 'menu1',
        action: 'copyRows',
        classNames: ['my']
      },
      {
        name: 'id2',
        label: 'menu2',
        action: () => {
          console.log('menu2');
        },
        subMenu: [
          {
            name: 'id3',
            label: 'subMenu1',
          },
        ],
      },
    ],
    [
      {
        name: 'id4',
        label: 'menu3',
        action: () => {
          console.log('menu3');
        }
      },
    ],
  ],
});

Full-featued CRUD Data Grid Component, TOAST UI Grid Plugin/Github

See Demo And Download

Official Website(nhn): Click Here

This superior jQuery/javascript plugin is developed by nhn. For extra Advanced usage, please go to the official website.