Handsontable JavaScript 數據網格庫
JavaScript Spreadsheet Library for Developers
Handsontable 是 App應用程式和網站的組合電子表格組件。它是用 JavaScript 編寫的，不受任何外部framework 的限制。它可以利用自訂插件輕鬆修改或擴展。它還使用 JSON格式綁定到任何源，並處理大量的數據。您可以輕鬆地執行所有 CRUD 操作，且為終端用戶提供相似 Excel 的體驗。
Handsontable 是開發者喜愛使用的 JavaScript 數據網格庫，是一個可擴展的電子表格解決方案，且可用來開發漂亮的 Web 應用程式。Handsontable 允許你使用 CLI 工具，因此可選擇任何所需的插件開發出作品。它提供一個空白的畫布或頁面，你可以按照自己的想法、感覺和審美自由發揮。它主要是以純 JavaScript 的形式編寫的。您可以通過 Polymer 組件和 AngularJS 指令來使用 Handsontable。
特色
多個frameworks
Handsontable有多種技術可供選擇，包括Angular，React，Vue，它包含一個TypeScript定義文件。
數據安全
Handsontable允許您將所有業務數據保存在自己的服務器上。僅通過以JSON格式傳遞數據來綁定任何給定的數據源。
簡單易學
您可以在幾分鐘內完成項目，而不是幾小時。使用級聯配置可根據業務需求調整Handsontable。
跨瀏覽器
Handsontable在所有現代瀏覽器中效果最佳，但也具有IE9 +的向後兼容性。
高性能
處理數十萬個具有最佳性能的電池。毫不拖延地搜索，排序或過濾數據。
包括支持
大型開發人員社區為此項目做出了貢獻。所有Handsontable Pro客戶均可獲得專業支持。
功能
| Most popular | Community Edition | Handsontable Pro | Advanced options | Wrappers |
| Drag-down Copy-paste Undo-redo Sorting Data validation Conditional formatting Keyboard shortcuts |
Fixed rows / columns Various cell types Context menu Alignment Moving rows / columns Resizing rows / columns Merged cells Comments Stretching |
Filtering Export to file Dropdown menu Nested headers Collapsing columns Hiding rows Hiding columns Trimming rows Column summary Header tooltips Binding rows with headers Multi-column sorting Formulas alpha Gantt Chart beta |
Custom renderers Custom buttons Custom borders Custom plugins |
React Vue Angular |
| Developer | Team | Enterprise | |
| Premium features | V | V | V |
| Distribution rights (OEM / SaaS) | Contact us | Contact us | Contact us |
| License type | Commercial | Commercial | Commercial |
| Number of servers | Unlimited | Unlimited | Unlimited |
| Number of developers | 1 | 5 | Custom |
| Free maintenance | 1 year | 1 year | 1 year |
| Support time | 1 hour | Custom | Custom |
| Initial response time | 36 hours | 36 hours | 12 hours |
| Emergency hot fixes | X | X | V |
Compatibility 相容性
Every release is tested in the most popular browsers.. This version (6.2.2) was tested in the following browsers:
|
Firefox |
Chrome |
Internet Explorer |
Edge |
Safari |
Opera |
|---|---|---|---|---|---|
|
|
|
|
|
|
|
Pro features
|
Name |
Description |
|---|---|
|
Binding rows with headers |
Bind rows with headers to lock the row number and always display one beside the other. |
|
Collapsing columns |
Expand and collapse columns to better fit the content. |
|
Column summary |
Make pre-defined calculations and display the results in Handsontable. |
|
Dropdown menu |
Add a menu to the heading to enable additional operations for the columns. |
|
Export to file |
Export data to a flat file like CSV or a string. |
|
Filtering |
Display rows that meet your criteria and hide the rest. |
|
Gantt Chart |
Create a simple Gantt Chart using Handsontable. |
|
Header tooltips |
Display the header label in a tooltip. |
|
Hiding columns |
Hide specific columns and show the rest. |
|
Hiding rows |
Hide specific rows and show the rest. |
|
Nested headers |
Create a nested, hierarchical structure of headers to get your data into groups. |
|
Trimming rows |
Exclude specific rows from the rendering process so they won't be displayed. |
Free features
|
Name |
Description |
|---|---|
|
Alignment |
Decide where the content is placed within the cell or a range of cells. |
|
Autocomplete |
Choose one of the suggested options while typing or entering a custom value. |
|
Checkbox |
Add a checkbox to a cell to indicate binary choices. |
|
Comments |
Provide an additional note about the cell to help better understand its content. |
|
Conditional formatting |
Define how specific cells are formatted depending on their values. |
|
Context menu |
Invoke a shortcut menu to choose an action related to the selected object. |
|
Custom borders |
Apply custom border style around cells or range of cells. |
|
Custom buttons |
Insert and remove column or row using custom action buttons. |
|
Custom HTML |
Display HTML content in a cell or header. |
|
Data validation |
Control what values can be entered into a cell. |
|
Date |
Use a date picker to select a date. |
|
Disable cell editing |
Make cell non-editable without changing its appearance and behaviour. |
|
Drag-down |
Drag the fill handle (a square in the bottom right corner of the cell) to fill cells with data series. |
|
Dropdown |
Create an advanced dropdown list of choices in a cell. |
|
Fixed rows and columns |
Define which rows or columns are visible while scrolling down or across the table. |
|
Formula support |
Use functions to calculate numerical information within a cell or range of cells. |
|
Freezing |
Create freeze columns to keep them visible while scrolling. |
|
Handsontable |
Use Handsontable itself as a custom cell editor. |
|
Highlighting current |
Indicate the entire active column or row. |
|
Merge cells |
Display cells across multiple rows or columns. |
|
Moving |
Drag rows or columns to swap them within the table. |
|
Numeric |
Type a custom number format in a cell. |
|
Pagination |
Limit the number of records being displayed in a single view. |
|
Password |
Use asterisks to mask the value in a cell. |
|
Pre-populating new rows |
Create empty cells with predefined types or values |
|
Read-only |
Lock the cell or a range of cells to disallow altering them. |
|
Resizing |
Drag the sizing handle to change the size of column or row. |
|
Scrolling |
Use native scrollbars to navigate within the table. |
|
Search for values |
Search through the content with the search field. |
|
Select |
Create a simple dropdown list of choices in a cell. |
|
Sorting data |
Sort data in ascending or descending order throughout the column. |
|
Stretching |
Allow columns to the parent container width. |
