Excel dynamic configuration filling method and device

Abstract

The invention discloses an Excel dynamic configuration filling method and device, and the method comprises the steps: carrying out Excel dynamic configuration according to a configuration function, and obtaining a dynamic configuration result, the configuration function comprising data source configuration, workflow configuration, dynamic row and column configuration, drop-down box configuration, jump configuration or authority configuration; and according to the dynamic configuration result, performing data filling and reporting to obtain a filling and reporting result. Excel dynamic configuration filling and reporting can be achieved through multiple configuration functions, and the data processing efficiency and the data accuracy are improved. The method can be widely applied to the technical field of computers.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of computer, and in particular to an Excel dynamic configuration reporting method and device. BACKGROUND

[0002] In the digital era, more and more enterprises and organizations rely on data-driven decision-making. In daily operations, especially in financial statements, data reporting, project management, etc., Excel is commonly used as the main tool. The powerful functions of Excel, such as formulas, pivot tables, formatting rules, and drop-down boxes, make it the first choice for data reporting and analysis. However, as business complexity increases and the need for cross-departmental collaboration grows, traditional Excel applications gradually reveal many limitations. When the data volume reaches a certain scale, formula calculations, data filtering, and other operations respond very slowly, and for complex report structures and frequent data updates, manual operations not only consume time and effort, but also have low data processing efficiency and are prone to human error, resulting in low data accuracy.

[0003] In summary, the technical problems in the related art need to be improved. SUMMARY

[0004] The present application provides an Excel dynamic configuration reporting method and device, which effectively improves data processing efficiency and data accuracy.

[0005] In one aspect, the present application provides an Excel dynamic configuration reporting method, comprising the following steps:

[0006] According to the configuration function, the Excel dynamic configuration is performed to obtain a dynamic configuration result, and the configuration function includes data source configuration, workflow configuration, dynamic row and column configuration, drop-down box configuration, jump configuration or permission configuration;

[0007] According to the dynamic configuration result, data reporting is performed to obtain a reporting result.

[0008] In some embodiments, when the configuration function is the data source configuration, the Excel dynamic configuration according to the configuration function to obtain the dynamic configuration result comprises:

[0009] Obtaining a data source configuration request;

[0010] Setting database connection information, the database connection information including database type, IP port, account, password and database driver;

[0011] According to the data source configuration request and the database connection information, data query is performed on the database to obtain original metadata, and the original metadata includes table name, table type, belonging schema and table note.

[0012] structuring the original metadata;

[0013] deeply parsing the structured original metadata to obtain table structure information, the table structure information including a field name, a field type, and a description;

[0014] caching the structured original metadata and the table structure information using a least recently used caching strategy;

[0015] extracting the structured original metadata and the table structure information from the cache and rendering to obtain the dynamic configuration result.

[0016] In some embodiments, when the configuration function is the workflow configuration, the Excel dynamic configuration according to the configuration function to obtain the dynamic configuration result includes:

[0017] obtaining a report publishing request;

[0018] generating a unique identifier according to the report publishing request;

[0019] generating a uniform resource locator according to the unique identifier and a security token;

[0020] determining whether there is an approval workflow according to the uniform resource locator;

[0021] if there is an approval workflow, sending a process instance start request to a workflow engine;

[0022] the workflow engine is configured to load a process configuration according to the process instance start request and a process ID, generate a process instance, and send an approval link to an approver according to the process instance;

[0023] the approver is configured to perform approval according to the approval link to obtain an approval result;

[0024] if the approval result is approval, performing data validation processing according to the process instance ID to obtain the dynamic configuration result.

[0025] In some embodiments, when the configuration function is the dynamic row and column configuration, the Excel dynamic configuration according to the configuration function to obtain the dynamic configuration result includes:

[0026] obtaining a dynamic row and column configuration request;

[0027] extracting a dynamic identifier from the dynamic row and column configuration request, the dynamic identifier being used to identify a dynamic main cell, a dynamic row number, a dynamic column number, or a main cell position;

[0028] According to the dynamic identifier, a database table, a field, and a correlation relationship dependent on a dynamic rule are determined;

[0029] According to the database table, the field, and the correlation relationship dependent on the dynamic rule, a structured rule object is generated, the structured rule object including a dynamic dimension, a filtering condition, and data correlation logic;

[0030] According to the structured rule object, a dynamic structured query language is constructed;

[0031] According to the dynamic structured query language, a database is queried to obtain an original data set;

[0032] According to a preset data conversion strategy, the original data set is converted to obtain a data matrix;

[0033] The data matrix is taken as the dynamic configuration result.

[0034] In some embodiments, when the configuration function is the drop-down box configuration, the Excel dynamic configuration is performed according to the configuration function to obtain a dynamic configuration result, including:

[0035] A drop-down box configuration request is obtained;

[0036] According to the drop-down box configuration request, a cell is brought into an editing state;

[0037] Context information of the cell is received, the context information including a current row ID, a field name, and a filtering condition;

[0038] According to the context information, a unique cache key is generated, the unique cache key including an interface code and a code parameter;

[0039] According to the unique cache key, a local cache query is performed to obtain a local cache query result;

[0040] If the local cache query result is a cache miss, query request information including identity authentication information and a filtering condition is sent to a backend server, the backend server being configured to execute a database query or a business logic calculation to obtain a query data result;

[0041] The query data result and the unique cache key are written into a cache;

[0042] The query data result is format-converted to obtain data required by a drop-down component;

[0043] The data required by the drop-down component is taken as the dynamic configuration result.

[0044] In some embodiments, when the configuration function is the jump configuration, the Excel dynamic configuration according to the configuration function to obtain a dynamic configuration result comprises:

[0045] Obtaining a jump configuration request;

[0046] Generating a jump identifier according to the jump configuration request;

[0047] Sending a cell key parameter to a configuration server according to the jump identifier, the configuration server being configured to return jump configuration information;

[0048] Adding a click event listener to a cell according to the jump configuration information, and replacing a specific value of current line data with a dynamic parameter in the jump configuration information;

[0049] In response to a click of the cell, judging a jump link type;

[0050] If the jump link type is an internal report jump, obtaining an access path of a target report from the configuration server as the dynamic configuration result;

[0051] If the jump link type is an external link jump, taking an external link in the jump configuration information as the dynamic configuration result.

[0052] In some embodiments, when the configuration function is the permission configuration, the Excel dynamic configuration according to the configuration function to obtain a dynamic configuration result comprises:

[0053] Obtaining a permission configuration request, the content of the permission configuration request comprising a user ID and a report ID;

[0054] Generating a unique cache key according to the permission configuration request;

[0055] Querying a permission through a local memory cache according to the unique cache key to obtain a local cache permission query result;

[0056] If the local cache permission query result is a miss, querying a permission through a distributed cache cluster to obtain a distributed cache permission query result;

[0057] Updating the distributed cache permission query result to the local memory cache to obtain the dynamic configuration result.

[0058] In some embodiments, the data filling according to the dynamic configuration result to obtain a filling result comprises:

[0059] Saving a configuration template to a database according to the dynamic configuration result, a user ID, a report ID, a report style, a tab ID and a tab name.

[0060] querying template report data from the database;

[0061] querying report details from the database according to the template report data;

[0062] report rendering is performed according to the report details;

[0063] report data written by a user in a report rendering interface is stored into the database, and an approver is used to audit the report data to obtain an audit result;

[0064] the report data in the database is updated according to the audit result to obtain a report result.

[0065] In another aspect, an Excel dynamic configuration report filling device is provided in an embodiment of the present application, and the device comprises:

[0066] a first module configured to perform Excel dynamic configuration according to a configuration function to obtain a dynamic configuration result, wherein the configuration function comprises data source configuration, workflow configuration, dynamic row and column configuration, drop-down box configuration, jump configuration or permission configuration;

[0067] a second module configured to perform data report filling according to the dynamic configuration result to obtain a report filling result.

[0068] In another aspect, a computer device is provided in an embodiment of the present application, and the device comprises:

[0069] at least one processor;

[0070] at least one memory configured to store at least one program;

[0071] when the at least one program is executed by the at least one processor, the at least one processor implements the method.

[0072] In another aspect, a computer readable storage medium is provided in an embodiment of the present application, and the computer readable storage medium stores a computer program, and the computer program is executed by a processor to implement the method.

[0073] The present application has the following beneficial effects:

[0074] The embodiment of the application firstly performs Excel dynamic configuration according to configuration functions, obtains a dynamic configuration result, wherein the configuration functions include data source configuration, workflow configuration, dynamic row and column configuration, drop-down box configuration, jump configuration or permission configuration, then performs data filling according to the dynamic configuration result, and obtains a filling result, so that Excel dynamic configuration filling can be realized through various configuration functions, and data processing efficiency and data accuracy are improved.

[0075] Additional features and advantages of the application will be set forth in the description that follows, and in part will be apparent from the description, or can be learned by practice of the application. The objectives and other advantages of the application will be realized and attained by the structure particularly pointed out in the description and claims. BRIEF DESCRIPTION OF DRAWINGS

[0076] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings needed to be used in the embodiment description will be briefly introduced. Obviously, the drawings in the following description are only some embodiments of the present application, and other drawings can be obtained by those skilled in the art without creative labor.

[0077] Figure 1 A flow chart of an Excel dynamic configuration filling method according to an embodiment of the present application;

[0078] Figure 2 A flow chart of a data source configuration according to an embodiment of the present application;

[0079] Figure 3 A flow chart of a workflow configuration according to an embodiment of the present application;

[0080] Figure 4 A flow chart of a dynamic row and column configuration according to an embodiment of the present application;

[0081] Figure 5 A flow chart of a drop-down box configuration according to an embodiment of the present application;

[0082] Figure 6 A flow chart of a jump configuration according to an embodiment of the present application;

[0083] Figure 7 A flow chart of a permission configuration according to an embodiment of the present application;

[0084] Figure 8 A flow chart of a data filling according to an embodiment of the present application;

[0085] Figure 9 A structure schematic diagram of an Excel dynamic configuration filling device according to an embodiment of the present application;

[0086] Figure 10 Figure 1 is a schematic diagram of a hardware structure of a computer device according to an embodiment of the present application. DETAILED DESCRIPTION

[0087] In order to make the objects, technical solutions and advantages of the present application clearer, the present application will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and not intended to limit the present application. When the following description refers to the accompanying drawings, the same numbers in different drawings represent the same or similar elements unless otherwise indicated. The implementations described in the following exemplary embodiments do not represent all implementations consistent with embodiments of the present application. They are merely examples of apparatuses and methods consistent with some aspects of the embodiments of the present application as detailed in the appended claims.

[0088] It can be understood that the terms "first", "second" and the like used in the present application can be used herein to describe various concepts, but unless specifically stated, these concepts are not limited by these terms. These terms are only used to distinguish one concept from another concept. For example, without departing from the scope of the embodiments of the present application, the first information can also be referred to as the second information, and similarly, the second information can also be referred to as the first information. Depending on the context, the word "if" as used herein can be interpreted as "when" or "upon" or "in response to determining".

[0089] The terms "at least one", "multiple", "each", "any" and the like used in the present application include one, two or more than two, multiple includes two or more than two, each refers to each of the corresponding multiple, and any refers to any one of the multiple.

[0090] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which the present application belongs. The terms used herein are only for the purpose of describing the embodiments of the present application and are not intended to limit the present application.

[0091] Before the embodiments of the present application are described in detail, first, some nouns and terms involved in the embodiments of the present application are described, and the nouns and terms involved in the embodiments of the present application are applicable to the following explanations.

[0092] Excel: is a spreadsheet software written by Microsoft for computers using Windows and Apple Macintosh operating systems. Intuitive interface, excellent calculation function and chart tool, plus successful marketing, make Excel the most popular personal computer data processing software.

[0093] Redis(Remote Dictionary Server): Remote Dictionary Server, an open source, network-enabled, in-memory, log-structured, key-value database written in ANSI C, with APIs for various languages.

[0094] In the related art, in the digital era, more and more enterprises and organizations rely on data-driven decision-making. In daily operations, especially in financial statements, data filling, project management, etc., Excel is commonly used as the main tool. The powerful functions of Excel, such as formulas, pivot tables, formatting rules, and drop-down boxes, make it the first choice for data filling and analysis. However, as business complexity increases and the need for cross-departmental collaboration grows, traditional Excel applications gradually reveal many limitations, and higher requirements are placed on the flexibility, scalability, and integration capabilities of data filling systems with other business systems. To address these challenges, more and more enterprises are beginning to seek solutions that deeply integrate Excel with workflow engines, dynamic data tables, and business systems. This new type of product not only retains the powerful functions of Excel, but also solves collaboration, automation, and data security issues, meeting the diverse needs of modern enterprises.

[0095] The existing technical solutions have the following problems: (1) Low data processing efficiency: When the data volume reaches a certain scale, formula calculation, data filtering, and other operations will become extremely slow; for complex report structures and frequent data updates, manual operations not only consume time and effort, but also are prone to human errors. (2) Fragmented functions: Online document tools support formulas up to Excel 2010 level; professional BI tools (such as Tableau) have weak filling functions and do not support complex verification rules. (3) Dynamic rendering bottleneck: Traditional DOM rendering of 10,000 rows of data has a response delay of more than 3 seconds; dynamic column switching causes layout misalignment rate of up to 28%. (4) System integration barriers: Existing workflow engines require custom development for integration, with an average time consumption of 15 person-days per interface; drop-down box data source changes require manual synchronization, with an error rate of 18%. (5) Lack of collaboration and control: Incomplete version conflict resolution mechanisms result in a data loss rate of 9.7%; insufficient granularity of sensitive data permissions (only file-level control is supported); some data does not take effect immediately after filling and requires leadership approval to take effect.

[0096] In view of this, the application adopts a distributed architecture based on cloud computing, the front end adopts the Vue.js 2.0 framework + Canvas rendering technology, and the back end uses the Spring Cloud microservice architecture; the online editing interface of the Excel-like is realized based on the secondary development of the open source library Luckysheet, and a familiar and convenient operation experience is provided for the user. The system mainly includes the following core modules: (1) table editing engine: responsible for realizing the basic editing or filling of Excel, such as cell editing, formula calculation, data analysis, data source configuration, drop-down box configuration and report generation, etc. The engine is based on the secondary development of the open source table editing library to ensure the stability and compatibility of the function. (2) data storage module: supporting multiple database types such as MYSQL, Dream, HANA, ORACLE, POSTGRESQL, storing user filling data and configured templates. (3) workflow engine interface module: realizing seamless connection with the existing workflow engine of the enterprise. Through the module, the user can define the business process in the Excel filling template, and automatically submit the filling data to the workflow engine for approval, realizing the automation of the business process. (4) dynamic report rendering module: generating dynamic row or dynamic column report in real time according to the rules and data sources set by the user. The module adopts a data-driven way to automatically generate the corresponding report layout by analyzing the data structure and business logic in the data source. (5) drop-down box linkage module: realizing the linkage function between drop-down boxes through JavaScript event listening and data binding technology. When the user selects a certain option in a drop-down box, the system will automatically update the option content of other related drop-down boxes according to the preset rules, improving the accuracy and efficiency of data filling.

[0097] The Excel dynamic configuration filling method provided by the embodiment of the application relates to the technical field of computers. The Excel dynamic configuration filling method provided by the embodiment of the application can be applied to a terminal, can be applied to a server, and can also be software running in the terminal or the server. In some embodiments, the terminal can be a smart phone, a tablet computer, a notebook computer, a desktop computer, a smart speaker, a smart watch, a vehicle-mounted terminal, or the like, but is not limited thereto; the server end can be configured as a stand-alone physical server, can be configured as a server cluster or a distributed system composed of multiple physical servers, can be configured as a cloud server providing basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communication, middleware services, domain name services, security services, CDNs, big data and artificial intelligence platforms, and the server can also be a node server in a blockchain network; and the software can be an application that implements an Excel dynamic configuration filling method, but is not limited to the above forms.

[0098] The application is operable with numerous general purpose or special purpose computer system environments or configurations. Examples include: personal computers, server computers, hand held or laptop devices, tablet devices, multiprocessor systems, microprocessor-based systems, set top boxes, programmable consumer electronics, network PCs, minicomputers, mainframe computers, distributed computing environments that include any of the above systems or devices, and the like. The application can be described in the general context of computer-executable instructions, such as program modules, being executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, and the like, that perform particular tasks or implement particular abstract data types. The application can also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules can be located in local and remote computer storage media including memory storage devices.

[0099] The embodiments of the application are explained in detail below with reference to the accompanying drawings:

[0100] Figure 1 is an optional flowchart of an Excel dynamic configuration filling method provided by the embodiments of the application, Figure 1 The method in the above can include but is not limited to steps S101 to S102.

[0101] Step S101, according to the configuration function, performing Excel dynamic configuration to obtain a dynamic configuration result, the configuration function including data source configuration, workflow configuration, dynamic row and column configuration, drop-down box configuration, jump configuration or permission configuration;

[0102] Step S102, according to the dynamic configuration result, performing data filling to obtain a filling result.

[0103] The steps S101 to S102 shown in the embodiments of the application realize Excel dynamic configuration filling, and improve data processing efficiency and data accuracy.

[0104] In some embodiments, LuckySheet can be integrated in the front end as a front-end online editing Excel solution to solve the problems of formula support, pivot table, collaborative editing, interface similar to Excel, etc., and the configuration function including data source configuration, workflow configuration, dynamic row and column configuration, drop-down box configuration, jump configuration or permission configuration is added for the convenience of users through secondary development.

[0105] In some embodiments, in step S101, when the configuration function is data source configuration, according to the configuration function, performing Excel dynamic configuration to obtain a dynamic configuration result, can include but is not limited to the following steps:

[0106] Obtaining a data source configuration request;

[0107] Setting database connection information, the database connection information including database type, IP port, account, password and database driver;

[0108] According to the data source configuration request and the database connection information, data query is performed on the database to obtain original metadata, the original metadata including table name, table type, belonging schema and table comment;

[0109] Structural processing is performed on the original metadata;

[0110] The original metadata after the structural processing is deeply parsed to obtain table structure information, the table structure information including field name, field type and description;

[0111] The original metadata after the structural processing and the table structure information are cached by using a least recently used cache strategy;

[0112] The original metadata after the structural processing and the table structure information are extracted from the cache and rendered to obtain a dynamic configuration result.

[0113] In some embodiments, a flowchart of data source configuration is as shown in Figure 2 The table structure information can be obtained by triggering a request after a user performs an operation (such as selecting a data source and clicking confirmation) on an interface, to trigger the data source configuration request, which is sent from the user interface (front end) to the metadata server (back end). Then, the database connection information is set, including database type, IP port, account, password and database driver. The database connection information can be input by data source configuration (inputting database type, IP port and account password), and the configuration driver class of the supported database types (such as MYSQL) is built in, high-performance connection pool management is realized based on HikariCP, and the connection pool is initialized in a lazy loading mode to reduce system startup resource consumption. Then, according to the data source configuration request and the database connection information, data query is performed on the database to obtain original metadata, wherein the original metadata includes table name (such as TABLE_NAME), table type (such as TABLE_TYPE, such as normal table, view, etc.), belonging schema (such as TABLE_SCHEMA) and table comment (such as TABLE_COMMENT). The original metadata is structurally processed to generate a structured data object (such as JSON or internal DTO), which can be represented as:

[0114]

[0115] Deeply parse the original metadata after structured processing to obtain table structure information, wherein the table structure information includes field name, field type and description. Exemplarily, the original metadata can be deeply parsed by a metadata server to extract detailed table structure information, DatabaseMetaData.getColumns() is called to obtain the field name, field type and description of each table, and a structured data object (such as JSON or internal DTO) is generated, which can be represented as:

[0116]

[0117] The original metadata after structured processing and the table structure information are cached by using a least recently used cache strategy. Exemplarily, an LRU (least recently used) cache strategy can be used, and a fixed capacity (such as caching 100 table structures) is set. When the cache is full, the table structure data that has not been accessed for the longest time is eliminated. The parsed structured metadata is stored with the table name (or table name + schema name) as the Key, so as to reduce the overhead of frequent database access and improve the subsequent query efficiency. The original metadata after structured processing and the table structure information are extracted from the cache and rendered to obtain a dynamic configuration result. The parsed field list can be packaged according to the requirements of the front end (such as tree structure or flat list). The table structure information is rendered on the user interface to display the table name, field name and field type, and the field details (such as whether it can be null, default value, etc.) can be viewed by expansion. It can be understood that the API provided by the database driver is used to perform the SQL query operation, and the result set returned by the database is parsed and converted into a Java object, a JSON data structure or the like, so as to facilitate the application program to further process and display the data, and realize that when the report is configured, the corresponding database table and its fields can be loaded according to the selected data source.

[0118] In some embodiments, when the configuration function is configured for the workflow in step S101, the Excel dynamic configuration is performed according to the configuration function to obtain a dynamic configuration result, which can include but is not limited to the following steps:

[0119] Obtain a report publishing request;

[0120] Generate a unique identifier according to the report publishing request;

[0121] Generate a uniform resource locator according to the unique identifier and the security token;

[0122] Determine whether there is an approval workflow according to the uniform resource locator;

[0123] If there is an approval workflow, send a process instance start request to a workflow engine;

[0124] The workflow engine is configured to load the process configuration according to the process instance start request and the process ID, generate a process instance, and send an approval link to an approver according to the process instance;

[0125] The approver is configured to perform approval according to the approval link and obtain an approval result;

[0126] If the approval result is approval, data validation processing is performed according to the process instance ID to obtain a dynamic configuration result.

[0127] In some embodiments, a unique access URL is automatically generated when a report is published (generated by a built-in general page route and a published configuration report report ID), and then the report dimension is connected to the workflow component according to the URL to provide differentiated configuration of the workflow component and direct validation of the report. At the same time, the general interface will have a built-in workflow component interface to automatically adjust the display strategy of the operation button, realize the button switching of supporting workflow and direct validation, and provide a standardized workflow interface adaptation layer, so that the report data validation logic can be realized when the workflow ends. The flow chart of the workflow configuration is shown in Figure 3 The report publishing request can be obtained first, and the request is triggered when the user clicks the "publish report" button. The request contains report metadata (such as report name, data source, permission configuration, etc.), which is sent by the user side to the publishing system backend. Then, according to the report publishing request, a unique identifier is generated, and a uniform resource locator is generated according to the unique identifier and a security token. For example, the publishing system generates a unique identifier (ID) for the report, which is usually based on a timestamp, a random number, or a database auto-increment sequence. The URL is generated by combining the ID and the security token (Token), and the format is / report / [ID]_token (for example, / report / 12345_abcde). Token is generated by an encryption algorithm (such as HMAC), which prevents the URL from being tampered with or forged, and the URL is bound to the report metadata and is persisted to the database to achieve storage association.

[0128] According to the uniform resource locator, it is judged whether there is an approval workflow. If there is no approval workflow, it is directly jumped to the publishing logic, the publishing system directly calls the data service, executes the publishing operation (such as writing the publishing log, updating the report state), generates the final access URL and returns the user. If there is an approval workflow, a process instance start request is sent to the workflow engine, the workflow engine is used to load the process configuration according to the process instance start request and the process ID, generate the process instance, and send the approval link to the approver according to the process instance. The approver is used to approve according to the approval link to obtain the approval result; if the approval result is approval, data validation processing is performed according to the process instance ID to obtain the dynamic configuration result. Exemplarily, it is different according to the accessed workflow engine, and the embodiment takes the self-provided workflow as an example. When approval is needed, the user interface displays the "submit for approval" button, and the process ID is associated. After the user clicks the submit button, the publishing system initiates a process instance start request to the workflow engine, the workflow engine loads the configuration according to the process ID (such as multi-level approval, signing or signing rules), generates the process instance, and records the instance state (in progress, pass, reject) to the database. At the same time, the workflow engine calls the data service to obtain the approver information (such as email, system account), and sends a notification through email, intranet letter or message queue (such as Kafka), including the approval link (containing the process instance ID). The approver accesses the approval link to view the report details, performs "pass" or "reject" operation, and synchronizes the operation result to the workflow engine in real time. If the approval is passed, the workflow engine triggers the callback interface of the publishing system, carries the process instance ID and the approval result, and the publishing system executes the data validation logic (such as updating the report state to "published" and activating the URL access permission). More, after the approval is successful, the front end displays the "publishing success" prompt and provides an accessible URL link. If the approval is rejected, the specific reason (such as "data validation failed") is prompted, and a re-submission entry is provided. The approval result can be represented as:

[0129]

[0130] In some embodiments, in step S101, when the configuration function is a dynamic row-column configuration, the Excel dynamic configuration is performed according to the configuration function to obtain a dynamic configuration result, which can include but is not limited to the following steps:

[0131] A dynamic row-column configuration request is obtained;

[0132] A dynamic identifier is extracted from the dynamic row-column configuration request, the dynamic identifier being used to identify a dynamic main cell, a dynamic row number, a dynamic column number or a main cell position;

[0133] According to the dynamic identifier, the database table, field and association relationship dependent on the dynamic rule are determined;

[0134] According to the database table, field and association relationship dependent on the dynamic rule, a structured rule object is generated, and the structured rule object includes dynamic dimension, filtering condition and data association logic;

[0135] According to the structured rule object, a dynamic structured query language is constructed;

[0136] According to the dynamic structured query language, the database is queried to obtain an original data set;

[0137] According to a preset data conversion strategy, the original data set is converted to obtain a data matrix;

[0138] The data matrix is taken as a dynamic configuration result.

[0139] In some embodiments, the flowchart of the dynamic row-column configuration is as shown in Figure 4 The dynamic row-column configuration request can be obtained first, and the user defines the rule triggering request of the dynamic row or column in the front-end interface. Then the dynamic identifier is extracted from the dynamic row-column configuration request, wherein the dynamic identifier is used to identify the dynamic master grid, the dynamic row sequence number, the dynamic column sequence number or the master grid position, such as $BTYPE:MASTER identifying the dynamic master grid, $biShowMasterFields:SEQNUM0 dynamic row (column) sequence number, and $BMRC:0,1 identifying the master grid position. It can be understood that the dynamic type can be identified by $BLOCKTYPE, and RD is the row and CD is the column. According to the dynamic identifier, the database table, field and association relationship dependent on the dynamic rule are determined, and the structured rule object is generated according to the database table, field and association relationship dependent on the dynamic rule, wherein the structured rule object includes dynamic dimension, filtering condition and data association logic. Exemplarily, the dynamic identifier in the configuration can be extracted and identified by the identifier ($BLOCKTYPE represents the dynamic expansion column according to the classification field) to determine the database table, field and association relationship dependent on the dynamic rule, and to generate the structured rule object. Then the dynamic structured query language SQL is constructed according to the structured rule object, the dynamic field name can be checked by white list to prevent SQL injection, and the precompiled statement or the ORM framework binding parameter is used. Exemplarily, the program code of the construction process of the dynamic structured query language SQL can be represented as:

[0140]

[0141]

[0142] According to the dynamic structured query language, the database is queried to obtain an original data set. The original data can be returned according to the dynamic SQL, and then corresponding data is processed according to identification of a dynamic row or a dynamic column. Finally, the original data set is converted according to a preset data conversion strategy to obtain a data matrix, and the data matrix is taken as a dynamic configuration result. Further, the flat data can be converted into a matrix structure data matrix, which can be expressed as:

[0143]

[0144]

[0145] In some embodiments, when the configuration function is a drop-down box configuration in step S101, the Excel dynamic configuration is performed according to the configuration function to obtain a dynamic configuration result, which can include but is not limited to the following steps:

[0146] A drop-down box configuration request is obtained.

[0147] According to the drop-down box configuration request, a cell is put into an editing state.

[0148] Context information of the cell is received, and the context information includes a current row ID, a field name and a filtering condition.

[0149] According to the context information, a unique cache key is generated, and the unique cache key includes an interface code and a code parameter.

[0150] According to the unique cache key, a local cache query is performed to obtain a local cache query result.

[0151] If the local cache query result is a cache miss, a query request information is sent to a backend server, and the query request information includes authentication information and a filtering condition. The backend server is used to perform a database query or a business logic calculation to obtain a query data result.

[0152] The query data result and the unique cache key are written into a cache.

[0153] The query data result is format-converted to obtain data required by a drop-down component.

[0154] The data required by the drop-down component is taken as a dynamic configuration result.

[0155] In some embodiments, the drop-down box configuration supports integrated system interface (value list, data dictionary, business dictionary), and also supports integrated system interface. According to the configured interface and parameters, the corresponding array can be queried and bound to the excel drop-down box. At the same time, the disadvantage that the excel drop-down box cannot input query is optimized. Both the operation habit of Excel and the interactive experience of modern Web application are retained, and the dynamic parameters (C1, R1 is the first cell linkage, and C, R1 is the dynamic linkage) of drop-down box configuration are supplemented, so as to realize the linkage drop-down box logic. The flow chart of drop-down box configuration is shown in Figure 5 The drop-down box configuration request can be obtained first. When the user enters the report with the configured drop-down box, the request is triggered. According to the drop-down box configuration request, the cell enters the editing state. If it is a static drop-down box (predefined options), the locally configured option list is directly loaded. If it is a dynamic drop-down box (call configured interface and configured request parameter), the interface supporting get request can be supported. Then, the context information (such as type = 1 & code = TWO_LEVEL_TASK & purOrgId) of the cell is received. The context information includes the current row ID, field name and filtering condition. According to the context information, a unique cache key (interface code [querySelectList] + code parameter [code]) is generated. The unique cache key includes the interface code and the code parameter.

[0156] According to the unique cache key, a local cache query (such as a memory cache or LocalStorage) is performed to obtain a local cache query result. If the local cache query result is a cache hit, the cached pull-down option data is directly returned, and subsequent external interface calls are skipped. If the local cache query result is a cache miss, a query request information is sent to a backend server, and the query request information includes authentication information and filtering conditions. The backend server is used to perform a database query or business logic calculation to obtain a query data result. Exemplarily, an API gateway can be used to dynamically route to a corresponding backend service (such as a user service or a dictionary service) according to parameters, such as gateway / config / buReportBasinfo / querySelectList?type=1&code=TWO_LEVEL_TASK&purOrg Id. The query data result and the unique cache key are written into the cache. The cache can be updated according to an HTTP header (such as Cache-Control) returned by an interface or a preset rule (such as a fixed TTL). The interface return data is stored in association with the cache key for subsequent request reuse. At the same time, if the cache space is insufficient, old data is discarded according to an LRU strategy. Finally, the query data result is format-converted to obtain data required by a pull-down component, and the data required by the pull-down component is used as a dynamic configuration result. The original data returned by the interface can be converted into a format (such as {value}) required by a front-end pull-down component. According to a keyword input by a user, options are filtered in real time (front-end local filtering or re-requesting an interface). Rendering is performed, and a drop-down box displays an option list, search, and other functions.

[0157] In some embodiments, in step S101, when the configuration function is a jump configuration, according to the configuration function, Excel dynamic configuration is performed to obtain a dynamic configuration result, which can include but is not limited to the following steps:

[0158] A jump configuration request is obtained.

[0159] A jump identifier is generated according to the jump configuration request.

[0160] According to the jump identifier, a cell key parameter is sent to a configuration server, and the configuration server is used to return jump configuration information.

[0161] According to the jump configuration information, a click event listener is added to the cell, and a dynamic parameter in the jump configuration information is replaced with a specific value of the current row data.

[0162] In response to a click of the cell, a jump link type is determined.

[0163] If the jump link type is an internal report jump, an access path of a target report is obtained from the configuration server as a dynamic configuration result.

[0164] If the jump link type is external link jump, the external link in the jump configuration information will be used as the dynamic configuration result.

[0165] In some embodiments, the jump configuration can use the identifier $JUMPURL to identify the user-configurable report or external link, and then when the template is loaded, a click event is added to the cell with the identifier to jump to the configured link or report. Figure 6 As shown, the jump configuration request can be obtained first, and a jump identifier can be generated based on the jump configuration request. The user enters the report page with the jump configured to trigger the request. The front-end renderer loads the template data to render the corresponding interface (including style) and data (including dynamic data), and triggers the metadata request when the $SUMPURL identifier is detected in the cell. Then, based on the jump identifier, the cell key parameters are sent to the configuration server, where the configuration server is used to return the jump configuration information. For example, the front-end renderer sends a request to the configuration server, carrying the cell key parameters, including the cell ID and the report ID, such as {repId:"da674ddc87ef0a675f8b2a0baf34a64d",compId:"2a81e0cacea8da84f5fe66ccfd8f91e9"}. The returned jump configuration information can be expressed as:

[0166]

[0167] Then, based on the jump configuration information, add a click event listener for the cell, and replace the dynamic parameters in the jump configuration information with the specific values ​​of the current row data. For example, based on the returned jump configuration information, you can add a click event listener for the marked cell, and replace the dynamic parameters (#R_C1) in the configuration with the specific values ​​of the current row data (such as "A"). In response to the click of the cell, the jump link type is determined. The user clicks on the cell that has been bound to the jump to trigger a response. The front-end captures the event and executes the jump logic. If the jump link type is an internal report jump, the access path of the target report is obtained from the configuration server as the dynamic configuration result. For example, the front-end renderer requests the actual access path of the target report from the configuration service. The parameter example is:

[0168]

[0169] The complete URL (with dynamic parameters) of the access path of the returned target report can be expressed as: workspace / views / LuckySheet / WriteDataInfoFilling / da674ddc87ef0a675f8b2a0baf34a64d / apply?projectCode=A. In the jump, the front-end renderer can jump to the target report through routing (such as Vue Router, React Router) or page redirection (window.location). If the jump link type is external link jump, the external link in the jump configuration information is used as the dynamic configuration result. Exemplarily, the external link in the configuration can be directly used to replace the dynamic parameters (such as https: / / www.baidu.com), and it is checked whether the link is a white list domain name to prevent malicious jump, so as to realize security check, and the link can also be opened in a new tab page through window.open(target_url,'_blank').

[0170] In some embodiments, in step S101, when the configuration function is permission configuration, the Excel dynamic configuration according to the configuration function is performed to obtain a dynamic configuration result, which can include but is not limited to the following steps:

[0171] A permission configuration request is obtained, and the content of the permission configuration request includes a user ID and a report ID;

[0172] A unique cache key is generated according to the permission configuration request;

[0173] A local memory cache is used for permission query according to the unique cache key to obtain a local cache permission query result;

[0174] If the local cache permission query result is a miss, a distributed cache cluster is used for permission query to obtain a distributed cache permission query result;

[0175] The distributed cache permission query result is updated to the local memory cache to obtain a dynamic configuration result.

[0176] In some embodiments, a unique access URL can be automatically generated when a report is published (generated by a built-in general page routing and a published configuration report report ID), and then permission configuration is realized according to the URL. The editing permission and the filling permission control can be realized according to the user, the role, and the organization. In the report query and filling, the interface filtering is increased, and finally the cache redis is written. If there is no permission, the corresponding report data is not returned, so as to realize permission control. The flow chart of the permission configuration is as follows: Figure 7As shown, the permission configuration request can be obtained first, wherein the content of the permission configuration request includes the user ID and the report ID, and can also include the report name and other query parameters. Then, according to the permission configuration request, a unique cache key is generated, and according to the unique cache key, a permission query is performed through the local memory cache to obtain a local cache permission query result. Exemplarily, the unique cache key can be generated according to the user ID and the report ID (such as userId: 1001: repId: da674ddc87ef0a675f8b2a0baf34a64d). It can be understood that the local memory cache (such as Guava Cache, Caffeine) is suitable for high-frequency and low-latency scenarios. If the local cache permission query result is a cache hit, the permission result is directly returned, and the cache expiration time is reset. If the local cache permission query result is a cache miss, a distributed cache (Redis) query process is entered, a permission query is performed through the distributed cache cluster to obtain a distributed cache permission query result, so as to reduce network overhead and improve response speed (microsecond level). Exemplarily, the Redis cluster can be used as the distributed cache, and the full-amount permission data is stored, the key is designed as perm: userId: 1001: repId: da674ddc87ef0a675f8b2a0baf34a64d. The data format is a JSON structure, for example:

[0177]

[0178]

[0179] Finally, the distributed cache permission query result is updated into the local memory cache to obtain a dynamic configuration result. Exemplarily, if Redis hits, the distributed cache permission query result is returned and the local cache is updated asynchronously (to reduce subsequent local cache penetration). If it is a miss, a database query is triggered. A relational database (such as MySQL) or a permission management special table can be used to perform a multi-table association query, combined with the user role, the resource permission table, the access control list (ACL), and the like.

[0180] Further, after obtaining the query result, if the data is queried, the result is written into the Redis cluster and the local cache. If the data is not queried, the default is to return {"hasAccess": false} and record the no permission log. Further, indexes can be added to the database (such as (userId, repId) to speed up the query. Read-write separation can also be used, and the slave database handles the query request, and the master database handles the permission change. Further, a cache update strategy can be used for cache update. When writing to Redis, the cache expiration time (such as 5 minutes) can be set to balance the data real-time performance and cache utilization, and the SETEX command is used to ensure atomic writing. When updating the local cache, the publish-subscribe mode (such as Redis Pub / Sub) can be used to notify other nodes to update the local cache, ensuring consistency within the cluster. The local cache is set to a short expiration time (such as 1 minute) to prevent long-term data inconsistency. During data synchronization, when the permission changes (such as user role adjustment), the old data in Redis and the local cache can be actively cleared (DEL perm:userId:1001:repId:da674ddc87ef0a675f8b2a0baf34a64d), and the database Binlog is listened to in real time to trigger cache invalidation.

[0181] In some embodiments, in step S102, according to the dynamic configuration result, data reporting is performed to obtain a reporting result, which can include but is not limited to the following steps:

[0182] According to the dynamic configuration result, the user ID, the report ID, the report style, the tab ID, and the tab name, the configuration template is saved to the database;

[0183] The template report data is queried from the database;

[0184] According to the template report data, the report details are queried from the database;

[0185] According to the report details, the report rendering is performed;

[0186] The reporting data written by the user in the report rendering interface is stored in the database, waiting for the approver to perform approval. The approver is used to audit the reporting data to obtain an audit result;

[0187] According to the audit result, the reporting data in the database is updated to obtain a reporting result.

[0188] In some embodiments, the flowchart of data reporting is as follows Figure 8As shown, the configuration template can be saved to the database according to the dynamic configuration result, user ID, report ID, report style, tab ID and tab name. Exemplarily, the user clicks the save template button to trigger the request, and the saved user ID, report ID, report style, tab ID and tab name can be represented as:

[0189]

[0190] Then query the template report data from the database, exemplarily, the user report interface clicks the query button to trigger the query request, and the template report data can be represented as:

[0191]

[0192] According to the template report data, query the report details from the database, exemplarily, the user clicks the report button to trigger the query request, and the report details can be represented as:

[0193]

[0194]

[0195] According to the report details, render the report, fill in the report data and submit, and the request for filling in the report data can be represented as:

[0196]

[0197] Store the report data written by the user in the report rendering interface into the database, and wait for the approver to approve. The approver is used to audit the report data and obtain the audit result. Exemplarily, the user clicks the report to be done to trigger the approval, and the approval result can be represented as:

[0198]

[0199] According to the audit result, update the report data in the database to obtain the report result. Exemplarily, the process approval interface or no process when submitting, the request for updating the database can be represented as:

[0200]

[0201] More, when querying the report record, the report data can be taken out from the database, and the user clicks the query button in the report record query interface to trigger the query request. The query request can be represented as:

[0202]

[0203] The report data taken out can be represented as:

[0204]

[0205]

[0206] It can be understood that after the configuration of the report template is stored in the database, the user reads the template and filters the reportable report according to the permission configuration function; then when entering the report filling data with permission, the operation button display strategy is automatically adjusted according to the work flow configuration function, and the corresponding interface (including style) and data (including dynamic data) are rendered according to the returned template data; after the user inputs the corresponding data and clicks submit, the system automatically identifies whether there is a configured work flow, judges whether to trigger the work flow interface and the data validation interface; if it is a work flow, the approver enters through the to-do interface, the report supports reading the corresponding filling data and the next approval information according to the to-do information, until the data validation interface is triggered after the approval is completed; finally, the user or administrator can also check the filling data in the report record.

[0207] In some embodiments, the purpose of the present embodiment is to solve many technical problems faced by existing Excel report templates in actual application, including: (1) improving data processing and editing efficiency: to solve the problem of low performance of traditional Excel in processing large-scale data, efficient storage and calculation of data are realized. At the same time, the response speed of editing operation is optimized to ensure that users can get real-time feedback when performing data input, formula calculation and other operations, improving work efficiency. (2) Realize business process automation: in order to break the gap between data filling and business process, the work flow engine is integrated into the Excel report template in the present embodiment. Data filling is no longer an isolated operation, but can automatically trigger the subsequent business approval process, realize the automatic transfer of business process, reduce manual intervention, and improve the accuracy and timeliness of business processing. (3) Enhance the flexibility and adaptability of report: in actual business, the demand for report is often complex and changeable. The report structure of traditional Excel report template is fixed, which is difficult to meet the demand of such dynamic change. The present embodiment designs a dynamic report rendering mechanism, which can automatically adjust the structure and content of the report according to the data source and user demand, greatly enhancing the flexibility and adaptability of the report, meeting the diversified report demand of enterprises. (4) Optimize the interactive experience of data filling: in order to improve the accuracy and efficiency of data filling, the present embodiment realizes the drop-down box linkage function. Through this interactive way, users can more conveniently select data, reduce the errors caused by manual input, and also improve the efficiency and user experience of data filling.

[0208] In some embodiments, the advantages of the present embodiment include: (1) efficient data processing capability: with the powerful computing resources and distributed architecture of cloud computing, the system can quickly process large-scale data to ensure real-time response of formula calculation, report generation and other operations. At the same time, through data caching and asynchronous processing mechanism, the data processing efficiency is further improved. (2) Strong real-time collaboration function: support multiple people to edit the same Excel filling template online at the same time, real-time synchronization of editing content, avoid version conflict. Users can communicate and collaborate in real time during the editing process, greatly improving team work efficiency. (3) Seamless system integration capability: provides rich API interfaces for easy integration with other business systems of the enterprise. Whether it is data import and export, or business process docking, it can be easily realized, breaking the information island, realizing the interconnection of data. (4) Flexible dynamic report generation function: can dynamically generate various complex report structures according to user needs and data source changes. Whether it is dynamic row, dynamic column, or nested report, it can be realized through simple configuration to meet the diversified report needs of enterprises. (5) Convenient drop-down box linkage setting: users only need to set the linkage relationship between the drop-down boxes through simple interface operation. The system will automatically update the drop-down box options according to the user's settings, reducing manual input and improving data filling accuracy and efficiency.

[0209] The beneficial effects of implementing the embodiments of the present application include: the embodiments of the present application first perform Excel dynamic configuration according to configuration functions to obtain dynamic configuration results, wherein the configuration functions include data source configuration, workflow configuration, dynamic row and column configuration, drop-down box configuration, jump configuration or permission configuration, and then perform data filling according to the dynamic configuration results to obtain filling results, so that Excel dynamic configuration filling can be realized through various configuration functions, thereby improving data processing efficiency and data accuracy. At the same time, the innovative design of the online editing Excel filling template product of the present embodiment effectively solves the pain points existing in the prior art, and provides an efficient, convenient and flexible data filling and processing tool for enterprises. Under the background of current digital transformation, the product has broad market application prospects.

[0210] As shown in Figure 9 The embodiments of the present application also provide an Excel dynamic configuration filling device, which comprises:

[0211] The first module 801 is configured to perform Excel dynamic configuration according to configuration functions to obtain dynamic configuration results, and the configuration functions include data source configuration, workflow configuration, dynamic row and column configuration, drop-down box configuration, jump configuration or permission configuration.

[0212] The second module 802 is configured to perform data filling according to the dynamic configuration results to obtain filling results.

[0213] The contents in the method embodiments are applicable to the device embodiments, the device embodiments specifically implement the functions same as the method embodiments, and achieve the same beneficial effects as the method embodiments.

[0214] As shown in Figure 10 The present application also provides a computer device, which comprises:

[0215] at least one processor 901;

[0216] at least one memory 902, configured to store at least one program;

[0217] When the at least one program is executed by the at least one processor, the at least one processor implements the method shown in Figure 1 .

[0218] The contents in the method embodiments are applicable to the device embodiments, the device embodiments specifically implement the functions same as the method embodiments, and achieve the same beneficial effects as the method embodiments.

[0219] The present application also provides a computer readable storage medium, which stores a computer program, and the computer program is executed by a processor to implement the method shown in Figure 1 .

[0220] The contents in the method embodiments are applicable to the storage medium embodiments, the storage medium embodiments specifically implement the functions same as the method embodiments, and achieve the same beneficial effects as the method embodiments.

[0221] The preferred embodiments of the present application are described above with reference to the accompanying drawings, and the scope of the present application is not limited thereto. Any modification, equivalent replacement and improvement made by those skilled in the art without departing from the scope and essence of the present application shall fall within the scope of the present application.

Claims

1. An Excel dynamic configuration reporting method, characterized in that: The following steps are involved: Perform dynamic Excel configuration according to the configuration function to obtain dynamic configuration results. The configuration function includes data source configuration, workflow configuration, dynamic row and column configuration, drop-down box configuration, jump configuration or permission configuration; According to the dynamic configuration result, data is reported to obtain a reporting result.

2. The method according to claim 1, characterized in that When the configuration function is the data source configuration, the Excel dynamic configuration is performed according to the configuration function to obtain the dynamic configuration result, including: Get data source configuration request; Set database connection information, including database type, IP port, account number, password and database driver; Performing a data query on the database according to the data source configuration request and the database connection information to obtain original metadata, wherein the original metadata includes a table name, a table type, a belonging mode, and a table comment; Performing structured processing on the original metadata; Performing in-depth analysis on the structured original metadata to obtain table structure information, wherein the table structure information includes field name, field type, and description; The structured original metadata and table structure information are cached using a least recently used cache strategy; The original metadata and table structure information after structured processing are extracted from the cache and rendered to obtain the dynamic configuration result.

3. The method according to claim 1, characterized in that When the configuration function is the workflow configuration, performing Excel dynamic configuration according to the configuration function to obtain a dynamic configuration result includes: Get report publishing request; Generate a unique identifier based on the report publishing request; generating a uniform resource locator based on the unique identifier and the security token; Determining whether an approval workflow exists based on the uniform resource locator; If there is an approval workflow, a process instance start request is sent to the workflow engine; The workflow engine is used to load the process configuration according to the process instance start request and the process ID, generate a process instance, and send an approval link to the approver according to the process instance; The approver is used to perform approval according to the approval link and obtain the approval result; If the approval result is approved, data validation processing is performed according to the process instance ID to obtain the dynamic configuration result.

4. The method according to claim 1, wherein When the configuration function is the dynamic row and column configuration, performing Excel dynamic configuration according to the configuration function to obtain a dynamic configuration result includes: Get dynamic row and column configuration request; Extracting a dynamic identifier from the dynamic row and column configuration request, where the dynamic identifier is used to identify a dynamic master cell, a dynamic row number, a dynamic column number, or a master cell position; Determine the database tables, fields, and associations that the dynamic rules depend on based on the dynamic identifier; Generate a structured rule object based on the database tables, fields, and association relationships that the dynamic rule depends on, wherein the structured rule object includes dynamic dimensions, screening conditions, and data association logic; Constructing a dynamic structured query language according to the structured rule object; Querying the database according to the dynamic structured query language to obtain the original data set; According to a preset data conversion strategy, the original data set is converted to obtain a data matrix; The data matrix is ​​used as the dynamic configuration result.

5. The method according to claim 1, wherein When the configuration function is the drop-down box configuration, the Excel dynamic configuration is performed according to the configuration function to obtain the dynamic configuration result, including: Get the drop-down box configuration request; According to the drop-down box configuration request, the cell enters the editing state; Receive context information of the cell, the context information including the current row ID, field name, and filter condition; Generate a unique cache key based on the context information, wherein the unique cache key includes an interface code and encoding parameters; Perform a local cache query based on the unique cache key to obtain a local cache query result; If the local cache query result is a cache miss, the query request information is sent to the backend server, the query request information includes authentication information and screening conditions, and the backend server is used to perform database query or business logic calculation to obtain the query data result; Writing the query data result and the unique cache key into the cache; Convert the query data result to obtain the data required by the drop-down component; The data required by the drop-down component is used as the dynamic configuration result.

6. The method according to claim 1, characterized in that When the configuration function is the jump configuration, the Excel dynamic configuration is performed according to the configuration function to obtain the dynamic configuration result, including: Get the jump configuration request; generating a jump identifier according to the jump configuration request; Sending the cell key parameters to a configuration server according to the jump identifier, wherein the configuration server is configured to return jump configuration information; According to the jump configuration information, add a click event listener for the cell, and replace the specific value of the current row data with the dynamic parameter in the jump configuration information; In response to a click on the cell, determining a jump link type; If the jump link type is an internal report jump, obtaining the access path of the target report from the configuration server as the dynamic configuration result; If the jump link type is an external link jump, the external link in the jump configuration information is used as the dynamic configuration result.

7. The method according to claim 1, characterized in that When the configuration function is the permission configuration, the Excel dynamic configuration is performed according to the configuration function to obtain the dynamic configuration result, including: Obtaining a permission configuration request, wherein the permission configuration request includes a user ID and a report ID; Generate a unique cache key based on the permission configuration request; Performing a permission query through the local memory cache based on the unique cache key to obtain a local cache permission query result; If the local cache permission query result is a miss, then perform a permission query through the distributed cache cluster to obtain a distributed cache permission query result; The distributed cache permission query result is updated to the local memory cache to obtain the dynamic configuration result.

8. The method according to claim 1, characterized in that The step of performing data reporting according to the dynamic configuration result to obtain a reporting result includes: Saving the configuration template to a database based on the dynamic configuration result, user ID, report ID, report style, page ID, and page signature; querying template report data from the database; querying report details from the database according to the template report data; Render the report according to the report details; The reported data written by the user in the report rendering interface is stored in the database and waits for approval by the approver, who reviews the reported data and obtains the review result; According to the audit result, the reporting data in the database is updated to obtain the reporting result.

9. An Excel dynamic configuration filling device, characterized in that: include: The first module is used to perform dynamic configuration of Excel according to the configuration function to obtain the dynamic configuration result. The configuration function includes data source configuration, workflow configuration, dynamic row and column configuration, drop-down box configuration, jump configuration or permission configuration; The second module is used to fill in data according to the dynamic configuration result and obtain the filling result.

10. A computer device, characterized in that: include: at least one processor; at least one memory for storing at least one program; When the at least one program is executed by the at least one processor, the at least one processor implements the method according to any one of claims 1 to 8.

Images