同步操作将从 Gitee 极速下载/jExcel 强制同步,此操作会覆盖自 Fork 仓库以来所做的任何修改,且无法恢复!!!
确定后同步将在后台操作,完成时将刷新页面,请耐心等待。
jExcel is a lightweight vanilla javascript plugin to create amazing web-based interactive tables and spreadsheets compatible with Excel or any 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 jExcel 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. jExcel 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 applications with jExcel javascript spreadsheet.
% npm install jexcel
A basic example to integrate the javascript spreadsheet in your website to create your first online spreadsheet.
<script src="https://bossanova.uk/jexcel/v3/jexcel.js"></script>
<script src="https://bossanova.uk/jsuites/v2/jsuites.js"></script>
<link rel="stylesheet" href="https://bossanova.uk/jsuites/v2/jsuites.css" type="text/css" />
<link rel="stylesheet" href="https://bossanova.uk/jexcel/v3/jexcel.css" type="text/css" />
You should initiate your table based on a div container, such as:
<div id="mytable"></div>
To initialize a jExcel table you should run a javascript, such as:
data = [
['Google', 1998, 807.80],
['Apple', 1976, 116.52],
['Yahoo', 1994, 38.66],
];
jexcel(document.getElementById('mytable'), {
data:data,
colWidths: [ 300, 80, 100 ]
});
React Implementation
A full example on how to integrate jExcel with React
VUE Implementation
A full example on how to integrate jExcel with Vue
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
Image upload
This examples shows how to upload images to your spreadsheet
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.
Events
Learn how to handle events on jExcel
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 jExcel spreadsheet.
Custom toolbars
Full example on how to enable nor customize your javascript spreadsheet toolbar.
Column comments
Allow comments in your table spreadsheet.
Headers
Enabled nested headers in your spreadsheet and learn how to set or get header values
Translations
How to translate the default messages from jExcel
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.
Lazy loading
This example brings a very nice feature to deal with large table datasets.
jExcel v3 is a complete rebuilt javascript vanilla version. For that reason it was not possible to keep a complete compatibility with the previous version. If you are upgrating you might need to implement a few updates in your code. If you have questions, you can review the article upgrating from jExcel v2 or Handsontable.
The jExcel v3 brings lot of great new features:
Big improviments are included, such as:
We are glad to bring you the latest jquery plugin version, with the following improvements:
jExcel is released under the [MIT license]. Copyrights belong to Paul Hodel paul.hodel@gmail.com
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。