CN112464632A - Form style dynamic storage and conversion method under excel report - Google Patents
Form style dynamic storage and conversion method under excel report Download PDFInfo
- Publication number
- CN112464632A CN112464632A CN202011367167.3A CN202011367167A CN112464632A CN 112464632 A CN112464632 A CN 112464632A CN 202011367167 A CN202011367167 A CN 202011367167A CN 112464632 A CN112464632 A CN 112464632A
- Authority
- CN
- China
- Prior art keywords
- report
- data
- style
- relationship
- excel
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/183—Tabulation, i.e. one-dimensional positioning
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/451—Execution arrangements for user interfaces
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Software Systems (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Human Computer Interaction (AREA)
- Artificial Intelligence (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Document Processing Apparatus (AREA)
Abstract
The invention discloses a form style dynamic storage and conversion method under an electronic report, which divides the form style of a form under an electronic report file into a plurality of data blocks according to a specific object; the form style of the current form is represented by the report type, a plurality of data relation tables are established, the data relation tables are used for maintaining the relation among the data blocks, and the report type is stored in each data relation table; the style of the current electronic report file is represented by the version number, and the style of the current electronic report file comprises the table style of each table and the relationship between the table styles of each table; storing the version number into a version control table; a plurality of data blocks, a plurality of data relational tables, and a version control table are stored. The invention realizes dynamic management of form styles and can be compatible with historical data. After the method is adopted, the maintenance efficiency of the report data is very high, a large amount of labor hour and deployment cost are saved, and the expansibility is improved.
Description
Technical Field
The invention relates to the technical field of computers, in particular to a method for dynamically storing and converting table styles under an excel report.
Background
In conventional report development, a system back-end engineer generally establishes a corresponding report entity to store report data through a report style, and the report style is directly written on a page by a front-end engineer.
However, since the report style of the business system is not uniform, it may need to be adjusted accordingly by different policies. This results in that if we develop in the traditional way, it takes a lot of time to change the table style in the code every year, and the historical data is compatible.
Disclosure of Invention
The invention aims to solve the technical problems that the prior art aims at a new report form, the compatibility is poor, and a large amount of time and energy are needed to adjust data storage, and aims to provide a table form dynamic storage and conversion method under an excel report form, so that the problems of dynamic management of the table form and compatibility with historical data are solved.
The invention is realized by the following technical scheme:
a method for dynamically storing form styles under an excel report specifically comprises the following steps: splitting a sheet style of a sheet under an excel report file into a plurality of data blocks according to a specific object, wherein the data blocks comprise header names, header relations, list names, list relations, sheet relations and sheet formulas; the form style of the current sheet is represented by the report type, one report type corresponds to the relationship between data blocks, and the report type, the form style of the sheet and the relationship between the data blocks are in one-to-one correspondence; establishing a plurality of data relation tables, wherein the data relation tables are used for maintaining the relation among the data blocks and storing the report type into each data relation table; the method comprises the steps that the style of a current excel report file is represented through a version number, the style of the current excel report file comprises the relationship between the form style of each sheet and the form style of each sheet, one version number corresponds to the relationship between data relationship tables, and the relationship among the style, the version number and the data relationship tables of the excel report file corresponds to one another; establishing a version control table, and storing the version number into the version control table; storing the plurality of data blocks, the plurality of data relationship tables, and the version control table.
In the prior art, the report forms are stored according to a fixed format, and when the table is adjusted or changed, even if the adjustment is fine, the whole data storage needs to be modified and adjusted, so that great efforts are taken. The form style under the excel report is dynamically stored, the form style of the first sheet is firstly split into a plurality of data blocks, the connection among the data blocks is described by using a data relation table, and the form style of the current sheet is represented by a field of report type. And then, after the table style of each sheet in the excel report is disassembled, describing the relation between the sheets and the relation between the database relation tables through the version number, and representing the style of the excel report through the version number. According to the method, the excel report style and the sheet style in the excel report are respectively disassembled, the disassembled data blocks are stored, and the relationship among the disassembled data blocks is stored, so that dynamic storage of the form style of the excel report is achieved. The method can be used for storing the excel report regardless of the change of the style of the excel report.
When a new sheet form style appears, the new sheet form style is represented by a new report type, and when a new excel report style appears, the new sheet form style is represented by a new version number. Therefore, the report type and the version number are added to reflect different excel report styles and sheet form styles. When the sheet form style is adjusted or changed, only a new relation needs to be established on the basis of the data block, namely a new 'report type' is established; when the excel report form is adjusted or changed, only a new relation needs to be established on the basis of the data relation table, namely a new version number is established, and each small change in the data relation table is recorded and reflected through the version number, so that dynamic management is realized. The invention mainly realizes the dynamic report storage in the application system, the excel report style and the sheet form style can be self-defined, the version control is added, the compatibility of the historical data and the newly added data in the reports of different versions can be realized, and the dynamic management of the report style can be realized.
The method further comprises a management end, wherein the management end is used for acquiring the lower table style of the UI report and converting the lower table style of the UI report into the table style of the excel report file. After the form style in the UI report is obtained and converted into the form style under the excel report file, the dynamic management of the UI report is also realized according to the method of the invention.
Furthermore, the data relation table contains a plurality of fields, and part of the fields are simultaneously present in different data relation tables.
Further, the data relationship table includes: tableA, tableB, tableC, and tableD; the tableA is used for maintaining the list names; the tableB is used for maintaining and maintaining the tabular relation; the tableC is used for maintaining and maintaining the header name, the header relation and the table relation; the tableD is used for maintaining the table formula; and describing the version control table through tableE, and maintaining the version information of the excel report file.
Further, the interconnection between the data blocks and the data relation table is realized through a plurality of fields, which specifically comprises the following steps: the tableA includes fields: a main key, column name names, report types, whether an item header and a version main key exist; the tableB includes fields: the system comprises a main key, a list name table main key, a superior main key, a serial number, a y coordinate, a report type and a version main key; the tableC includes fields: the method comprises the following steps of (1) main keys, column relation table main keys, table head names, table head serial numbers, X coordinates, table description, table merging coordinates, report types and whether content and version main keys exist or not; the tableD includes fields: the method comprises the following steps of (1) automatically calculating a formula and a version main key according to a main key, coordinates, a table formula, table coordinates influenced by the formula, a formula type, formula description, a report type and the condition whether the formula and the version main key are automatically calculated or not; the tableE includes fields: a primary key, a version number, and a version description.
Further, obtaining tableA and tableB corresponding to the version number through the version number and the report type, performing table-linked query on the tableA and the tableB, and packaging a list title; determining a hierarchical relationship through the superior primary key, determining whether a title is thickened through whether the content exists, and defining a column y coordinate of a table through the y coordinate; obtaining tableC corresponding to the version number through the version number and the report type, determining the columns of the tables through a main key of tableB, sequencing through the serial numbers of talbeB, sequentially fixing the names of the table headers, determining whether the tables can be filled through the content, determining a merging cell through table merging coordinates, and rendering a primary report.
Furthermore, based on the primary reports, the corresponding primary reports are positioned through a formula, and data linkage between the primary reports is realized.
Further, formula data is obtained from tableD through a version main key and a report type, and a formula is obtained from the formula data through coordinates.
Further, the type of the formula is obtained by a formula type, and the formula type includes: formulas for verifying data errors and formulas for data rationality.
The invention also discloses a method for converting an excel report into a page report, which comprises a first processing end, a memory and a second processing end; disassembling the excel report, and the concrete process is as follows: splitting a sheet style of a sheet under an excel report file into a plurality of data blocks according to a specific object, wherein the data blocks comprise header names, header relations, list names, list relations, sheet relations and sheet formulas; the form style of the current sheet is represented by the report type, one report type corresponds to the relationship between data blocks, and the report type, the form style of the sheet and the relationship between the data blocks are in one-to-one correspondence; establishing a plurality of data relation tables, wherein the data relation tables are used for maintaining the relation among the data blocks and storing the report type into each data relation table; the method comprises the steps that the style of a current excel report file is represented through a version number, the style of the current excel report file comprises the relationship between the form style of each sheet and the form style of each sheet, one version number corresponds to the relationship between data relationship tables, and the relationship among the style, the version number and the data relationship tables of the excel report is in one-to-one correspondence; establishing a version control table, and storing the version number into the version control table; storing the plurality of data blocks, the plurality of data relation tables and the version control table by adopting a memory, responding to the request of the second processing terminal, and transmitting the plurality of data blocks and the plurality of data relation tables to the second processing terminal; reconstructing a UI report, which comprises the following specific processes: a second processing terminal is utilized to input a target version number of an excel format report file required by a UI report, and the second processing terminal sends a request to the memory; the memory indexes from the version control table according to the target version number to obtain a plurality of data blocks and a plurality of data relation tables corresponding to the target version number; the second processing terminal obtains a plurality of data blocks and a plurality of data relation tables; and the second processing terminal calls the data blocks and the data relation tables to reconstruct the form style of the excel report under the UI report, wherein the form style of the obtained UI report is the same as that of the excel format report file.
Compared with the prior art, the invention has the following advantages and beneficial effects:
the invention realizes the dynamic management of the report in the application system, the report style can be self-defined, the version control is added, and the historical data and the newly added data can be compatible in the reports of different versions. And the data calculation between report forms is realized by maintaining the calculation formula in the report forms. In the development of a new business system, a corresponding report can be quickly generated on a view interface by importing a formulated report template into the system, and then the report style, formula and version are controlled through a management interface. The complex report forms related to the finance are dynamically managed, the content increase and change which possibly occur in the financial report forms after the financial report forms are directly solved, the development efficiency of the report form function is accelerated, and the intelligent characteristic of the system is also embodied.
After the dynamic report is adopted, the maintenance efficiency in the project later stage is very high, a large amount of labor hour and project deployment cost are saved, and the expansibility of the project is also greatly improved.
Drawings
The accompanying drawings, which are included to provide a further understanding of the embodiments of the invention and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the invention and together with the description serve to explain the principles of the invention. In the drawings:
FIG. 1 is a diagram illustrating a method for implementing a dynamic report;
FIG. 2 is a data relationship representation.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is further described in detail below with reference to examples and accompanying drawings, and the exemplary embodiments and descriptions thereof are only used for explaining the present invention and are not meant to limit the present invention.
Example 1
Embodiment 1 is a method for implementing a dynamic report, and a method for dynamically storing a form style under an excel report specifically includes: splitting a sheet style of a sheet under an excel report file into a plurality of data blocks according to a specific object, wherein the data blocks comprise header names, header relations, list names, list relations, sheet relations and sheet formulas; the form style of the current sheet is represented by the report type, one report type corresponds to the relationship between data blocks, and the report type, the form style of the sheet and the relationship between the data blocks are in one-to-one correspondence; establishing a plurality of data relation tables, wherein the data relation tables are used for maintaining the relation among the data blocks, and storing the report type into each data relation table; the method comprises the steps that the style of a current excel report file is represented through a version number, the style of the current excel report file comprises the relationship between the form style of each sheet and the form style of each sheet, one version number corresponds to the relationship between data relationship tables, and the relationship among the style, the version number and the data relationship tables of the excel report file corresponds to one another; establishing a version control table, and storing the version number into the version control table; a plurality of data blocks, a plurality of data relational tables, and a version control table are stored.
In the prior art, the report forms are stored according to a fixed format, and when the table is adjusted or changed, even if the adjustment is fine, the whole data storage needs to be modified and adjusted, so that great efforts are taken. In this embodiment 1, form styles under an excel report are dynamically stored, the form styles of a first sheet are all split into multiple data blocks, the association between the data blocks is described by using a data relationship table, and the form style of the current sheet is represented by a field "report type". And then, after the table style of each sheet in the excel report is disassembled, describing the relation between the sheets and the relation between the database relation tables through the version number, and representing the style of the excel report through the version number. In this embodiment 1, the excel report style and the sheet style in the excel report are respectively disassembled, the disassembled data blocks are stored, and the relationship between the disassembled data blocks is stored, so that the dynamic storage of the form style of the excel report is achieved. The method of the embodiment 1 can be used for storing the excel report regardless of the change of the style of the excel report.
When a new sheet form style appears, the new sheet form style is represented by a new report type, and when a new excel report style appears, the new sheet form style is represented by a new version number. Therefore, the report type and the version number are added to reflect different excel report styles and sheet form styles. When the sheet form style is adjusted or changed, only a new relation needs to be established on the basis of the data block, namely a new 'report type' is established; when the excel report form is adjusted or changed, only a new relation needs to be established on the basis of the data relation table, namely a new version number is established, and each small change in the data relation table is recorded and reflected through the version number, so that dynamic management is realized. In this embodiment 1, the implementation of dynamic report storage in an application system is mainly completed, an excel report style and a sheet form style can be customized, version control is added, historical data and newly added data can be compatible in reports of different versions, and dynamic management of report styles is realized.
A management end may also be provided on the basis of this embodiment 1, where the management end is configured to obtain a table style under the "UI interface report" and convert the table style under the "UI interface report" into a table style under an excel report file. After the form style in the "UI interface report" is obtained and converted into the form style in the excel report file, the dynamic management of the "UI interface report" is also realized according to the method of this embodiment 1.
Example 2
Embodiment 2 is a method for converting an excel report into a page report based on embodiment 1, and includes a first processing end, a memory, and a second processing end;
firstly, disassembling an excel report, and the concrete process is as follows: splitting a sheet style of a sheet under an excel report file into a plurality of data blocks according to a specific object, wherein the data blocks comprise header names, header relations, list names, list relations, sheet relations and sheet formulas; the form style of the current sheet is represented by the report type, one report type corresponds to the relationship between data blocks, and the report type, the form style of the sheet and the relationship between the data blocks are in one-to-one correspondence; establishing a plurality of data relation tables, wherein the data relation tables are used for maintaining the relation among the data blocks, and storing the report type into each data relation table; the method comprises the steps that the style of a current excel report file is represented through a version number, the style of the current excel report file comprises the relationship between the form style of each sheet and the form style of each sheet, one version number corresponds to the relationship between data relationship tables, and the relationship among the style, the version number and the data relationship tables of the excel report is in one-to-one correspondence;
then establishing a version control table and storing the version number into the version control table;
the method comprises the steps that a memory is adopted to store a plurality of data blocks, a plurality of data relation tables and a version control table, and the plurality of data blocks and the plurality of data relation tables are transmitted to a second processing end in response to a request of the second processing end;
and finally reconstructing a UI report, wherein the specific process comprises the following steps:
a second processing terminal is utilized to input a target version number of an excel format report file required by a UI report, and the second processing terminal sends a request to a memory;
the memory indexes from the version control table according to the target version number to obtain a plurality of data blocks and a plurality of data relation tables corresponding to the target version number;
the second processing terminal obtains a plurality of data blocks and a plurality of data relation tables; and the second processing terminal calls the data blocks and the data relation tables to reconstruct the form style of the excel report under the UI report, wherein the form style of the obtained UI report is the same as that of the excel format report file.
In this embodiment 2, an Excel report in a Microsoft Excel worksheet state is analyzed in a dynamic management manner into a plurality of data blocks, a plurality of data relationship tables, and a version control table for managing version numbers, and the plurality of data blocks, the plurality of data relationship tables, and the version control table are stored in a memory in a scattered data form, where the memory in this embodiment 2 is usually a server. When the UI interface needs to call an Excel report stored in the server, according to the method of this embodiment 2, the Excel report in the Microsoft Excel worksheet state can be displayed in the form of a "UI interface report" on the UI interface.
Example 3
This embodiment 3 is a dynamic table solution for maintenance based on embodiment 1, and in order to solve the limitation of conventional report development in software development, the table maintenance is more flexible, the efficiency is improved, and the cost is reduced.
Firstly, the report is subjected to specific object splitting, and a complex table is split into six blocks, namely 1, the name of a table head, 2, the relation of the table head, 3, the name of a table column, 4, the relation of the table column, 5, the relation of the table and 6, the formula of the table.
And maintaining the data and the relation of the six blocks to realize the dynamic report. The specific implementation mode is that a server side for software development establishes 5 database relational tables. The table is mainly responsible for maintaining the table list entity table A of the table list name, the entity table B of the table list relation, the table relation table tableC of the table head and the table list, the formula table tableD of the table and the version control table tableE of the table, and the table relation is shown in figure 2.
And the specific logic flow acquires tableA and tableB linked query data of corresponding versions through the version number versionId and the report type, and encapsulates the tabular header data. The hierarchical relationship is determined by parentId (parent), whether the title is bolded is determined by isContent, and the table column y coordinate is defined by yCoordinate. And then acquiring the tableC data of the corresponding version through the version number versionId and the report type, determining the column of the table through tableBId, sequencing through orderNumber, sequentially fixing the headName, and determining whether the table can be filled through the isContent. And finally, determining a merging cell through a coordinate set of the formMergings array.
The forms of the form are often related, and data linkage between the forms is performed through a formula. Through the version number versionId, the report type obtains the formula data of the form from tableD. A specific formula, for example a19 ═ a16+ a17, is taken through the coordinate field. Formulas for verifying data errors and formulas for data rationality may be defined by the formulaType formula type. Because the table was previously rendered, the x, y coordinates have been fixed. Therefore, the data can be directly positioned to the corresponding table through the formula to carry out the check linkage of the data.
Example 4
This embodiment 4 is a method for implementing a dynamic report based on embodiment 3, as shown in fig. 1, and includes the following steps:
1. firstly, importing an Excel template, newly building a report at a management end, judging according to the style of the report, selecting a corresponding version without the corresponding version, newly building a version for the style of the current report, wherein one version corresponds to the style of the report.
2. And analyzing the style of the report, storing the report data into a database in another type, splitting the report into a plurality of data blocks, and storing the data blocks into the database according to a certain logical relationship.
3. Transmitting the data blocks in the database to the front end in a uniform data format;
the front end acquires a report form according to the actual service and fills in data;
the front end acquires a corresponding report style and a report formula through the report type and the version number, and initializes data;
the back end takes out the filled data and the formula of the report form through the service and analyzes the data through the formula;
the management interface edits and controls report forms, related formulas and version control.
4. And rendering a page at the front end, loading data, and verifying the data through a formula.
The dynamic report implementation method of this embodiment 4 is applied to financial report management to implement entry, calculation, and data analysis of numerous financial reports. In conventional report development, a system back-end engineer generally establishes a corresponding report entity to store report data through a report style, and the report style is directly written on a page by a front-end engineer. However, the financial statement style is often not consistent and needs to be adjusted by national financial policy each year. If the traditional development mode is adopted, a great amount of time is spent on sending out a hand to change the form style in the code every year, and the historical data is compatible. The dynamic report of embodiment 2 can solve this problem well.
In order to realize dynamic storage, firstly, a database for storing reports is divided into several data blocks:
1. report column name maintenance: the method is mainly used for storing the column attribute names of the maintenance report and defining whether the column names have header and other attributes.
2. Report column relationship maintenance: the method is mainly used for storing and maintaining the hierarchical relationship of report list names, sorting modes and defining the y-axis coordinate of the report.
3. Maintaining the name of the report head: the method is mainly used for storing the header attribute names of the maintenance report and the attribution relationship of the multi-level headers.
4. Maintaining the relation of the report head: the method is mainly used for storing and maintaining the relation between the headers of the report, sequencing the relation and defining the x-axis coordinate of the report.
5. And (3) report form maintenance: the method is mainly used for storing corresponding table attributes of the report, whether the cells are combined or not, whether the content needs to be filled or not and the like, and defines a unique identifier for mapping the filled data relation.
6. Report form formula maintenance: the method is mainly used for storing formula information corresponding to the report form and generating form data through formula verification.
After the dynamic management of the report is realized, the version control function after the report is changed needs to be considered. And when the report form style is obtained, obtaining the report form style through the version number and the report form type. The report modification only adds or deletes the table, and the data is stored through a json. The key value of Json is a unique identification code generated by the form, and when the form style and data are taken by the front end, data matching can be automatically carried out. Therefore, after the report is edited, the history data playback is not influenced.
This embodiment 4 mainly completes the implementation of the dynamic report in the application system. The report form style can be self-defined, version control is added, and the historical data and the newly added data can be compatible in reports of different versions. And the data calculation between report forms can be realized by maintaining the calculation formula in the report forms. In the development of a new business system, a corresponding report can be quickly generated on a view interface by importing a formulated report template into the system, and then the report style, formula and version are controlled through a management interface. And realizing dynamic management of the report. And dynamically managing the complex report forms related to the finance. Directly solving the possible content increase and change of the financial statement after the operation. And the development efficiency of the report function is accelerated. After the dynamic report is adopted, the maintenance after the project is very concise and efficient. Saving a large amount of labor hour and project deployment cost, and greatly improving the expansibility of the project.
The Excel report form refers to an Excel report form in a Microsoft Excel worksheet format of a computer; the invention relates to a sheet which is any one of Microsoft Excel working tables of a computer. The excel report includes one or more sheets.
The above-mentioned embodiments are intended to illustrate the objects, technical solutions and advantages of the present invention in further detail, and it should be understood that the above-mentioned embodiments are merely exemplary embodiments of the present invention, and are not intended to limit the scope of the present invention, and any modifications, equivalent substitutions, improvements and the like made within the spirit and principle of the present invention should be included in the scope of the present invention.
Claims (10)
1. A form style dynamic storage method under an excel report is characterized by specifically comprising the following steps:
splitting a sheet style of a sheet under an excel report file into a plurality of data blocks according to a specific object, wherein the data blocks comprise header names, header relations, list names, list relations, sheet relations and sheet formulas;
the form style of the current sheet is represented by the report type, one report type corresponds to the relationship between data blocks, and the report type, the form style of the sheet and the relationship between the data blocks are in one-to-one correspondence;
establishing a plurality of data relation tables, wherein the data relation tables are used for maintaining the relation among the data blocks and storing the report type into each data relation table;
the method comprises the steps that the style of a current excel report file is represented through a version number, the style of the current excel report file comprises the relationship between the form style of each sheet and the form style of each sheet, one version number corresponds to the relationship between data relationship tables, and the relationship among the style, the version number and the data relationship tables of the excel report file corresponds to one another;
establishing a version control table, and storing the version number into the version control table;
storing the plurality of data blocks, the plurality of data relationship tables, and the version control table.
2. The form style dynamic storage method under the excel report according to claim 1, comprising a management end, wherein the management end is used for obtaining the form style under the UI interface report and converting the form style under the UI interface report into the form style under the excel report file.
3. The form style dynamic storage method under an excel report according to claim 1, characterized in that the data relationship table contains a plurality of fields, and part of the fields appear in different data relationship tables at the same time.
4. The dynamic report storage method according to claim 1, wherein the data relationship table comprises: tableA, tableB, tableC, and tableD;
the tableA is used for maintaining the list names; the tableB is used for maintaining and maintaining the tabular relation; the tableC is used for maintaining and maintaining the header name, the header relation and the table relation; the tableD is used for maintaining the table formula; and describing the version control table through tableE, and maintaining the version information of the excel report file.
5. The dynamic report storage method according to claim 4, wherein the interconnection between the data blocks and the data relation table is realized by a plurality of fields, specifically:
the tableA includes fields: a main key, column name names, report types, whether an item header and a version main key exist;
the tableB includes fields: the system comprises a main key, a list name table main key, a superior main key, a serial number, a y coordinate, a report type and a version main key;
the tableC includes fields: the method comprises the following steps of (1) main keys, column relation table main keys, table head names, table head serial numbers, X coordinates, table description, table merging coordinates, report types and whether content and version main keys exist or not;
the tableD includes fields: the method comprises the following steps of (1) automatically calculating a formula and a version main key according to a main key, coordinates, a table formula, table coordinates influenced by the formula, a formula type, formula description, a report type and the condition whether the formula and the version main key are automatically calculated or not;
the tableE includes fields: a primary key, a version number, and a version description.
6. The dynamic report storing method according to claim 5,
obtaining tableA and tableB corresponding to the version number through the version number and the report type, performing table-linked query on the tableA and the tableB, and packaging a list title;
determining a hierarchical relationship through the superior primary key, determining whether a title is thickened through whether the content exists, and defining a column y coordinate of a table through the y coordinate;
obtaining tableC corresponding to the version number through the version number and the report type, determining the columns of the tables through a main key of tableB, sequencing through the serial numbers of talbeB, sequentially fixing the names of the table headers, determining whether the tables can be filled through the content, determining a merging cell through table merging coordinates, and rendering a primary report.
7. The dynamic report storage method according to claim 6, wherein based on the primary reports, the corresponding primary reports are located by a formula, and data linkage between the primary reports is realized.
8. The dynamic report storage method according to claim 7, wherein the formula data is obtained from tableD by the version home key and the report type, and the formula is obtained from the formula data by the coordinates.
9. The dynamic report storage method according to claim 8, wherein the type of the formula is obtained by a formula type, and the formula type comprises: formulas for verifying data errors and formulas for data rationality.
10. A method for converting an excel report into a page report is characterized by comprising a first processing end, a memory and a second processing end;
disassembling the excel report, and the concrete process is as follows:
splitting a sheet style of a sheet under an excel report file into a plurality of data blocks according to a specific object, wherein the data blocks comprise header names, header relations, list names, list relations, sheet relations and sheet formulas; the form style of the current sheet is represented by the report type, one report type corresponds to the relationship between data blocks, and the report type, the form style of the sheet and the relationship between the data blocks are in one-to-one correspondence; establishing a plurality of data relation tables, wherein the data relation tables are used for maintaining the relation among the data blocks and storing the report type into each data relation table; the method comprises the steps that the style of a current excel report file is represented through a version number, the style of the current excel report file comprises the relationship between the form style of each sheet and the form style of each sheet, one version number corresponds to the relationship between data relationship tables, and the relationship among the style, the version number and the data relationship tables of the excel report is in one-to-one correspondence; establishing a version control table, and storing the version number into the version control table;
storing the plurality of data blocks, the plurality of data relation tables and the version control table by adopting a memory, responding to the request of the second processing terminal, and transmitting the plurality of data blocks and the plurality of data relation tables to the second processing terminal;
reconstructing a UI report, which comprises the following specific processes:
a second processing terminal is utilized to input a target version number of an excel format report file required by a UI report, and the second processing terminal sends a request to the memory;
the memory indexes from the version control table according to the target version number to obtain a plurality of data blocks and a plurality of data relation tables corresponding to the target version number;
the second processing terminal obtains a plurality of data blocks and a plurality of data relation tables;
and the second processing terminal calls the data blocks and the data relation tables to reconstruct the form style of the excel report under the UI report, wherein the form style of the obtained UI report is the same as that of the excel format report file.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011367167.3A CN112464632B (en) | 2020-11-27 | 2020-11-27 | Dynamic storage and conversion method for table style under excel report |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011367167.3A CN112464632B (en) | 2020-11-27 | 2020-11-27 | Dynamic storage and conversion method for table style under excel report |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112464632A true CN112464632A (en) | 2021-03-09 |
| CN112464632B CN112464632B (en) | 2023-07-14 |
Family
ID=74809645
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011367167.3A Active CN112464632B (en) | 2020-11-27 | 2020-11-27 | Dynamic storage and conversion method for table style under excel report |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112464632B (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114004196A (en) * | 2021-12-30 | 2022-02-01 | 云账户技术(天津)有限公司 | Method and device for converting single data format of table |
| CN114021058A (en) * | 2021-11-09 | 2022-02-08 | 成都长虹网络科技有限责任公司 | Front-end page style management method and device, computer equipment and storage medium |
| CN115659934A (en) * | 2022-12-09 | 2023-01-31 | 泰盈科技集团股份有限公司 | Method for calculating and storing data of different worksheet columns in table document |
| CN117408338A (en) * | 2023-12-14 | 2024-01-16 | 神州医疗科技股份有限公司 | Method and system for constructing knowledge graph of traditional Chinese medicine decoction pieces based on Chinese pharmacopoeia |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030120686A1 (en) * | 2001-12-21 | 2003-06-26 | Xmlcities, Inc. | Extensible stylesheet designs using meta-tag and/or associated meta-tag information |
| CN109800264A (en) * | 2018-12-27 | 2019-05-24 | 平安科技（深圳）有限公司 | Diversified declaration form deriving method, device and storage medium |
| CN109948132A (en) * | 2019-03-18 | 2019-06-28 | 航天云网科技发展有限责任公司 | A kind of data of configuration template make a report on method and system |
| CN110618983A (en) * | 2019-08-15 | 2019-12-27 | 复旦大学 | JSON document structure-based industrial big data multidimensional analysis and visualization method |
| US20200073926A1 (en) * | 2017-05-09 | 2020-03-05 | Hefei Hanteng Information Technology Co., Ltd. | Form customization method and device |
-
2020
- 2020-11-27 CN CN202011367167.3A patent/CN112464632B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030120686A1 (en) * | 2001-12-21 | 2003-06-26 | Xmlcities, Inc. | Extensible stylesheet designs using meta-tag and/or associated meta-tag information |
| US20200073926A1 (en) * | 2017-05-09 | 2020-03-05 | Hefei Hanteng Information Technology Co., Ltd. | Form customization method and device |
| CN109800264A (en) * | 2018-12-27 | 2019-05-24 | 平安科技（深圳）有限公司 | Diversified declaration form deriving method, device and storage medium |
| CN109948132A (en) * | 2019-03-18 | 2019-06-28 | 航天云网科技发展有限责任公司 | A kind of data of configuration template make a report on method and system |
| CN110618983A (en) * | 2019-08-15 | 2019-12-27 | 复旦大学 | JSON document structure-based industrial big data multidimensional analysis and visualization method |
Non-Patent Citations (3)
| Title |
|---|
| VIACHESLAV PARAMONOV ET AL: "Table Header Correction Algorithm Based on Heuristics for Improving Spreadsheet Data Extraction", ICIST 2020: INFORMATION AND SOFTWARE TECHNOLOGIES * |
| 宋永利;: "一套智能的报表生成方法及设计原则", 自动化与仪器仪表 * |
| 汤加等: "一种基于单数据源的可视化自定义报表模型", 计算机科学 * |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114021058A (en) * | 2021-11-09 | 2022-02-08 | 成都长虹网络科技有限责任公司 | Front-end page style management method and device, computer equipment and storage medium |
| CN114004196A (en) * | 2021-12-30 | 2022-02-01 | 云账户技术(天津)有限公司 | Method and device for converting single data format of table |
| CN115659934A (en) * | 2022-12-09 | 2023-01-31 | 泰盈科技集团股份有限公司 | Method for calculating and storing data of different worksheet columns in table document |
| CN115659934B (en) * | 2022-12-09 | 2023-03-07 | 泰盈科技集团股份有限公司 | Method for calculating and storing different worksheet column data in table document |
| CN117408338A (en) * | 2023-12-14 | 2024-01-16 | 神州医疗科技股份有限公司 | Method and system for constructing knowledge graph of traditional Chinese medicine decoction pieces based on Chinese pharmacopoeia |
| CN117408338B (en) * | 2023-12-14 | 2024-03-12 | 神州医疗科技股份有限公司 | Method and system for constructing knowledge graph of traditional Chinese medicine decoction pieces based on Chinese pharmacopoeia |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112464632B (en) | 2023-07-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112464632A (en) | Form style dynamic storage and conversion method under excel report | |
| CN111881192B (en) | Method, system, electronic equipment and storage medium for generating visual configuration report | |
| US7970795B2 (en) | Data model development tool | |
| CN104572122B (en) | A kind of generating means and method of software application data | |
| JP5818394B2 (en) | System and method for operating a mass data platform | |
| US7159209B1 (en) | Inter-application validation tool for use in enterprise architecture modeling | |
| CN112651218A (en) | Automatic generation method and management method of bidding document, medium and computer | |
| CN102971703A (en) | Enhancing an inquiry for a search of a database | |
| CN111666344A (en) | Heterogeneous data synchronization method and device | |
| CN105933396B (en) | A kind of each canalization interface of collaboration realizes the method and system of long flow | |
| CN112214473B (en) | Data migration method and system between databases | |
| CN114625344A (en) | Application service generation system and service process configuration method | |
| CN111125045B (en) | Lightweight ETL processing platform | |
| CN114895875B (en) | Zero-code visual information system metadata production application method and system | |
| CN101546395A (en) | Method and equipment for generating service process model and method for identifying status field | |
| CN101179450A (en) | Network performance monitoring method and system and master control veneer and service veneer thereof | |
| CN112258151B (en) | Pampas-based account checking method, device, computer equipment and storage medium | |
| CN114139514A (en) | Intelligent report generation method and device and computer storage medium | |
| CN110515993B (en) | Tax data conversion method and system | |
| CN114528277A (en) | Method for dynamically configuring import service data | |
| CN101646191A (en) | Data processing method and device | |
| CN114090595A (en) | Drive type data processing method based on polymorphic power grid model | |
| CN112559837A (en) | Business electronic file development method | |
| CN111858670A (en) | Intelligent risk report generation method and report system for consumption financial industry | |
| US9412083B2 (en) | Aggregation and workflow engines for managing project information |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |