Jspreadsheet v4: The javascript spreadsheet
Jexcel has been renamed to Jspreadsheet.Jspreadsheet is a lightweight vanilla javascript plugin to create amazing web-based online interactive tables and spreadsheets compatible with other spreadsheet software. You can create an online spreadsheet table from a JS array, JSON, CSV or XSLX files. You can copy from excel and paste straight to your online spreadsheet and vice versa. It is very easy to integrate any third party javascript plugins to create your own custom columns, custom editors, and customize any feature into your application. Jspreadsheet has plenty of different input options through its native column types to cover the most common web-based application requirements. It is a complete solution for web data management. Create amazing online spreadsheets with Jspreadsheet.
With a few simple steps, you can have Jspreadsheet integrated into your applications. Impress your clients with better user experience with this amazing data interactive tool.
- Make rich and user-friendly web interfaces and applications
- You can easily handle complicated data inputs in a way users are used to
- Improve your user software experience
- Create rich CRUDS and beautiful UI
- Compatibility with excel spreadsheets: users can move data around with common copy and paste shortcuts
- Easy customizations with easy third-party plugin integrations
- Lean, fast and simple to use
- Thousands of successfully user cases
- Speed up your work dealing with difficult data entry in a web-based software
- Create and share amazing online spreadsheets
Installation
// From the NPM % npm install jspreadsheet-ce // From a CDN <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/jspreadsheet-ce/dist/jspreadsheet.min.css" type="text/css" /> <script type="text/javascript" src="https://cdn.jsdelivr.net/npm/jspreadsheet-ce/dist/index.min.js"></script> // Clone our project http://github.com/jspreadsheet/ce
Create amazing online spreadsheets
A example how to embed a simple javascript spreadsheet in your application. You can check out for more examples here.
Spreadsheet source code example
<html>
<script src="https://bossanova.uk/jspreadsheet/v4/jexcel.js"></script>
<link rel="stylesheet" href="https://bossanova.uk/jspreadsheet/v4/jexcel.css" type="text/css" />
<script src="https://jsuites.net/v4/jsuites.js"></script>
<link rel="stylesheet" href="https://jsuites.net/v4/jsuites.css" type="text/css" />
<div id="spreadsheet"></div>
<script>
var data = [
['Jazz', 'Honda', '2019-02-12', '', true, '$ 2.000,00', '#777700'],
['Civic', 'Honda', '2018-07-11', '', true, '$ 4.000,01', '#007777'],
];
jspreadsheet(document.getElementById('spreadsheet'), {
data:data,
columns: [
{
type: 'text',
title:'Car',
width:90
},
{
type: 'dropdown',
title:'Make',
width:120,
source:[
"Alfa Romeo",
"Audi",
"Bmw",
"Chevrolet",
"Chrystler",
// (...)
]
},
{
type: 'calendar',
title:'Available',
width:120
},
{
type: 'image',
title:'Photo',
width:120
},
{
type: 'checkbox',
title:'Stock',
width:80
},
{
type: 'numeric',
title:'Price',
mask:'$ #.##,00',
width:80,
decimal:','
},
{
type: 'color',
width:80,
render:'square',
},
]
});
</script>
</html>
Jspreadsheet History
Jspreadsheet 4.6.0
- Jexcel is renamed to Jpreadsheet
- Integration with Jsuites v4
Jspreadsheet 4.2.3
- The spreadsheet plugin now compatible with Jsuites v3.
- New flags, security implementation
- New DOM element references in the Toolbar and tabs spreadsheet worksheet events
4.0.0
A special thank to the FDL - Fonds de Dotation du Libre support and sponsorship that make the new online spreadsheet version possible with so many nice features.
- The online spreadsheet with Support workbooks/tabs
- Create a dynamic spreadsheet table from a HTML static element
- Highlight the selected cells in the spreadsheet after CTRL+C
- Footer with formula support
- Multiple columns resize
- JSON update support (Helpers to update a remote server)
- Javascript spreadsheet global super event (centralized method to dispatch all events in one)
- Custom helpers: =PROGRESS (progressbar), =RATING (5 star rating)
- Custom helpers: =COLUMN, =ROW, =CELL, =TABLE, =VALUE information to be used on formula execution
- Dynamic nested header updates
- A new column type for HTML editing
- New flags such as: includeHeadersOnCopy, persistance, filters, autoCasting, freezeColumns
- New events such as: onevent, onchangepage, onbeforesave, onsave
- More examples and documentation
Jspreadsheet 3.9.0
- New methods
- General fixes
Jspreadsheet 3.6.0
- Better spreadsheet formula parsing
- New javascript spreadsheet events
- New initialization options
- General fixes
Jspreadsheet 3.2.3
- getMeta, setMeta methods
- Npm package with jSuites
- General fixes
Jspreadsheet 3.0.1
Jspreadsheet v3 is a complete rebuilt of the javascript spreasheet jquery plugin version. For that reason it was not possible to keep a complete compatibility with the previous version. If you are upgraging you might need to implement a few updates in your code. If you have questions, you can review the article upgraging from Jspreadsheet Spreadsheet v2 or Handsontable.
The Jspreadsheet v3 brings lot of great new features:
- Drag and drop columns
- Resizable rows
- Merge columns
- Search
- Pagination
- Lazy loading
- Full screen flag
- Image upload
- Native color picker
- Better mobile compatibility
- Better nested headers compatibily
- Amazing keyboard navegation support
- Better hidden column management
- Great data picker: dropdown, autocomplete, multiple, group options and icons
- Importing from XSLX (experimental)
Big improviments are included, such as:
- Complete new formula engine with no external depencies with much faster results.
- Absolutely no selectors, means a much faster application
- New native columns
- No jQuery is required
- React, Vue and Angular examples
- XLXS support using a custom sheetjs (Experimental).
Jspreadsheet 2.1.0
We are glad to bring you the latest jquery plugin version, with the following improvements:
- Mobile touch fixes
- Paste fixes & New CSV parser
Jspreadsheet 2.0.0
- New radio column
- New dropdown with autocomplete and multiple selection options
- Header/body separation for a better scroll/column resize behavior and compatibility
- Better text-wrap including alt+enter excel compatibility
- New set/get meta information
- New set/get config parameters
- New set/get programmatically cell style
- New set/get cell comments
- New table custom toolbar
- New responsive calendar picker
Jspreadsheet 1.5.7
- Checkbox column type improvements
- Destroy jquery table updates
Jspreadsheet 1.5.1
- Spreadsheet data overflow and fixed headers. See an example
- Navigation improvements
Jspreadsheet 1.5.0
- Relative insertRow, deleteRow, insertColumn, deleteColumn. See an example
- Redo, Undo action tracker for insertRow, deleteRow, insertColumn, deleteColumn, moveRow
- New formula column recursive chain
- New alternative design option bootstrap-like. See an example
- updateSettings updates
Javascript spreadsheet examples
A full example on how to create a dynamic jspreadsheet table from a HTML table.
Grouping multiple spreasheets in tabs.
Adding formulas fixed on the table footer.
A full example on how to integrate Jspreadsheet with React
A full example on how to integrate Jspreadsheet with Vue
A full example on how to integrate Jspreadsheet with Angular
A full example on how to integrate Jspreadsheet with Jquery
Full spreadsheet example with search and pagination to bring great compatibility for those who love datatables.
Learn more about the powerful column types. This example brings all native column types and how to create your own custom type.
Full examples on how to handle simple, advanced, multiple, autocomplete and conditional dropdowns. Create amazing javascript tables using categories and images in your dropdowns.
Example from basic to advanced calendar usage, date and datetime picker
This examples shows how to embed and upload images to your spreadsheet
This examples shows how to create a rich text column
How to update your spreadsheet and its data by javascript
Bring a very special touch to your applications customizing your javascript spreadsheet.
Customize the table behavior using javascript
Learn how to handle events on Jspreadsheet
How to import data from an external CSV, json file or XLSX.
Unleash the power of your tables bringing formulas and custom javascript methods on your Jspreadsheet spreadsheet.
Full example on how to enable nor customize your javascript spreadsheet toolbar.
Allow comments in your table spreadsheet.
Header updates and column dragging
Enabled nested headers in your spreadsheet and learn how to set or get header values
Enabled the column dragging
How to translate the default messages from Jspreadsheet
Keep hidden information about your cells using meta information methods
Full example on how to handle merge cells in your javascript tables.
Example how to sort the table by a column via javascript.
Example how to setup readonly cells
This example brings a very nice feature to deal with large table datasets.
How to customize jspreadsheet contextmenu
How define a fixed width and height for the jspreadsheet tables.
How to enable column filters on a Jspreadsheet - the online spreadsheet.
Setup freeze columns in Jspreadsheet
Copyright and license
Jspreadsheet is released under the MIT license.The software is registered under UK law. Contact contact@jspreadsheet.com
About Jspreadsheet
The Jspreadsheet is a full original javascript software created to facilitate the data manipulation in web based applications. It was created to be an easy javascript data input tool for users and it was created inspired on other spreadsheet software.This software is free and was created to be a light alternative to create amazing online javascript spreadsheets.