CN112464632B - Dynamic storage and conversion method for table style under excel report - Google Patents
Dynamic storage and conversion method for table style under excel report Download PDFInfo
- Publication number
- CN112464632B CN112464632B CN202011367167.3A CN202011367167A CN112464632B CN 112464632 B CN112464632 B CN 112464632B CN 202011367167 A CN202011367167 A CN 202011367167A CN 112464632 B CN112464632 B CN 112464632B
- Authority
- CN
- China
- Prior art keywords
- report
- data
- style
- relation
- version
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- 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 method for dynamically storing and converting a table style under an electronic report, which divides the table style under the electronic report file into a plurality of data blocks according to specific objects; the method comprises the steps of representing a table style of a current table through report types, establishing a plurality of data relation tables, wherein the data relation tables are used for maintaining the relation among data blocks, and storing the report types into 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 relation 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 relationship tables, and a version control table are stored. The invention realizes the dynamic management of the form style and can be compatible with the historical data. After the method is adopted, the maintenance efficiency of report data is very high, a great 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 a table style under an excel report.
Background
In conventional report development, a system back-end engineer establishes a corresponding report entity through a report style to store report data, and the style of the report is directly written on a page by a front-end engineer.
However, because the reporting model of the business system is not constant, corresponding adjustments may need to be made by different policies. This results in that if we develop in a traditional way, it takes a lot of time for the dispatcher to change the form style in the code each year, compatible with the history data.
Disclosure of Invention
The invention aims to solve the technical problems that the prior art aims at a new report style, has poor compatibility and needs to spend a great deal of time and effort to adjust data storage, and aims to provide a method for dynamically storing and converting the table style under an excel report, so that the problems of dynamically managing the table style and being compatible with historical data are solved.
The invention is realized by the following technical scheme:
a dynamic storage method for table style under excel report includes: splitting a table style of a sheet under an excel report file into a plurality of data blocks according to specific objects, wherein the data blocks comprise table head names, table head relations, table column names, table column relations, table relations and table formulas; the method comprises the steps that the table style of the current sheet is represented by a report type, one report type corresponds to the relation among data blocks, and the relation among the report type, the table style of the sheet and the data blocks corresponds one by one; 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 types into the data relation tables; the method comprises the steps that the version number is used for representing the style of a current excel report file, the style of the current excel report file comprises the relation between the table style of each sheet and the table style of each sheet, one version number corresponds to the relation among one data relation table, and the style, the version number and the relation among the data relation tables of the excel report file are 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 relationship tables, and the version control table.
In the prior art, the report is stored in a fixed format, and when the form is adjusted or changed, even if the form is finely adjusted, the whole data storage is required to be modified and adjusted, so that great effort is spent. The method and the system dynamically store the table style under the excel report, split the table style of the first sheet into a plurality of data blocks, describe the connection among the data blocks by using a data relation table, and express the table style of the current sheet by a field of report type. And then describing the relation between the sheets and the relation table of the database through version numbers after the table style of each sheet in the excel report is disassembled, and representing the style of the excel report through the version numbers. According to the method, the excel report style and the sheet style in the excel report are disassembled respectively, disassembled data blocks are stored, and the relationship among the disassembled data blocks is stored, so that the dynamic storage of the excel report style is achieved. Regardless of how the style of the excel report changes, the excel report can be stored by the method.
When a new sheet form style appears, it is represented by a new "report type" and when a new excel report style appears, it is represented by a new version number. Therefore, the report type and the version number are added to embody different excel report styles and sheet table styles. When the sheet form style is adjusted or changed, only a new relation is established on the basis of the data blocks, namely a new report type is established; when an excel report style is regulated or changed, a new relation is 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 embodied through the version number, so that dynamic management is realized. The invention mainly completes the realization of dynamic report storage in an application system, excel report patterns and sheet table patterns can be customized, version control is added, and the historical data and the newly added data can be compatible in reports of different versions, thereby realizing the dynamic management of the report patterns.
Further, the method comprises a management end, wherein the management end is used for acquiring a form style under the 'UI report', and converting the form style under the 'UI report' into a form style under an excel report file. The method also realizes the dynamic management of the UI report after the table style in the UI report is obtained and converted into the table style under the excel report file.
Further, 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 tab A is used for maintaining the list names; the tab B is used for maintaining the list relation; the tableeC is used for maintaining the header names, the header relations and the table relations; the tab is used for maintaining the table formula; and describing the version control table through a tab E, and maintaining version information of the excel report file.
Further, interconnection between the data blocks and between the data relation tables is realized through a plurality of fields, specifically: the tableA includes fields: a primary key, a column name, a report type, whether a project header and a version primary key; the tableB includes fields: a main key, a list main key, an upper main key, a serial number, a y coordinate, a report type and a version main key; the tableC includes fields: a main key, a list relation list main key, a header name, a header serial number, an X coordinate, a table description, a table merging coordinate, a report type, whether contents and version main keys exist or not; the tableD includes fields: a primary key, coordinates, a table formula, a table coordinate affected by the formula, a formula type, a formula description, a report type, whether to automatically calculate the formula and a version primary key; the tableE includes fields: a primary key, a version number, and a version description.
Further, obtaining a tableA and a tableB corresponding to the version number through the version number and the report type, carrying out table-linked query on the tableA and the tableB, and packaging out a table list title; determining a hierarchical relationship through the upper primary key, determining whether a title is thickened through the content, and defining a column y coordinate of a table through the y coordinate; and obtaining the tableC corresponding to the version number through the version number and the report type, determining the column of the table through the main key of the tableB, sequencing through the sequence number of the tableB, sequentially fixing the names of the table heads, determining whether the table can be filled or not through whether the table is filled or not, determining the merging unit cell through the merging coordinates of the table, and rendering the primary report.
Further, based on the primary report forms, the corresponding primary report forms are positioned through formulas, and data linkage among the primary report forms is achieved.
Further, formula data is obtained from the tab through the version primary key and the report type, and a formula is obtained from the formula data through coordinates.
Further, the type of the formula is obtained through the formula type, and the formula type comprises: a formula for verifying data errors and a formula for verifying data rationality.
The invention relates to 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 an excel report, wherein the concrete process is as follows: splitting a table style of a sheet under an excel report file into a plurality of data blocks according to specific objects, wherein the data blocks comprise table head names, table head relations, table column names, table column relations, table relations and table formulas; the method comprises the steps that the table style of the current sheet is represented by a report type, one report type corresponds to the relation among data blocks, and the relation among the report type, the table style of the sheet and the data blocks corresponds one by one; 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 types into the data relation tables; the method comprises the steps that the version number is used for representing the style of a current excel report file, the style of the current excel report file comprises the relation between the table style of each sheet and the table style of each sheet, one version number corresponds to the relation among one data relation table, and the style of the excel report, the version number and the relation among the data relation tables are 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, and transmitting the plurality of data blocks and the plurality of data relation tables to the second processing end in response to the request of the second processing end; reconstructing a UI report, wherein the specific process is as follows: typing in a target version number of an excel format report file required by a UI report by using a second processing end, and sending a request to the memory by the second processing end; the memory indexes from the version control table according to the target version number, and a plurality of data blocks and a plurality of data relation tables corresponding to the target version number are indexed; the second processing end obtains a plurality of data blocks and a plurality of data relation tables; and the second processing end calls a plurality of data blocks and a plurality of data relation tables under the state of assembling the UI interface, and reconstructs a table style of the excel report under the UI interface report, wherein the table style of the obtained UI interface 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 customized, version control is added, and the historical data and the newly added data can be compatible in the report of different versions. And the data calculation among the report forms is realized by maintaining a calculation formula in the report. In the development of a new business system, a corresponding report can be quickly generated on a view interface by importing a formulated excel report template into the system, and then the report style, the formula and the version are controlled through a management interface. The dynamic management is carried out on the financial related complex report, the possible content modification of the subsequent financial report is directly solved, the development efficiency of the report function is accelerated, and the intelligent characteristic of the system is also embodied.
After the dynamic report is adopted, the maintenance efficiency of the later period of the project is very high, a great amount of manual 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 embodiments of the invention and are incorporated in and constitute a part of this application, illustrate embodiments of the invention. In the drawings:
FIG. 1 is a schematic diagram of a dynamic report implementation method;
fig. 2 shows an intention for a data relationship.
Detailed Description
For the purpose of making apparent the objects, technical solutions and advantages of the present invention, the present invention will be further described in detail with reference to the following examples and the accompanying drawings, wherein the exemplary embodiments of the present invention and the descriptions thereof are for illustrating the present invention only and are not to be construed as limiting the present invention.
Example 1
Embodiment 1 is a method for implementing a dynamic report, and a method for dynamically storing a table style under an excel report, which specifically includes: splitting a sheet form under an excel report file into a plurality of data blocks according to specific objects, wherein the data blocks comprise header names, header relations, list names, list relations, table relations and table formulas; the table style of the current sheet is represented by a report type, one report type corresponds to the relation among one data block, and the relation among the table style of the sheet and the data block corresponds to one report type; establishing a plurality of data relation tables, wherein the data relation tables are used for maintaining the relation among the data blocks, and storing report types into the data relation tables; the method comprises the steps that the version number is used for representing the style of a current excel report file, the style of the current excel report file comprises the relation between the table style of each sheet and the table style of each sheet, one version number corresponds to the relation between one data relation table, and the style of the excel report file, the version number and the relation between the data relation tables correspond one by one; establishing a version control table, and storing the version number into the version control table; a plurality of data blocks, a plurality of data relationship tables, and a version control table are stored.
In the prior art, the report is stored in a fixed format, and when the form is adjusted or changed, even if the form is finely adjusted, the whole data storage is required to be modified and adjusted, so that great effort is spent. In this embodiment 1, the table style under the excel report is dynamically stored, and the table style of the first sheet is split into multiple data blocks, the association between the data blocks is described by using a data relationship table, and the table style of the current sheet is represented by a field "report type". And then describing the relation between the sheets and the relation table of the database through version numbers after the table style of each sheet in the excel report is disassembled, and representing the style of the excel report through the version numbers. In this embodiment 1, the excel report style and the sheet style in the excel report are disassembled respectively, the disassembled data blocks are stored, and the relationship between the disassembled data blocks is stored, so that the dynamic storage of the excel report form style is achieved. Regardless of how the style of the excel report changes, the excel report can be stored by the method of this embodiment 1.
When a new sheet form style appears, it is represented by a new "report type" and when a new excel report style appears, it is represented by a new version number. Therefore, the report type and the version number are added to embody different excel report styles and sheet table styles. When the sheet form style is adjusted or changed, only a new relation is established on the basis of the data blocks, namely a new report type is established; when an excel report style is regulated or changed, a new relation is 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 embodied through the version number, so that dynamic management is realized. The embodiment 1 mainly completes the realization of dynamic report storage in an application system, excel report patterns and sheet table patterns can be defined by users, version control is added, and the history data and the newly added data can be compatible in reports of different versions, so that the dynamic management of the report patterns is realized.
The management end can be further set on the basis of the embodiment 1, and 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. After the table style in the UI interface report is obtained and converted into the table style under the excel report file, the dynamic management of the UI interface report is also realized according to the method of embodiment 1.
Example 2
The embodiment 2 is a method for converting an excel report into a page report based on the embodiment 1, and includes a first processing end, a memory, and a second processing end;
firstly, disassembling an excel report, wherein the concrete process is as follows: splitting a sheet form under an excel report file into a plurality of data blocks according to specific objects, wherein the data blocks comprise header names, header relations, list names, list relations, table relations and table formulas; the table style of the current sheet is represented by a report type, one report type corresponds to the relation among one data block, and the relation among the table style of the sheet and the data block corresponds to one report type; establishing a plurality of data relation tables, wherein the data relation tables are used for maintaining the relation among the data blocks, and storing report types into the data relation tables; the method comprises the steps that the version number is used for representing the style of a current excel report file, the style of the current excel report file comprises the relation between the table style of each sheet and the table style of each sheet, one version number corresponds to the relation between one data relation table, and the style of the excel report, the version number and the relation between the data relation tables correspond one to one;
then, establishing a version control table, and storing the version number into the version control table;
a memory is used for storing a plurality of data blocks, a plurality of data relation tables and a version control table, and the data blocks and the 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 is as follows:
typing in a target version number of an excel format report file required by a UI report by using a second processing end, and sending a request to a memory by the second processing end;
the memory indexes from the version control table according to the target version number, and a plurality of data blocks and a plurality of data relation tables corresponding to the target version number are indexed;
the second processing end obtains a plurality of data blocks and a plurality of data relation tables; and the second processing end calls a plurality of data blocks and a plurality of data relation tables under the state of assembling the UI interface, and reconstructs a table style of the excel report under the UI interface report, wherein the table style of the obtained UI interface report is the same as that of the excel format report file.
In this embodiment 2, an Excel report in the state of a Microsoft Excel worksheet is dynamically managed, and parsed 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 the form of scattered data, and the memory in this embodiment 2 is typically a server. When the UI interface needs to call the Excel report stored by the server, according to the above method of this embodiment 2, the Excel report in the state of the Microsoft Excel worksheet may be displayed in the form of a "UI interface report" at the UI interface.
Example 3
In this embodiment 3, on the basis of embodiment 1, a dynamic table solution for maintenance is provided, so as to solve the limitation of conventional report development in software development, make table maintenance more flexible, improve efficiency, and reduce cost.
Firstly, a report is split into specific objects, and a complex table is split into six blocks, namely 1, the name of the table header, 2, the relation of the table header, 3, the name of the 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 of software development builds 5 database relation tables. A table entity table A mainly responsible for maintaining table names, a table entity table B responsible for table relationships, a table relationship table C responsible for associating table headers and tables, the formula table d of the table and finally the version control table of the table are shown in fig. 2.
And the specific logic flow obtains the tableA and tableB linked list query data of the corresponding version through version number version Id and report type, and encapsulates list header data. The hierarchical relationship is determined by the parent node, whether the title is thickened is determined by the isContent, and the y coordinate of the table column is defined by the ycoordinates. And then obtaining the tableC data of the corresponding version through version number version Id and report type, determining the column of the table through tableBId, sequentially fixing the headName through orderNumber sequencing, and determining whether the table can be filled through isContent. And finally determining the merging cells through the coordinate set of the formamers array.
There is often an association between the tables of the form, and the data linkage between the tables is done through a formula. The report type obtains the formula data of the form from the tableD through the version number version id. The specific formula is taken through the cordinate field, for example a19=a16+a17. The formula for verifying the data error and the formula for verifying the data rationality can be defined by the formula type. Because the table was rendered before, the x, y coordinates have been fixed. Therefore, the data can be directly positioned to the corresponding table through the formula to carry out verification linkage of the data.
Example 4
Embodiment 4 is a dynamic report implementation method based on embodiment 3, as shown in fig. 1, including the following steps:
1. firstly, importing an Excel template, creating a report at a management end, judging according to the style of the report, selecting a corresponding version, creating a version for the style of the current report without the corresponding version, and enabling the version to correspond to the style of the report.
2. And carrying out style analysis on the report, storing report data in a database in a classified mode, splitting the report into a plurality of data blocks, and storing the data blocks in the database according to a certain logic relationship.
3. The data blocks in the database are transmitted to the front end in a unified data format;
the front end acquires a report form according to the actual service and fills data;
the front end acquires a corresponding report style and report formula through the report type and version number, and initializes data;
the back end takes out the report filling data and formulas through the business, and analyzes the data through the formulas;
the management interface edits and controls the report style, the related formulas and the version control.
4. The front end renders the page, loads data and checks the data through a formula.
The dynamic report implementation method of the embodiment 4 is applied to financial report management, and the input, calculation and data analysis of a plurality of financial reports are realized. In conventional report development, a system back-end engineer establishes a corresponding report entity through a report style to store report data, and the style of the report is directly written on a page by a front-end engineer. However, financial reporting patterns are often not constant and require corresponding adjustments by national financial policies every year. If the development is carried out in a traditional way, a great deal of time is spent by dispatching hands each year to change the form style in the code, so that the historical data is compatible. The dynamic report of this embodiment 2 can well solve this problem.
In order to realize dynamic storage, a database for report storage is firstly divided into a plurality of data blocks:
1. report column name maintenance: the method is mainly used for storing column attribute names of maintenance reports, and defining whether the column names are header attributes or not.
2. Maintaining the relation of report columns: the method is mainly used for storing and maintaining the hierarchical relation of the report column names, defining the y-axis coordinate of the report in a sorting mode.
3. And (3) maintaining the name of the newspaper header: the method is mainly used for storing attribute names of the table heads of the maintenance report forms and attribution relations of the multi-stage table heads.
4. And (3) maintaining the relationship of the newspaper header: the method is mainly used for storing the relation among the headers of the maintenance report, and defining the x-axis coordinate of the report in a sorting mode.
5. Maintaining a report form: the method is mainly used for storing corresponding table attributes of the report, merging cells, filling content and the like, and defining a unique identifier for mapping the filled data relationship.
6. Maintaining a report form formula: 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 change needs to be considered. And when the report style is acquired, acquiring the report style through the version number and the report type. Modification of the report adds or deletes only tables, and the data is stored through a json. The key value of Json is a unique identification code generated by the table, and the current end can automatically match the data when the current end takes the table style and the data. Therefore, after the report is edited, the back display of the historical data is not affected.
The implementation of the dynamic report in the application system is mainly completed in the embodiment 4. The report style can be customized, 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 among the report forms can be realized by maintaining the calculation formula in the report form. In the development of a new business system, a corresponding report can be quickly generated on a view interface by importing a formulated excel report template into the system, and then the report style, formula and version are controlled through a management interface. And realizing the dynamic management of the report. And dynamically managing the financial related complex report. Directly solving the content modification that may occur to the subsequent financial statement. The development efficiency of report functions is quickened. After the dynamic report is adopted, maintenance after the project is very simple and efficient. The method saves a great deal of manual labor and project deployment cost, and greatly improves the expansibility of the project.
The Excel report forms refer to Excel report forms in the format of a computer Microsoft Excel worksheet; in the invention, "sheet" refers to any sheet form in a computer Microsoft Excel work form. An excel report includes one or more sheets.
The foregoing description of the embodiments has been provided for the purpose of illustrating the general principles of the invention, and is not meant to limit the scope of the invention, but to limit the invention to the particular embodiments, and any modifications, equivalents, improvements, etc. that fall within the spirit and principles of the invention are intended to be included within the scope of the invention.
Claims (8)
1. A dynamic storage method of a table style under an excel report is characterized by comprising the following steps:
splitting a table style of a sheet under an excel report file into a plurality of data blocks according to specific objects, wherein the data blocks comprise table head names, table head relations, table column names, table column relations, table relations and table formulas;
the method comprises the steps that the table style of the current sheet is represented by a report type, one report type corresponds to the relation among data blocks, and the relation among the report type, the table style of the sheet and the data blocks corresponds one by one;
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 types into the data relation tables;
the method comprises the steps that the version number is used for representing the style of a current excel report file, the style of the current excel report file comprises the relation between the table style of each sheet and the table style of each sheet, one version number corresponds to the relation among one data relation table, and the style, the version number and the relation among the data relation tables of the excel report file are 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 relationship tables, and the version control table;
wherein the data relationship table comprises: tableA, tableB, tableC, tableD and tableE;
the tab A is used for maintaining the list names; the tab B is used for maintaining the list relation; the tableeC is used for maintaining the header names, the header relations and the table relations; the tab is used for maintaining the table formula; and describing the version control table through a tab E, and maintaining version information of the excel report file.
2. The method for dynamically storing the table patterns under the excel report according to claim 1, wherein the method comprises a management end, wherein the management end is used for acquiring the table patterns under the 'UI interface report', and converting the table patterns under the 'UI interface report' into the table patterns under the excel report file.
3. The method for dynamically storing a table style in an excel report according to claim 1, wherein the data relationship table comprises a plurality of fields, and part of the fields are simultaneously present in different data relationship tables.
4. The method for dynamically storing a table style in an excel report according to claim 1, wherein interconnection between data blocks and between data relationship tables is realized through a plurality of fields, specifically:
the tableA includes fields: a primary key, a column name, a report type, whether a project header and a version primary key;
the tableB includes fields: a main key, a list main key, an upper main key, a serial number, a y coordinate, a report type and a version main key;
the tableC includes fields: a main key, a list relation list main key, a header name, a header serial number, an X coordinate, a table description, a table merging coordinate, a report type, whether contents and version main keys exist or not;
the tableD includes fields: a primary key, coordinates, a table formula, a table coordinate affected by the formula, a formula type, a formula description, a report type, whether to automatically calculate the formula and a version primary key;
the tableE includes fields: a primary key, a version number, and a version description.
5. The method for dynamically storing a table style in an excel report according to claim 4, wherein,
obtaining a tableA and a tableB corresponding to the version number through the version main key and the report type, carrying out table-linked query on the tableA and the tableB, and packaging out a table list title;
determining a hierarchical relationship through the tableB upper-level primary key, determining whether a title is thickened or not through whether the tableA item header is provided, and defining a column y coordinate of a table through a y coordinate of the tableB;
and obtaining the tableeC corresponding to the version number through the version main key and the report type, determining the column of the table through the column relation table main key, sequencing through the table head serial numbers, sequentially fixing the table head names, determining whether the table can be filled or not through whether contents exist, determining the merging unit cell through the table merging coordinates, and rendering the primary report.
6. The method for dynamically storing the table patterns under the excel report according to claim 5, wherein the data linkage between the primary reports is realized by locating the corresponding primary report through a formula based on the primary report.
7. The method for dynamically storing a table style in an excel report according to claim 6, wherein the formula data is obtained from a tab through a version primary key and a report type, and the formula is obtained from the formula data through coordinates.
8. The method for dynamically storing a table style in an excel report according to claim 7, wherein the type of the formula is obtained through a formula type, and the formula type comprises: a formula for verifying data errors and a formula for verifying data rationality.
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 CN112464632A (en) | 2021-03-09 |
| CN112464632B true 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) |
Families Citing this family (4)
| 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 |
| CN114004196B (en) * | 2021-12-30 | 2022-03-15 | 云账户技术(天津)有限公司 | Method and device for converting single data format of table |
| CN115659934B (en) * | 2022-12-09 | 2023-03-07 | 泰盈科技集团股份有限公司 | Method for calculating and storing different worksheet column data in table document |
| 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 |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7080083B2 (en) * | 2001-12-21 | 2006-07-18 | Kim Hong J | Extensible stylesheet designs in visual graphic environments |
| CN115098084A (en) * | 2017-05-09 | 2022-09-23 | 合肥汉腾信息技术有限公司 | Non-coding form design and drawing method |
-
2020
- 2020-11-27 CN CN202011367167.3A patent/CN112464632B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
|---|
| Table Header Correction Algorithm Based on Heuristics for Improving Spreadsheet Data Extraction;Viacheslav Paramonov et al;ICIST 2020: Information and Software Technologies;第1283卷;第147-158页 * |
| 一套智能的报表生成方法及设计原则;宋永利;;自动化与仪器仪表(第11期);第200-201,205页 * |
| 一种基于单数据源的可视化自定义报表模型;汤加等;计算机科学;第44卷(第5期);第184-188页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112464632A (en) | 2021-03-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112464632B (en) | Dynamic storage and conversion method for table style under excel report | |
| US7634492B2 (en) | Aggregate data view | |
| CN103455540B (en) | The system and method for generating memory model from data warehouse model | |
| US9110686B2 (en) | Web client command infrastructure integration into a rich client application | |
| US20050114394A1 (en) | Mapping XML schema components to qualified Java components | |
| US20080215621A1 (en) | Metamodel-based automatic report generation | |
| CN104376068A (en) | Data representation system and method based on dynamic report template | |
| US7159209B1 (en) | Inter-application validation tool for use in enterprise architecture modeling | |
| EP1465062A2 (en) | Dynamically generated user interface for business application integration | |
| CN111160658B (en) | Collaborative manufacturing resource optimization method, system and platform | |
| CN105224631A (en) | Build the system of the open cloud of industry and the method for establishment XBRL financial statement | |
| CN111078702A (en) | SQL sentence classification management and unified query method and device | |
| CN111061733A (en) | Data processing method and device, electronic equipment and computer readable storage medium | |
| US7908548B2 (en) | User interface for establishing mappings from internal metadata to external metadata | |
| CN107515866A (en) | A kind of data manipulation method, device and system | |
| CN101604338A (en) | User-defined information query method of a kind of realization and device | |
| CN114625792A (en) | Method and device for exporting query result of database | |
| CN114297994A (en) | Method, system, device and storage medium for generating parameterized report | |
| CN111401023B (en) | Report generation method, report generation device, server and storage medium | |
| CN110955839B (en) | Tax declaration method, system and storage medium | |
| CN110704635B (en) | Method and device for converting triplet data in knowledge graph | |
| US20050144087A1 (en) | Disparate sales system integration and method | |
| CN114895875B (en) | Zero-code visual information system metadata production application method and system | |
| CN108228688B (en) | Template generation method, system and server based on XBRL | |
| CN115879435A (en) | Cloud contract generation method in intelligent engineering scene |
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 |