SpreadJS It's based on HTML5 The pure front-end table control , compatible 450 More than species Excel The formula , Have “ High performance 、 Cross platform 、 And Excel Highly compatible ” The product characteristics of , Can provide users with highly similar Excel The function of , Satisfy Web Excel Component development 、 Form document co editing 、 Data filling 、 class Excel Report design and other business scenarios , Greatly reduce the R & D cost and project delivery risk of the enterprise .
The product has been on the market since , It is well received by Huawei 、 Suning e-buy 、 Celestica fund 、 High beam software and other fields of the favor of leading enterprises , And in 2020 It was recognized by China Software Industry Association as “ Excellent software products in China ”.
recently ,SpreadJS Official release V14.0 edition . From this release ,SpreadJS Launched the PivotTable function , Further reduce the threshold of enterprise data analysis , Improve the ability of data processing in the system .
Besides ,SpreadJS still V14.0 A component-based online form editor has been released in , Provides easier to embed 、 Load in seconds 、 Flexible customization features . Online form editor can be used with SpreadJS Integrate , Help developers in the mainstream front end JS In the frame , Achieve high performance template design 、 Online editing 、 Filling and data binding and other functions .
In detail SpreadJS V14.0 Before the new features of , Please download the experience synchronously ：
SpreadJS V14.0 Introduction to new features
1\. PivotTable ： Perfect representation Excel Powerful data analysis ability
As a functional layout with Excel Highly similar pure front-end table control ,SpreadJS Not only is it compatible with 450 More than species Excel The formula 、32 Kind of charts and 18 Kind of mini , In this version, the PivotTable function is officially launched .
（SpreadJS The PivotTable of ）
As shown in the figure above ,SpreadJS The PivotTable of has Excel Most of the functions of PivotTables , Including the perspective panel 、 PivotTable fields 、 Filter 、 Value field settings 、 Data sorting 、 Sort, summarize, etc .
adopt 50 Ten thousand lines of data test ,SpreadJS The PivotTable still shows extremely high data processing performance , All operations are in 527 It can be executed in milliseconds .
2\. Component based online form editor ： It's easier to embed 、 Load in seconds 、 Flexible customization
Online form editor as SpreadJS Enhanced components of , It can easily embed all kinds of front-end pages , Built in open API And the class Excel Of UI Design elements , Help developers in Angular、Vue、React Equal front end JS In the frame , Achieve high performance template design 、 Online editing / Filling and data binding and other functions , And bring a high degree of similarity to end users Excel Using experience of .
stay V14.0 In the version ,SpreadJS An online table editor based on component design architecture is introduced , The editor uses Dom As a container , Release through front-end components , You can download and try it locally , There are no functional restrictions .
Component based online form editor has the following advantages ：
- The application is more flexible
（ Component design architecture , The application is more flexible ）
- It's easier to embed 、 transplant
（ Don't rely on any third-party libraries ）
- A smaller , Load in seconds
（ It's less than 4 MB, Load in seconds ）
- It's easier to customize , More interaction
（ Use declarative syntax instead of HTML Source code , It's easier to customize ）
3\. Formula function ： Support iterative calculation , Join in XMatch & XLookup、LET And so on
SpreadJS Iterative computation is supported in the current version , The initial approximation can be corrected repeatedly by a recursive formula , Until the required precision is reached , The specific implementation is as follows ：
（SpreadJS The iterative computing function of ）
（ An example of iterative computation ）
Except for iterative computation ,SpreadJS In the current version XMatch & XLookup, as well as LET function
（SpreadJS Of XMatch & XLookup function ）
（SpreadJS Of LET function ）
4\. Import and export ： Support progressive loading 、HTML export
In the current version ,SpreadJS Not only can it be done directly in the browser Excel、CSV、JSON Import and export the file 、PDF export 、 Print and preview operations , Progressive loading is also added 、HTML More new features like export .
（SpreadJS Of HTML Export function ）
5\. Cell ： Support progressive filling 、 Multiple column selection
SpreadJS Progressive cell fill effects are supported , Multi column selection can be realized 、 The column head supports formula functions and sparklines .
（SpreadJS The progressive filling effect of ）
（SpreadJS Support formula and sparkline ）
6\. Data visualization ： Added funnel chart , Support chart axis crossing properties
SpreadJS Funnel chart type has been added in the current version , And support chart template filling 、GapWidth & Overlap adjustment 、 Ring graph holeSize Attribute adjustment , And new features like chart axis crossing .
（SpreadJS The funnel of ）
（SpreadJS The chart template filling effect of ）
（SpreadJS The chart axis cross function of ）
（SpreadJS Of GapWidth & Overlap Adjust the effect ）
（SpreadJS Of holeSize Attribute adjustment effect ）
The above is the pure front-end table control SpreadJS V14.0 The main functions of the introduction , For more information about the new version , Welcome to visit SpreadJS The product's official website .