CN115629750B - Server visual programming method and system supporting Excel formula - Google Patents
Server visual programming method and system supporting Excel formula Download PDFInfo
- Publication number
- CN115629750B CN115629750B CN202211667843.8A CN202211667843A CN115629750B CN 115629750 B CN115629750 B CN 115629750B CN 202211667843 A CN202211667843 A CN 202211667843A CN 115629750 B CN115629750 B CN 115629750B
- Authority
- CN
- China
- Prior art keywords
- low
- formula
- server
- information
- code platform
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/34—Graphical or visual programming
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Stored Programmes (AREA)
Abstract
The application discloses a server visual programming method and system supporting an Excel formula, and the method comprises the following steps: the method comprises the steps that a low code platform sends request information to a server, wherein the request information comprises an Excel formula request; the low-code platform displays execution information transmitted by the server aiming at the request information, wherein the execution information comprises Excel formula content; and the low-code platform displays the result information of the execution information operation by means of a browser, wherein the result information is the operation result of the execution information. The system comprises a front-end low-code platform, a rear-end server and a user side browser, wherein the Excel formula and visual programming are combined together on the low-code development platform, the problem of high threshold of development technical requirements in the prior art is solved, the development efficiency is improved, and the development difficulty is reduced.
Description
Technical Field
The application relates to the technical field of low code development, in particular to a service end visual programming method and system supporting an Excel formula.
Background
The low-code development platform consists of a visual designer and a server, so that developers and business personnel can quickly construct attractive and easy-to-use Web application programs, the personalized management requirements of enterprises are met, and the requirements are changed as required. The user can flexibly drag each graphical control, construct a business process, a logic and data model and the like, and realize each function required by the enterprise information system.
When the existing low-code development platform constructs the Web application program, graphical server programming and programming language are mostly adopted for graphical convenience for developers to use. However, given the abstract of the programming language, even if translated into graphs, it is still necessary for some simple computations to be performed graphically by the developer himself.
Excel is spreadsheet software written by a computer, and has an intuitive interface, excellent computing function and a diagram tool, so that Excel becomes a master of data processing software of a personal computer. The Excel can be used for manufacturing various models, and the models in the Excel software can be rapidly converted and share data.
In order to improve development efficiency and reduce the threshold of development technical requirements, how to enable developers to further simplify graphical programming through an Excel formula becomes a low-code development problem to be solved urgently.
Disclosure of Invention
The embodiment of the application combines the Excel formula and the visual programming together on a low-code development platform by providing the server visual programming method and system supporting the Excel formula, solves the problem of high threshold of development technical requirements in the prior art, improves the development efficiency, and reduces the development difficulty.
In a first aspect, an embodiment of the present invention provides a server visual programming method supporting an Excel formula, including:
the method comprises the steps that a low-code platform sends request information to a server, wherein the request information comprises an Excel formula request;
the low-code platform displays execution information transmitted by the server aiming at the request information, wherein the execution information comprises Excel formula content;
and the low-code platform displays result information of the execution information operation by means of a browser, wherein the result information is an operation result executed by the execution information.
In practical application, the request information of the invention comprises the permission information of the low-code platform, the address information of the low-code platform, the name information of the server command in the low-code platform and the command information of the server command in the low-code platform besides the Excel formula request. It should be noted that the low code platform of the embodiment of the present invention sends request information for invoking a server command to a server, where the request information includes permission information, address information, name information, and command information, and the command information includes an Excel formula; the low-code platform acquires visual resources of a server command; and the low-code platform runs the visualization resource and displays the content corresponding to the command information in the browser.
Further, the low-code platform sends request information for calling the server-side command to the server, and the request information comprises: creating a server command module on a low-code platform; editing a command request according to a prompt of a server command module, wherein the command request comprises a command name, command parameters, command elements and a return value, and the command name and the command parameters are necessary requests; triggering a exporting task of a server command, and exporting a command request into name information and command information by the server command; acquiring authority information and address information of a low-code platform; and the low-code platform integrates the name information, the command information, the authority information and the address information into request information and sends the request information to the server. More specifically, in actual use, the command name of the present invention is derived as the command information, and the command parameter, the command element, and the return value of the present invention are derived as the command information. The above-mentioned prompt editing command request according to the server command module includes: selecting a command name at a command interface of a server command module; selecting command parameters, command elements, return values and an Excel formula at an attribute interface of a server command module; the Excel formula comprises input parameters, the input parameters replace fixed values in the Excel formula, and the input parameters are decoupled from actual services of the enterprise information system of the low-code platform to realize multiplexing.
With reference to the first aspect, in a possible implementation manner, the low-code platform sends request information to a server in a first manner or a second manner;
the first mode is as follows: (11) A plurality of cells of the low-code platform are transversely combined into an edit box; (12) The editing frame receives a formula calling instruction and a formula content in sequence, the low-code platform is connected with a formula database of the server according to the formula calling instruction, and the low-code platform generates request information according to the formula content and self-contained information of the low-code platform and sends the request information to the server;
the second way is: (21) triggering a server command of the low-code platform; (22) selecting a formula edit box in the server command; (23) The formula editing frame receives the formula calling instruction and the formula content in sequence, the low-code platform is connected with a formula database of the server according to the formula calling instruction, and the low-code platform generates request information according to the formula content and the self-contained information of the low-code platform and sends the request information to the server.
Of course, the first method may also be: the low code platform comprises a formula calling instruction, a formula database and a low code platform self-contained information, wherein the formula calling instruction and the formula content are sequentially received by an edit box of the low code platform, the low code platform is connected with the formula database of the server according to the formula calling instruction, and the low code platform generates request information according to the formula content and the low code platform self-contained information and sends the request information to the server.
With reference to the first aspect, in a possible implementation manner, the displaying, by the low-code platform, execution information of the request information transmission by the server includes:
the low code platform calls a cell where the instruction is located according to the formula in the request information, displays Excel formula content transmitted by the server on the cell, and the Excel formula content follows behind the formula calling instruction;
after the cell is selected, a formula input box of the low-code platform displays a formula calling instruction and Excel formula content; if the Excel formula content is a pure expression formula, storing a formula calling instruction and the Excel formula content in a database through a character string, and if the Excel formula content refers to a specific cell of a specific page in the low code platform, storing the formula calling instruction and the Excel formula content in the database through the character string, the specific cell referred by the Excel formula content and a page where the Excel formula content is located;
the formula calling instruction, the Excel formula content, the specific cell referenced by the Excel formula content and the page where the Excel formula content is located are jointly used as execution information, and the execution information is executed on the browser through the running module of the low-code platform.
With reference to the first aspect, in a possible implementation manner, the displaying, by the low-code platform and by means of a browser, result information of the execution information operation includes:
the low code platform receives request page information sent by a browser;
and the low-code platform sends a page to the browser according to the request page information, wherein the page comprises an operation result of the low-code platform running the execution information.
With reference to the first aspect, in a possible implementation manner, the displaying, by the low-code platform, execution information of the request information transmission by the server includes:
the low code platform opens up an interface as an Execute command, and the Execute command is one part of a server command of the low code platform;
one attribute in the server side command is used as a formula edit box, the low code platform displays Excel formula contents transmitted by the server in the formula edit box according to a formula calling instruction in the request information, and the Excel formula contents follow behind the formula calling instruction;
the temporary storage area of the low code platform stores execution information, if the content of the Excel formula is a pure expression formula, a formula calling instruction and the content of the Excel formula in the execution information are stored in the temporary storage area through a character string, and if the content of the Excel formula refers to a specific cell of a specific page in the low code platform, the formula calling instruction and the content of the Excel formula in the execution information are stored in the temporary storage area through the character string, the specific cell referred by the content of the Excel formula and the page where the content of the Excel formula is located;
and executing the execution information in a browser through an operation module of the low-code platform.
The low code platform calls an Execute command of a current traversal item and processes related parameters of the Execute command through a calling interface method, and executes a related parameter processing result; and the low-code platform continues traversing the command list if judging that the processing result of the related parameters is correct.
With reference to the first aspect, in a possible implementation manner, the displaying, by the low-code platform and by means of a browser, result information of the execution information operation includes:
the low-code platform receives request page information sent by a browser;
the low-code platform sends a page to the browser according to the request page information;
the low code platform receives a request for triggering a server side command sent by a browser;
the low code platform checks authority and records logs according to a trigger server side command request, and executes a server side command through a command engine to obtain an execution result;
and the low-code platform sends the execution result to a browser.
With reference to the first aspect, in a possible implementation manner, the requesting, by the low-code platform, an examination authority and a log record according to a trigger server command includes:
the low code platform acquires parameter information in the server side command request, wherein the parameter information comprises a name of a command for executing the server side, input parameters of the command for executing the server side and user information for sending the request of the command for the server side;
the low code platform checks the user authority according to the user information, and if the user does not have corresponding authority, the low code platform ignores the command request of the server; if the corresponding authority is checked, acquiring the name of the command of the execution server and the input parameter of the command of the execution server, and sending the name of the command of the execution server and the input parameter of the command of the execution server to a command engine of the server.
With reference to the first aspect, in a possible implementation manner, the executing, by the low-code platform, the server-side command by the command engine includes:
the low-code platform acquires a command list according to a command request of a server;
the low-code platform executes a first command in the command list, judges that an execution result is correct, and then executes a second command until the command list is traversed;
and after traversing the low-code platform ending command list, checking and processing an abnormal traversing result, and sending the execution result to the browser until all the abnormal traversing results are checked.
In a second aspect, an embodiment of the present invention provides a server-side visual programming system supporting an Excel formula, including a front-end low-code platform, a back-end server, and a client-side browser;
the front-end low-code platform sends first request information to the back-end server, the back-end server sends execution information to the front-end low-code platform after receiving the first request information, and the low-code platform receives and displays the execution information;
the user-side browser sends second request information to the front-end low-code platform, the front-end low-code platform responds to the second request information after checking the authority of the second request information, and the user-side browser displays result information of the execution information operation;
the first request information comprises a request for constructing an Excel formula content, and the second request information comprises a request for running the Excel formula.
One or more technical schemes provided in the embodiments of the present invention have at least the following technical effects or advantages:
according to the embodiment of the invention, the Excel formula and the visual programming are combined together on the low-code development platform, so that the problem of high development technical requirement threshold in the prior art is solved, the development efficiency is improved, and the development difficulty is reduced.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments of the present invention or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without creative efforts.
Fig. 1 is a flowchart of a server-side visual programming method supporting an Excel formula according to an embodiment of the present application;
fig. 2 is a flowchart of a step S120 in the first manner selected in fig. 1 according to an embodiment of the present disclosure;
fig. 3 is a flowchart of a step S130 of fig. 1 in the first manner according to an embodiment of the present disclosure;
fig. 4 is a flowchart of a step S120 of selecting a second manner in fig. 1 according to an embodiment of the present disclosure;
fig. 5 is a flowchart of a step S130 of selecting the second manner in fig. 1 according to an embodiment of the present disclosure;
FIG. 6 is a flowchart illustrating that the low-code platform requests the checking authority and the log recording according to the trigger server command in step S134' of FIG. 5 according to an embodiment of the present application;
FIG. 7 is a flowchart illustrating the low-code platform executing a server command through a command engine in step S134' in FIG. 5 according to an embodiment of the present application;
fig. 8 is a schematic block diagram of a server-side visual programming system supporting an Excel formula according to an embodiment of the present application;
FIG. 9 is a flow chart of Excel formula analysis.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1, an embodiment of the present invention provides a server visual programming method supporting an Excel formula, including:
step S110, the low code platform sends request information to a server, wherein the request information comprises an Excel formula request;
step S120, the low code platform display server displays the execution information transmitted by the request information, wherein the execution information comprises Excel formula content;
step S130, the low-code platform displays result information of executing information operation by using the browser, where the result information is an operation result executed by the executing information.
In practical application, the request information of the invention comprises the Excel formula request, the authority information of the low-code platform, the address information of the low-code platform, the name information of the server side command in the low-code platform and the command information of the server side command in the low-code platform. It should be noted that, the low code platform of the embodiment of the present invention sends request information for invoking a server command to a server, where the request information includes permission information, address information, name information, and command information, and the command information includes an Excel formula; the low-code platform acquires visual resources of the server side command; and the low-code platform runs the visual resources and displays the content corresponding to the command information in the browser.
Further, the low-code platform sends request information for calling the server-side command to the server, and the request information comprises: creating a server command module on a low-code platform; editing a command request according to the prompt of a server command module, wherein the command request comprises a command name, command parameters, command elements and return values, and the command name and the command parameters are necessary requests; triggering a exporting task of a server command, and exporting a command request into name information and command information by the server command; acquiring authority information and address information of a low-code platform; and the low-code platform integrates the name information, the command information, the authority information and the address information into request information and sends the request information to the server. More specifically, in actual use, the command name of the present invention is derived as the command information, and the command parameter, the command element, and the return value of the present invention are derived as the command information. The above-mentioned prompt editing command request according to the server command module includes: selecting a command name at a command interface of a server command module; selecting command parameters, command elements, return values and an Excel formula at an attribute interface of a server command module; the Excel formula comprises input parameters, the input parameters replace fixed values in the Excel formula, and the input parameters are decoupled from actual services of the enterprise information system of the low-code platform to realize multiplexing.
In combination with the first aspect, preferably, the low-code platform sends the request information to the server in a first manner or a second manner;
the first mode is as follows: (11) A plurality of cells of the low-code platform are transversely combined into an edit box; (12) The editing frame receives a formula calling instruction and a formula content in sequence, the low-code platform is connected with a formula database of the server according to the formula calling instruction, and the low-code platform generates request information according to the formula content and self-contained information of the low-code platform and sends the request information to the server;
the second way is: (21) triggering a server command of the low-code platform; (22) selecting a formula edit box in the server command; (23) The formula editing frame receives the formula calling instruction and the formula content in sequence, the low-code platform is connected with the formula database of the server according to the formula calling instruction, and the low-code platform generates request information according to the formula content and the self-contained information of the low-code platform and sends the request information to the server.
Of course, the first method may also be: the editing frame of the low-code platform receives the formula calling instruction and the formula content in sequence, the low-code platform is connected with the formula database of the server according to the formula calling instruction, and the low-code platform generates request information according to the formula content and the self-contained information of the low-code platform and sends the request information to the server.
When the low code platform sends the request information to the server in the first manner, referring to fig. 2, preferably, step S120, where the low code platform displays the execution information of the server for the request information transmission, includes:
step S121, the low code platform calls a cell where the instruction is located according to the formula in the request information, displays Excel formula content transmitted by the server in the cell, and the Excel formula content follows behind the formula calling instruction;
step S122, displaying a formula calling instruction and Excel formula contents on a formula input box of the low-code platform after the cell is selected; if the Excel formula content is a pure expression formula, storing a formula calling instruction and the Excel formula content in a database through a character string, and if the Excel formula content refers to a specific cell of a specific page in a low code platform, storing the formula calling instruction and the Excel formula content in the database through the character string, the specific cell referred by the Excel formula content and a page where the Excel formula content is located;
and S123, taking the formula calling instruction, the Excel formula content, the specific cell quoted by the Excel formula content and the page where the Excel formula content is located as execution information together, and executing the execution information in the browser through the running module of the low-code platform.
When the low-code platform sends the request information to the server in the first manner, referring to fig. 3, preferably, in step S130, the low-code platform displays result information of executing information operation by using a browser, including:
step S131, the low-code platform receives request page information sent by the browser;
and S132, the low-code platform sends a page to the browser according to the request page information, wherein the page comprises an operation result of the low-code platform operation execution information.
When the low code platform sends the request information to the server in the second manner, referring to fig. 4, preferably, step S120, where the low code platform displays the execution information of the server for the request information transmission, includes:
step S121', an interface is opened up by the low-code platform to be used as an Execute command, and the Execute command is one part of a service end command of the low-code platform;
step S122', one attribute in the server side command is used as a formula edit box, the low-code platform displays Excel formula contents transmitted by the server in the formula edit box according to the formula calling instruction in the request information, and the Excel formula contents follow behind the formula calling instruction;
step S123', a temporary storage area of the low code platform stores execution information, if the content of the Excel formula is a pure expression formula, a formula calling instruction and the content of the Excel formula in the execution information are stored in the temporary storage area through character strings, and if the content of the Excel formula refers to a specific cell of a specific page in the low code platform, the formula calling instruction and the content of the Excel formula in the execution information are stored in the temporary storage area through the character strings, the specific cell referred by the content of the Excel formula and the page where the content of the Excel formula is located;
and step S124', executing the execution information in the browser through the running module of the low-code platform.
The low code platform calls an Execute command of a current traversal item through a calling interface method and processes related parameters of the Execute command, and executes a related parameter processing result; and the low-code platform continues traversing the command list if judging that the processing result of the related parameters is correct.
When the low-code platform sends the request message to the server in the second manner, referring to fig. 5, preferably, in step S130, the low-code platform displays result information of executing message operation by means of the browser, including:
s131', the low-code platform receives request page information sent by the browser;
s132', the low-code platform sends a page to the browser according to the request page information;
step S133', the low-code platform receives a trigger service end command request sent by the browser;
step S134', the low code platform checks the authority and records the log according to the trigger server command request, and the low code platform executes the server command through the command engine to obtain an execution result;
in step S135', the low-code platform sends the execution result to the browser.
Referring to fig. 6, in step S134', the low-code platform requests the checking authority and the log recording according to the trigger server command, including:
step S1341', the low code platform obtains parameter information in the server command request, the parameter information comprises a name of the server command, input parameters of the server command, and user information for sending the server command request;
step S1342', the low code platform checks the user authority according to the user information, if no corresponding authority exists, the low code platform ignores the request of the server command; if the corresponding authority is checked, acquiring the name of the command of the execution server and the input parameter of the command of the execution server, and sending the name of the command of the execution server and the input parameter of the command of the execution server to the command engine of the server.
Referring to fig. 7, in step S134', the low-code platform executes the server command through the command engine, including:
step S1343', the low code platform acquires a command list according to the command request of the service terminal;
step S1344', the low code platform executes the first command in the command list and executes the second command until traversing the command list after judging the execution result is correct;
in step S1345', after the low code platform finishes the traversal of the command list, the abnormal traversal result is checked and processed, and the execution result is sent to the browser until all the results are checked to be normal.
In practical application, when one or more commands in the server command list are Excel formula contents, and the low-code platform processes parameters and logic, the participation mode of the Excel engine formula is as follows: usually, when the server side commands to calculate the formula, parameters are input. The purpose of the parameter is to replace a fixed value and make the formula more universal, so that the server command can be decoupled from the top to the bottom to realize multiplexing, and a user can design a very universal server command. However, it is also necessary to additionally analyze the parameters when processing the formula of Excel itself.
There are two methods for defining parameters: (1) from a data sheet, such as from a database. The final result is sorted into key-value pairs to be stored inside the low-code platform. (2) From Json text data, sometimes the data may originate from other web site services, such as restful api. The parameter may be Table1, or may be a sub-attribute, ID, or text of Table 1. Based on the above situation, the analysis of the Excel formula is divided into two parts, i.e., the analysis of parameters and the analysis of the Excel formula. Referring to fig. 9, fig. 9 is a flowchart illustrating an analysis of an Excel formula.
Referring to fig. 8, an embodiment of the present invention provides a server-side visual programming system supporting an Excel formula, including a front-end low-code platform, a back-end server, and a client browser;
the front-end low-code platform sends first request information to the back-end server, the back-end server sends execution information to the front-end low-code platform after receiving the first request information, and the low-code platform receives and displays the execution information;
the user-side browser sends second request information to the front-end low-code platform, the front-end low-code platform responds to the second request information after checking the authority of the second request information, and the user-side browser displays result information of executing information operation;
the first request information comprises a request for constructing an Excel formula content, and the second request information comprises a request for running the Excel formula.
The low-code development platform of the embodiment of the invention enables the server command to support the use of the formula by realizing the server engine by self and combining the Excel formula engine. Compared with the common graphical programming of the server, the development threshold is further reduced, and the development efficiency is improved.
The embodiments in the present specification are described in a progressive manner, and the same or similar parts among the embodiments may be referred to each other, and each embodiment focuses on the differences from the other embodiments.
The above embodiments are only used to illustrate the technical solutions of the present application, and not to limit the present application; although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; such modifications or substitutions do not depart from the spirit and scope of the present disclosure.
Claims (8)
1. A service end visual programming method supporting an Excel formula is characterized by comprising the following steps:
the method comprises the steps that a low code platform sends request information to a server, wherein the request information comprises an Excel formula request;
the low-code platform displays execution information transmitted by the server aiming at the request information, wherein the execution information comprises Excel formula content;
the low-code platform displays result information of the execution information operation by means of a browser, wherein the result information is an operation result executed by the execution information;
the low code platform sends request information to a server in a first mode or a second mode;
the first mode is as follows: the method comprises the following steps that an edit box of a low-code platform sequentially receives a formula calling instruction and formula contents, the low-code platform is connected with a formula database of a server according to the formula calling instruction, and the low-code platform generates request information according to the formula contents and own information of the low-code platform and sends the request information to the server;
the second way is: (21) triggering a server command of the low-code platform; (22) selecting a formula edit box in the server command; (23) The formula editing frame receives the formula calling instruction and the formula content in sequence, the low-code platform is connected with the formula database of the server according to the formula calling instruction, and the low-code platform generates request information according to the formula content and the self-contained information of the low-code platform and sends the request information to the server.
2. The method for visual programming of a server supporting Excel formula according to claim 1, wherein the displaying, by the low-code platform, the execution information of the server for the requested information transmission comprises:
the low code platform calls a cell where the instruction is located according to the formula in the request information, displays Excel formula content transmitted by the server on the cell, and the Excel formula content follows behind the formula calling instruction;
after the cell is selected, a formula input box of the low-code platform displays a formula calling instruction and Excel formula content; if the Excel formula content is a pure expression formula, storing a formula calling instruction and the Excel formula content in a database through a character string, and if the Excel formula content refers to a specific cell of a specific page in the low code platform, storing the formula calling instruction and the Excel formula content in the database through the character string, the specific cell referred by the Excel formula content and a page where the Excel formula content is located;
the formula calling instruction, the Excel formula content, the specific cell quoted by the Excel formula content and the page where the Excel formula content is located are used as execution information together, and the execution information is executed on a browser through an operation module of the low-code platform.
3. The method for visual programming of a server supporting an Excel formula according to claim 2, wherein the displaying, by the low-code platform, result information of the execution information run by means of a browser comprises:
the low code platform receives request page information sent by a browser;
and the low-code platform sends a page to the browser according to the request page information, wherein the page comprises an operation result of the low-code platform running the execution information.
4. The method for visual programming of a server supporting Excel formula according to claim 1, wherein the displaying, by the low-code platform, the execution information of the server for the requested information transmission comprises:
opening an interface as an Execute command by the low code platform, wherein the Execute command is one part of a server command of the low code platform;
one attribute in the server side command is used as a formula edit box, the low code platform displays Excel formula contents transmitted by the server in the formula edit box according to a formula calling instruction in the request information, and the Excel formula contents follow behind the formula calling instruction;
the temporary storage area of the low-code platform stores execution information, if the content of the Excel formula is a pure expression formula, a formula calling instruction and the content of the Excel formula in the execution information are stored in the temporary storage area through character strings, and if the content of the Excel formula refers to a specific cell of a specific page in the low-code platform, the formula calling instruction and the content of the Excel formula in the execution information are stored in the temporary storage area through the character strings, the specific cell referred by the content of the Excel formula and the page where the content of the Excel formula is located;
and executing the execution information in a browser through an operation module of the low-code platform.
5. The visual programming method for the server supporting the Excel formula according to claim 4, wherein the displaying, by the low-code platform, the result information of the execution information run by means of a browser comprises:
the low-code platform receives request page information sent by a browser;
the low-code platform sends a page to the browser according to the request page information;
the low code platform receives a request for triggering a server side command sent by a browser;
the low code platform checks authority and records logs according to a trigger server command request, and executes a server command through a command engine to obtain an execution result;
and the low-code platform sends the execution result to a browser.
6. The method for visual programming of a server supporting Excel formula according to claim 5, wherein the low code platform requests for checking authority and logging according to a trigger server command, comprising:
the low code platform acquires parameter information in a server command request, wherein the parameter information comprises a name of a server command, input parameters of the server command and user information for sending the server command request;
the low code platform checks the user authority according to the user information, and if the user does not have corresponding authority, the low code platform ignores the command request of the server; if the corresponding authority is checked, acquiring the name of the command of the execution server and the input parameter of the command of the execution server, and sending the name of the command of the execution server and the input parameter of the command of the execution server to a command engine of the server.
7. The method for visual programming of a server supporting Excel formula according to claim 5, wherein the low-code platform executes a server command through a command engine, comprising:
the low code platform acquires a command list according to a command request of a server;
the low-code platform executes a first command in the command list, judges that an execution result is correct, and then executes a second command until the command list is traversed;
and after traversing the low-code platform ending command list, checking and processing an abnormal traversing result, and sending the execution result to the browser until all the abnormal traversing results are checked.
8. A service-side visual programming system supporting an Excel formula, characterized in that, based on the service-side visual programming method supporting the Excel formula of any one of claims 1 to 7, the service-side visual programming system comprises a front-end low-code platform, a back-end server and a user-side browser;
the front-end low-code platform sends first request information to the back-end server, the back-end server sends execution information to the front-end low-code platform after receiving the first request information, and the low-code platform receives and displays the execution information;
the user-side browser sends second request information to the front-end low-code platform, the front-end low-code platform responds to the second request information after checking the authority of the second request information, and the user-side browser displays result information of the execution information operation;
the first request information comprises a request for constructing an Excel formula content, and the second request information comprises a request for running the Excel formula.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211667843.8A CN115629750B (en) | 2022-12-24 | 2022-12-24 | Server visual programming method and system supporting Excel formula |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211667843.8A CN115629750B (en) | 2022-12-24 | 2022-12-24 | Server visual programming method and system supporting Excel formula |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115629750A CN115629750A (en) | 2023-01-20 |
| CN115629750B true CN115629750B (en) | 2023-03-17 |
Family
ID=84911255
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211667843.8A Active CN115629750B (en) | 2022-12-24 | 2022-12-24 | Server visual programming method and system supporting Excel formula |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115629750B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2019200701A1 (en) * | 2018-04-17 | 2019-10-24 | 平安科技（深圳）有限公司 | Configuration management method and apparatus, terminal device and storage medium |
| CN114036177A (en) * | 2021-11-03 | 2022-02-11 | 重庆邮电大学 | Design and implementation method of intelligent report based on component |
| CN114115904A (en) * | 2021-11-29 | 2022-03-01 | 中国平安财产保险股份有限公司 | Information processing method, information processing apparatus, server, and storage medium |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US11907198B2 (en) * | 2021-04-15 | 2024-02-20 | Sap Se | Selective recommendation and deployment of extensions in low-code approach |
| CN114253515A (en) * | 2021-11-19 | 2022-03-29 | 苏州趣谷科技有限公司 | Low-code development platform for quickly constructing manufacturing type enterprise management software |
| CN114741071A (en) * | 2022-04-14 | 2022-07-12 | 北京字节跳动网络技术有限公司 | Application construction method and device |
| CN114756212A (en) * | 2022-06-13 | 2022-07-15 | 济南浪潮数据技术有限公司 | Low-code application integration method, device, equipment and medium |
| CN115268910A (en) * | 2022-07-27 | 2022-11-01 | 重庆忽米网络科技有限公司 | Data visualization model construction method based on multiple Excel sublists |
-
2022
- 2022-12-24 CN CN202211667843.8A patent/CN115629750B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2019200701A1 (en) * | 2018-04-17 | 2019-10-24 | 平安科技（深圳）有限公司 | Configuration management method and apparatus, terminal device and storage medium |
| CN114036177A (en) * | 2021-11-03 | 2022-02-11 | 重庆邮电大学 | Design and implementation method of intelligent report based on component |
| CN114115904A (en) * | 2021-11-29 | 2022-03-01 | 中国平安财产保险股份有限公司 | Information processing method, information processing apparatus, server, and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115629750A (en) | 2023-01-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6442714B1 (en) | Web-based integrated testing and reporting system | |
| KR100652482B1 (en) | Method and apparatus for providing direct transaction access to information residing on a host system | |
| US7493597B2 (en) | System and method for model based generation of application programming interface test code | |
| US8060863B2 (en) | Conformance control module | |
| US20050065936A1 (en) | System and method for reusing form elements in a form building application | |
| CN105205144B (en) | Method and system for data diagnosis optimization | |
| US20080005747A1 (en) | System and method for object state management | |
| US8285660B2 (en) | Semi-automatic evaluation and prioritization of architectural alternatives for data integration | |
| CN111930489B (en) | Task scheduling method, device, equipment and storage medium | |
| JP7209306B2 (en) | Online work system for Excel documents based on templates | |
| US8533587B2 (en) | Web server, web server having function of Java servlet, and computer readable medium | |
| CN112182089B (en) | Report generation method, device and equipment based on data warehouse model | |
| US20040193644A1 (en) | Exposing a report as a schematized queryable data source | |
| CN114185791A (en) | Method, device and equipment for testing data mapping file and storage medium | |
| US20210124752A1 (en) | System for Data Collection, Aggregation, Storage, Verification and Analytics with User Interface | |
| US11874728B2 (en) | Software application diagnostic aid | |
| CN115629750B (en) | Server visual programming method and system supporting Excel formula | |
| CN115470152B (en) | Test code generation method, test code generation device, and storage medium | |
| US20230195792A1 (en) | Database management methods and associated apparatus | |
| CN113435830A (en) | Mail information summarizing method, system, electronic device and storage medium | |
| CN113051262A (en) | Data quality inspection method, device, equipment and storage medium | |
| CN108416023B (en) | Method for simulating user operation to write back system data | |
| CN115629768B (en) | E-mail template analysis method based on Excel formula engine | |
| CN115795322B (en) | Railway configuration data comparison method, device, electronic equipment and storage medium | |
| US20220334829A1 (en) | Custom abap cloud enabler |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |