Handsontable JavaScript 數據網格庫
JavaScript Spreadsheet Library for Developers
Handsontable 是 App應用程式和網站的組合電子表格組件。它是用 JavaScript 編寫的,不受任何外部framework 的限制。它可以利用自訂插件輕鬆修改或擴展。它還使用 JSON格式綁定到任何源,並處理大量的數據。您可以輕鬆地執行所有 CRUD 操作,且為終端用戶提供相似 Excel 的體驗。
Handsontable 是開發者喜愛使用的 JavaScript 數據網格庫,是一個可擴展的電子表格解決方案,且可用來開發漂亮的 Web 應用程式。Handsontable 允許你使用 CLI 工具,因此可選擇任何所需的插件開發出作品。它提供一個空白的畫布或頁面,你可以按照自己的想法、感覺和審美自由發揮。它主要是以純 JavaScript 的形式編寫的。您可以通過 Polymer 組件和 AngularJS 指令來使用 Handsontable。
主要應用
- Database editing
- Configuration controlling
- Data merging
- Workforce planning
- Sales reporting
- Financial analysis
核心技術概念
- Extensibility - it makes possible to build new functionalities upon the core and use only those required in a certain project. It gives you the real freedom of creating.
- ECMAScript 2015 (ES6) - in the future the most important parts of the library will be rewritten to ES6 provide a better control over the code.
- Virtual rendering - also known as "lazy loading". In short, we don't render the cells outside the viewport until you scroll down or across the table to see them. This allows to handle large datasets, some of which contain thousands of rows.
特色
多個frameworks
Handsontable有多種技術可供選擇,包括Angular,React,Vue,它包含一個TypeScript定義文件。
數據安全
Handsontable允許您將所有業務數據保存在自己的服務器上。僅通過以JSON格式傳遞數據來綁定任何給定的數據源。
簡單易學
您可以在幾分鐘內完成項目,而不是幾小時。使用級聯配置可根據業務需求調整Handsontable。
跨瀏覽器
Handsontable在所有現代瀏覽器中效果最佳,但也具有IE9 +的向後兼容性。
高性能
處理數十萬個具有最佳性能的電池。毫不拖延地搜索,排序或過濾數據。
包括支持
大型開發人員社區為此項目做出了貢獻。所有Handsontable Pro客戶均可獲得專業支持。
功能
Frameworks | Most popular | Basic features | Advanced features | Cell types |
React Vue Angular |
Easy data-binding Copy to clipboard Auto fill Filtering data Sorting data Context menu Fixed rows and columns Merging cells |
Collapsing columns Column summary Conditional formatting Data validation Resizing rows and columns Moving rows and columns Dropdown menu Export to file Comments Hiding rows Hiding columns Alignment |
Custom renderers Custom buttons Custom borders Custom plugins Binding rows with headers Multi-column sorting Trimming rows Nested headers |
Numeric Date Time Checkbox Select Dropdown Autocomplete Password Handsontable |
Community Free for personal use |
Commercial license Contact us for a license that meets your needs |
Non-commercial use |
Commercial use |
Overview
Handsontable supports Chrome, Safari, Firefox, Edge, Opera, Samsung Internet, and others.
We carefully test our code on the two latest versions of every modern browser, on both mobile and desktop devices. In addition to running unit and end-to-end tests, we focus on two factors that are crucial for all users: performance and accuracy of the user interface.
Testing compatibility
Tests are run in BrowserStack (opens new window)as well as on a limited number of physical desktop and mobile devices. Access to physical machines gives us an opportunity to measure the performance better which is hard to do with virtual machines.
List of browsers
Desktop Browsers | Mobile Browsers |
Chrome | Chrome |
Firefox | Firefox for Android |
Safari | Firefox for iOS |
Edge | Safari iOS |
Opera | Opera |
QQ browser | Samsung Internet |
Handsontable 11.x is the long-term support (LTS) version for Internet Explorer 11 and Edge Legacy (the non-Chromium version of Edge), until the end of 2023.