A development method, system and device for a low-code platform based on Excel

Abstract

The present application discloses a development method, system and device for a low-code platform based on Excel. The method includes: drawing a table composed of multiple cells in a designer and displaying the cells in a visual area to form a table interface; introducing the toolbar of Excel in the table interface to simulate the Excel table interface; wherein, the cell types of the cells are integrated in the toolbar to expand the content in the cells; 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, debugging it and then publishing it to a server to generate a low-code platform. It solves the problem that the designers of existing low-code platforms have a relatively high learning cost for new users. The present application can reduce the difficulty for users to get started and improve the development efficiency and experience of users.

Description

Technical Field

[0001] This application relates to the technical field of low-code development, and particularly relates 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 designed to simplify the application development process, enabling developers to design and develop applications in a more efficient and intuitive manner. It allows developers to quickly build applications through a graphical user interface and configuration rather than traditional manual coding. Such platforms usually provide rich prefabricated modules and components, as well as powerful logic orchestration capabilities.

[0003] Currently, there are many products on the market for low-code platforms. 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, all used to deploy the final running products, but the designer sides have their own advantages. For example: for custom forms, the core of its designer is a form submission page, and users can only drag and drop controls at fixed positions or in a fixed order to define the elements and content of the form. For custom canvas forms, it is more flexible than pure forms. Users can drag and drop the form positions arbitrarily, but generally still within a canvas, and 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 freely place controls to combine the functions of application services rather than just a single form submission.

[0004] However, whether using forms or custom canvases, the designers of low-code platforms have a relatively high learning cost for new users. For users without any development experience, they may have no understanding of professional development concepts such as forms, controls, and lists at all, so it is very 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 design using built-in components and cannot meet the requirements of many specific scenarios. Summary of the Invention

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

[0006] In a first aspect, an embodiment of the present application provides a development method for a low-code platform based on Excel, including: drawing a table composed of multiple cells in a designer and displaying the cells in a visual area to form a table interface; introducing the toolbar of Excel in the table interface to simulate the Excel table interface; wherein, the cell types of the cells are integrated in the toolbar to expand the content in the cells; 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, debugging it, and then publishing it to a server to generate a low-code platform.

[0007] In combination with the first aspect, in a possible implementation manner, the step of drawing a table composed of multiple cells in a designer includes: constructing a first panel in the designer, where the first panel is used to set the background color of the cells; constructing a second panel above the first panel, where the second panel is used to draw the cells; constructing a wireframe canvas above the second panel, where the wireframe canvas is used to draw the borders of the cells; constructing a floating panel above the wireframe canvas, where the floating panel is used to display the cell area selected by the user; constructing a function panel above the floating panel, where 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 manner, the step of displaying cells in a visual 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 visual 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 manner, the step of embedding an analyzer in the Excel table interface to implement Excel formula calculation includes: the analyzer includes a lexical analyzer and a syntax analyzer; decomposing the formula input in the cell into a token sequence through the lexical analyzer; using the syntax analyzer to convert the token sequence into an abstract syntax tree, and performing semantic analysis on the abstract syntax tree to check its correctness and validity; executing the abstract syntax tree to implement the Excel formula.

[0010] In combination with the first aspect, in a possible implementation manner, the step that the cell types of the cells are integrated in the toolbar to expand the content in the cells further includes: constructing an abstract class and using it as the base class of the cells to unify the interfaces of the cells; defining the basic attributes and methods of the cells in the abstract class; constructing a designer class and defining the visual representation and interaction logic of the cells in the designer class; packaging the abstract class and the designer class into a plugin and integrating it into the toolbar.

[0011] In combination with the first aspect, in a possible implementation, it further includes: directly importing a data source 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 the data.

[0013] In a second aspect, an embodiment of the present application provides a development system for a low-code platform based on Excel, including: a designer for providing an operation interface for business design to a user; generating metadata in response to an operation of the user on the operation interface; wherein, the business design includes business interface design and business logic design; an application server for parsing the metadata and rendering the parsing result into an accessible web page and / or application through a front-end engine; responding to an operation of the user on the web page and / or application based on the metadata, and returning the result of the user operation to the user after rendering through the front-end engine; a service manager for connecting the designer and the application server; receiving the metadata generated by the designer and sending it to the application server.

[0014] In combination with the second aspect, in a possible implementation, the service manager further includes: monitoring the running state 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 a user operation; and authenticating and authorizing the identity of the user.

[0015] In a third aspect, an embodiment of the present application provides a device, the device includes: a processor; a memory for storing executable instructions executable by the processor; when the processor executes the executable instructions, the method described in the first aspect or any possible implementation manner of the first aspect is implemented.

[0016] One or more technical solutions provided in the embodiments of the present application have at least the following technical effects or advantages:

[0017] In the embodiment of the present application, by drawing a plurality of cells in a designer to form a table, it is possible to support a user to insert various spaces in the cells, improving the flexibility of the low-code platform; by simulating the Excel table interface, it is possible to reduce the difficulty for a user to get started and shorten the adaptation process; by implementing Excel formula calculation, it is possible to meet the basic needs of the user. It effectively solves the problem that the designer of the existing low-code platform has a relatively high learning cost for new users. The present application can reduce the difficulty for a user to get started and improve the development efficiency and experience of the user. BRIEF DESCRIPTION OF THE DRAWINGS

[0018] To more clearly illustrate the technical solutions of the embodiments of the present application, the following will briefly introduce the drawings required for the description of the embodiments of the present application or the prior art. Obviously, the drawings in the following description are some embodiments of the present invention. For those of ordinary skill in the art, without creative efforts, other drawings can also be obtained based on these drawings.

[0019] Figure 1 It is a flowchart of a development method for a low-code platform based on Excel provided by an embodiment of the present application;

[0020] Figure 2 It is a flowchart for implementing Excel formula calculation provided by an embodiment of the present application;

[0021] Figure 3 It is an example diagram of an Excel table interface provided by an embodiment of the present application;

[0022] Figure 4 It is an example diagram of cell types provided by an embodiment of the present application;

[0023] Figure 5 It is an example diagram of Excel functions integrated in the Excel table interface provided by an embodiment of the present application;

[0024] Figure 6 It is an example diagram of entering a formula in a cell provided by an embodiment of the present application;

[0025] Figure 7 It is an example diagram of filling a formula in a cell provided by an embodiment of the present application;

[0026] Figure 8 It is an example diagram of a calculation running on the browser side provided by an embodiment of the present application;

[0027] Figure 9 It is an example diagram of a button provided by an embodiment of the present application;

[0028] Figure 10 It is another example diagram of a button provided by an embodiment of the present application;

[0029] Figure 11 It is an example diagram of a toolbar of an Excel table interface provided by an embodiment of the present application;

[0030] Figure 12 It is an example diagram of an abstract syntax tree provided by an embodiment of the present application;

[0031] Figure 13 It is a system block diagram of a development system for a low-code platform based on Excel provided by an embodiment of the present application. Detailed Implementation Manner

[0032] Next, the technical solutions in the embodiments of the present application will be clearly and completely described in conjunction with the accompanying drawings in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present invention, rather than all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of the present invention.

[0033] The following explanations are made for some of the technologies involved in the embodiments of the present application to facilitate understanding. It should be considered that they are only exemplary. Therefore, those of ordinary skill in the art should recognize that various changes and modifications can 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.

[0034] The server functions of existing low-code platforms are more or less the same as those of this patent. The biggest difference between platforms lies in the designer part. As shown in the previous subsection, the designers of many platforms provide a completely new canvas, which takes users a long time to learn and cannot interact well with Excel, making it difficult to get started. Therefore, this patent also mainly focuses on the designer part, aiming to present the best Excel development experience for users.

[0035] Figure 1 is a flowchart of a development method for a low-code platform based on Excel provided by 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 for a low-code platform based on Excel. Under the condition that the final result can be achieved, Figure 1 the steps shown can be executed in parallel or reversed.

[0036] 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 the 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 cells. A second panel is constructed above the first panel, and the second panel is used to draw the cells. A wireframe canvas is constructed above the second panel, and the wireframe canvas is used to draw the borders of the cells. A floating panel is constructed above the wireframe canvas, and the floating panel is used to display the cell area selected by the user. A function panel is constructed above the floating panel, and the function panel is used to respond to the user's editing operations and data verification.

[0037] Specifically, the cells of this application are two-dimensional structures. The cells in the table are used to store data, and the pixel grid is simulated by adjusting the cell size. The designer of this application is based on Microsoft's WPF technology, and a multi-layer structure is constructed in the designer. Each layer is a panel or a canvas. Each layer is responsible for processing a certain part of the function, and finally, through stacking layer by layer, a complete table is formed. The first panel at the bottom layer is a floating Panel for drawing the background color, and the background color can be set at any position of any cell. The second panel above the first panel is used to draw cells. 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 constructed in the cell according to the type of data. For example, when text is to be input into a cell, a TextBlock (text block) is constructed in the cell in real time. Above the second panel is the wireframe canvas, which can be set as a Canvas layer for drawing cell borders. Since the border styles are diverse and complex, the drawing of this layer involves a series of optimization algorithms to ensure the efficient display of different line-shaped borders. Above the wireframe canvas is the floating panel, which is used to display the frame of the selected area by the user. Exemplarily, when the user performs a multi-selection operation, the selection box is implemented through the floating panel. In addition, the floating panel can also implement data verification, content editing, floating elements, etc. The specific implementation methods are not elaborated here.

[0038] Exemplarily, the SpreadX For WPF component is used to simulate a table, draw multiple cells arranged to form a table, and the table in the visible area forms a table interface. To optimize performance, only the cells in the visible area are displayed, and the invisible area will be recycled by adding elements to the resource pool. When the page scrolls, the cells that move out of sight will be reused in the newly entered part of the field of view, and the content of the cells will be stored in the background dictionary data structure. 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.

[0039] Step 102: Introduce the Excel toolbar into the table interface to simulate the Excel table interface. Among them, the cell types of the cells are integrated in the toolbar to expand the content in the cells. In the embodiment of this application, the Excel toolbar is introduced into the table interface. As Figure 3 shown, the design area of the low-code platform is designed in the style of Excel.

[0040] Excel is the most widely used office software globally and is a tool that almost everyone uses or comes into contact with. This application adopts the Excel-style design, which can bring a familiar operation experience to users, enabling them to easily transition from Excel to the low-code platform of this application.

[0041] The difference between this application and Excel is that only text-type values can be filled in the cells of Excel, but the cells of this application can place low-code development components. 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 specifically provided for users to freely customize their exclusive cell types.

[0042] In each cell of this application, data or any control can be freely placed. Users can insert, delete, or merge cells just like operating Excel, and can also switch fonts, set center alignment, adjust row heights and column widths, expand the page size of the design area, set styles using conditional formatting, and verify data using data validation.

[0043] As Figure 4 shown, it is a component list of the cell types provided by this application. Users can drag a cell area at will and select the components of the corresponding cell type, and finally the component will be rendered in the design area. Exemplarily, as Figure 9 shown, the button cell type is selected in an area and will finally be displayed in the design area. Users can also modify the style drawing of the button to change its style. For example, the button can be set to have rounded corners and the background color can be changed, as Figure 10 shown. Thus, it can be seen that the design area provided by this application is very free. Users can define the plug-in content at any area and any position, greatly improving flexibility. Usually, another effect brought by flexibility is complexity, but this application not only supports the absolute layout model, but also can use grid layout and adaptive layout.

[0044] In an embodiment of this application, a plug-in is defined as follows. An abstract class is constructed and used as the base class of the cell to unify the interfaces of the cells. The basic attributes and methods of the cell are defined in the abstract class. A designer class is constructed, and the visual representation and interaction logic of the cell are defined in the designer class. The abstract class and the designer class are packaged as a plug-in and integrated into the toolbar.

[0045] Specifically, construct the CellType abstract class, which serves as the base class for all cells. Define the basic attributes (such as validation rules, type names, data types, etc.) and methods (create different subclasses for different types of cells) of the cells in the CellType abstract class. The designer class is the CellTypeDesigner class, which is used to define the visual representation and interaction logic of the cells, that is, define how the cell types are drawn in the cells, design the styles of the cells, and the styles of the cells in the selected or clicked state. 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 preview interface of the tree structure. When the data (such as nodes, attributes, etc.) in the CellTypeDesigner class changes, a redrawing operation needs to be triggered to update the preview interface.

[0046] In addition, the main function of Excel is to create various reports, but these reports are often difficult to be directly converted into websites. The low-code platform of this application can realize the one-key conversion of Excel documents into websites based on Excel, greatly improving the productivity of users, and at the same time filling the gap in the "Excel to website" function in the low-code field. As Figure 11 shown, this application can also directly import the data source into the low-code platform, and then convert the imported data source into a web page and / or a page of an application.

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

[0048] Step 201: Input the formula. In the embodiment of this application, there are two analyzers, namely the lexical analyzer and the syntax analyzer. Enter the formula to be calculated in the cell. Exemplarily, as Figure 6 shown, enter "=SUM(A1,B1)+$C$3" in cell D1. In addition, as Figure 7 shown, the user can also pull down to apply the same logic to all of the A1:B4 area.

[0049] Step 202: Decompose the formula entered in the cell into a token sequence through the lexical analyzer. In the embodiment of this application, the input formula is decomposed into a token sequence by using the lexical analyzer.

[0050] Exemplarily, decompose the formula input in step 201 into "=: equal sign, SUM: function name, (: left parenthesis, A1: cell reference, : function parameter separator, B1: cell reference, ): right parenthesis, +: plus sign, $C$3: absolute reference of a cell".

[0051] Step 203: Use a parser to convert the token sequence into an abstract syntax tree. In the embodiment of the present application, convert the token sequence into an abstract syntax tree through a parser. The abstract syntax tree converted from the token sequence in step 202 is as Figure 12 shown.

[0052] 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, use a compiler 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 names or cell references of each node are valid, whether the function parameters are correct, whether the data types match, whether the inheritance relationship between classes is legal, etc. If the formula references non-existent cells or functions, the semantic analyzer will report an error. Exemplarily, decompose the four formulas in Figure 7 into an abstract syntax tree and execute the abstract syntax tree. The running results are as Figure 8 shown.

[0053] Step 104: Parse the Excel table interface and the analyzer into a page file, debug it, and then publish it to the server to generate a low-code platform. In the embodiment of the present application, the designed content will ultimately be stored in multiple JSON files. Users can debug the designed web service locally. After multiple debugging sessions are completed, deploy it to the application server to go live and provide services.

[0054] During deployment and operation, these JSON files will be passed to the application server. The application server of the present application is a web site of Asp.Net 6, which can parse the resource files at design time and finally render them into the final web page and / or application, thereby generating a low-code platform.

[0055] As Figure 13 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.

[0056] The designer is used to provide an operation interface for business design for users. Generate metadata in response to the operations of users on the operation interface. Among them, business design includes business interface design and business logic design.

[0057] In the embodiments of the present application, the designer is implemented based on Microsoft's WPF technology. WPF is a technology stack for Windows desktop application development. Therefore, the core principle of the designer depends on various controls in WPF.

[0058] It should be noted that during the development stage of the low-code platform, the operation interface refers to the implementation of the interface design of the low-code platform, providing a visual programming interface and an interaction design interface for developers. Then, the operations of the user in the designer are transmitted to the application server for data processing. After the low-code platform is developed, the operation interface is an Excel spreadsheet interface through which users can quickly build a user interface that meets business requirements by means of dragging, configuration, etc. The interface elements in the Excel spreadsheet interface include, but are not limited to, buttons, text boxes, drop-down menus, etc. Users can select appropriate interface elements according to their business scenarios for combination and layout, so as to create a beautiful and practical business interface and realize their business design. The designer generates metadata based on the user's drag operations and sends it to the application server through the service manager.

[0059] The application server is used to parse the metadata and render the parsing result through the front-end engine to generate an accessible web page and / or application. Respond to the operations of the user on the web page and / or application based on the metadata, and render the results of the user operations through the front-end engine and return them to the user. In the embodiments of the present application, the application server exemplarily adopts a Web service of Asp.Net 6 (a cross-platform and open-source development framework launched by Microsoft). It supports cross-platform by itself and is the carrier server of user services. Its core function is to parse the metadata designed by the designer, render it through the front-end engine, and provide services.

[0060] The application server converts the parsed metadata 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 result into a visual front-end interface, and multiple front-end interfaces constitute a web page and / or application, which are published in a browser. Users can access the web page and / or application to operate on it. The application server can respond to the operations of the user and perform corresponding data processing, and render the results of the data processing through the front-end engine and return them to the user.

[0061] 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.

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

[0063] 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 anomalies. The service manager can also provide user information services, application management, operation, and licensing services. It ensures that only authorized users and systems can access or transmit data and opens specific permissions based on the user's identity. It also monitors key performance indicators such as CPU usage, memory occupancy, disk space, and network traffic, performs health checks regularly to ensure the normal operation and responsiveness of the application server, and collects and analyzes system logs to detect and diagnose problems in a timely manner.

[0064] Although this application provides method operation steps as described in the embodiments or flowcharts, more or fewer operation steps may be included based on routine or non-creative labor. The step order listed in this embodiment is only one way among the execution orders of numerous steps and does not represent the only execution order. When the actual device or client product is executed, it can be executed in the method order shown in this embodiment or the accompanying drawings or in parallel (for example, in an environment with parallel processors or multi-threaded processing).

[0065] The methods, systems, or modules described in this application can be implemented in the form of 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 a processor, a computer-readable medium storing computer-readable program code (such as software or firmware) executable by the (micro)processor, logic gates, switches, application specific integrated circuits (ASICs), programmable logic controllers, and embedded microcontrollers. 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 the form of pure computer-readable program code, the method steps can be logically programmed to enable the controller to be implemented in the form of logic gates, switches, application specific integrated circuits, programmable logic controllers, and embedded microcontrollers to achieve the same function. Therefore, such a controller can be considered a hardware component, and the devices included therein for implementing various functions can also be regarded as the structures within the hardware component. Or even, the devices for implementing various functions can be regarded as both software modules for implementing the method and the structures within the hardware component.

[0066] The embodiments of the present application also provide a device, which includes: a processor; a memory for storing executable instructions that can be executed by the processor; when the processor executes the executable instructions, the method described in the embodiments of the present application is implemented.

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

[0068] The above storage medium includes but is 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.

[0069] From the description of the above embodiments, those skilled in the art can clearly understand that the present application can be implemented by means of software plus necessary hardware. Based on such an understanding, the technical solution of the present application, in essence, or the part that contributes to the prior art, can be embodied in the form of a software product, or can also be reflected in the implementation process of data migration. This computer software product can be stored in a storage medium, such as ROM / RAM, magnetic disk, optical disc, etc., and includes several instructions for causing a computer device (which can be a personal computer, a mobile terminal, a server, or a network device, etc.) to execute the method described in each embodiment or some parts of the embodiments of the present application.

[0070] The various embodiments in this specification are described in a progressive manner. For the same or similar parts between the various embodiments, reference can be made to each other. Each embodiment focuses on the differences from other embodiments. All or part of the present application can be used in many general or special computer system environments or configurations. For example: personal computers, server computers, handheld 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, and so on.

[0071] The above embodiments are only used to illustrate the technical solutions of the present application, rather than limiting the present application; although the present application has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that they can still modify the technical solutions described in the foregoing embodiments, or perform equivalent replacements on some or all of the technical features; and 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 a plurality of cells in the designer to form a table, and display the cells in the visible area to form a table interface, including: draw a plurality of cells in the designer to form a table, the table in the visible area forms a table interface, only display the cells in the visible area, and the invisible area will be added to the resource pool by recycling the elements. When the table appears in the visible area, the corresponding cells are loaded from the resource pool and rendered to form a table interface to optimize performance; when the page scrolls, the cells that are out of sight are reused in the new part that enters the field of view, and the content of the cells is stored in the dictionary data structure in the background; wherein, drawing a plurality of cells in the 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; constructing a function panel on the floating panel, the function panel is used to respond to the user's editing operation and data verification; Wherein, 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; Introducing an Excel toolbar into the table interface to simulate an Excel table interface; wherein the toolbar integrates the cell type of 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 a page file, and published to the server after debugging to generate a low-code platform to realize one-click conversion of the Excel document into a Web site.

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

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

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

5. A development system based on a low-code platform of Excel, used to implement the method described in any one of claims 1 to 4, 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.

6. The system according to claim 5, 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.

7. 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 4 is implemented.

Images