Data processing method based on dynamic configuration spreadsheet and storage medium

Abstract

The invention relates to the technical field of data information processing, in particular to a data processing method based on a dynamic configuration spreadsheet and a storage medium, the data processing method based on the dynamic configuration spreadsheet comprises the following steps: obtaining template configuration information and template labeling information input by an administrator, and generating a template metadata model; generating a data converter and hidden annotations corresponding to the template metadata model, and dynamically generating a spreadsheet template file with built-in hidden annotations; performing data conversion on the spreadsheet information filled by the user to obtain converted data; and packaging the converted data and storing the data into a database. The spreadsheet template file with the hidden annotation is correspondingly generated through the template configuration information and the template annotation information input by the administrator and the data processing method, so that the adaptability of the generated spreadsheet template to the requirements of the administrator is improved; and the user is prompted to the form filling rule of the corresponding list through the hidden annotation under the condition that the data calculation of the form is not influenced.

Description

Technical Field

[0001] This invention relates to the field of data information processing technology, and in particular to a data processing method and storage medium based on dynamically configured spreadsheets. Background Technology

[0002] With the rapid development of information technology, the speed of data generation and processing is constantly accelerating. Spreadsheets, as a carrier of data information, have a significant advantage in data processing efficiency. Currently, there are data information processing systems based on spreadsheets for data input, output, and processing. However, due to differences between users' form-filling syntax and computer data syntax rules, data import failures are prone to occur when user input is non-compliant, especially with dynamically configured spreadsheet-based data processing methods. Summary of the Invention

[0003] To address the problem that existing data import syntax rules based on dynamically configured spreadsheets differ from users' input syntax, leading to import failures due to non-compliant user input, this invention provides a data processing method and storage medium based on dynamically configured spreadsheets.

[0004] The present invention addresses the technical problem by providing a data processing method and storage medium based on dynamically configured spreadsheets. This method includes the following steps: obtaining template configuration information and template annotation information input by an administrator, integrating and encapsulating them to generate at least one template metadata model corresponding to the template configuration information and the template annotation information; parsing each template metadata model to generate a data converter and hidden comments in a one-to-one correspondence, and dynamically generating a spreadsheet template file containing the hidden comments based on the data converter; obtaining spreadsheet information filled in by the user according to the spreadsheet template file, and performing data conversion processing based on the spreadsheet information to obtain converted data; encapsulating the converted data into a unified data structure and storing it in a database; wherein the template configuration information includes the field structure, display attributes, validation rules, and data conversion rules of the spreadsheet template.

[0005] Preferably, obtaining the template configuration information and template annotation information input by the administrator specifically includes the following steps: based on the business data pre-stored in the database, pre-configure multiple sub-configuration information and present them in the form of multiple sets of options on the user interface; obtain the combination of multiple sub-configuration information selected by the administrator and the template annotation information input by the administrator, integrate and encapsulate them to generate a single template metadata model; repeat the above two steps until each piece of template configuration information and template annotation information is converted into the corresponding template metadata model.

[0006] Preferably, generating a spreadsheet template file with the built-in hidden comments specifically includes the following steps: parsing the template configuration information in the template metadata model, generating the corresponding data converter, and generating table column templates based on the data converter; detecting whether the template annotation information in the template metadata model is empty, and if not, generating hidden comments at the header of the table column templates; merging each table column template to generate the spreadsheet template file with hidden comments.

[0007] Preferably, the template annotation information further includes overall template annotations and template field annotations, wherein the template field annotations correspond to the hidden header annotations of the generated table column template; after generating the spreadsheet template file with hidden annotations, the method further includes: detecting whether the overall template annotation is empty, and if not, generating a hidden annotation at the title of the spreadsheet template file.

[0008] Preferably, the data processing method based on dynamically configured spreadsheets has at least one associated appendix configured based on the business data of the database, and the template configuration information includes associated appendix information; when dynamically generating the spreadsheet template file, at least one associated appendix may be output or no associated appendix may be output according to the associated appendix information input by the administrator.

[0009] Preferably, the template configuration information further includes example fill-in content and example fill-in rules; generating the spreadsheet template file with hidden comments specifically includes the following steps: based on the administrator's selection, generating a form filling guide template in the format of "header name-fill-in content-fill-in rules"; obtaining the example fill-in content and example fill-in rules input by the administrator, and filling them into the tables under the corresponding header items of the form filling guide template to generate a form filling guide table; adding the form filling guide table as an appendix to the spreadsheet template file, and outputting the form filling guide together.

[0010] Preferably, obtaining the spreadsheet information filled in by the user according to the spreadsheet template file specifically includes the following steps: obtaining the spreadsheet information and validating the spreadsheet information based on the validation rules of the template configuration information to detect whether there are input syntax errors; if yes, generating an error log that can track error points; if no, obtaining the validation result, and then performing data conversion processing on the validation result to obtain the converted data.

[0011] Preferably, the same template metadata model is used to drive the generation of the spreadsheet template, the verification of the spreadsheet information imported by the user, and the data conversion processing of the verification results.

[0012] Preferably, the template configuration information is represented using enumerated values.

[0013] To solve the above-mentioned technical problems, the present invention also provides a computer-readable storage medium having a computer program stored thereon, wherein when the computer program is executed by a processor, it implements the data processing method based on a dynamically configured spreadsheet as described in any of the preceding claims.

[0014] Compared with the prior art, the data processing method and storage medium based on dynamically configured spreadsheets of the present invention have the following advantages: 1. The data processing method based on dynamically configured spreadsheets of the present invention includes the following steps: obtaining template configuration information and template annotation information input by the administrator, and generating at least one template metadata model accordingly; generating a data converter and hidden comments for each template metadata model, and dynamically generating a spreadsheet template file with built-in hidden comments; obtaining spreadsheet information filled in by the user, performing data conversion and obtaining the converted data; encapsulating the converted data into a unified data structure and storing it in a database. By using the template configuration information and template annotation information input by the administrator, the data processing method generates a spreadsheet template file with hidden comments, improving the adaptability of the generated spreadsheet template to the administrator's needs, and prompting the user with the form-filling rules of the corresponding list through hidden comments without affecting the calculation of the spreadsheet data.

[0015] 2. The present invention obtains the template configuration information and template annotation information input by the administrator, specifically including the following steps: Based on the business data pre-stored in the database, multiple sub-configuration information is pre-configured; the combination of multiple sub-configuration information selected by the administrator and the template annotation information input by the administrator are obtained, integrated and encapsulated to generate a single template metadata model; the above two steps are repeated until each piece of template configuration information and template annotation information has been converted. Through the pre-set sub-configuration information, the administrator can obtain the result immediately after completing the configuration information selection. The operation is simple and timely, improving the convenience of use, while reducing the burden of later system maintenance for developers.

[0016] 3. The specific steps for generating a spreadsheet template file with built-in hidden comments in this invention include: parsing the template configuration information in the template metadata model, generating a corresponding data converter and generating table column templates; detecting whether the template annotation information is empty; if not, generating hidden comments in the header of the table column templates; and merging each table column template. By generating table column templates with comments, all column annotations correspond one-to-one with the fields, preventing comment misalignment when merging to obtain the complete template, thus greatly improving the accuracy of spreadsheet template generation.

[0017] 4. The template annotation information of this invention also includes overall template annotations and template field annotations. The template field annotations correspond to the hidden header comments of the generated table column template. After generating the spreadsheet template file with hidden comments, the method further includes: checking whether the overall template annotation is empty; if not, generating a corresponding hidden comment in the title of the spreadsheet template file. By annotating the overall purpose and specific filling method or content of the template, it is beneficial for upstream and downstream to quickly align the purpose of the spreadsheet template. At the same time, it is convenient for administrators to trace back to the source through the annotation content when anomalies are found, reducing the cost required for later template maintenance.

[0018] 5. This invention is based on business data from a database. The data processing method also includes at least one associated appendix, and the template configuration information corresponds to the associated appendix information. When dynamically generating the spreadsheet template file, at least one associated appendix is ​​output, or none is output, based on the associated appendix information. By configuring the associated appendix, reference materials are further provided to users filling out the form, and their understanding of the form-filling logic is aided, thus improving the spreadsheet template file's ability to guide users to fill in the correct form content.

[0019] 6. The specific steps for generating a spreadsheet template file with hidden annotations in this invention include: generating a form-filling guide template in the format "Header Name - Content to be Filled - Filling Rules" based on administrator selection; obtaining the example content and example filling rules input by the administrator and filling them into the corresponding tables under the header items of the form-filling guide template to generate a form-filling guide table; and adding the form-filling guide table to the spreadsheet template file for output. Through the optional output of the form-filling guide, administrators can simultaneously output an example file with sample data when creating a spreadsheet template, further helping users understand the form-filling format and improving the readability and usability of the spreadsheet template file.

[0020] 7. The specific steps for obtaining spreadsheet information filled in by the user based on the spreadsheet template file in this invention include: obtaining the spreadsheet information and detecting whether there are input syntax errors based on the validation rules of the template configuration information; if so, generating an error log that can trace the error points; if not, obtaining the validation result, and then performing data conversion processing on the validation result to obtain the converted data. By validating the spreadsheet information entered by the user, the data processing method can quickly filter out the spreadsheet content with incorrect information before the above information data is converted, and return the log information that can locate the error to the user, which improves the traceability of erroneous data in the spreadsheet and helps users quickly locate and modify the spreadsheet content.

[0021] 8. In generating spreadsheet templates, verifying user-imported spreadsheet information, and performing data conversion processing on the verification results, the present invention uses the same template metadata model to drive the process. This facilitates the elimination of ambiguities in data processing or generation, and greatly improves the data consistency and maintainability of the data processing method based on dynamically configured spreadsheets.

[0022] 9. The template configuration information of the present invention is represented by enumeration values, which further restricts the input rules for users when filling out electronic forms, improves the standardization of user input, and thus reduces the generation of error messages or invalid input.

[0023] 10. The present invention also provides a computer-readable storage medium that has the same beneficial effects as the above-described data processing method based on dynamically configured spreadsheets, which will not be described in detail here. Attached Figure Description

[0024] To more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0025] Figure 1 This is a flowchart of the steps of the data processing method based on dynamically configured spreadsheets provided in the first embodiment of the present invention.

[0026] Figure 2 This is a flowchart of step S1 of the data processing method based on dynamically configured spreadsheets provided in the first embodiment of the present invention.

[0027] Figure 3 This is a flowchart of step S2 of the data processing method based on dynamically configured spreadsheets provided in the first embodiment of the present invention.

[0028] Figure 4 This is a flowchart of step S23 of the data processing method based on dynamically configured spreadsheets provided in the first embodiment of the present invention.

[0029] Figure 5 This is a flowchart of step S3 of the data processing method based on dynamically configured spreadsheets provided in the first embodiment of the present invention.

[0030] Figure 6 This is an example of the data processing method based on dynamically configured spreadsheets provided in the first embodiment of the present invention. Figure 1 .

[0031] Figure 7This is an example of the data processing method based on dynamically configured spreadsheets provided in the first embodiment of the present invention. Figure 2 . Detailed Implementation

[0032] To make the objectives, technical solutions, and advantages of this invention clearer, the invention 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 merely illustrative and not intended to limit the invention.

[0033] Please see Figure 1 The first embodiment of the present invention provides a data processing method based on dynamically configured spreadsheets, including the following steps: S1: Obtain the template configuration information and template annotation information input by the administrator, integrate and encapsulate them to generate at least one template metadata model corresponding to the template configuration information and template annotation information.

[0034] The template configuration information includes the field structure, display attributes, validation rules, and data conversion rules of the spreadsheet template.

[0035] Metadata models are methods and languages ​​used to describe specific types of models, playing a positive role in standardizing and structuring data for specific types of models. In this application, the template metadata model is used to describe the data structure, relationships, and uses between multiple fields set by the administrator, helping backend developers to manage and design spreadsheet templates.

[0036] Understandably, in this application, a single template metadata model refers to a corresponding column in the spreadsheet template generated by the corresponding data processing method.

[0037] S2: Parse each template metadata model, generate a data converter and hidden comments one by one, and dynamically generate a spreadsheet template file with built-in hidden comments based on the data converter.

[0038] Data converters are a type of converter that transforms data from one form to another, typically used to achieve compatibility and interoperability between different systems, formats, or domains.

[0039] Understandably, each template configuration information is equipped with a corresponding data converter, and each sub-configuration information corresponds to a data conversion rule. The data converter performs data conversion processing on the spreadsheet information, ensuring that the spreadsheet information and the data inside the data processing method are consistent in format and type, thereby reducing errors when the data processing method processes data and greatly improving the data processing efficiency of the data processing method based on dynamically configured spreadsheets.

[0040] For example, when the administrator enters the template configuration information as "yes / no", the data converter will convert the natural language "yes / no" into the computer language "true / false" to facilitate the software to perform data calculations.

[0041] As an optional implementation, the data processing method uses a data converter that enables bidirectional data conversion.

[0042] As an optional implementation, in this embodiment, the output spreadsheet template file is an Excel file, and the data converter uses the BaseConverter interface, which can automatically convert between Excel data and JavaBean data in both directions.

[0043] S3: Obtain the spreadsheet information filled in by the user based on the spreadsheet template file, and perform data conversion processing based on the spreadsheet information to obtain the converted data.

[0044] S4: Encapsulate the transformed data into a unified data structure and store it in the database.

[0045] Understandably, the hidden comments generated by the template annotation information in the final generated spreadsheet template file serve to prompt users on the rules for inputting content, without affecting the calculation of table data or the overall layout of the table. This reduces the user's error rate and, consequently, reduces the occurrence of data errors when importing the completed spreadsheet into the database.

[0046] Understandably, the data processing method generates spreadsheet templates based on the template configuration information input by the administrator, which improves the adaptability to different needs of the administrator and thus increases the application scenarios of the generated spreadsheet template files. In addition, the template configuration information and template annotation information encapsulated in the same template metadata model ensure a one-to-one correspondence between the two. If the administrator needs to adjust the column order of the spreadsheet template, the one-to-one correspondence of the template configuration information and template annotations avoids the occurrence of misalignment of annotations when generating the table.

[0047] As an optional implementation method, this application establishes database tables such as configuration templates, table templates, and domain templates to uniformly manage template configuration information, thereby improving the flexibility of data processing methods in generating spreadsheet templates to meet different business needs and improving the management efficiency of different spreadsheet templates.

[0048] Please see Figure 1 and Figure 2 Furthermore, step S1 specifically includes the following steps: S11: Based on the business data pre-stored in the database, multiple sub-configuration information is pre-configured and presented to the user interface in the form of multiple sets of options.

[0049] S12: Obtain the combination of multiple sub-configuration information selected by the administrator and the template annotation information entered by the administrator, integrate and encapsulate them to generate a single template metadata model.

[0050] S13: Repeat the above two steps until each template configuration information and template annotation information is converted into the corresponding template metadata model.

[0051] As an optional implementation, the data processing method of this application can also read template files uploaded by the administrator and initialize the spreadsheet template according to the template files.

[0052] Understandably, the pre-configuration of sub-configuration information allows administrators to select the required configuration information without additional input. On the one hand, it saves administrators time from having to input configuration content one by one, making it easy to operate; on the other hand, administrators can obtain the results immediately after completing the selection of configuration information, which is conducive to timely checking the correctness and rationality of the configuration content.

[0053] Understandably, sub-configuration information converges open inputs into a finite enumeration, and data processing methods can obtain new personalized spreadsheet templates through combination, greatly reducing the time developers spend on repetitive work due to updating code according to each user requirement. On the other hand, since the pre-configured sub-configuration information is all content that has been tested by developers in advance, the possibility of unexpected errors when administrators use sub-configuration information is greatly reduced, reducing the errors that may occur when outputting spreadsheet template files and improving the operational stability of data processing methods.

[0054] As an optional implementation, the sub-configuration information includes preset information of various types such as date, number, currency, and boolean; the data processing method provides the EasyExcelBaseModel composite class to encapsulate commonly used fields such as row number, custom fields, and error information, which improves the integrability and scalability of the template metadata model.

[0055] Please see Figures 1-3 Furthermore, step S2 specifically includes the following steps: S21: Parse the template configuration information in the template metadata model, generate the corresponding data converter, and generate table column templates based on the data converter.

[0056] S22: Check if the template annotation information in the template metadata model is empty. If not, generate a hidden annotation in the header of the table column template.

[0057] S23: Merge each table column template to generate a spreadsheet template file with hidden comments.

[0058] Understandably, the annotated table column templates correspond to the encapsulated template metadata model, ensuring that there are no misaligned annotations when adjusting the sorting between different columns, thus improving the accuracy of spreadsheet template generation. Furthermore, a single table column template can be reused in multiple spreadsheet templates, and administrators only need to add existing table column templates to generate new tables, significantly reducing the time required for administrators to re-copy tables.

[0059] Understandably, the independent generation of each table column template also improves the modularity of generating spreadsheet templates, making it easier to modify individual table column templates when they need to be edited, without having to modify the complete table generation code.

[0060] Understandably, the design of generating table column templates and hidden comments sequentially helps to quickly skip template annotation information without content, thus improving the response speed of generating spreadsheet template files; and the separation of the two operations also helps to quickly locate the error at the table column template generation point or the comment addition point when problems occur.

[0061] Furthermore, the template annotation information also includes overall template annotations and template field annotations, with the template field annotations corresponding to the hidden header comments of the generated table column templates; and after step S23, it also includes: S24: Check if the overall annotation of the template is empty. If not, generate a hidden annotation in the title of the spreadsheet template file.

[0062] Understandably, the overall template annotations annotate the overall purpose, table functions, and global filling rules of the spreadsheet template, while the template field annotations annotate the specific purpose, filling method, and filling content rules of a single field. The coexistence of both facilitates quick alignment of the usage effect of the spreadsheet template file between upstream and downstream, and further reduces the difficulty for users to understand the syntax rules of filling out the spreadsheet template.

[0063] Understandably, overall template annotations and template field annotations also facilitate administrators' self-checking of spreadsheet template logic and reverse tracing of problematic table columns after data import failures, reducing the cost required for later maintenance of spreadsheet templates.

[0064] Furthermore, the data processing method based on dynamically configured spreadsheets has at least one associated appendix configured based on the business data configuration of the database, and the template configuration information includes the associated appendix information. When dynamically generating the spreadsheet template file, at least one of the associated appendices can be output or no associated appendices can be output according to the associated appendix information input by the administrator.

[0065] Specifically, in this embodiment, the associated appendix is ​​output as a table in a spreadsheet template file.

[0066] Understandably, the configurable associated appendix is ​​a summary appendix of information related to the application areas of the spreadsheet templates that the administrator needs to generate. It further provides users with reference materials for filling out the form, making it easier for users to understand the form filling logic, improving the ability of the spreadsheet template to guide users to fill out the spreadsheet content correctly, and reducing the non-standard or non-standard content in the spreadsheets imported later.

[0067] Please combine further Figure 6 and Figure 7 For example, if an administrator wants to configure a spreadsheet template for collecting participant information, they can do so through methods such as... Figure 6 Configure information and obtain information through the user interface shown. Figure 7 The spreadsheet template file shown.

[0068] Figure 6 Part A of the document is a schematic diagram of the user interface, including the template name, template annotations, worksheet name, associated appendices, whether to enable the form filling guide, and template code items. Administrators fill in the overall template annotations in the template annotations section and select whether to add associated appendices and form filling guides.

[0069] Figure 6 The user interface in section A includes both required and optional fields. When an administrator clicks to add a new field or modify an existing field, a configuration interface for that individual field pops up. Figure 6 Taking the participant number field configuration interface in Part B as an example, the configuration interface includes fields, codes, input methods, field types, and field formats. The configuration interface also includes field comments, fill-in content, and fill-in rules. Administrators fill in template field annotations in the field comments.

[0070] Figure 7 Part A in the text is Figure 6 A diagram showing the generated spreadsheet template file corresponding to the template configuration information and template annotation information. Figure 6 The template name and worksheet name in the template correspond to the title and table name in the spreadsheet template, respectively. Non-empty template annotation items correspond to hidden comments generated at the title. Selected related appendices are output as appendices in the spreadsheet template file. Each added field corresponds to each column in the spreadsheet template. The input content of the field item corresponds to the header name of the table column template. Non-empty field annotation items generate hidden comments at the corresponding column header.

[0071] Please see Figure 1 , Figure 3 and Figure 4 Furthermore, the template configuration information also includes sample fill-in content and sample fill-in rules; and step S23 specifically includes the following steps: S231: Based on the administrator's selection, generate a form filling guide template in the format of "Form Header Name - Fill Content - Filling Rules".

[0072] As an optional implementation, “Header Name-Fill Content-Fill Rules” are the three table headers of the form filling guide template; understandably, each row of the form filling guide template corresponds to the fill rules and example display for each field in the spreadsheet template file.

[0073] S232: Obtain the example content and example filling rules entered by the administrator, and fill them into the tables under the corresponding header items of the form filling guide template to generate the form filling guide table.

[0074] S233: Add the form completion guide as an appendix to the spreadsheet template file and output the form completion guide together.

[0075] Understandably, when creating a spreadsheet template, the administrator can generate a corresponding form-filling guide. By showing actual filling examples, users can easily refer to the guide and imitate the input content when filling out the form template. Based on the provided annotations, this further reduces the user's misunderstanding and improves the readability and usability of the spreadsheet template file.

[0076] Please combine further Figure 6 and Figure 7 When the administrator is Figure 6 When you select "Yes" for the "Whether to enable form filling guide" item, Figure 7 The corresponding spreadsheet template in the document generates, for example: Figure 7 The form filling guide is attached to Part B; the “Header Name” column lists all the added field names in order, and the non-empty fill content and fill rule items are respectively filled in the “Fill Content (can be directly copied and pasted)” and “Fill Rule” cells in the corresponding fields.

[0077] Please see Figure 1 and Figure 5 Furthermore, step S3 specifically includes the following steps: S31: Obtain spreadsheet information and validate the spreadsheet information based on the validation rules of the template configuration information to detect whether there are input syntax errors; if so, generate an error log that can track the error points.

[0078] S32: If not, obtain the verification result, and then perform data conversion processing on the verification result to obtain the converted data.

[0079] Understandably, setting the data verification step before the data transformation step helps the data processing method quickly detect and filter out incorrectly filled table content, stop the data import process in time, ensure the accuracy and reliability of the content stored in the database, and reduce the wasted computing resources due to incorrect table content during transformation.

[0080] Understandably, returning log information that pinpoints the location of errors improves the traceability of erroneous data within spreadsheets, making it easier for users to quickly locate and correct the erroneous spreadsheet content.

[0081] As an optional implementation, this application adds validation annotations to data fields and combines them with a unified interface validator; understandably, this validation mechanism can be flexibly extended according to business rules to achieve automatic validation of numerical ranges, formats and complex logic, thereby realizing business logic validation of imported data.

[0082] Furthermore, the same template metadata model is used to drive the generation of spreadsheet templates, the verification of user-imported spreadsheet information, and the data conversion of the verification results.

[0083] Understandably, the same driving model helps eliminate ambiguity caused by different data processing or generation methods, improves data consistency throughout the entire process, and thus improves maintainability.

[0084] Understandably, a single template metadata model can be generated and reused multiple times without repeated reading and writing, greatly improving the data processing efficiency of data processing methods when performing large-scale data operations. If the template metadata model is updated, the reference-driven model in the above process is updated synchronously, without requiring developers to modify the code one by one.

[0085] Furthermore, template configuration information is represented using enumerated values.

[0086] Understandably, template configuration information represented by enumeration values ​​is generated as enumeration options within the spreadsheet template file, further restricting the user's input rules when filling out the spreadsheet, improving the standardization of user input, and reducing the generation of error messages or invalid input.

[0087] A second embodiment of the present invention provides a computer-readable storage medium storing a computer program thereon. When executed by a processor, the computer program implements the data processing method based on dynamically configured spreadsheets as described in any of the first embodiments. It can have the same beneficial effects as the data processing method based on dynamically configured spreadsheets in the first embodiment, and will not be elaborated further here.

[0088] In the embodiments provided by this invention, it should be understood that "B corresponding to A" means that B is associated with A, and B can be determined based on A. However, it should also be understood that determining B based on A does not mean determining B solely based on A; B can also be determined based on A and / or other information.

[0089] It should be understood that the phrase "one embodiment" or "an embodiment" throughout the specification means that a specific feature, structure, or characteristic related to the embodiment is included in at least one embodiment of the invention. Therefore, "in one embodiment" or "in an embodiment" appearing throughout the specification does not necessarily refer to the same embodiment. Furthermore, these specific features, structures, or characteristics can be combined in any suitable manner in one or more embodiments. Those skilled in the art should also recognize that the embodiments described in the specification are optional embodiments, and the actions and modules involved are not necessarily essential to the invention.

[0090] In various embodiments of the present invention, it should be understood that the sequence number of each process does not necessarily imply the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present invention.

[0091] The flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to various embodiments of this application. In this regard, each block in a flowchart or block diagram may represent a module, segment, or portion of code containing one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions indicated in the blocks may occur in a different order than those indicated in the drawings. For example, two consecutively indicated blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. It is particularly important to note that each block in the block diagrams and / or flowcharts, and combinations of blocks in the block diagrams and / or flowcharts, can be implemented using a dedicated hardware-based system that performs the specified function or operation, or using a combination of dedicated hardware and computer instructions.

[0092] The above provides a detailed description of the intelligent agent task processing method and storage medium disclosed in the embodiments of the present invention. Specific examples have been used to illustrate the principles and implementation methods of the present invention. The descriptions of the above embodiments are only for the purpose of helping to understand the method and core ideas of the present invention. At the same time, for those skilled in the art, there will be changes in the specific implementation methods and application scope based on the ideas of the present invention. Therefore, the content of this specification should not be construed as a limitation of the present invention. Any modifications, equivalent substitutions, and improvements made within the principles of the present invention should be included within the protection scope of the present invention.

Claims

1. A data processing method based on dynamically configured spreadsheets, characterized in that, Includes the following steps: Obtain the template configuration information and template annotation information input by the administrator, integrate and encapsulate them to generate at least one template metadata model corresponding to the template configuration information and the template annotation information; Each template metadata model is parsed, and a data converter and hidden annotations are generated one-to-one. A spreadsheet template file with the hidden annotations built in is dynamically generated based on the data converter. Obtain the spreadsheet information filled in by the user based on the spreadsheet template file, and perform data conversion processing based on the spreadsheet information to obtain the converted data; The transformed data is encapsulated into a unified data structure and stored in a database; The template configuration information includes the field structure, display attributes, validation rules, and data conversion rules of the spreadsheet template.

2. The data processing method based on dynamically configured spreadsheets as described in claim 1, characterized in that: Obtaining the template configuration information and template annotation information input by the administrator includes the following steps: Based on the business data stored in the database, multiple sub-configuration information is pre-configured and presented to the user interface in the form of multiple sets of options. The system obtains multiple sub-configuration information combinations selected by the administrator and template annotation information input by the administrator, integrates and encapsulates them to generate a single template metadata model; Repeat the above two steps until each template configuration information and template annotation information is converted into the corresponding template metadata model.

3. The data processing method based on dynamically configured spreadsheets as described in claim 1, characterized in that: Generating a spreadsheet template file with the built-in hidden comments includes the following steps: The template configuration information in the template metadata model is parsed to generate the corresponding data converter, and a table column template is generated based on the data converter. Check if the template annotation information in the template metadata model is empty; if not, generate a hidden annotation in the header of the table column template. Merge each of the table column templates to generate the spreadsheet template file with hidden comments.

4. The data processing method based on dynamically configured spreadsheets as described in claim 3, characterized in that: The template annotation information also includes overall template annotations and template field annotations, wherein the template field annotations correspond to the hidden header comments generated for the table column template; After generating the spreadsheet template file with hidden comments, the method further includes: detecting whether the overall annotation of the template is empty; if not, generating a hidden comment at the title of the spreadsheet template file.

5. The data processing method based on dynamically configured spreadsheets as described in claim 3, characterized in that: The data processing method based on dynamically configured spreadsheets has at least one associated appendix configured based on the business data of the database, and the template configuration information includes associated appendix information. When dynamically generating the spreadsheet template file, at least one associated appendix may be output or no associated appendix may be output according to the associated appendix information input by the administrator.

6. The data processing method based on dynamically configured spreadsheets as described in claim 3, characterized in that: The template configuration information also includes sample fill-in content and sample fill-in rules; generating the spreadsheet template file with hidden comments specifically includes the following steps: Based on the administrator's selection, a form filling guide template with the format "Form Header Name - Fill Content - Filling Rules" is generated; Obtain the example content and example filling rules input by the administrator, and fill them into the tables under the corresponding header items of the form filling guide template to generate the form filling guide table; The form completion guide is added as an appendix to the spreadsheet template file and output together with the form completion guide.

7. The data processing method based on dynamically configured spreadsheets as described in claim 3, characterized in that: Obtaining the spreadsheet information filled in by the user based on the spreadsheet template file specifically includes the following steps: The spreadsheet information is obtained and validated based on the validation rules of the template configuration information to detect whether there are any input syntax errors; if so, an error log with traceable error points is generated. If not, obtain the verification result, and then perform data conversion processing on the verification result to obtain the converted data.

8. The data processing method based on dynamically configured spreadsheets as described in claim 7, characterized in that: The same template metadata model is used to drive the generation of the spreadsheet template, the verification of the spreadsheet information imported by the user, and the data conversion processing of the verification results.

9. The data processing method based on dynamically configured spreadsheets as described in claim 1, characterized in that: The template configuration information is represented using enumerated values.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by the processor, it implements the data processing method based on dynamically configured spreadsheets as described in any one of claims 1-9.

Images