A hot question on Zhihu recently: What online document editing software like Google Docs is available in China? You reply is essentially revolves around mature online document editing software, such as graphite documents, tencent, youdao cloud collaboration, etc., in which each software has the most suitable for the use of scenarios, some pay attention to data storage and data security, while others focus on team management and document collaboration, for the end user, There are a variety of mature online document editing software products on the market, but the best one is the one that best fits your business needs.
According to different business requirements, users’ attention direction also varies greatly:
-
Large companies are paying more attention to data security, collaboration efficiency, and compatibility with original system documentation
-
Smes pay more attention to rights control, automatic backup, and data synchronization
How to make sure the system fits the business perfectly? In addition to self-development, a more time-saving way is to develop a personalized “online Excel” system with third-party components.
Based on this, today I will give you a pure front-end development tool called SpreadJS, which can meet the needs of Web Excel component development, data filling, Excel report design, online Excel co-editing and other business scenarios. SpreadJS will also share how to efficiently develop and maintain the online Excel system with its “high performance, cross-platform and highly compatible with Excel” features.
Difficulties in the development of online Excel system
Teams’ needs for document management generally fall into three layers: storage, management, and collaboration.
A qualified online document editing software, first of all to meet the team document storage, synchronization, and data security needs; Secondly, it needs to meet the requirements of document management, that is, to achieve retrieval and permission control in a complex and multi-tiered document catalog. Finally, it is to meet the needs of multi-team collaborative work. In many cases, multiple people need to modify a document at the same time. At this time, the online collaboration function can help the team greatly improve work efficiency.
To sum up, the difficulties in the development of “online Excel” system include:
-
Storage requirements: Storage space, real-time data synchronization, and data security
-
Document management: rights control, document retrieval, classification and summary
-
Online collaboration: multiplayer online editing, data rollback, backup, comments
-
Compatibility and ease of use: compatible with native Excel documents, multi-terminal availability, low learning cost
SpreadJS is aimed at the difficulty of “online Excel” system development
For storage performance and data security
SpreadJS is a pure front end table control based on HTML5, using HTML5 Canvas, which is more advanced than DOM, to draw interactive interfaces. With its exclusive Sparse Array model, SpreadJS maximizes storage savings without compromising access performance. Run the SpreadJS performance test here.
SpreadJS is essentially a control (component) product with a specific interface, logic, and UI presentation. It does not contain business logic or front and back data transfers, so it fully complies with HIPPA and GDPRP requirements. It does not store private information or send it to third parties.
SpreadJS works with the AES-256 encryption algorithm, which is widely used in the military and financial industries. SpreadJS supports SSL encryption channels or HTTPS encryption to secure data transmission over the Internet.
For document management
With SpreadJS, you can import and export Excel, CSV and JSON files, export, print and preview PDF files from your browser without any background code or third-party components.
SpreadJS provides a rich event response mechanism on forms that allows you to customize right-click menus, cell behavior, form protection, data validation, and more to meet your application’s personalized business logic needs.
For online collaboration
The online collaboration system developed by SpreadJS is characterized by high efficiency (multiple people can edit together without waiting), ease of use (Excel-like operation mode and UI can be embedded into the system for direct use) and quick response to business needs (no IT and development departments need to intervene). Business units can design their own templates).
For compatibility and ease of use
SpreadJS provides the same behavior and logic as Excel (look, toolbars, dialogs, right-click menus, etc., without any barriers or learning costs). SpreadJS is compatible with more than 90% of Excel’s common functions and supports front-end import and export of native Excel files. SpreadJS is not limited by servers and runs stably in C++,.net, Java, JavaScript and other frameworks. The product has been developed for more than 30 years.
SpreadJS is also compatible with more than 450 Excel formulas and 32 charts. Thanks to its HTML5-based architecture, SpreadJS allows users to customize extensions on demand, enabling developers to easily mix and calculate data on both the front and back ends by executing functions asynchronously.
SpreadJS core functions and application scenarios
-
Highly similar to Excel in functionality, appearance, and operation
-
Provides efficient computing engine, compatible with more than 450 Excel formulas
-
Pure front-end import, export Excel files, no dependence, can be arbitrary expansion
-
Web Excel component Development:
By calling the API, developers can embed all of Excel’s capabilities in Web applications, including data processing, sorting, data filtering, PivotTable analysis, importing and exporting Excel files, data binding, data validation, and visual designers.
- Excel report design:
SpreadJS presents data in a tabular format with built-in data processing functions such as sorting, filtering, row headers, list headers, data summarization, border and cell styles, data grouping, aggregation and calculation formulas.
- Data filling:
SpreadJS uses forms to fill out data and embed the modules into your Web applications. SpreadJS can fill out data online or offline, including application forms, Word document reports and test reports.
- Online Excel collaborative editing:
By embedding SpreadJS ‘Excel like interface into Web applications, it enables end users to manipulate documents and update data directly from a browser.
- Data visualization:
SpreadJS provides a wealth of charts, minigraphs, conditional visualizations and shapes to bring more creative and flexible data visualization to Web applications, meeting typical business scenarios such as data analysis, Dashboard, OLAP and BI.
Some examples of SpreadJS applications
Case 1: A leading domestic communication equipment enterprise uses SpreadJS to build an efficient internal data management system
In order to strengthen the data exchange between the institutes, improve the daily office efficiency of the company, quickly grasp the data management situation, integrate information management into the daily office, improve the overall data management level and management efficiency. Based on the actual needs of the company and multi-party evaluation of the tool, we finally choose pure front-end table control SpreadJS to manage the internal data system.
View case details >>
Case 2: A professional manufacturer of mobile office OA software promotes the rapid development of OA software with SpreadJS
In order to improve the company’s information collaborative development and enterprise data management level, we take “workflow” as the way of management, combined with business needs, after multi-expert evaluation and investigation, we finally choose pure front-end form control SpreadJS, which is used in the software development of enterprise collaborative OA management platform.
View case details >>
Case 3: An “Internet + Tax” technology company uses SpreadJS to build a one-stop service platform for “Internet + tax”
In order to achieve convenient, efficient, real-time and controllable invoice and tax plate management, improve the overall office and management efficiency of the enterprise. According to the business needs of the company, we unanimously decided to adopt pure front-end SpreadJS for embedded development for the two modules of invoice report management and data analysis.
View case details >>
It is better to teach others how to fish than to teach others how to fish. SpreadJS helps enterprises develop their “online Excel” system efficiently
With the acceleration of information construction in various fields in China, information system development, online collaboration, upgrading and iteration of old and new systems, data migration and so on will become the core problems that enterprises have to face. However, enterprise information system construction is a system engineering, which requires business personnel to work closely with developers, and SpreadJS can solve this problem.
Developers with limited code skills can use SpreadJS’s extensive API interface to design table templates, fill in data, perform statistics, manage data and present data with a simple drag and click. For developers with strong coding skills, SpreadJS offers source code for free customization and on-demand extension.
As the saying goes, “to teach fishing is better than teach them to fish”, pure front form controls SpreadJS break the traditional coding method, will develop the return to the simple and efficient, quick to implement user needs, solve the enterprise development and the contradiction between standardization production, make enterprises more focus on innovation and development, will become the future enterprise one of the important tools in digital process.
To get a taste of this pure front end spreadsheet control, go to the SpreadJS website and download it.