Excel-based low-code platform development method, system and equipment

Abstract

The invention discloses an Excel-based low-code platform development method, system and device, and the method comprises the steps: drawing a plurality of cells in a designer to form a table, and displaying the cells in a visual area to form a table interface; introducing an Excel toolbar into a table interface to simulate the Excel table interface; wherein cell types of cells are integrated in the toolbar so as to expand contents in the cells; an analyzer is embedded in an Excel table interface to achieve Excel formula calculation; and analyzing the Excel table interface and the analyzer into a page file, debugging the page file, and publishing the page file to a server to generate a low-code platform. The problem that an existing designer of a low-code platform has high learning cost for new users is solved. The method and the device can reduce the starting difficulty of the user and improve the development efficiency and experience of the user.

Description

Technical Field

[0001] The present application relates to the field of low-code development technology, and in particular to a development method, system and device for a low-code platform based on Excel. Background Art

[0002] A low-code platform is a software development tool that aims to simplify the application development process, allowing developers to design and develop applications in a more efficient and intuitive way. It allows developers to quickly build applications through a graphical user interface and configuration rather than traditional manual coding. Such platforms usually provide a wealth of pre-made modules and components, as well as powerful logic orchestration capabilities.

[0003] There are many low-code platform products on the market. Their core functions are to design application services through the designers of each product, and finally publish them to the server for operation. The servers of each product are similar, and are all used to deploy the final running products, but the designer side has its own advantages. For example: for custom forms, the core of its designer is a form submission page, and users can only define the elements and content of the form by dragging in controls in a fixed position or order. For custom canvas forms, it is more flexible than pure forms. Users can drag the position of the form at will, but it is still within a canvas as a whole. The elements within the canvas cannot overflow, and the page size is uncontrollable. For custom canvases, its capabilities are more flexible than the form of canvas forms. Users can arbitrarily place controls to combine the functions of application services instead of just a single form submission.

[0004] But whether using forms or custom canvases, the designers of low-code platforms have a high learning cost for new users. For users who have no development experience, they may not understand professional development concepts such as forms, controls, and lists at all, so it is difficult to get started and the learning cost is very high. In addition, many low-code platforms perform poorly in terms of scalability and customization. Users can only use built-in components for design, which cannot meet the needs of many specific scenarios. Summary of the invention

[0005] The embodiments of the present application solve the problem that the designers of existing low-code platforms have a high learning cost for new users by providing a development method, system and device for a low-code platform based on Excel.

[0006] In the first aspect, an embodiment of the present application provides a method for developing a low-code platform based on Excel, including: drawing multiple cells in a designer to form a table, and displaying the cells in a visible area to form a table interface; introducing an Excel toolbar in the table interface to simulate an Excel table interface; wherein the toolbar integrates the cell type of the cell to expand the content in the cell; embedding an analyzer in the Excel table interface to implement Excel formula calculation; parsing the Excel table interface and the analyzer into a page file, and publishing it to a server after debugging to generate a low-code platform.

[0007] In combination with the first aspect, in a possible implementation method, drawing multiple cells in a designer to form a table includes: constructing a first panel in the designer, the first panel is used to set the background color of the cell; constructing a second panel on the first panel, the second panel is used to draw the cell; constructing a wireframe canvas on the second panel, the wireframe canvas is used to draw the border of the cell; constructing a floating panel on the wireframe canvas, the floating panel is used to display the cell area selected by the user; and constructing a function panel on the floating panel, the function panel is used to respond to the user's editing operations and data verification.

[0008] In combination with the first aspect, in a possible implementation method, displaying cells in the visible area to form a table interface includes: recycling the cells in the table and storing them in a resource pool; when the table appears in the visible area, loading the corresponding cells from the resource pool and rendering them to form the table interface.

[0009] In combination with the first aspect, in a possible implementation, the analyzer is embedded in the Excel table interface to implement Excel formula calculation, including: the analyzer includes a lexical analyzer and a syntax analyzer; the formula entered in the cell is decomposed into a token sequence by the lexical analyzer; the token sequence is converted into an abstract syntax tree by the syntax analyzer, and the abstract syntax tree is semantically analyzed to check its correctness and validity; the abstract syntax tree is executed to implement the Excel formula.

[0010] In combination with the first aspect, in a possible implementation method, the toolbar integrates the cell type of the cell to expand the content in the cell, and also includes: constructing an abstract class and using it as the base class of the cell to unify the interface of the cell; defining the basic properties and methods of the cell in the abstract class; constructing a designer class and defining the visual representation and interaction logic of the cell in the designer class; packaging the abstract class and the designer class as a plug-in, and integrating them into the toolbar.

[0011] In combination with the first aspect, in a possible implementation method, it also includes: importing the data source directly into the low-code platform; converting the imported data source into a web page and / or a page of an application.

[0012] In combination with the first aspect, in a possible implementation, the cell includes: when no data is stored in the cell, it is a control for fixing the width and height; when data is stored in the cell, a control block for storing the corresponding data is constructed in the cell according to the type of data.

[0013] In the second aspect, an embodiment of the present application provides a development system of a low-code platform based on Excel, including: a designer, used to provide users with an operating interface for business design; generating metadata in response to user operations on the operating interface; wherein the business design includes business interface design and business logic design; an application server, used to parse the metadata, and render the parsing results through a front-end engine to generate accessible web pages and / or applications; respond to user operations on web pages and / or applications based on the metadata, and return the results of the user operations to the user after rendering through the front-end engine; a service manager, used to connect the designer and the application server; receive the metadata generated by the designer, and send it to the application server.

[0014] In combination with the second aspect, in a possible implementation, the service manager also includes: monitoring the operating status of the application server to ensure the stable operation of the web page and / or application; updating, deleting or modifying the web page and / or application in response to user operations; and authenticating and authorizing the user's identity.

[0015] In a third aspect, an embodiment of the present application provides a device, comprising: a processor; a memory for storing processor-executable instructions; when the processor executes the executable instructions, it implements the method described in the first aspect or any possible implementation method of the first aspect.

[0016] One or more technical solutions provided in the embodiments of the present application have at least the following technical effects or advantages: The embodiment of the present application can support users to insert various spaces in cells by drawing multiple cells to form a table in the designer, thereby improving the flexibility of the low-code platform; by simulating the Excel table interface, it can reduce the difficulty of users getting started and shorten the adaptation process; by implementing Excel formula calculations, it can meet the basic needs of users. It effectively solves the problem that the designers of existing low-code platforms have a high learning cost for new users. This application can reduce the difficulty of users getting started and improve the development efficiency and experience of users. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for use in the embodiments of the present application or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0018] Figure 1 A flowchart of a method for developing a low-code platform based on Excel provided in an embodiment of the present application; Figure 2 A flowchart for implementing Excel formula calculations provided in an embodiment of the present application; Figure 3 An example diagram of an Excel spreadsheet interface provided in an embodiment of the present application; Figure 4 An example diagram of cell types provided for embodiments of the present application; Figure 5 An example diagram of an Excel function integrated into an Excel spreadsheet interface provided in an embodiment of the present application; Figure 6 An example diagram of inputting a formula in a cell provided in an embodiment of the present application; Figure 7 An example diagram of filling a formula in a cell provided in an embodiment of the present application; Figure 8 A computing example diagram running on a browser provided in an embodiment of the present application; Fig. 9 An example diagram of a button provided in an embodiment of the present application; Fig.10 Another example diagram of a button provided in an embodiment of the present application; Fig.11 An example diagram of a toolbar of an Excel spreadsheet interface provided in an embodiment of the present application; Fig.12 An example diagram of an abstract syntax tree provided in an embodiment of the present application; Fig.13 A system block diagram of a development system based on an Excel low-code platform provided in an embodiment of the present application. DETAILED DESCRIPTION

[0019] The technical solutions in the embodiments of the present application will be described clearly and completely below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0020] The following describes some of the techniques involved in the embodiments of the present application to facilitate understanding, and they should be considered as merely exemplary. Therefore, it should be appreciated by those of ordinary skill in the art that various changes and modifications may be made to the embodiments described herein without departing from the scope and spirit of the present application. Similarly, for the sake of clarity and conciseness, some descriptions of well-known functions and structures are omitted in the following description.

[0021] The server functions of the existing low-code platforms are similar to those in this patent. The biggest difference between the platforms is the designer part. As shown in the previous section, the designers of many platforms provide a brand new canvas, which takes a long time for users to learn and cannot interact well with Excel, making it difficult to get started. Therefore, this patent also focuses on the designer part, aiming to provide users with the best Excel development experience.

[0022] Figure 1 1 is a flowchart of a method for developing a low-code platform based on Excel provided in an embodiment of the present application, including steps 101 to 104. Among them, Figure 1 This is only an execution order shown in the embodiment of the present application, and does not represent the only execution order of a development method of a low-code platform based on Excel. If the final result can be achieved, Figure 1 The steps shown may be performed in parallel or reversed.

[0023] Step 101: Draw multiple cells in the designer to form a table, and display the cells in the visible area to form a table interface. In an embodiment of the present application, a first panel is constructed in the designer, and the first panel is used to set the background color of the cell. A second panel is constructed on the first panel, and the second panel is used to draw the cell. A wireframe canvas is constructed on the second panel, and the wireframe canvas is used to draw the border of the cell. A floating panel is constructed on the wireframe canvas, and the floating panel is used to display the cell area selected by the user. A function panel is constructed on the floating panel, and the function panel is used to respond to the user's editing operations and data verification.

[0024] Specifically, the cell of the present application is a two-dimensional structure, and the cells in the table are used to store data, and the pixel grid is simulated by adjusting the cell size. The designer of the present application is based on Microsoft's WPF technology. A multi-level structure is built in the designer, and each layer is a panel (Panel) or canvas. Each layer is responsible for processing a certain part of the function, and finally stacked layer by layer to form a complete table. The first panel at the bottom is a floating Panel for drawing the background color, which can set the background color for any position of any cell. The second panel above the first panel is used to draw the cell. When there is no data stored in the cell, it is a control for fixing the width and height. When data is stored in the cell, a control block for storing the corresponding data is built in the cell according to the type of data. For example, when you want to enter text in a cell, a TextBlock (text block) will be built in the cell in real time. Above the second panel is a wireframe canvas, which can be set to a Canvas layer for drawing cell borders. Due to the diversity and complexity of border styles, the drawing of this layer involves a series of optimization algorithms to ensure that borders of different linear shapes can be displayed efficiently. Above the wireframe canvas is a floating panel for displaying the frame of the area selected by the user. For example, when the user performs a multi-select operation, the selection box is realized through the floating panel. In addition, the floating panel can also realize data verification, content editing, floating elements, etc. The specific implementation method will not be repeated here.

[0025] Exemplarily, the SpreadX For WPF component is used to simulate a table, and multiple cells are drawn to form a table. The table in the visible area forms a table interface. In order to optimize performance, only the cells in the visible area are displayed, and the invisible area is added to the resource pool by recycling the elements. When the page scrolls, the cells that are out of sight will be reused in the new part that enters the field of view, and the content of the cells will be stored in the dictionary data structure in the background. Specifically, the cells in the table are recycled and stored in the resource pool. When the table appears in the visible area, the corresponding cells are loaded from the resource pool and rendered to form a table interface.

[0026] Step 102: Introduce the Excel toolbar into the table interface to simulate the Excel table interface. The toolbar integrates the cell type of the cell to expand the content in the cell. In the embodiment of the present application, the Excel toolbar is introduced into the table interface, such as Figure 3 As shown in the figure, the design area of ​​the low-code platform is designed in the style of Excel.

[0027] Excel is the most widely used office software in the world, and it is a tool that almost everyone uses or touches. This application adopts the Excel style design, which can bring a familiar operation experience to users, allowing them to easily transition from Excel to the low-code platform of this application.

[0028] The difference between this application and Excel is that only text-type values ​​can be filled in Excel cells, but low-code development components can be placed in the cells of this application. It supports dozens of the most commonly used cell types, such as buttons, text boxes, check boxes, etc., which are sufficient to meet the daily development needs of users. In addition, a plug-in mechanism is also provided for users to freely customize their own exclusive cell types.

[0029] Data or any control can be placed freely in each cell of this application. Users can insert, delete or merge cells just like operating Excel, switch fonts, set center alignment, adjust row height and column width, expand the page size of the design area, use conditional formatting to set styles, use data validation to verify data, etc.

[0030] like Figure 4 As shown in the figure, it is a list of cell type components provided by the present application. The user can drag a cell area at will and select a component of the corresponding cell type, and the component will eventually be rendered in the design area. Fig. 9 As shown in the figure, a button cell type is selected in an area, and it will eventually be displayed in the design area. Users can also modify the style of the button to change its style, such as setting rounded corners for the button and changing the background color, such as Fig.10 As shown. It can be seen that the design area provided by this application is very free, and users can define plug-in content in any area and any position, which greatly improves flexibility. Usually, another effect brought by flexibility is complexity, but this application not only supports absolute layout model, but also grid layout and adaptive layout.

[0031] In one embodiment of the present application, a plug-in is defined as follows. An abstract class is constructed and used as the base class of cells to unify the interface of cells. Basic properties and methods of cells are defined in the abstract class. A designer class is constructed and the visual representation and interaction logic of cells are defined in the designer class. The abstract class and the designer class are packaged as a plug-in and integrated into the toolbar.

[0032] Specifically, construct the CellType abstract class and use it as the base class for all cells. Define the basic properties of cells (such as validation rules, type name, data type, etc.) and methods (create different subclasses for different types of cells) in the CellType abstract class. The instrument class is the CellTypeDesigner class, which is used to define the visual representation and interaction logic of the cell, that is, define the drawing method of the cell type in the cell, design the style of the cell, and the style of the cell when it is selected or clicked. It is also responsible for managing and displaying the tree structure of CellType. It contains methods for adding, deleting, and modifying nodes of the CellType abstract class, as well as methods for rendering the tree structure preview interface. When the data in the CellTypeDesigner class (such as nodes, attributes, etc.) changes, a redraw operation needs to be triggered to update the preview interface.

[0033] In addition, the main function of Excel is to create various reports, but these reports are often difficult to convert directly into websites. The low-code platform of this application can convert Excel documents into websites with one click based on Excel, greatly improving user productivity and filling the gap in the "Excel to website" function in the low-code field. Fig.11 As shown, the present application can also import the data source directly into the low-code platform, and then convert the imported data source into a page of a web page and / or application.

[0034] Step 103: Embed an analyzer in the Excel table interface to implement Excel formula calculation. In the embodiment of the present application, cells also support the use of Excel formulas, aiming to provide an intuitive and easy-to-use low-code development experience, allowing users to complete tasks efficiently in a familiar environment. Figure 5 As shown in the figure, functions are introduced into the Excel table interface, and the implementation of function calculation is as follows Figure 2 As shown, it includes steps 201 to 204, which are specifically as follows.

[0035] Step 201: Enter a formula. In the embodiment of the present application, two analyzers are included, namely a lexical analyzer and a syntax analyzer. Enter the formula to be calculated in a cell, for example, Figure 6 As shown, enter "=SUM(A1,B1)+$C$3" in cell D1. In addition, Figure 7 As shown, the user can also pull down to use the same logic for all A1:B4 ranges.

[0036] Step 202: Decompose the formula input into the cell into a token sequence by a lexical analyzer. In the embodiment of the present application, a lexical analyzer is used to decompose the input formula into a token sequence.

[0037] Exemplarily, the formula input in step 201 is decomposed into “=: equal sign SUM: function name (: left bracket A1: cell reference,: function parameter separator B1: cell reference): right bracket +: plus sign $C$3: absolute reference of the cell”.

[0038] Step 203: Use a syntax analyzer to convert the tag sequence into an abstract syntax tree. In the embodiment of the present application, the tag sequence is converted into an abstract syntax tree by a syntax analyzer. The abstract syntax tree converted from the tag sequence in step 202 is as follows: Fig.12 shown.

[0039] Step 204: Perform semantic analysis on the abstract syntax tree to check its correctness and validity, and execute the abstract syntax tree. In the embodiment of the present application, the compiler is used to traverse each node of the abstract syntax tree, and perform corresponding semantic checks according to the type of the node. Check whether the variable name or cell reference of each node is valid, whether the function parameters are correct, whether the data type matches, whether the inheritance relationship between classes is legal, etc. If a non-existent cell or function is referenced in the formula, the semantic analyzer will report an error. Exemplarily, Figure 7 The four formulas in are decomposed into an abstract syntax tree and the abstract syntax tree is executed. The running results are as follows Figure 8 shown.

[0040] Step 104: Parse the Excel spreadsheet interface and analyzer into a page file, and publish it to the server after debugging to generate a low-code platform. In the embodiment of the present application, the designed content will eventually be stored in multiple JSON files, and the user can debug the designed Web service locally. After multiple debugging, it will be deployed to the application server to provide services online.

[0041] When deployed and run, these JSON files will be passed to the application server. The application server of this application is an Asp.Net 6 website, which can parse the resource files at design time and ultimately render them into final web pages and / or applications to generate a low-code platform.

[0042] like Fig.13 As shown, the present application also provides a development system for a low-code platform based on Excel, including a designer, an application server and a service manager, as follows.

[0043] The designer is used to provide the user with an operation interface for business design. Metadata is generated in response to the user's operation on the operation interface. The business design includes business interface design and business logic design.

[0044] In the embodiment of the present application, the designer is implemented based on Microsoft's WPF technology. WPF is a Windows desktop application development technology stack, so the core principle of the designer relies on various controls in WPF.

[0045] It should be noted that the operation interface in the low-code platform development stage refers to the interface design of the low-code platform, providing developers with a visual programming interface and an interactive design interface. The user's operations in the designer are then passed to the application server for data processing. After the low-code platform is developed, the operation interface is an Excel spreadsheet interface where users can quickly build a user interface that meets business needs by dragging, configuring, and other methods. The interface elements in the Excel spreadsheet interface include but are not limited to buttons, text boxes, drop-down menus, and the like. Users can choose appropriate interface elements for combination and layout according to their business scenarios, thereby creating a business interface that is both beautiful and practical, and realizing their business design. The designer generates metadata based on the user's drag and drop operations, and sends it to the application server through the service manager.

[0046] The application server is used to parse the metadata and render the parsed results through the front-end engine to generate accessible web pages and / or applications. Respond to the user's operations on the web pages and / or applications based on the metadata, and return the results of the user's operations to the user after rendering through the front-end engine. In the embodiment of the present application, the application server exemplarily adopts the Web service of Asp.Net 6 (a cross-platform, open source development framework launched by Microsoft), which itself supports cross-platform and is a carrier server for user services. Its core function is to parse the metadata designed by the designer, render it through the front-end engine, and provide services.

[0047] The application server parses the metadata and converts it into a format that the front-end engine can understand and process, such as JSON format, XML format, etc. The front-end engine renders the parsing results into a visual front-end interface. Multiple front-end interfaces constitute web pages and / or applications and are published on the browser. Users can access web pages and / or applications to operate them. The application server can respond to user operations and perform corresponding data processing. The front-end engine renders the data processing results and returns them to the user.

[0048] The service manager is used to connect the designer and the application server; receive the metadata generated by the designer and send it to the application server.

[0049] In addition, the service manager is also used to monitor the operating status of the application server to ensure the stable operation of the web page and / or application; or to update, delete or modify the web page and / or application in response to user operations; or to verify and authorize the user's identity.

[0050] Specifically, the service manager is responsible for establishing and maintaining the communication connection between the designer and the application server, ensuring the stability and reliability of the connection, and handling network fluctuations and abnormal situations. The service manager can also provide user information services and application management, operation, and licensing services. It ensures that only authorized users and systems can access or transmit data, and opens specific permissions to them based on the user's identity. It also monitors key performance indicators such as CPU usage, memory usage, disk space, network traffic, etc., performs health checks regularly to ensure the normal operation and responsiveness of the application server, and collects and analyzes system logs to promptly detect and diagnose problems.

[0051] Although the present application provides method operation steps as described in the embodiments or flowcharts, more or fewer operation steps may be included based on conventional or non-creative labor. The order of steps listed in this embodiment is only one way of executing the order of many steps and does not represent the only execution order. When the actual device or client product is executed, it can be executed in sequence or in parallel according to the method shown in this embodiment or the accompanying drawings (for example, in a parallel processor or multi-threaded processing environment).

[0052] The method, system or module described in this application can be implemented in the form of a computer-readable program code. The controller can be implemented in any appropriate manner. For example, the controller can take the form of a microprocessor or processor and a computer-readable medium storing a computer-readable program code (such as software or firmware) that can be executed by the (micro)processor, a logic gate, a switch, an application-specific integrated circuit (English: Application Specific Integrated Circuit; Abbreviation: ASIC), a programmable logic controller and an embedded microcontroller. Examples of controllers include but are not limited to the following microcontrollers: ARC 625D, Atmel AT91SAM, Microchip PIC18F26K20 and Silicone Labs C8051F320. The memory controller can also be implemented as part of the control logic of the memory. Those skilled in the art also know that in addition to implementing the controller in a purely computer-readable program code, the controller can be implemented in the form of a logic gate, a switch, an application-specific integrated circuit, a programmable logic controller and an embedded microcontroller by logically programming the method steps. Therefore, this controller can be considered as a hardware component, and the devices included in it for implementing various functions can also be regarded as structures within the hardware component. Or even, the means for realizing various functions may be regarded as both a software module for realizing the method and a structure within a hardware component.

[0053] An embodiment of the present application further provides a device, comprising: a processor; a memory for storing processor executable instructions; when the processor executes the executable instructions, the method described in the embodiment of the present application is implemented.

[0054] In addition, each functional module in each embodiment of the present invention may be integrated into one processing module, or each module may exist independently, or two or more modules may be integrated into one module.

[0055] The above storage media include but are not limited to random access memory (RAM), read-only memory (ROM), cache, hard disk drive (HDD) or memory card. The memory can be used to store computer program instructions.

[0056] It can be seen from the description of the above implementation methods that those skilled in the art can clearly understand that the present application can be implemented by means of software plus necessary hardware. Based on this understanding, the technical solution of the present application can be essentially or partly reflected in the prior art in the form of a software product, or it can be reflected in the implementation process of data migration. The computer software product can be stored in a storage medium, such as ROM / RAM, a magnetic disk, an optical disk, etc., including a number of instructions for a computer device (which can be a personal computer, a mobile terminal, a server, or a network device, etc.) to execute the methods described in the various embodiments of the present application or certain parts of the embodiments.

[0057] The various embodiments in this specification are described in a progressive manner, and the same or similar parts between the various embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. All or part of this application can be used in many general or special computer system environments or configurations. For example: personal computers, server computers, handheld devices or portable devices, tablet devices, mobile communication terminals, multi-processor systems, microprocessor-based systems, programmable electronic devices, network PCs, minicomputers, mainframe computers, distributed computing environments including any of the above systems or devices, etc.

[0058] The above embodiments are only used to illustrate the technical solutions of the present application, rather than to limit the present application. Although the present application has been described in detail with reference to the aforementioned embodiments, a person of ordinary skill in the art should understand that the technical solutions described in the aforementioned embodiments may still be modified, or some or all of the technical features thereof may be replaced by equivalents. However, these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the present application.

Claims

1. A method for developing a low-code platform based on Excel, characterized in that: include: Draw multiple cells in the designer to form a table, and display the cells in the visible area to form a table interface; Introducing an Excel toolbar into the table interface to simulate an Excel table interface; wherein the toolbar integrates the cell type of the cell to expand the content in the cell; Embedding an analyzer in the Excel table interface to implement Excel formula calculation; The Excel spreadsheet interface and the analyzer are parsed into page files, which are debugged and published to the server to generate a low-code platform.

2. The method according to claim 1, characterized in that Drawing a plurality of cells in the designer to form a table includes: Constructing a first panel in a designer, wherein the first panel is used to set a background color of a cell; Building a second panel on the first panel, the second panel being used for drawing cells; Building a wireframe canvas on the second panel, wherein the wireframe canvas is used to draw the border of the cell; Building a floating panel on the wireframe canvas, wherein the floating panel is used to display the cell area selected by the user; A function panel is constructed on the floating panel, and the function panel is used to respond to user editing operations and data verification.

3. The method according to claim 1, characterized in that The step of displaying cells in the visible area to form a table interface includes: Recycle the cells in the table and store them in the resource pool; When a table appears in the visible area, corresponding cells are loaded from the resource pool and rendered to form the table interface.

4. The method according to claim 1, characterized in that: The embedding of an analyzer in the Excel table interface to implement Excel formula calculation includes: The analyzer includes a lexical analyzer and a grammatical analyzer; The formula entered in the cell is broken down into a sequence of tokens by a lexical analyzer; Converting the tag sequence into an abstract syntax tree using a syntax analyzer, and performing semantic analysis on the abstract syntax tree to check its correctness and validity; The abstract syntax tree is executed to implement the Excel formula.

5. The method according to claim 1, characterized in that The toolbar integrates the cell type of the cell to expand the content in the cell, and also includes: Construct an abstract class and use it as the base class of cells to unify the interface of cells; Define the basic properties and methods of the cell in the abstract class; Building a designer class and defining the visual representation and interaction logic of the cell in the designer class; The abstract class and the designer class are packaged as a plug-in and integrated into the toolbar.

6. The method according to claim 1, characterized in that Also includes: Importing data sources directly into the low-code platform; Convert an imported data source into a web page and / or a page of an app.

7. The method according to claim 2, characterized in that The cell comprises: When there is no data stored in the cell, it is a control for fixing the width and height; When data is stored in a cell, a control block for storing the corresponding data is constructed in the cell according to the type of the data.

8. A development system based on a low-code platform of Excel, used to implement the method described in any one of claims 1 to 6, characterized in that: include: Designer, used to provide users with an operation interface for business design; generating metadata in response to the user's operation on the operation interface; wherein the business design includes business interface design and business logic design; The application server is used to parse the metadata and render the parsing results through the front-end engine to generate accessible web pages and / or applications; respond to user operations on the web pages and / or applications based on the metadata, and return the results of the user operations to the user after rendering through the front-end engine; The service manager is used to connect the designer and the application server; receive the metadata generated by the designer and send it to the application server.

9. The system according to claim 8, characterized in that The service manager further includes: Monitor the running status of the application server to ensure stable operation of the web page and / or application; Update, delete or modify web pages and / or applications in response to user operations; Used to authenticate and authorize the user.

10. A device for executing a development method of a low-code platform based on Excel, characterized in that: include: processor; a memory for storing processor-executable instructions; When the processor executes the executable instructions, the method according to any one of claims 1 to 7 is implemented.

Images