Method and system for converting Excel line data into visual blueprint view

Abstract

The invention belongs to the technical field of data processing, and particularly discloses a method and system for converting Excel line data into a visual blueprint view. According to the method, the line data metadata model is constructed based on the line data structure of the worksheet, so that the extraction of the data structure is automated, and the data and the elements of the visual blueprint can be accurately mapped; through the preset view element type library, the data mapping rule, the view style rule and the layout rule, the complex data of the Excel file can be automatically converted into the blueprint view which is clear in structure, visual and easy to understand, errors possibly caused by manual operation are avoided, the accuracy and consistency of data visualization are improved, and the data visualization efficiency is improved. By introducing an automatic difference labeling function for the reference version and the comparison version, changes between different versions can be accurately presented, and a user can quickly identify and analyze data differences, so that the efficiency of comparing multiple versions is improved, and convenience is provided for complex operations such as data merging and version management.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of data processing, in particular to a method and system for converting Excel row data into visual blueprint views. BACKGROUND

[0002] In daily data management, Excel is one of the commonly used tools. When dealing with complex data, especially when multiple versions of Excel data need to be compared or data needs to be merged, the traditional method usually relies on manual operation, which is inefficient and prone to errors. There is a lack of an effective tool in the prior art that can automatically convert Excel data into intuitive blueprint views and support data comparison and merging. SUMMARY

[0003] The main purpose of the present application is to provide a method for converting Excel row data into visual blueprint views, aiming to solve the technical problems in the prior art.

[0004] The present application provides a method for converting Excel row data into visual blueprint views, comprising: obtaining a plurality of worksheets of a to-be-processed Excel file and a row data structure of each worksheet, and constructing a row data metadata model according to the row data structure of each worksheet; obtaining a view element type library of a preset visual blueprint view, and configuring a conversion relationship between row data and the preset visual blueprint view according to the row data metadata model and the view element type library, wherein the conversion relationship includes data mapping rules, view element style rules, and view layout rules; obtaining a plurality of to-be-converted Excel files, and converting row data of each to-be-converted Excel file into an initial visual blueprint view according to the data mapping rules, the view element style rules, and the view layout rules, wherein the to-be-converted Excel files include a baseline version Excel file and a plurality of comparison version Excel files; performing parsing analysis on the baseline version Excel file and each comparison version Excel file to obtain corresponding data difference information; differentially labeling the corresponding initial visual blueprint view according to each of the data difference information to obtain a corresponding labeled visual blueprint view.

[0005] Preferably, the step of constructing a row data metadata model according to the row data structure of each worksheet comprises: obtaining a row data structure, wherein the row data structure includes a plurality of column names; obtaining the cell format attribute, the cell format string and all non-empty cells corresponding to each column name, and obtaining the data type and data format of the corresponding column name according to each cell format attribute and cell format string; obtaining the non-empty data of each non-empty cell, and obtaining the data length of the corresponding column name according to a plurality of non-empty data; obtaining the column data set of any two column names, and determining the data association relationship according to the two column data sets, wherein the column data set includes all non-empty data of the column name; taking each column name as a core index, and associating the data type, data format and data length of each column name with the corresponding core index to obtain the corresponding column-level metadata; obtaining all data association relationships of each column name, and constructing the association relationship mapping of each column name and other column names with the corresponding core index as the center; integrating a plurality of column-level metadata and association relationship mappings to form a row data metadata model.

[0006] As a preferred, the step of configuring the conversion relationship of the row data and the preset visual blueprint view according to the row data metadata model and the view element type library includes: obtaining the view element type library of the preset visual blueprint view, and matching the corresponding view element type from the view element type library according to the data type of each column name in the row data metadata model; configuring the data mapping rule according to the data format and data length of each column name in the row data metadata model and the matched view element type; determining the color attribute configuration, border style and font attribute configuration of the view element according to the data association relationship and data format of each column name in the row data metadata model, wherein the font attribute configuration includes font type and size, and font color and effect; determining the border width of the view element according to the data association relationship and data length of each column name in the row data metadata model, and obtaining the border attribute configuration according to the border width and border style; obtaining the number of non-empty data rows and the total number of rows of each column name in the row data metadata model, and obtaining the corresponding data non-empty proportion according to each non-empty data row number and total row number; determining the transparency attribute configuration of the view element according to each data non-empty proportion, and obtaining the view element style rule according to the transparency attribute configuration, the border attribute configuration, the color attribute configuration and the font attribute configuration; obtaining the width size and height size of the preset visual blueprint view, and determining the horizontal basic parameter and vertical basic parameter according to the width size and height size and the column number feature and row number feature in the row data metadata model, respectively; determining coordinate positions of each view element in the preset visual blueprint view according to the transverse basic parameter and the longitudinal basic parameter, to obtain a view layout rule.

[0007] As preferred, the step of converting the row data of each to-be-converted Excel file into an initial visual blueprint view according to the data mapping rule, the view element style rule and the view layout rule comprises: obtaining a plurality of worksheets of the to-be-converted Excel file, and associating and integrating the row data of the plurality of worksheets according to the data association relationship in the row data metadata model to obtain associated and integrated row data; obtaining the data type of each row data in the associated and integrated row data, and obtaining the corresponding view element type according to the data mapping rule and the data type of each row data; determining the view element attribute parameters required to be configured for each view element type according to the data mapping rule; determining the style attribute parameters required to be configured for each view element type according to the view element style rule; determining the coordinate position parameters of each view element in the blueprint view according to the style attribute parameters and the view element attribute parameters and based on the view layout rule; drawing each view element corresponding to each view element type according to the view element type, the core attribute parameter, the style attribute parameter and the coordinate position parameter on the preset visual blueprint view, and arranging and combining all the view elements according to the coordinate position parameters to generate an initial visual blueprint view.

[0008] As preferred, the step of analyzing the baseline version Excel file and each comparison version Excel file to obtain corresponding data difference information comprises: obtaining a row identification field according to the row data metadata model of the baseline version Excel file and each comparison version Excel file; extracting a baseline row identification set of the baseline version Excel file and a comparison row identification set of the row data of each comparison version Excel file, respectively, and obtaining an identification similarity between each baseline row identification in the baseline row identification set and each comparison row identification in each comparison row identification set; determining a corresponding row matching relationship according to each identification similarity, and obtaining a row-level difference type according to the row matching relationship; obtaining a cell data type of a matching row in the row-level difference type, obtaining a corresponding cell difference degree according to each cell data type, and determining a cell difference type according to each cell difference degree; obtaining a reference data association relationship set of the reference version Excel file and a comparison data association relationship set of each comparison version Excel file, and determining an association relationship type according to the reference data association relationship set and each comparison data association relationship set; integrating the association relationship type, the cell difference type and the row-level difference type to obtain data difference information.

[0009] As preferred, the step of annotating the corresponding initial visual blueprint view according to each of the data difference information to obtain a corresponding annotated visual blueprint view, comprising: establishing a mapping relationship between the data difference information and the view element according to the row identification in each of the data difference information and the row association relationship between the view element in the initial visual blueprint view; extracting corresponding new data row information, deleted data row information, modified data cell information and data association relationship change information from the data difference information according to each of the mapping relationship; obtaining corresponding new annotation attributes according to each of the new data row information, and generating corresponding new annotation view elements according to each of the new annotation attributes; obtaining corresponding deletion annotation attributes according to each of the deleted data row information, and generating corresponding deletion annotation view elements according to each of the deletion annotation attributes; obtaining corresponding modification annotation attributes according to each of the modified data cell information, and generating corresponding modification annotation view elements according to each of the modification annotation attributes; obtaining corresponding association annotation attributes according to each of the data association relationship change information, and generating corresponding association annotation view elements according to each of the association annotation attributes; integrating the plurality of association annotation view elements, modification annotation view elements, deletion annotation view elements and new annotation view elements with the unannotated view elements in the initial visual blueprint view to obtain the corresponding annotated visual blueprint view.

[0010] The application also provides a system for converting Excel row data into a visual blueprint view, comprising: a construction module configured to obtain a plurality of worksheets of a to-be-processed Excel file and a row data structure of each worksheet, and construct a row data metadata model according to the row data structure of each worksheet; a configuration module configured to obtain a view element type library of a preset visual blueprint view, and configure a conversion relationship between the row data and the preset visual blueprint view according to the row data metadata model and the view element type library, wherein the conversion relationship comprises a data mapping rule, a view element style rule and a view layout rule; a conversion module, configured to obtain a plurality of Excel files to be converted, and convert row data of each Excel file to be converted into an initial visual blueprint view according to the data mapping rules, view element style rules, and view layout rules, wherein the Excel files to be converted include a baseline version Excel file and a plurality of comparison version Excel files; A parsing module is used to parse and analyze the baseline version Excel file and each comparison version Excel file to obtain corresponding data difference information; The annotation module is used to perform difference annotation on the corresponding initial visual blueprint view according to each of the data difference information to obtain the corresponding annotated visual blueprint view.

[0011] Preferably, the building blocks include: A first acquiring unit is configured to acquire a row data structure, wherein the row data structure includes a plurality of column names; The second acquiring unit is used to acquire the cell format attributes, cell format string and all non-empty cells of the column corresponding to each column name, and respectively acquire the data type and data format of the corresponding column name according to each of the cell format attributes and cell format string; A third acquiring unit is configured to acquire non-empty data of each non-empty cell, and acquire the data length of the corresponding column name according to the plurality of non-empty data; a determination unit, configured to obtain column data sets of any two column names and determine a data association relationship based on the two column data sets, wherein the column data sets include all non-empty data of the column names; The association unit is used to use each column name as a core index and associate the data type, data format, and data length of each column name with the corresponding core index to obtain the corresponding column-level metadata; The construction unit is used to obtain all data associations for each column name and construct a mapping of the associations between each column name and other column names based on the corresponding core index; The integration unit is used to integrate the plurality of column-level metadata and association relationship mappings to form a row data metadata model.

[0012] The present invention also provides a computer device comprising a memory and a processor, wherein the memory stores a computer program, and when the processor executes the computer program, the steps of the above-mentioned method of converting Excel row data into a visual blueprint view are implemented.

[0013] The present invention also provides a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the steps of the above-mentioned method of converting Excel row data into a visual blueprint view.

[0014] The beneficial effects of the present application are: the present application is based on the row data structure of the worksheet, constructs the row data metadata model, thereby not only automates the extraction of the data structure, but also accurately maps the data and the elements of the visualization blueprint, so that the generated blueprint view is more consistent with the actual content and display requirements of the data, the complex data of the Excel file can be automatically converted into the blueprint view with clear structure, intuitive and easy to understand through the preset view element type library, data mapping rules, view style rules and layout rules, errors caused by manual operation are avoided, and the accuracy and consistency of data visualization are improved, through the introduction of the automatic difference marking function of the benchmark version and the comparison version, the changes between different versions can be accurately presented, which facilitates the user to quickly identify and analyze the data difference, thereby not only improving the efficiency of multiple version comparison, but also providing convenience for complex operations such as data merging and version management, and greatly reducing the manual processing time. BRIEF DESCRIPTION OF DRAWINGS

[0015] Figure 1 The method flowchart of an embodiment of the present application.

[0016] Figure 2 The system structure schematic diagram of an embodiment of the present application.

[0017] Figure 3 The internal structure schematic diagram of the computer equipment of an embodiment of the present application.

[0018] The implementation, functional features and advantages of the present application will be further described with reference to the embodiments and the accompanying drawings. DETAILED DESCRIPTION

[0019] It should be understood that the specific embodiments described herein are only used to explain the present application, and are not used to limit the present application.

[0020] As shown in the accompanying drawings, Figure 1 The present application provides a method for converting Excel row data into a visualization blueprint view, comprising: S1, obtaining a plurality of worksheets of a to-be-processed Excel file and a row data structure of each worksheet, and constructing a row data metadata model according to the row data structure of each worksheet; S2, obtaining a view element type library of a preset visualization blueprint view, and configuring a conversion relationship between the row data and the preset visualization blueprint view according to the row data metadata model and the view element type library, wherein the conversion relationship comprises data mapping rules, view element style rules and view layout rules; S3, acquire a plurality of to-be-converted Excel files, and convert row data of each to-be-converted Excel file into an initial visual blueprint view according to the data mapping rule, the view element style rule and the view layout rule, wherein the to-be-converted Excel files include a baseline version Excel file and a plurality of comparison version Excel files; S4, performing parsing analysis on the baseline version Excel file and each comparison version Excel file to obtain corresponding data difference information; S5, differentially marking the corresponding initial visual blueprint view according to each of the data difference information to obtain a corresponding marked visual blueprint view.

[0021] As described in the above steps S1-S5, wherein the to-be-processed Excel file refers to a basic Excel file used for constructing row data metadata model and configuring conversion relationship, which is the core input data carrier in the rule making stage of the entire technical solution, and its core role is to provide row data structure benchmark for extracting common features of data (such as column name, data type, format, association relationship, etc.), and its essence is a rule source file. By analyzing the row data structure of the file, a general standard for converting all subsequent Excel files into blueprint views is established, avoiding repeated conversion logic for each version. The to-be-converted Excel file refers to a set of Excel files that actually perform initial visual blueprint view conversion based on the configured conversion relationship, which is the core input data carrier in the rule application stage of the technical solution, and its core role is to serve as a conversion object to apply the general conversion rules extracted from the to-be-processed Excel file, and generate visual blueprint views that can be used for difference comparison and data merging. The essence is a rule application object file, which is the data subject that needs to be presented and analyzed through the blueprint view. The to-be-processed Excel file and the to-be-converted Excel file have three types of associations: structural consistency association, rule dependency association and target consistency association. The structural consistency association means that the structure of the to-be-converted file must match the metadata model extracted from the to-be-processed file. The rule dependency association means that the blueprint view conversion of the to-be-converted file completely depends on the conversion relationship configured by the to-be-processed file. The target consistency association means that both serve the core target of multi-version data visual comparison and merging.

[0022] The application obtains a plurality of worksheets of an Excel file to be processed and a row data structure of each worksheet, constructs a row data metadata model according to the row data structure of each worksheet, and effectively provides a basic framework for subsequent data processing by obtaining the worksheet and the row data structure of the Excel file. Unlike the manual import of Excel and the viewing one by one in the prior art, the application ensures the accuracy of data acquisition by automatically identifying the file structure and the row data, and reduces the workload of manual checking and inputting by automatically extracting the row data structure of each worksheet, thereby improving the data processing efficiency, avoiding data omission, errors and inconsistent structures caused by manual operation, and abstractly representing the data structure of each worksheet in the Excel file by constructing the row data metadata model. The construction of the metadata model enables the system to clearly understand the data structure of each worksheet and the relationship therebetween, thereby avoiding errors and redundant operations when subsequent mapping and conversion are performed. The establishment of the metadata model enables the system to flexibly adapt to the data structure of different Excel files and efficiently process cross-table data association problems, avoids the tedious processing of data structure by manual operation, acquires a view element type library of a preset visual blueprint view, configures a conversion relationship between the row data and the preset visual blueprint view according to the row data metadata model and the view element type library, and makes the subsequent view generation process customizable and standardized. Compared with the manual selection and adjustment of chart elements in the traditional method, the application provides a standardized element library, reduces human intervention, and ensures the consistency and standardization of the visual view. Different versions of Excel data can be uniformly displayed according to the standard view element types in the library, improving the readability, accuracy and overall consistency of the view. The use of the view element type library also improves the flexibility of the visual design, facilitating the subsequent view style updating and expansion. By associating the row data metadata model with the view element type library, a mapping rule of data to view is generated, ensuring that the conversion between data and visual elements not only conforms to the rules, but also has clear logic and reasonable structure. Compared with the traditional manual adjustment of the relationship between data and graphics, this automatic configuration reduces human errors, so that the data can automatically follow the established rules when mapped to the view elements, reducing the complexity of operation and the possibility of errors. Automatic mapping not only improves the efficiency, but also ensures the consistency of data and view, so that omission and error conversion can be avoided when processing complex data.

[0023] The implementation of the present application relies on the cooperation of the data mapping rule, the view element style rule and the view layout rule, automatically obtains data from multiple Excel files to be converted and uniformly visualizes the data, compared with the manual comparison of multiple Excel versions and the manual processing of data mapping in the prior art, the present application automatically completes the conversion of data to view through the preset rule, greatly improves the processing speed and accuracy, especially when facing large amounts of data or complex structure data, the manual operation of the traditional method is prone to error, and the automatic conversion can guarantee efficient and accurate data display, reduces the need for manual intervention, significantly improves the work efficiency and accuracy, by analyzing the reference version Excel file and each comparison version Excel file, corresponding data difference information is obtained, by analyzing the differences between the reference version Excel and the multiple comparison version Excel files, the multiple version Excel files can be accurately compared, which not only helps users quickly find the differences between versions, but also provides a basis for subsequent decision-making and analysis, manual comparison of multiple versions of Excel files in the prior art may miss some details, or even lead to misunderstanding of the comparison result, and automatic difference analysis not only saves a lot of manual comparison time, but also guarantees accurate detection of differences, the difference analysis result provides a basis for subsequent difference marking, and ensures that the changes between each version can be clearly reflected in the visual view, each data difference information is marked on the corresponding initial visual blueprint view to obtain a corresponding marked visual blueprint view, the difference marking can intuitively present the differences between the reference version and the comparison version in the visual blueprint view, compared with manual marking or simple difference comparison in the prior art, the present application reflects the difference information clearly and easily in the final visual view through the automatic marking process, which not only improves the accuracy of difference analysis, but also greatly reduces the risk of manual operation, through the graphical marking, the user can intuitively understand the specific differences between each version, and further analyzes or decides data according to the marking information, thereby improving the efficiency and accuracy of information processing.

[0024] In one embodiment, the step S1 of constructing the row data metadata model according to the row data structure of each worksheet comprises: S11, obtaining a row data structure, wherein the row data structure comprises a plurality of column names; S12, obtaining the cell format attribute, the cell format string and all non-empty cells of the column corresponding to each column name, and obtaining the data type and the data format of the column name corresponding to each cell format attribute and cell format string, respectively. S13, obtaining non-empty data of each non-empty cell, and obtaining data length of a corresponding column name according to a plurality of the non-empty data; S14, obtaining column data sets of any two column names, and determining data association relationship according to two column data sets, wherein the column data set includes all non-empty data of the column name; S15, taking each column name as a core index, and associating data type, data format and data length of each column name with the corresponding core index to obtain corresponding column-level metadata; S16, obtaining all data association relationships of each column name, and constructing association relationship mapping of each column name and other column names with the corresponding core index as the center; S17, integrating a plurality of the column-level metadata and the association relationship mapping to form a row data metadata model.

[0025] As described in steps S11-S17, wherein the non-empty cell describes a physical carrier in the Excel table, and the essence is to locate the cell position with content filled in the column, and the core function is to locate the physical range of data source, the non-empty data describes the specific information carried in the non-empty cell, and the essence is the content extracted from the non-empty cell itself, and the core function is to serve as the core object for analysis and calculation, and the data type of the column name is determined according to the cell format attribute, including: if the number format in the cell format attribute is regular and the data in the column can be converted into a floating-point number, then the data type is determined to be numerical according to the cell format attribute and the data conversion result; if the number format in the cell format attribute is text, or the data in the column contains non-numeric characters and cannot be converted into a floating-point number, then the data type is determined to be text according to the cell format attribute and the data characteristics; if the number format in the cell format attribute is date or time, then the data type is determined to be date according to the cell format attribute; if the data in the column only contains TRUE (true) or FALSE (false) two values, then the data type is determined to be Boolean according to the data value characteristics.

[0026] The data format of the column name is determined according to the cell format string, including: if the cell format string is “0.00”, then the data format is obtained as numerical data with 2 decimal places according to the format string parsing result; if the cell format string is “yyyy-mm-dd”, then the data format is obtained as date type data displayed in the year-month-day format according to the format string parsing result; if the cell format string is a letter, then the data format is obtained as text type data displayed according to the original characters according to the format string parsing result.

[0027] According to the data length of the plurality of non-empty data acquisition column names, the data length of the column name corresponding data includes: for text type data, the maximum value of the character number of all non-empty text type data in the column is taken as the length of the column name corresponding data by calculating the character number of each non-empty cell data; for numerical value type data, the maximum value of the sum of the integer part bit number and the decimal part bit number of all non-empty numerical value type data in the column is taken as the length of the column name corresponding data by calculating the sum of the integer part bit number and the decimal part bit number of each non-empty cell data; for date type data, the length of the column name corresponding data is directly determined as 8 bits according to the format characteristics; for Boolean type data, since it only contains TRUE or FALSE two fixed length values, and the character number of TRUE is 4 and the character number of FALSE is 5, the maximum value of the two is taken as the length of the column name corresponding data.

[0028] According to the data association relationship of the two column data sets, the data association relationship of any two column names A and B is determined, whether all non-empty data in the column data set of the column name A are contained in the column data set of the column name B, if all are contained, the data association relationship of the column names and is determined as a primary-foreign key association according to the data containing relationship; if there is data in the column data set of the column name C that satisfies the sum of the jth row data of the column name A and the jth row data of the column name B equal to the jth row data of the column name C, then the data association relationship of the column names A and C, and the column names C and B is determined as a logical dependency association according to the data logical operation relationship; if the column data sets corresponding to any two column names do not satisfy the containing relationship of the primary-foreign key association, nor satisfy the operation relationship of the logical dependency association, then the data association relationship of the two column names is determined as no association.

[0029] The row data metadata model is a structured metadata system formed by associating each item of attribute information corresponding to a column name, and creating an independent attribute storage unit for each column name is used to associate multi-dimensional attribute information obtained subsequently, so that the attribute data of each column name can be individually retrieved and updated, and the association relationship mapping of each column name and other column names can be constructed around the core index, so that a column inter-association network with each column name core index as a node and an association relationship as an edge can be formed, thereby completely reflecting the mutual dependency or association state of all column names. The column-level metadata is a core component of the data metadata, which takes the column name as the core index, and the system associates and stores the basic descriptive information of the column data, including data type, data format, data length, and associated inter-column data association relationship, etc. attributes, which is a key basic information carrier for subsequent data conversion, data verification, data visualization configuration and other operations.

[0030] The application can obtain the column names of the row data structure, obtain the cell format attribute, the cell format string and all non-empty cells of the column corresponding to each column name, obtain the data type and the data format of the column name corresponding to each cell format attribute and cell format string, obtain the column names of the row data structure, the system can determine the variables in the data set, form a global view, and ensure that a unified reference is used in subsequent steps, the format attribute and the format string of the cell are helpful for in-depth analysis of the structure and properties of the data, and the accuracy of the data is ensured, by determining the data type and the format of each column, the automatic classification and processing of the data can be realized, the subsequent data operation (such as merging, comparison, etc.) is more efficient and standardized, compared with the manual type specification in the traditional method, the application can automatically adapt to various data forms, greatly reducing the workload of manual discrimination, improving the work efficiency, by obtaining the non-empty data of each non-empty cell and obtaining the data length of the column name corresponding to the plurality of non-empty data, by obtaining the non-empty data, the system can effectively filter invalid information and process useful data, thereby not only improving the data quality but also helping to analyze the distribution and effectiveness of the data, in the traditional way, the data is often affected by the null value when processing the data, leading to inaccurate data analysis, and the application can make the subsequent data analysis more reliable.

[0031] The prior art generally cannot systematically identify the connection between data by acquiring column data sets of any two column names and determining the data association relationship according to the two column data sets, which is easy to lead to one-sidedness of data analysis, and the present application determines the association relationship between data, which is the key to understanding the data set. This step not only helps to discover potential correlations and relationship patterns between data, but also lays the foundation for interactive analysis of complex data sets. By taking each column name as a core index and associating the data type, data format, and data length of each column name with the corresponding core index, the corresponding column-level metadata is obtained. By taking the column name as the core index, a clear and structured metadata management framework is provided, enabling users to quickly access and analyze the data properties of a specific column. This structured information presentation method provides higher logicality and visual convenience compared to traditional flat data processing methods. By acquiring all data association relationships of each column name and constructing the association relationship mapping of each column name with other column names centered on the corresponding core index, the row data metadata model is formed by integrating multiple column-level metadata and association relationship mappings. The association relationship mapping of each column name provides a intuitive view, helping users understand the complex relationships between columns and supporting more in-depth data analysis, such as data exploration and aggregation analysis. Compared to traditional methods that lack such clear relationship mapping support, the efficiency of data mining is greatly improved. The final integration step can form a complete row data metadata model, providing a one-stop data view. This not only improves the systematicness and orderliness of data management, but also provides reliable support for subsequent decision-making. Compared to the prior art, the present application significantly improves the efficiency and accuracy of data processing through a systematic and automated method, reduces the risk of human error, and enhances the depth of data analysis, providing more accurate decision support for enterprises and users.

[0032] In one embodiment, the step S2 of configuring the conversion relationship of the row data with the preset visualization blueprint view according to the row data metadata model and the view element type library includes: S21, acquiring the view element type library of the preset visualization blueprint view, and matching the corresponding view element type from the view element type library according to the data type of each column name in the row data metadata model; S22, configuring the data mapping rule according to the data format and data length of each column name in the row data metadata model and the matched view element type; S23, determining the color attribute configuration, border style, and font attribute configuration of the view element according to the data association relationship and data format of each column name in the row data metadata model, wherein the font attribute configuration includes font type and size, and font color and effect; S24, determine the border width of the view element according to the data association relationship and data length of each column name in the row data metadata model, and obtain the border attribute configuration according to the border width and border style; S25, obtain the number of non-empty data rows and the total number of rows of each column name in the row data metadata model, and obtain the corresponding data non-empty proportion according to the ratio of each non-empty data row number and total row number; S26, determine the transparency attribute configuration of the view element according to each data non-empty proportion, and obtain the view element style rule according to the transparency attribute configuration, border attribute configuration, color attribute configuration and font attribute configuration; S27, obtain the width size and height size of the preset visual blueprint view, and determine the horizontal basic parameter and vertical basic parameter according to the width size and height size and the column number feature and row number feature in the row data metadata model respectively; S28, determine the coordinate position of each view element in the preset visual blueprint view according to the horizontal basic parameter and vertical basic parameter, and obtain the view layout rule.

[0033] As described above in steps S21-S28, wherein the data mapping rule is used to establish the corresponding relationship between the row data and the view element type and attribute, the view element style rule is used to define the visual presentation features of the view element, and the view layout rule is used to plan the spatial position of the view element in the blueprint view. The view element style rule needs to cover four core dimensions of color, border, font and transparency, to ensure that the style attribute is accurately corresponding to the data association relationship and data format, which includes numerical data, text data, date data and Boolean data. The color configuration of the view element corresponding to the numerical data is determined according to the format and association relationship of the numerical data, the color configuration of the view element corresponding to the text data is determined according to the format and association relationship of the text data, the color configuration of the view element corresponding to the date data is determined according to the format and association relationship of the date data, and the color configuration of the view element corresponding to the Boolean data is determined according to the format and association relationship of the Boolean data. The border style and font type and size of the view element are determined according to the data association relationship and data format type of each column name in the row data metadata model, and the font color and effect of the view element are determined according to the data association relationship and data format precision requirement of each column name in the row data metadata model.

[0034] The step of obtaining data mapping rules according to the data format and data length of each column name in the row data metadata model and the matching view element type configuration includes configuring the mapping rule configuration for numerical data and bar chart elements as follows: when the view element type is a bar chart (matching numerical data), the height, width and data annotation precision of the bar chart are defined according to the decimal place information and data length in the data format; and configuring the mapping rule configuration for text data and text box elements as follows: when the view element type is a text box (matching text data), the font format (such as regular, bold, italic) and number in the data format are defined. The mapping rule configuration defines the width, height, and font properties of the text box based on the length. The mapping rule configuration for date data and timeline elements is that when the view element type is timeline (matching date data), the mapping rule configuration defines the timeline node spacing, node style, and date label format based on the date display format and data length in the data format. The mapping rule configuration for Boolean data and switch elements is that when the view element type is switch element (matching Boolean data), the mapping rule configuration defines the switch element state, size, and display text based on the Boolean value display form and data length in the data format. The grid layout algorithm is used in combination with the number of columns, number of rows and data length in the row data metadata model to determine the coordinate position of each view element in the blueprint view. The horizontal basic parameter (column spacing) is calculated by dividing the difference between the preset width of the visual blueprint view and the sum of the widths of all column view elements in the row data metadata model by the total number of columns. Similarly, the vertical basic parameter (row spacing) can be calculated by the height size. The coordinate position of the view element in the preset visual blueprint view is calculated by the formula, which is: ,in, Indicates the Liedi The horizontal coordinate of the upper left corner of the row view element, Represents the column index, Represents the row index, Indicates the horizontal spacing, Indicates the Column view element width; ,in, Indicates the Liedi The upper left corner ordinate of the row view element, Represents the column index, Represents the row index, Indicates the vertical spacing, The average height of the view element is represented; finally, the verification and correction of the data mapping rule is performed by selecting part of the non-empty row data in the row data metadata model as sample data, generating corresponding view elements according to the mapping rule configured above, verifying the matching of the view element attribute and the data format and the data length, the layout rationality and the consistency of the view element and the data content respectively until all the view elements meet the accurate mapping, and ensuring the effectiveness of the data mapping rule.

[0035] The application provides a basis and a framework for further data visualization by acquiring the view element type library of the preset visual blueprint view and matching the corresponding view element type from the view element type library according to the data type of each column name in the row data metadata model, different types of view elements (such as columnar charts, pie charts, tables and the like) can be optimized according to different data types and analysis requirements, the preset library system can be flexibly configured according to the user demand, thereby improving the adaptability and accuracy of visualization, the data type is automatically matched with the view element, and the rationality and effectiveness of data display are ensured, for example, numerical data uses a columnar chart, and category data uses a pie chart, the intelligent matching significantly improves the accuracy of the visualization result, in the traditional technology, the user is often required to manually select the element type, which is easy to cause errors or inconsistency, and reduces the effectiveness of data interpretation, the data mapping rule is obtained by matching the data format and the data length of each column name in the row data metadata model with the view element type, the configuration of the data mapping rule can ensure that the data display is consistent with the nature of the data, avoids misleading display, and sets the rule by analyzing the data format (such as date, number) and the length (such as the number of characters), so that the user can more intuitively understand the data.

[0036] The color attribute configuration, border style, and font type and size, as well as font color and effect, of the view element are determined by the data association relationship and data format of each column name in the row data metadata model. Customizing the visual attributes of the view element according to the data association relationship and format can provide users with richer visual information and guidance. For example, using different colors to represent different types of data trends can help users quickly identify key data points and changes. Traditional methods usually rely on fixed style configurations, lack flexibility, and cannot effectively convey the emotions and trends behind the data. The border width of the view element is determined by the data association relationship and data length of each column name in the row data metadata model, and the border is obtained based on the border width and border style. Frame attribute configuration: the border width of view elements can reflect the relevance and importance of the data. By setting different widths, users can identify at a glance which data is more significant or requires attention. This dynamic adjustment capability is more effective in providing clear information than the traditional method of statically setting borders, and significantly improves the interactivity and readability of visualization. By obtaining the number of non-empty data rows and the total number of rows for each column name in the row data metadata model, and obtaining the corresponding data non-empty ratio based on the ratio of each non-empty data row to the total number of rows, the system can quantify the integrity and reliability of the data by analyzing the non-empty ratio of the data. This analysis helps users identify data quality issues, thereby performing targeted data cleaning or supplementation to enhance data availability.

[0037] The transparency attribute configuration of the view element is determined by the non-empty proportion of each data, and the view element style rules are obtained according to the transparency attribute configuration, border attribute configuration, color attribute configuration and font attribute configuration. The transparency setting can not only provide a more intuitive sense of information hierarchy, but also guide users to pay attention to more important or attention-grabbing data, improve data insights, and provide flexibility compared to the rigid settings in traditional methods, making the visualization results more expressive and attractive. By obtaining the width and height dimensions of the preset visualization blueprint view, and determining the horizontal basic parameters and vertical basic parameters respectively according to the width and height dimensions and the column and row characteristics in the row data metadata model, through comprehensive consideration of the view size, the system can reasonably layout the view elements to ensure the effectiveness of information communication. Reasonable layout reduces the sense of information congestion. , easy for users to read and understand, the coordinate position of each view element in the preset visualization blueprint view is determined by the horizontal basic parameters and the vertical basic parameters, the view layout rules are obtained, the coordinate position of the view elements is determined, and a scientific and reasonable layout rule is formed to ensure the orderliness and logic of information display. The effective layout design makes the data display more beautiful and professional. Compared with the traditional manual layout, the automatic positioning of elements can significantly improve the efficiency of visualization design and improve the neatness and readability of the final presentation. The present invention conducts in-depth analysis and automatic configuration through multiple dimensions such as data types, attributes, and associations, thereby solving the problems of low efficiency and easy errors in manual operations in the existing technology, making complex data processing more efficient and reliable, not only improving the performance of data visualization, but also providing strong support for user decision-making.

[0038] In one embodiment, step S3 of converting row data of each Excel file to be converted into an initial visual blueprint view according to the data mapping rules, view element style rules, and view layout rules includes: S31, obtaining multiple worksheets of the Excel file to be converted, and associating and integrating the row data of the multiple worksheets according to the data association relationship in the row data metadata model to obtain associated and integrated row data; S32, obtaining the data type of each row of data in the associated and integrated row data, and obtaining the corresponding view element type according to the data mapping rule and the data type of each row of data; S33. Determine the view element attribute parameters required to be configured for each view element type according to the data mapping rule; S34. Determine the style attribute parameters required to be configured for each view element type according to the view element style rule; S35. Determine the coordinate position parameters of each view element in the blueprint view according to the style attribute parameters and the view element attribute parameters and based on the view layout rule; S36, drawing each view element according to the view element type, the core attribute parameter, the style attribute parameter and the coordinate position parameter on the preset visual blueprint view, and arranging and combining all view elements according to the coordinate position parameter to generate an initial visual blueprint view.

[0039] As described in the above steps S31-S36, wherein the view element type includes a column chart, a text box, a time axis and a switch element, the view element attribute parameter includes a height reference value and a proportion coefficient of the column chart, a character width reference value and a single line height reference value of the text box, a time span coefficient of the time axis and a color threshold value of the switch element, the style attribute parameter includes a color value, a font attribute, a border attribute and a transparency, wherein the color value is calculated by a data value range in the view element attribute parameter, the font attribute is determined according to a column type in the column name association relationship, the border attribute is set according to a display priority of the view element type, and the transparency is calculated according to an importance weight of the data, and the coordinate position parameter includes a left upper corner abscissa, a left upper corner ordinate, a view element width and a view element height, wherein the abscissa is calculated by a total width of the blueprint view, a column number and a horizontal spacing, the ordinate is calculated by a total height of the blueprint view, a row number and a vertical spacing, and the view element width and height are calculated by the reference value and data characteristics (data length, data maximum value) in the view element attribute parameter.

[0040] The present application can avoid the traditional manual processing process by first obtaining the multiple worksheets of the Excel file to be converted and integrating the row data of the multiple worksheets based on the data association relationship in the row data metadata model, and can eliminate human errors in the manual comparison and association process through automatic data association, thereby greatly improving the processing efficiency and reducing the risk of errors. Compared with the manual operation mode in the prior art, this automatic integration mode not only saves time, but also ensures the accuracy and consistency of the data. By obtaining the data type of each row data in the associated and integrated row data, and obtaining the corresponding view element type according to the data mapping rule and the data type of each row data, the structured processing of the data is ensured, the type of each row data is determined according to the data mapping rule to determine the appropriate view element type, and each data point is directly bound to the corresponding visual display element, avoiding the problems of non-uniform, chaotic or unable to reflect the essence of data in the traditional mode. The data mapping rule system can intelligently determine the best presentation mode for each data type, which can improve the accuracy and flexibility of data display compared with the prior art.

[0041] The view element attribute parameter required to be configured for each view element type is determined through the data mapping rule, the attribute parameter required by each view element is automatically generated according to the type of the view element, the work flow of the designer is simplified, the automatic configuration through the data mapping rule can ensure that each view element meets the predetermined standard in visual effect, and the standardization and consistency of the entire design process are improved, the style attribute parameter required to be configured for each view element type is determined through the view element style rule, the style of the view element is usually manually configured by the designer in the prior art, which is time-consuming and easy to produce inconsistent design styles, and the application of the automatic style rule can unify and optimize the style configuration of each view element, so that the artificial intervention is reduced, the efficiency is improved, the style of all generated view elements is consistent, the design specification is met, and the visual effect of the final product is improved, the coordinate position parameter of each view element in the blueprint view is determined through the style attribute parameter and the view element attribute parameter and based on the view layout rule, the layout of the view element is usually completed by artificial experience in the traditional technology, and there is certain randomness and instability, and the coordinate position of each view element is calculated according to the view layout rule, so that the orderliness and standardization of the view layout are ensured, the layout efficiency is improved, and human errors are reduced, so that the finally generated blueprint is more neat and has high readability, the corresponding view element is drawn on the preset visual blueprint view through the view element type, the core attribute parameter, the style attribute parameter and the coordinate position parameter, and all view elements are arranged and combined according to the coordinate position parameter, to generate an initial visual blueprint view, the drawing efficiency and accuracy of the blueprint are greatly improved through the automatic drawing function, the drawing of the blueprint usually needs to be manually adjusted by the designer according to different requirements in the prior art, and a large amount of time is consumed and misplacement or inconsistent elements are easy to appear, the application can accurately draw each view element according to the parameters, ensure the efficient generation of the view, and avoid human errors, the accurate position and arrangement order of each element are ensured through the automatic arrangement and combination function, the repeated labor in the artificial process is avoided, so that the efficiency is improved, the consistency and neatness of the generated blueprint view are improved in vision, and the visual experience of the user is enhanced.

[0042] In one embodiment, the step S4 of obtaining corresponding data difference information by parsing and analyzing the benchmark version Excel file and each comparison version Excel file comprises: S41, obtaining a row identification field according to row data metadata models of the benchmark version Excel file and each comparison version Excel file; S42, respectively extract the reference row identifier set of the reference version Excel file and the comparison row identifier set of the row data of each comparison version Excel file, and obtain the identifier similarity between each reference row identifier in the reference row identifier set and each comparison row identifier in each comparison row identifier set; S43, determine the corresponding row matching relationship according to each identifier similarity, and obtain the row-level difference type according to the row matching relationship; S44, obtain the cell data type of the matching row in the row-level difference type, obtain the corresponding cell difference degree according to each cell data type, and determine the cell difference type according to each cell difference degree; S45, obtain the reference data association relationship set of the reference version Excel file and the comparison data association relationship set of each comparison version Excel file, and determine the association relationship type according to the reference data association relationship set and each comparison data association relationship set; S46, integrate the association relationship type, the cell difference type and the row-level difference type to obtain the data difference information.

[0043] As described in steps S41-S46, wherein the determination of the row identifier field is to check the column name association relationship of the row data metadata model of the reference version Excel file and each comparison version Excel file, and if there is a primary-foreign key association, the primary key column is extracted as the row identifier field; if there is no primary-foreign key association, the key column combination whose data uniqueness meets the preset threshold is selected from the column name set, and the data uniqueness is calculated by the repetition rate of each column data (the ratio of the number of repeated data to the total number of data). The row-level difference type includes new row, deleted row and matching row, if there is a row identifier in the comparison version Excel file whose identifier similarity with all row identifiers in the reference version Excel file is less than the preset similarity threshold, it is determined as a new row; if there is a row identifier in the reference version Excel file whose identifier similarity with all row identifiers in the comparison version Excel file is less than the preset similarity threshold, it is determined as a deleted row; if there is a row identifier in the comparison version Excel file whose identifier similarity with the row identifier in the reference version Excel file is not less than the preset similarity threshold, it is determined as a matching row; the calculation formula principle of the identifier similarity is 1 minus the difference degree, the calculation method of the cell difference degree is the ratio of the absolute difference value of two cell data to the maximum value of the absolute value of two cell data, the cell difference type includes modified cell and non-difference cell, if the cell difference degree is greater than the preset difference degree threshold, the cell is determined as a modified cell, if the cell difference degree is not greater than the preset difference degree threshold, the cell is determined as a non-difference cell.

[0044] The application obtains a row identification field according to a row data metadata model of a benchmark version Excel file and each comparison version Excel file, ensures unique identification and accurate positioning of each row data by obtaining the row data metadata model in the Excel file and extracting the row identification field, can provide a unique identifier for the row data of each version of the Excel file after extracting the row identification field, thereby effectively improving the data accuracy in the comparison process, can accurately compare each row by obtaining the row identification field, avoids the unclear or inconsistent row identification in the traditional method, extracts a benchmark row identification set of the benchmark version Excel file and a comparison row identification set of the row data of each comparison version Excel file, can divide the data set into clear comparison units by extracting the row identification set in the benchmark version and the comparison version Excel file, provides a basis for subsequent difference analysis, eliminates the data redundancy and confusion problems that may occur in the comparison process in the traditional method, can ensure consistent and accurate comparison of the row data between each version by the clear benchmark row identification and comparison row identification set, improves the quality and efficiency of data comparison, and obtains an identification similarity between each benchmark row identification in the benchmark row identification set and each comparison row identification in each comparison row identification set, the identification similarity calculation can accurately evaluate the matching degree between the benchmark row and the comparison row, is convenient for judging which rows in the two versions are similar, which rows are newly added or deleted, can greatly reduce the error of manual judgment, and improves the processing capacity of complex data sets, especially in the case of large data volume, can maintain high comparison efficiency.

[0045] The corresponding row matching relationship is determined through each identification similarity, the matching relationship of the corresponding row is further determined according to the identification similarity, the comparison between data can be sequentially performed, by introducing the identification similarity, more accurate matching relationship can be dynamically generated, for comparison of multiple versions of data, the traditional method may not effectively judge the influence of the order change, deletion or insertion of data between rows, and the present application can help the system better handle these situations through similarity analysis, greatly improving the automation and accuracy of data comparison, and obtaining a row-level difference type according to the row matching relationship, further analyzing the data difference of each row based on the row-level matching relationship, so that the data difference of each row can be classified, and it is clear which difference is at the row level and which difference is at the cell level, avoiding the confusion of the wrong level, which can improve the accuracy of comparison, especially when comparing multiple versions, all changes can be accurately identified, greatly improving work efficiency and accuracy, by obtaining the cell data type of the matching row in the row-level difference type, obtaining the corresponding cell difference degree according to each cell data type, by obtaining each cell data type and judging the difference type according to the difference degree, the further refinement of data difference processing is realized, through the judgment of the cell difference degree, the present application can identify the data changes at the detail level, such as slight changes in cell content, format changes, etc., greatly improving the depth and delicacy of data comparison, and then being able to cope with complex Excel file formats and data types, avoiding the neglect of format or small range changes in the traditional method, ensuring that all differences can be identified and accurately classified in time, and determining the cell difference type according to each cell difference degree, further refining the cell difference type, which can identify the specific difference type of each cell, through the judgment of the difference of the cell data type, more specific difference information can be provided for the user, so that the final comparison result not only stays at the large-scale comparison level, but also goes deep into each detail.

[0046] By acquiring the reference data association relationship set of the reference version Excel file and the comparison data association relationship set of each comparison version Excel file, and determining the association relationship type according to the reference data association relationship set and each comparison data association relationship set, the data dependency between different versions can be better understood by analyzing the association relationship of the data, and in the prior art, manual comparison can only focus on the data of a single row or cell, and lacks in-depth analysis of the mutual correlation between the data, while the present application can help to identify the logic and relationship between the data in multiple versions, especially in the case of complex dependence between the data, the corresponding relationship between the data can be accurately judged, the ability to process complex data sets is significantly improved, the result of data merging or version comparison is more accurate and comprehensive, the association relationship type, the cell difference type and the row-level difference type are integrated to obtain the data difference information, by integrating various difference types, a comprehensive difference report can be provided in the final result, this integration step eliminates the defect of fragmented processing of difference information in the traditional method, can provide complete difference information and clear report for the user, helps the user to quickly understand and make decisions, compared with the prior art, the present application can significantly improve the accuracy, efficiency and flexibility of data processing, eliminate the uncertainty caused by manual operation in an automated and intelligent manner, and further improve the quality of data comparison and merging.

[0047] In one embodiment, according to each of the data difference information, the corresponding initial visual blueprint view is annotated to obtain a corresponding annotated visual blueprint view, step S5, including: S51, according to the row identification in each of the data difference information and the row association relationship between the view element in the initial visual blueprint view, a mapping relationship between the data difference information and the view element is established; S52, according to each of the mapping relationship, the corresponding new data row information, the deleted data row information, the modified data cell information and the data association relationship change information are extracted from the data difference information; S53, according to the row identification of each new data row information, the mapped view element is searched and the current attribute of the corresponding view element is obtained, and according to the annotation rule of each new data row information, the current attribute of the view element is adjusted to obtain the corresponding new annotation attribute; S54, according to each of the new annotation attribute, the mapped view element is annotated to generate a corresponding new annotated view element; S55, according to the row identification of each deleted data row information, the mapped view element is searched and the current transparency and current color of the corresponding view element are obtained, and according to the annotation rule of each deleted data row information, the current transparency and current color of the view element are adjusted to obtain the corresponding deleted annotation attribute; S56, according to each of the delete annotation attribute, the mapping view element is marked, and the corresponding delete annotation view element is generated; S57, according to each modification data cell information modification row identifier and modification column identifier, the mapping view element is found and the current border attribute of the corresponding view element is obtained, and according to each modification data cell information annotation rule, the current border attribute of the view element is adjusted to obtain the corresponding modification annotation attribute; S58, according to each of the modification annotation attribute, the mapping view element is marked, and the corresponding modification annotation view element is generated; S59, according to each data association relationship change information association column identifier, the mapping of two view elements is found and the current position coordinates of the corresponding two view elements are obtained, and according to each data association relationship change information annotation rule, the current position coordinates of the two view elements are adjusted to obtain the corresponding association annotation attribute; S510, according to each of the association annotation attribute, the mapping of two view elements is marked, and the corresponding association annotation view element is generated; S511, the plurality of association annotation view elements, modification annotation view elements, delete annotation view elements and new annotation view elements are integrated with the unannotated view elements in the initial visual blueprint view, and the corresponding annotated visual blueprint view is obtained.

[0048] As described in steps S51-S511 above, the application establishes a mapping relationship between data difference information and view elements by the row identifier in each data difference information and the row association relationship of the view elements in the initial visualization blueprint view. The mapping of data difference information and view elements through the row identifier and the row association relationship of the view elements means that the data difference of each row has an accurate visualization mapping relationship. Compared with the traditional technology, which often relies on manual comparison and manual adjustment of the correspondence between rows and view elements, the error rate of manual intervention is high, and the efficiency is low. Through this mapping relationship, manual operation can be reduced, and the difference between data and view can be automatically and efficiently mapped, ensuring accuracy and avoiding the use of fuzzy matching or rough data comparison. This ensures that each row of difference information and its corresponding view element has consistency, reduces visualization display errors caused by mis-matching, and extracts corresponding new data row information, deleted data row information, modified data cell information, and data association relationship change information from each mapping relationship. By extracting new, deleted, modified, and data association change information from each mapping relationship, the view elements can be adjusted according to different types of data changes (such as new, delete, modify). This can accurately and systematically extract different categories of data difference information, avoid missing some details, reduce errors in manual operation, and improve efficiency through the differentiation and processing of different types of difference information. This simplifies the process of comparing multiple versions of data and greatly reduces the risk and errors introduced by manual processing.

[0049] The current attribute of the mapped view element is obtained through the row identifier of each new data row information, and the current attribute of the view element is adjusted according to the labeling rule of each new data row information to obtain the corresponding new labeling attribute. After the new data row is mapped to a specific view element, the view attribute can be automatically updated according to the new data, such as color, border, label, etc. This is more accurate than the traditional manual update of the view element, and ensures that each view update is completely consistent with the data change. The labeling rule is used to adjust the attribute of the view element, so that the display mode of the new data can automatically adapt to the change of the data content without manual intervention. Not only does it improve the automation level, but it also maintains a high consistency between the data and the visualization blueprint. Each new labeling attribute is used to label the mapped view element to generate the corresponding new labeled view element. The current transparency and current color of the mapped view element are obtained through the row identifier of each deleted data row information, and the current transparency and current color of the view element are adjusted according to the labeling rule of each deleted data row information to obtain the corresponding deletion labeling attribute. When deleting the data row, the transparency and color of the view element are adjusted to reflect the deletion of the data, which can directly show the operation of deleting the data and avoid the blank or error state left after deleting in the traditional method. The change of transparency and color not only makes the user understand at a glance, but also provides a more flexible view update method. Compared with the traditional method, the present application can better reflect the actual impact of data deletion by automatically adjusting the view attribute using rules, without the need for manual modification of the chart, reducing the chance of error.

[0050] The view element mapped by each deletion annotation attribute is annotated and processed to generate a corresponding deletion annotated view element, the view element mapped by each modified data cell information is found through the modified row identifier and the modified column identifier of each modified data cell information, and the current border attribute of the corresponding view element is obtained, and the current border attribute of the view element is adjusted according to the annotation rule of each modified data cell information to obtain a corresponding modified annotation attribute. When modifying the data cell, the border attribute of the view element is automatically adjusted, which can help the user quickly identify which data has changed. Through the regularized border adjustment mechanism, it can effectively ensure that each data change is clearly and accurately presented. Through the adjustment of the border attribute, the readability and interactivity of the view element can be enhanced, and the user can quickly identify the data modification part when viewing, thereby improving the efficiency of data comparison and contrast. The two view elements mapped by each modified annotation attribute are annotated and processed to generate a corresponding modified annotated view element, the current position coordinates of the two view elements are obtained through the association column identifier of each data association relationship change information, and the current position coordinates of the two view elements are adjusted according to the annotation rule of each data association relationship change information to obtain a corresponding association annotation attribute. Through each association annotation attribute, the two view elements mapped are annotated and processed to generate a corresponding association annotated view element, thereby solving the change of the association relationship between multiple columns or multiple rows of data. The logical consistency of the data and the synchronization of the view element can be maintained through accurate coordinate adjustment. Unlike the position disorder or misidentification that may occur in traditional methods, this method can ensure that the position relationship of the view after updating still meets the expectation after the data relationship changes. Through the use of data association changes to accurately adjust the position of the view element, the consistency and integrity of data visualization are ensured, so that the entire view can still maintain logicality and intuitiveness when updating data. By integrating the multiple association annotated view elements, the modified annotated view elements, the deletion annotated view elements and the newly added annotated view elements with the unannotated view elements in the initial visual blueprint view, a corresponding annotated visual blueprint view is obtained. By recombining all the annotation elements and integrating them with the unannotated view elements, a final visual blueprint is formed. Compared with the traditional manual step-by-step annotation addition, the automated integration process can greatly improve the efficiency and ensure the logical coherence and data consistency of the final view. Through automatic integration, annotation omissions or errors caused by human operation errors are reduced, the efficient display and high accuracy of the final view element are ensured, the conversion and update between data and the visual blueprint are more automated and intelligent, thereby improving the processing efficiency, reducing the risk of human intervention, and improving the accuracy and visualization effect.

[0051] As Figure 2 shown, the application also provides a system for converting Excel row data into a visual blueprint view, comprising: The constructing module is configured to acquire a plurality of worksheets of an Excel file to be processed and a row data structure of each worksheet, and construct a row data metadata model according to the row data structure of each worksheet; The configuring module is configured to acquire a view element type library of a preset visual blueprint view, and configure a conversion relationship between row data and the preset visual blueprint view according to the row data metadata model and the view element type library, wherein the conversion relationship includes data mapping rules, view element style rules and view layout rules; The converting module is configured to acquire a plurality of Excel files to be converted, and convert row data of each Excel file to be converted into an initial visual blueprint view according to the data mapping rules, the view element style rules and the view layout rules, wherein the Excel files to be converted include a baseline version Excel file and a plurality of comparison version Excel files; The parsing module is configured to perform parsing analysis on the baseline version Excel file and each comparison version Excel file to obtain corresponding data difference information; The marking module is configured to mark differences in the corresponding initial visual blueprint view according to each data difference information to obtain a corresponding marked visual blueprint view.

[0052] In one embodiment, the constructing module comprises: The first acquiring unit is configured to acquire a row data structure, wherein the row data structure comprises a plurality of column names; The second acquiring unit is configured to acquire a cell format attribute, a cell format string and all non-empty cells of a column corresponding to each column name, and acquire a data type and a data format of the corresponding column name according to each cell format attribute and cell format string, respectively; The third acquiring unit is configured to acquire non-empty data of each non-empty cell, and acquire a data length of the corresponding column name according to a plurality of non-empty data; The determining unit is configured to acquire column data sets of any two column names, and determine a data association relationship according to two column data sets, wherein the column data set comprises all non-empty data of the column name; The association unit is configured to take each column name as a core index, and associate a data type, a data format and a data length of each column name with the corresponding core index to obtain corresponding column-level metadata; The constructing unit is configured to acquire all data association relationships of each column name, and construct an association relationship mapping between each column name and other column names with the corresponding core index as the center; The integrating unit is configured to integrate a plurality of column-level metadata and association relationship mappings to form a row data metadata model.

[0053] It should be noted that the modules and units in the system for converting the Excel row data into the visual blueprint view correspond one-to-one to the steps in the method for converting the Excel row data into the visual blueprint view.

[0054] As shown in Figure 3 The computer device can be a server, and the internal structure thereof can be as shown in Figure 3 The computer device comprises a processor, a memory, a network interface and a database connected through a system bus. The processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for running the operating system and the computer program in the non-volatile storage medium. The database of the computer device is configured to store all data required in the process of the method for converting the Excel row data into the visual blueprint view. The network interface of the computer device is configured to communicate with an external terminal through a network connection. The computer program is executed by the processor to implement the method for converting the Excel row data into the visual blueprint view.

[0055] Those skilled in the art can understand that Figure 3 The structure shown in the above embodiment is only a block diagram of part of the structure related to the scheme of the present application, and does not constitute a limitation on the computer device to which the scheme of the present application is applied.

[0056] The computer program is executed by the processor to implement the method for converting the Excel row data into the visual blueprint view.

[0057] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program. The computer program can be stored in a non-volatile computer readable storage medium, and when the computer program is executed, the processes of the above-mentioned embodiment methods can be included. Any reference to memory, storage, databases, or other media in this application and in examples used herein, unless specifically stated otherwise, can include non-volatile and / or volatile memory. Non-volatile memory can include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM), or flash memory. Volatile memory can include random access memory (RAM) or external cache memory. As an illustration but not limitation, RAM is available in many forms such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (SSRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (Synchlink) DRAM (SLDRAM), Rambus direct RAM (RDRAM), direct RAM bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), etc.

[0058] It should be noted that in this document, the terms "comprising", "including", or any other variant thereof are intended to cover a non-exclusive inclusion, such that a process, device, article, or method that comprises a list of elements does not only include those elements, but can also include other elements not expressly listed or inherent to such process, device, article, or method. Without more limitations, the element defined by the statement "comprising a" does not exclude the presence of additional identical elements in the process, device, article, or method that includes the element.

[0059] The above description is only the preferred embodiment of the present application, and does not limit the patent scope of the present application. Any equivalent structure or equivalent process transformation, or direct or indirect application in other related technical fields, based on the content of the present application specification and drawings, is also included in the patent protection scope of the present application.

Claims

1. A method for converting Excel row data into a visual blueprint view, characterized in that: include: Obtain multiple worksheets of the Excel file to be processed and the row data structure of each worksheet, and build a row data metadata model based on the row data structure of each worksheet; Obtaining a view element type library of a preset visualization blueprint view, and configuring a conversion relationship between row data and the preset visualization blueprint view according to the row data metadata model and the view element type library, wherein the conversion relationship includes data mapping rules, view element style rules, and view layout rules; Acquire multiple Excel files to be converted, and convert row data of each Excel file to be converted into an initial visual blueprint view according to the data mapping rule, view element style rule, and view layout rule, wherein the Excel files to be converted include a baseline version Excel file and multiple comparison version Excel files; Parsing and analyzing the baseline version Excel file and each comparison version Excel file to obtain corresponding data difference information; The corresponding initial visual blueprint view is marked with differences according to each piece of data difference information to obtain a corresponding marked visual blueprint view.

2. The method for converting Excel row data into a visual blueprint view according to claim 1, characterized in that: The steps to build a row data metadata model based on the row data structure of each worksheet include: Obtaining a row data structure, wherein the row data structure includes a plurality of column names; Obtain the cell format attributes, cell format string, and all non-empty cells of the column corresponding to each column name, and obtain the data type and data format of the corresponding column name according to each of the cell format attributes and cell format string; Obtaining non-empty data of each non-empty cell, and obtaining the data length of the corresponding column name according to the plurality of non-empty data; Obtain column data sets of any two column names, and determine the data association relationship based on the two column data sets, wherein the column data sets include all non-empty data of the column names; Each column name is used as a core index, and the data type, data format, and data length of each column name are associated with the corresponding core index to obtain the corresponding column-level metadata; Get all data associations for each column name, and build a mapping of the associations between each column name and other column names with the corresponding core index as the center; The plurality of column-level metadata and association relationship mappings are integrated to form a row data metadata model.

3. The method for converting Excel row data into a visual blueprint view according to claim 1, characterized in that: The step of configuring the conversion relationship between row data and a preset visualization blueprint view according to the row data metadata model and the view element type library includes: and matching a corresponding view element type from a view element type library according to the data type of each column name in the row data metadata model; Obtaining a data mapping rule according to the data format and data length of each column name in the row data metadata model and the matching view element type configuration; Determining the color attribute configuration, border style, and font attribute configuration of the view element according to the data association relationship and data format of each column name in the row data metadata model, wherein the font attribute configuration includes font type and size and font color and effect; Determine the border width of the view element according to the data association relationship and data length of each column name in the row data metadata model, and obtain border attribute configuration according to the border width and border style; Obtain the number of non-empty data rows and the total number of rows for each column name in the row data metadata model, and obtain the corresponding data non-empty ratio based on the number of non-empty data rows and the total number of rows; Determine the transparency attribute configuration of the view element according to the non-space ratio of each data, and obtain the view element style rule according to the transparency attribute configuration, border attribute configuration, color attribute configuration and font attribute configuration; Obtaining a width and height of a preset visualization blueprint view, and determining horizontal basic parameters and vertical basic parameters respectively according to the width and height and the column number characteristics and row number characteristics in the row data metadata model; The coordinate position of each view element in the preset visualization blueprint view is determined according to the horizontal basic parameters and the vertical basic parameters to obtain the view layout rules.

4. The method for converting Excel row data into a visual blueprint view according to claim 1, characterized in that: The step of converting row data of each Excel file to be converted into an initial visual blueprint view according to the data mapping rules, view element style rules, and view layout rules comprises: Acquire multiple worksheets of the Excel file to be converted, and associate and integrate the row data of the multiple worksheets according to the data association relationship in the row data metadata model to obtain associated and integrated row data; Obtaining the data type of each row of data in the associated and integrated row data, and obtaining the corresponding view element type according to the data mapping rule and the data type of each row of data; Determine the view element attribute parameters required to be configured for each view element type according to the data mapping rule; Determine the style attribute parameters required to be configured for each view element type according to the view element style rules; Determine the coordinate position parameters of each view element in the blueprint view according to the style attribute parameters and the view element attribute parameters and based on the view layout rules; Draw each corresponding view element on the preset visual blueprint view according to the view element type, core attribute parameters, style attribute parameters and coordinate position parameters, and arrange and combine all view elements according to the coordinate position parameters to generate an initial visual blueprint view.

5. The method for converting Excel row data into a visual blueprint view according to claim 1, characterized in that: The step of parsing and analyzing the baseline version Excel file and each comparison version Excel file to obtain corresponding data difference information includes: Obtaining a row identification field according to the row data metadata model of the benchmark version Excel file and each comparison version Excel file; Extracting a reference row identifier set of the reference version Excel file and a comparison row identifier set of row data of each comparison version Excel file respectively, and obtaining an identifier similarity between each reference row identifier in the reference row identifier set and each comparison row identifier in each comparison row identifier set; Determining a corresponding row matching relationship according to each of the identification similarities, and obtaining a row-level difference type according to the row matching relationship; Obtaining the cell data type of the matching row in the row-level difference type, obtaining the corresponding cell difference degree according to each cell data type, and determining the cell difference type according to each cell difference degree; Obtaining a baseline data association relationship set of the baseline version Excel file and a comparison data association relationship set of each comparison version Excel file, and determining an association relationship type according to the baseline data association relationship set and each comparison data association relationship set; The association relationship type, cell difference type and row-level difference type are integrated to obtain data difference information.

6. The method for converting Excel row data into a visual blueprint view according to claim 1, characterized in that: The step of annotating the corresponding initial visual blueprint view according to each data difference information to obtain the corresponding annotated visual blueprint view includes: Establishing a mapping relationship between the data difference information and the view element according to the row identifier in each of the data difference information and the row association relationship between the view element in the initial visualization blueprint view; Extracting corresponding newly added data row information, deleted data row information, modified data cell information and data association relationship change information from the data difference information according to each of the mapping relationships; Acquire corresponding new annotation attributes according to each new data row information, and generate corresponding new annotation view elements according to each new annotation attribute; Obtain corresponding deletion mark attributes according to each deleted data row information, and generate corresponding deletion mark view elements according to each of the deletion mark attributes; Acquire corresponding modification annotation attributes according to each modified data cell information, and generate corresponding modification annotation view elements according to each modification annotation attribute; Acquire corresponding association annotation attributes according to each data association relationship change information, and generate corresponding association annotation view elements according to each of the association annotation attributes; The plurality of associated annotated view elements, modified annotated view elements, deleted annotated view elements and newly added annotated view elements are integrated with the unannotated view elements in the initial visual blueprint view to obtain a corresponding annotated visual blueprint view.

7. A system for converting Excel row data into a visual blueprint view, used to implement the method according to any one of claims 1 to 6, characterized in that: include: A construction module is used to obtain multiple worksheets of the Excel file to be processed and the row data structure of each worksheet, and to construct a row data metadata model based on the row data structure of each worksheet; a configuration module, configured to obtain a view element type library of a preset visualization blueprint view, and configure a conversion relationship between row data and the preset visualization blueprint view according to the row data metadata model and the view element type library, wherein the conversion relationship includes data mapping rules, view element style rules, and view layout rules; a conversion module, configured to obtain a plurality of Excel files to be converted, and convert row data of each Excel file to be converted into an initial visual blueprint view according to the data mapping rules, view element style rules, and view layout rules, wherein the Excel files to be converted include a baseline version Excel file and a plurality of comparison version Excel files; A parsing module is used to parse and analyze the baseline version Excel file and each comparison version Excel file to obtain corresponding data difference information; The annotation module is used to perform difference annotation on the corresponding initial visual blueprint view according to each of the data difference information to obtain the corresponding annotated visual blueprint view.

8. The system for converting Excel row data into a visual blueprint view according to claim 7, characterized in that: The building blocks include: A first acquiring unit is configured to acquire a row data structure, wherein the row data structure includes a plurality of column names; The second acquiring unit is used to acquire the cell format attributes, cell format string and all non-empty cells of the column corresponding to each column name, and respectively acquire the data type and data format of the corresponding column name according to each of the cell format attributes and cell format string; A third acquiring unit is configured to acquire non-empty data of each non-empty cell, and acquire the data length of the corresponding column name according to the plurality of non-empty data; a determination unit, configured to obtain column data sets of any two column names and determine a data association relationship based on the two column data sets, wherein the column data sets include all non-empty data of the column names; The association unit is used to use each column name as a core index and associate the data type, data format, and data length of each column name with the corresponding core index to obtain the corresponding column-level metadata; The construction unit is used to obtain all data associations for each column name and construct a mapping of the associations between each column name and other column names based on the corresponding core index; The integration unit is used to integrate the plurality of column-level metadata and association relationship mappings to form a row data metadata model.

9. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 6 are implemented.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

Images