handsontable 的使用方法

Excel-like Data Grid Editor ForjQuery - handsontable

handsontable is a aminimalistic Excel-like data grid editor for HTML,JavaScript & jQuery. It allows you to use auto-expanding and auto-completeas well as add new rows and columns. It also includes a legend, scrolling (so as your tablegrows, it won’t take up your entire page and become unwieldy), context menus,conditional formatting and other features. You can even set it to track changesmade to the table. And, all the data you enter in Handsontable can be copiedand pasted to Excel, Google Spreadsheet, or LibreOffice.

You might also like:

·        jQueryEditable Spreadsheet Plugin For Handsontable - handsontable-excel

How to use it:

1. Include jQuerylibrary and handsontable.js

1 2	<scriptsrc="../lib/jquery.min.js"></script> <scriptsrc="dist/jquery.handsontable.full.js"></script>

2. Includehandsontable CSS to style your plugin

1	<linkrel="stylesheet"media="screen"href="dist/jquery.handsontable.full.css">

3. Markup

1	<divid="dataTable"></div>

4. Call the pluginand load some data if you wish

1 2 3 4 5 6 7 8 9 10 11 12 13

<script>   vardata = [     ["",  "Kia", "Nissan", "Toyota", "Honda"],     ["2008",  10, 11, 12, 13],     ["2009",  20, 11, 14, 13],     ["2010",  30, 15, 12, 13]   ];   $("#dataTable").handsontable({     data:  data,     startRows:  6,     startCols:  8   }); </script>