Jspreadsheet v4: The javascript spreadsheet

本文主要是介绍Jspreadsheet v4: The javascript spreadsheet，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！

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.

For enterprise projects go Pro Version (exclusive features, plugins, extensions and technical support). You can test our Pro Version in development for free for as long as you need.

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

Create amazing online spreadsheets

A example how to embed a simple javascript spreadsheet in your application. You can check out for more examples here.

	Car	Make	Available	Photo	Stock	Price	G
1	Jazz	Honda	12/02/2019			$ 2.000,00
2	Civic	Honda	11/07/2018			$ 4.000,01

Installation

% npm install jspreadsheet-ce

Or download from our Github Official

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

Create from a HTML table
A full example on how to create a dynamic jspreadsheet table from a HTML table.

Using tabs
Grouping multiple spreasheets in tabs.

Formulas on table footer
Adding formulas fixed on the table footer.

React Implementation
A full example on how to integrate Jspreadsheet with React

VUE Implementation
A full example on how to integrate Jspreadsheet with Vue

Angular Implementation
A full example on how to integrate Jspreadsheet with Angular

Jquery Implementation
A full example on how to integrate Jspreadsheet with Jquery

Search and pagination
Full spreadsheet example with search and pagination to bring great compatibility for those who love datatables.

Column types
Learn more about the powerful column types. This example brings all native column types and how to create your own custom type.

Advanced dropdown
Full examples on how to handle simple, advanced, multiple, autocomplete and conditional dropdowns. Create amazing javascript tables using categories and images in your dropdowns.

Date and datetime picker
Example from basic to advanced calendar usage, date and datetime picker

Images
This examples shows how to embed and upload images to your spreadsheet

Richtext column
This examples shows how to create a richtext column

Programmatically updates
How to update your spreadsheet and its data by javascript

Table Style
Bring a very special touch to your applications customizing your javascript spreadsheet.

Table Scripting
Customize the table behavior using javascript

Events
Learn how to handle events on Jspreadsheet

Importing data
How to import data from an external CSV, json file or XLSX.

Formulas
Unleash the power of your tables bringing formulas and custom javascript methods on your Jspreadsheet spreadsheet.

Custom toolbars
Full example on how to enable nor customize your javascript spreadsheet toolbar.

Cell comments
Allow comments in your table spreadsheet.

Headers
Header updates and column dragging

Nested headers
Enabled nested headers in your spreadsheet and learn how to set or get header values

Column dragging
Enabled the column dragging

Translations
How to translate the default messages from Jspreadsheet

Meta information
Keep hidden information about your cells using meta information methods

Merged cells
Full example on how to handle merge cells in your javascript tables.

Sorting columns
Example how to sort the table by a column via javascript.

Readonly Columns
Example how to setup readonly cells

Lazy loading
This example brings a very nice feature to deal with large table datasets.

Custom Contextmenu
How to customize jspreadsheet contextmenu

Table overflow
How define a fixed width and height for the jspreadsheet tables.

Column filters
How to enable column filters on a Jspreadsheet - the online spreadsheet.

Freeze columns
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.

这篇关于Jspreadsheet v4: The javascript spreadsheet的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！

Java教程