jspreadsheet/ce

Jspreadsheet CE is a JavaScript library for embedding a spreadsheet-style data grid directly inside a web page. Instead of building tables with plain HTML or a basic grid library, you get an interface that looks and behaves like a desktop spreadsheet, with editable cells, column resizing, keyboard shortcuts, and copy-paste support that works with clipboard data from Excel. You initialize it by pointing it at a div element on your page and passing in your data and column configuration. Each column can be assigned a type: text, numeric, dropdown, calendar, checkbox, image, or color picker. The library handles rendering, validation, and user input for each type. Formulas work across cells, and the library includes its own formula engine with no external dependencies. Multiple worksheets can exist in a single grid, similar to tabs in a spreadsheet application. Features like search, pagination, column merging, row resizing, drag-and-drop column reordering, and frozen columns are all included. The library also provides events and methods so your application code can respond to changes and push or pull data programmatically. It is available through npm or via CDN script tags, and dedicated wrappers are provided for React and Vue. The library was originally called jExcel before being renamed to Jspreadsheet. The community edition is open source, while a paid Pro version with additional features is sold separately. The README includes a working code example showing a table with different column types, and links to a variety of examples in the documentation covering topics like rich text editing, XLSX import, web components, and jQuery integration.