Home > front end >  Recommend a similar excel source js spreadsheet plug-in
Recommend a similar excel source js spreadsheet plug-in

Time:09-17

Plug-in website according to the electronic form, is a pure front similar to excel in the online form, powerful, simple configuration, completely open source.

Based on the canvas.

Website links:
Luckysheet website
Online DEMO

Features include:
1. The table set, include a freeze, merged cells, filtering, sorting, query, conditional formatting, notation;
2. Support data analysis function including pivottables, respectively, and matrix operation, the built-in 385 calculation function;
3. To support a key screenshots, copy to the json data, Shared editing, excel data between Luckysheet and copy and paste.
4. Support the mobile end see

Open the online DEMO experience, quickly, operating down and excel, the following simple intercepting main function shows the core functionality:

Freezing 1. The first line, also include a freeze first column, freezing, the regional support


2. Merger cell


3. The selection, basic ascending, descending, support according to the color filter, filter according to the condition, according to the value filtering, etc.


4. Look for replacement and support regular expression match, a whole word matching, case-insensitive matching a variety of ways


5. Conditional formatting rules, can highlight the cell project selection rules, the article data, levels, icon sets, also support the rule management, new custom rules


6. New notation, all can hide or show a key notation


Pivot table, drag and drop operation meet the demand of daily data analysis


8. Text respectively, support the TAB key, commas, semicolons, Spaces such as segmentation symbols


9. Matrix operations support, transpose, matrix calculation operations such as


10. Function, in addition to support common sum, average, count, maximum, minimum, support almost all of the excel function, and the if formula generator


11. A key screenshot


12. Copy as json or array


13. Copy excel data paste into Luckysheet still keep the original format


14. The mobile end support, sliding good experience


Do look very strong, and you can see the writer is very attentively in doing, also in active maintenance,
Ready to use in the project, are interested in communication with everyone,

So how to use in our project?

With everyone follow tutorial locally run a run.

Use steps:
1. The clone project

Git clone https://github.com/mengshukeji/Luckysheet.git

2. Install depend on

CD Luckysheet
NPM install
NPM install gulp - g

3. The developer mode experience

NPM run dev


Simple steps has run up, if you want to introduce their own projects, need through the NPM run build pack out, put the dist folder file copy to your project introduced in use,
Now, core functions can meet the needs of the project, but should be have a lot of details need to supplement, document also in further perfect, looking forward to further,
  • Related