Handson Tables Navigation
Back to top

Handson Table Documetation

  1. Home
  2. Handson Table Documetation

Handson Tables

HandsonTable provides different types of formatting options like Conditional formatting, Customizing borders, Highlighting selection & Mobiles and tablets.

1. Initialize the plugin by referencing the necessary files:
                
                    <script src="handsontable.full.js"></script>
                    <link rel="stylesheet" type="text/css" href="handsontable.full.min.css">
2. Call the DataTable-function after the page has loaded
                
                    hotMobilesTablets = new Handsontable(containerMobilesTablets, {
                        data: Handsontable.helper.createSpreadsheetData(100, 100),
                        rowHeaders: true,
                        colHeaders: true,
                        fixedRowsTop: 2,
                        fixedColumnsLeft: 2
                    });

Refer following links for detailed documentation, configuration options, methods and examples:

Type URL
Template Page http://demo.pixinvent.com/robust-admin/ltr/vertical-menu-template/handson-table-appearance.html
Plugin Link https://handsontable.com/
Type URL
Conditional formatting https://docs.handsontable.com/0.29.1/demo-conditional-formatting.html
Customizing borders https://docs.handsontable.com/0.29.1/demo-customizing-borders.html
Highlighting selection https://docs.handsontable.com/0.29.1/demo-highlighting-selection.html
Mobiles and tablets https://docs.handsontable.com/0.29.1/demo-mobiles-and-tablets.html

Rows Columns

HandsonTable provides rows and columns feather like scrolling, fixing, resizing & moving.

Refer following links for detailed documentation, configuration options, methods and examples:

Type URL
Template Page http://demo.pixinvent.com/robust-admin/ltr/vertical-menu-template/handson-table-rows-columns.html
Plugin Link
Type URL
Scrolling https://docs.handsontable.com/0.29.1/demo-scrolling.html
Fixing https://docs.handsontable.com/0.29.1/demo-fixing.html
Resizing https://docs.handsontable.com/0.29.1/demo-resizing.html
Moving https://docs.handsontable.com/0.29.1/demo-moving.html

Rows Only

Cell renderers can be used to present the template values for empty rows.

Refer following links for detailed documentation, configuration options, methods and examples:

Type URL
Template Page http://demo.pixinvent.com/robust-admin/ltr/vertical-menu-template/handson-table-rows-only.html
Plugin Link
Type URL
Pre-populating https://docs.handsontable.com/0.29.1/demo-pre-populating.html

Columns Only

HandsonTable provides columns Stretching & Freezing options.

Refer following links for detailed documentation, configuration options, methods and examples:

Type URL
Template Page http://demo.pixinvent.com/robust-admin/ltr/vertical-menu-template/handson-table-columns-only.html
Plugin Link
Type URL
Stretching https://docs.handsontable.com/0.29.1/demo-stretching.html
Freezing https://docs.handsontable.com/0.29.1/demo-freezing.html

Data Operations

HandsonTable provides Data operations options like Sorting, Paginating & Searching.

Refer following links for detailed documentation, configuration options, methods and examples:

Type URL
Template Page http://demo.pixinvent.com/robust-admin/ltr/vertical-menu-template/handson-table-data-operations.html
Plugin Link
Type URL
Sorting https://docs.handsontable.com/0.29.1/demo-sorting.html
Paginating https://docs.handsontable.com/0.29.1/demo-paginating.html
Searching https://docs.handsontable.com/0.29.1/demo-searching.html

Cell Features

HandsonTable provides cell features like Data validation, Drag down, Merged cells, Alignment, Read-only & Disabled editing.

Refer following links for detailed documentation, configuration options, methods and examples:

Type URL
Template Page http://demo.pixinvent.com/robust-admin/ltr/vertical-menu-template/handson-table-cell-features.html
Plugin Link
Type URL
Data Validation https://docs.handsontable.com/0.29.1/demo-data-validation.html
Drag Down https://docs.handsontable.com/0.29.1/demo-drag-down.html
Merged Cells https://docs.handsontable.com/0.29.1/demo-merged-cells.html
Alignment https://docs.handsontable.com/0.29.1/demo-alignment.html
Read-only https://docs.handsontable.com/0.29.1/demo-read-only.html
Disabled editing https://docs.handsontable.com/0.29.1/demo-disabled-editing.html

Cell Types

HandsonTable support almost all kind of cell types i.e numeric, time, date, checkbox, select, dropdowns & password etc..

Refer following links for detailed documentation, configuration options, methods and examples:

Type URL
Template Page http://demo.pixinvent.com/robust-admin/ltr/vertical-menu-template/handson-table-cell-types.html
Plugin Link
Type URL
Custom Renderers http://demo.pixinvent.com/robust-admin/ltr/vertical-menu-template/handson-table-cell-types.html
Numeric https://docs.handsontable.com/0.29.1/demo-numeric.html
Date https://docs.handsontable.com/0.29.1/demo-date.html
Time https://docs.handsontable.com/0.29.1/demo-time.html
Checkbox https://docs.handsontable.com/0.29.1/demo-checkbox.html
Select https://docs.handsontable.com/0.29.1/demo-select.html
Dropdown https://docs.handsontable.com/0.29.1/demo-dropdown.html
Autocomplete https://docs.handsontable.com/0.29.1/demo-autocomplete.html
Password https://docs.handsontable.com/0.29.1/demo-password.html
Handson table https://docs.handsontable.com/0.29.1/demo-handsontable.html

Integration

HandsonTable provides integrations support with jQuery, ChromaJS, Bootstrap & BackboneJS.

Refer following links for detailed documentation, configuration options, methods and examples:

Type URL
Template Page http://demo.pixinvent.com/robust-admin/ltr/vertical-menu-template/handson-table-integrations.html
Plugin Link
Type URL
jQuery https://docs.handsontable.com/0.29.1/demo-jquery.html
gRaphaël charts https://docs.handsontable.com/0.29.1/demo-graphael-charts.html
ChromaJS https://docs.handsontable.com/0.29.1/demo-chromajs.html
Bootstrap https://docs.handsontable.com/0.29.1/demo-bootstrap.html
Backbone.js https://docs.handsontable.com/0.29.1/demo-backbonejs.html

Utilities

HandsonTable also provides utilities like context menu, custom buttons & comments.

Refer following links for detailed documentation, configuration options, methods and examples:

Type URL
Template Page http://demo.pixinvent.com/robust-admin/ltr/vertical-menu-template/handson-table-integrations.html
Plugin Link
Type URL
Context menu https://docs.handsontable.com/0.29.1/demo-context-menu.html
Custom buttons https://docs.handsontable.com/0.29.1/demo-custom-buttons.html
Comments https://docs.handsontable.com/0.29.1/demo-comments_.html