Introduction
SpreadJS pure front-end table control is a front-end table technology product launched by Grape City, and the software copyright belongs to Xi'an Grape City Software Co., Ltd
Background
Table is a way of visual communication, and also the most common means of data collation for enterprises. The information automation of most enterprises starts from a single electronic form. Whether it is dealing with documents, reports, vouchers, forms, bills, etc., as long as we need to add, delete, or modify data, tables can be completed efficiently.
As an organized form composed of several rows and columns, tables can store more style information. In the era of mobile internet applications, even complex data can be clearly presented to users through the organization of "tables", and support viewing, filtering, and modification from multiple dimensions。
As the world's leading development technology provider, Grapevine City has invested in research and development since 1991, exploring how to embed spreadsheets into various application systems in the form of components. Nowadays, Grapevine's table technology has achieved the same efficient data processing and visualization capabilities in business systems based on user experience and accumulation, while retaining user usage habits.
Major Function
SpreadJS is compatible with more than 450 Excel formulas. It is highly similar to Excel in terms of interface and function, but not limited to Excel. It provides enterprise information systems with application scenario support for Collaborative editing of table documents, data filling and reporting, and Excel like report design. The specific functions are as follows：
Class Excel Table Editor：SpreadJS's table editor provides highly Excel like functions and APIs, allowing for online/offline design of report templates, editing, calculation, analysis of data, and binding with databases to meet the development needs of the reporting system。
High performance data processing：SpreadJS provides an efficient computing engine and is optimized for data processing performance, meeting various data calculation, visualization, data perspective analysis and other needs of enterprises without occupying too much system resources。
Import/Export Excel：SpreadJS supports online import/export of Excel (xlsx) and PDF documents. Users can load and modify various Excel documents in the browser, and save the modified data to the database。
More than 450 calculation formulas：SpreadJS's computing engine supports over 450 Excel formula functions, including custom functions, array functions, dynamic arrays, asynchronous functions, XMATCH, LET, XLOOKUP functions, etc。
Data binding：SpreadJS allows you to directly create binding relationships with data through templates, such as binding JavaScript objects and object arrays, or binding entire worksheets, tables, or cells to data sources。
Rich Data and information visualization means：SpreadJS has 32 kinds of charts, 18 kinds of minigraphs and 182 kinds of shapes built in. Rich Data and information visualization means can add more details to the system, and can be imported and exported losslessly in Excel
Supporting components
GcExcel is compatible with SpreadJS front-end and back-end, and can directly import SSJSON format. Without relying on Office, POI, and third-party software, it meets functions such as front-end and back-end data synchronization of online documents, online reporting, batch export and printing on the server, as well as Excel like report template design and high-performance processing on the server. We provide a complete set of Excel like full stack solutions for your developed applications。
Operating environment
SpreadJS supports cross platform development without the need to pre install any plugins or third-party components. It supports native embedding of various applications and integration with various backend technology frameworks。
High performance table component compatible with SpreadJS front-end and back-end
GcExcel is compatible with SpreadJS front-end and back-end, and can directly import SSJSON format. Without relying on Office, POI, and third-party software, it meets the requirements of online document front-end and back-end data synchronization, online reporting, batch export and printing on the server, as well as Excel like report template design and high-performance processing on the server. It provides a complete set of Excel like full stack solutions for your developed applications.
Why do developers need SpreadJS?
Why do developers need SpreadJS? SpreadJS is a pure front-end form control launched by Grapevine City based on more than 40 years of professional control technology and experience in spreadsheet application. Based on HTML5, SpreadJS is compatible with more than 450 Excel formulas, and has the product characteristics of "high performance, cross platform, and highly compatible with Excel". It is favored by Huawei, Mingyuan Cloud, Yuanguang Software and other well-known enterprises, and is recognized as "China's Excellent Software Product" by the China Software Industry Association. SpreadJS is highly similar to Excel in terms of interface and function, but not limited to Excel. It provides enterprise information systems with application scenario support for Collaborative editing of table documents, data filling and Excel like report design, which greatly reduces enterprise research and development costs and project delivery risks.
Using SpreadJS's online table editor, efficient template design, online editing, and data binding functions can be directly implemented in front-end frameworks such as Angular, React, and Vue, providing end users with a highly Excel like user experience。
Six core functions
Three major application scenarios
Data filling：Implement Excel based data reporting and display
Built in API for online reporting, print submission, real-time preview, and data verification; Through customized development, it can meet business requirements such as batch import and export of Excel, filling and temporary storage, multi-sheet filling, and multi-level reporting.。
Design of Excel like reports：Reduce the workload of Data migration from local to online
Compatible with Excel data format, providing a highly Excel like user experience. Through secondary development, SpreadJS can be embedded into the enterprise report SaaS platform, reusing the original Excel report template of the business system。
Form document Collaborative editing：Online documents for real-time Collaborative editing by multiple people
The Granularity of cell level operations is provided. Through secondary development, Excel documents can be parsed at the front end to meet the requirements of online document development such as multi person collaboration, Collaborative editing, data synchronization, version management, and history query.
