Pure front-end table control spreadjs v14.0 release: component editor + PivotTable

Grape City 2020-11-10 12:04:43
pure front-end end table control

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 :

Pure front-end table control SpreadJS V14.0 download

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 .

Click here to , download SpreadJS Component table editor

Component based online form editor has the following advantages :

  1. The application is more flexible


( Component design architecture , The application is more flexible )

  1. It's easier to embed 、 transplant

( Don't rely on any third-party libraries )

  1. A smaller , Load in seconds


( It's less than 4 MB, Load in seconds )

  1. 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 .

本文为[Grape City]所创,转载请带上原文链接,感谢

  1. [front end -- JavaScript] knowledge point (IV) -- memory leakage in the project (I)
  2. This mechanism in JS
  3. Vue 3.0 source code learning 1 --- rendering process of components
  4. Learning the realization of canvas and simple drawing
  5. gin里获取http请求过来的参数
  6. vue3的新特性
  7. Get the parameters from HTTP request in gin
  8. New features of vue3
  9. vue-cli 引入腾讯地图(最新 api,rocketmq原理面试
  10. Vue 学习笔记(3,免费Java高级工程师学习资源
  11. Vue 学习笔记(2,Java编程视频教程
  12. Vue cli introduces Tencent maps (the latest API, rocketmq)
  13. Vue learning notes (3, free Java senior engineer learning resources)
  14. Vue learning notes (2, Java programming video tutorial)
  15. 【Vue】—props属性
  16. 【Vue】—创建组件
  17. [Vue] - props attribute
  18. [Vue] - create component
  19. 浅谈vue响应式原理及发布订阅模式和观察者模式
  20. On Vue responsive principle, publish subscribe mode and observer mode
  21. 浅谈vue响应式原理及发布订阅模式和观察者模式
  22. On Vue responsive principle, publish subscribe mode and observer mode
  23. Xiaobai can understand it. It only takes 4 steps to solve the problem of Vue keep alive cache component
  24. Publish, subscribe and observer of design patterns
  25. Summary of common content added in ES6 + (II)
  26. No.8 Vue element admin learning (III) vuex learning and login method analysis
  27. Write a mini webpack project construction tool
  28. Shopping cart (front-end static page preparation)
  29. Introduction to the fluent platform
  30. Webpack5 cache
  31. The difference between drop-down box select option and datalist
  32. CSS review (III)
  33. Node.js学习笔记【七】
  34. Node.js learning notes [VII]
  35. Vue Router根据后台数据加载不同的组件(思考->实现->不止于实现)
  36. Vue router loads different components according to background data (thinking - & gt; Implementation - & gt; (more than implementation)
  37. 【JQuery框架,Java编程教程视频下载
  38. [jQuery framework, Java programming tutorial video download
  39. Vue Router根据后台数据加载不同的组件(思考->实现->不止于实现)
  40. Vue router loads different components according to background data (thinking - & gt; Implementation - & gt; (more than implementation)
  41. 【Vue,阿里P8大佬亲自教你
  42. 【Vue基础知识总结 5,字节跳动算法工程师面试经验
  43. [Vue, Ali P8 teaches you personally
  44. [Vue basic knowledge summary 5. Interview experience of byte beating Algorithm Engineer
  45. 【问题记录】- 谷歌浏览器 Html生成PDF
  46. [problem record] - PDF generated by Google browser HTML
  47. 【问题记录】- 谷歌浏览器 Html生成PDF
  48. [problem record] - PDF generated by Google browser HTML
  49. 【JavaScript】查漏补缺 —数组中reduce()方法
  50. [JavaScript] leak checking and defect filling - reduce() method in array
  51. 【重识 HTML (3),350道Java面试真题分享
  52. 【重识 HTML (2),Java并发编程必会的多线程你竟然还不会
  53. 【重识 HTML (1),二本Java小菜鸟4面字节跳动被秒成渣渣
  54. [re recognize HTML (3) and share 350 real Java interview questions
  55. [re recognize HTML (2). Multithreading is a must for Java Concurrent Programming. How dare you not
  56. [re recognize HTML (1), two Java rookies' 4-sided bytes beat and become slag in seconds
  57. 【重识 HTML ,nginx面试题阿里
  58. 【重识 HTML (4),ELK原来这么简单
  59. [re recognize HTML, nginx interview questions]
  60. [re recognize HTML (4). Elk is so simple