Zcell ZCELL Browser-Based Excel-Like Spreadsheet jQuery Plugin (Original)

Add-ons

2026-07-26 03:59 4 次浏览 • 0 次下载 65.4KB

Zcell ZCELL Browser-Based Excel-Like Spreadsheet jQuery Plugin (Original)

Plugin Description: A pure JavaScript table plugin similar to Excel

Last Updated: 2020-08-02 23:21:51

Changelog:At users' request, this update mainly adds Excel file import and export functionality, along with features for retrieving cell formulas and displayed values. Everyone is welcome to try it out.

The following are the changes in this version:

Version: V1.9 Release Date: 2020-08-01

1. Added Excel file import functionality. Supports importing cell values, row heights, column widths, merged cells, font sizes, bold formatting, horizontal text alignment, automatic text wrapping, and other properties. Color and border importing are not yet supported. Compatible with IE10 and above, as well as other mainstream browsers.

2. Added Excel file export functionality. Supports exporting cell values, row heights, column widths, merged cells, horizontal text alignment, automatic text wrapping, borders, and other properties. Font sizes, bold formatting, and colors are not yet supported for export. Compatible with IE10 and above, as well as other mainstream browsers.

3. Added functionality to retrieve displayed cell values, such as the displayed value of a dropdown list.

4. Added functionality to retrieve formula expressions already assigned to cells.

5. Adjusted the return values of the get column width and get row height methods to integers.

Last Updated: 2019/5/21 12:55:27 AM

Changelog:This update mainly addresses event support when cell values change and adds related APIs for operating on cells by name. Everyone is welcome to try it out.

The following are the changes in this version:

Version: V1.6 Release Date: 2019-05-20

1. Added support for cell value change events, allowing custom events to invoke functions.

2. Added functionality to retrieve row heights and column widths.

3. Added functionality to retrieve the names of specified cells.

4. Added API interfaces for operating on cells by name, all ending with N. These include: GetCellN, SetCellValueN, GetCellValueN, MoveToCellN, SetCellTypeN, SetCellFormatN, SetFormulaN, SetCellReadOnlyN, SetCellStyleN, and other API interfaces.

5. Added support for percentage formatting in cell display formats.

6. Fixed the encoding issue when entering spaces in cell values.

Last Updated: 2019/2/22 7:55:09 PM

Changelog:This update resolves compatibility issues in IE8\IE9. Please ask the administrator to update the compatibility settings.

Version: V1.5.0 Release Date: 2019-02-21

The following are the changes in this version:

1. Added drag-and-drop cell filling, supporting both drag-and-drop copying and sequential filling.

2. Fixed compatibility issues in IE8 and IE9.

3. Added support for numeric keypad operations.

4. Added support for moving with arrow keys while editing cells.

5. Fixed an issue where checkboxes could not be selected when setting their checked state.

Last Updated: 2018/8/25 6:35:15 PM Version: V1.4.0

Release Date:2018-08-23

The following are the changes in this version:

1. Added column insertion functionality, supporting batch insertion.

2. Added column appending functionality, supporting batch appending.

3. Added column deletion functionality, supporting batch deletion.

4. Added row insertion functionality, supporting batch insertion.

5. Added row appending functionality, supporting batch appending.

6. Added row deletion functionality, supporting batch deletion.

7. Added row hiding functionality, allowing multiple rows to be hidden at once.

8. Added row unhiding functionality, allowing multiple rows to be unhidden at once.

9. Added functionality to save and exit editing mode.

10. Added functionality to retrieve the number of table rows.

11. Added functionality to retrieve the number of table columns.

12. Added functionality to retrieve all selected cells.

13. Added functionality to disable automatic formula calculation.

14. Added functionality to manually calculate formulas.

15. Improved merged cell and split cell functionality.

16. Improved column hiding and unhiding functionality.

17. To avoid ambiguity, LoadJsonData() has been replaced with LoadArrData(), and GetDataJson() has been replaced with GetDataArr().

Zcell is a jQuery plugin that provides an Excel-like spreadsheet in the browser. Zcell offers an intelligent spreadsheet experience similar to Excel, supporting double-click editing, formula configuration, display decimal precision settings, dropdown lists, custom cell types, copy and paste, non-contiguous selection, cell merging, cell splitting, row and column insertion, row and column deletion, row and column hiding, keyboard operations, and more.

For API documentation, please visit my blog or contact me (QQ108653210, specify 'Zcell Consultation').

Last Updated: 2018/6/28 9:16:47 PM

Changelog:

Version: V1.3.2 Release Date: 2018-06-27

The following are the changes in this version:

1. Added column width adjustment by dragging.

2. Added batch paste functionality, allowing one copied cell to be pasted into multiple selected target cells.

3. Added an API interface for destroying the table.

Last Updated: 2018/6/18 4:47:39 PM

Changelog:

Version: V1.3.1 Release Date: 2018-06-16

The following are the changes in this version:

1. Modified the licensing method by adding support for importing a license file. The licensed version no longer displays the license notice in the bottom-left corner.

2. Fixed an issue where a dropdown list appeared during double-click editing.

3. Fixed the selected cell background color display issue when the ruler was hidden.

4. Added functionality to hide the status bar.

Last Updated: 2018/6/4 10:05:03 PM

Changelog:This update involved adjustments to the core structure due to the addition of new features, so the release was slightly delayed compared to the original schedule. Thank you for your patience.

Version: V1.3 Release Date: 2018-06-02

The following are the changes in this version:

1. Added double-click cell editing.

2. Added cell formula calculation functionality, supporting addition, subtraction, multiplication, division, and custom functions.

3. Added support for numeric and Boolean data formats. Numeric values support configurable display precision.

4. Added support for checkbox, dropdown, button, and custom cell types.

5. Added support for the = key and ESC key in keyboard operations.

6. Added read-only settings for cells.

7. The row and column rulers change color when a cell is selected.

Why Choose Zcell?

1. Unlike other similar products, zcell is lightweight and has a small file size, enabling better performance in the browser.

2. Compared with other products that often cost thousands, tens of thousands, or even 100,000, zcell is much more affordable and offers better value for money.

3. zcell focuses on convenient browser-based data operations, aiming to reduce the workload of actual operations rather than providing overly complicated features.

4. zcell preserves Excel's familiar operating conventions to the greatest extent, ensuring a consistent and intuitive user experience.

5. zcell is developed based on jQuery, a mainstream framework with stable core dependencies. It is compatible with current mainstream browsers and offers excellent adaptability.

6. zcell retains jQuery's original usage conventions to the greatest extent. Anyone with basic knowledge of jQuery can quickly get started, making the learning curve extremely low!

7. We provide timely updates and upgrade services, continuously optimize existing features, and fix bugs as soon as they are discovered, allowing you to focus on business development.

Please note that Zcell (zcell) is not a completely free product. It offers a free trial version. The free trial has no time limit, but some features are restricted compared with the licensed version.

The trial version is for personal learning and research only and must not be used for commercial purposes.

Last Updated: 2018/4/6 12:57:13 PM

Changelog:Features have been improved based on the first release. The updates in this version are as follows. The demo file index.html is included in the archive.

Version: V1.1.0.1 Release Date: 2018-04-05

Version Update Notes

1. Added cell merging functionality.

2. Added functionality to split merged cells.

3. Added column hiding functionality, allowing multiple columns to be hidden at once.

4. Added functionality to unhide hidden columns, allowing multiple columns to be restored at once.

5. Added Enter key response functionality.

6. Added arrow key response functionality.

7. Added functionality to retrieve the current row number.

8. Added functionality to retrieve the current column number.

9. Fixed an issue where row heights expanded when pasting content containing line breaks.

Zcell is a browser-based jQuery plugin that provides an Excel-like spreadsheet. Zcell offers an intelligent spreadsheet experience similar to Excel, with flexible cell selection and real-time calculations, powerful copy and paste functionality, standardized data loading and retrieval, and flexible appearance and style settings.

Why Choose Zcell?
1. Unlike other similar products, zcell is lightweight and has a small file size, enabling better performance in the browser.

2. Compared with other products that often cost thousands, tens of thousands, or even 100,000, zcell is much more affordable and offers better value for money.

3. zcell focuses on convenient browser-based data operations, aiming to reduce the workload of actual operations rather than providing overly complicated features.

4. zcell preserves Excel's familiar operating conventions to the greatest extent, ensuring a consistent and intuitive user experience.

5. zcell is developed based on jQuery, a mainstream framework with stable core dependencies. It is compatible with current mainstream browsers and offers excellent adaptability.

6. zcell retains jQuery's original usage conventions to the greatest extent. Anyone with basic knowledge of jQuery can quickly get started, making the learning curve extremely low!

7. zcel provides comprehensive and detailed Chinese development documentation, with extensive content, clear API examples, and method descriptions, making development hassle-free!

8. We provide timely updates and upgrade services, continuously optimize existing features, and fix bugs as soon as they are discovered, allowing you to focus on business development.

Please note that Zcell (zcell) is not a completely free product. It offers a free trial version. The free trial has no time limit, but some features are restricted compared with the paid version.

The trial version is for personal learning and research only and must not be used for commercial purposes.