CN105488073A - Method and device for generating report header - Google Patents
Method and device for generating report header Download PDFInfo
- Publication number
- CN105488073A CN105488073A CN201410504764.4A CN201410504764A CN105488073A CN 105488073 A CN105488073 A CN 105488073A CN 201410504764 A CN201410504764 A CN 201410504764A CN 105488073 A CN105488073 A CN 105488073A
- Authority
- CN
- China
- Prior art keywords
- node
- gauge outfit
- cell
- tree structure
- content
- 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.)
- Pending
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method and a device for generating a report header. The method comprises the following steps: obtaining a header format of a report to be generated, and calculating a merged row attribute value and a merged column attributed value of a header cell corresponding to each node according to a hierarchical relationship between the tree-structure nodes corresponding to the header format; and taking contents in each tree-structure node as the contents of each corresponding header cell, and generating the header of the report according to the merged row attribute value and the merged column attributed value of each header cell. The method for generating the header of the report is simple in implementation, is low in the professional ability requirement of a user and solves the problem that reporting software is only suitable for professionals but is not suitable for non-professionals.
Description
Technical field
The present invention relates to technical field of data processing, be specifically related to a kind of method and apparatus of generating report forms gauge outfit.
Background technology
Form carrys out Dynamic Announce data with the form such as form, chart exactly, can be formulated as: " form+dynamic data of form=various ".Along with the appearance of computing machine, generate by the function of computer processing data and interface, show that form becomes possibility, a large amount of data processing needs, has expedited the emergence of many report software, and the principal feature of report software is Data Dynamic, form variation, and realize being separated completely of report data and statement form, gauge outfit pattern and data fix all in advance, only have the content of form to be dynamic data, user can a Update Table, or only revises form.The general all more complicated of existing report software, when making form, especially having in the report heading made requires higher to the technical capability making reports user when more merging rows, conjunction parallel operation, be only suitable for professional to operate, be not suitable for layman, therefore need the scheme that a kind of applicable layman processes complex format gauge outfit badly.
Summary of the invention
The method and apparatus that the invention provides a kind of generating report forms gauge outfit requires high technical matters to solve existing report software to the professional ability making reports user.
For achieving the above object, technical scheme of the present invention is achieved in that
According to an aspect of the present invention, provide a kind of method of generating report forms gauge outfit, the method comprises:
Obtain the top-of-form of form to be generated;
According to the hierarchical relationship between each node of the tree structure corresponding with top-of-form, calculate the merging rows property value of gauge outfit cell corresponding to each node and close concurrent property values;
Using the content of the content in each node of tree structure as each gauge outfit cell of correspondence, and according to the merging rows property value of each gauge outfit cell and close concurrent property values generating report forms gauge outfit.
Alternatively, according to the hierarchical relationship between each node of the tree structure corresponding with top-of-form, the conjunction concurrent property values calculating gauge outfit cell corresponding to each node comprises:
Conjunction concurrent property values according to gauge outfit cell corresponding to each node of following formulae discovery:
The number of all leaf nodes under the node that conjunction concurrent property values=this gauge outfit cell of the gauge outfit cell that each node is corresponding is corresponding.
Alternatively, according to the hierarchical relationship between each node of the tree structure corresponding with top-of-form, the merging rows property value calculating gauge outfit cell corresponding to each node comprises:
Calculate maximum hierarchical value N and the hierarchical value M of each node in tree structure of tree structure;
Whether having leaf node under judging the node that each gauge outfit cell is corresponding, is then, and the merging rows property value of this gauge outfit cell is set to 1;
Otherwise the merging rows property value=N-M+1 of this gauge outfit cell, wherein M is less than N.
Alternatively, the gauge outfit cell in top-of-form is divided into report name cell and other cells of gauge outfit;
The content of report name cell is the root node of tree structure, and the content of other cells of gauge outfit is branch node or the leaf node of tree structure.
Alternatively, the method also comprises:
In tree structure, increase one or more node, and upgrade the hierarchical relationship between each node; Or,
In tree structure, delete one or more node, and upgrade the hierarchical relationship between each node.
According to another aspect of the present invention, provide a kind of device of generating report forms gauge outfit, this device comprises:
Form acquiring unit, for obtaining the top-of-form of form to be generated;
Computing unit, for according to the hierarchical relationship between each node of tree structure corresponding with top-of-form, calculates the merging rows property value of gauge outfit cell corresponding to each node and closes concurrent property values;
Generation unit, for using the content of the content in each node of tree structure as each gauge outfit cell of correspondence, and according to the merging rows property value of each gauge outfit cell and close concurrent property values generating report forms gauge outfit.
Alternatively, computing unit comprises: close concurrent property values computing unit;
Close concurrent property values computing unit, the conjunction concurrent property values for according to each gauge outfit cell of following formulae discovery:
The number of all leaf nodes under the node that conjunction concurrent property values=this gauge outfit cell of the gauge outfit cell that each node is corresponding is corresponding.
Alternatively, computing unit comprises: merging rows property value computing unit;
Merging rows property value computing unit, for calculating maximum hierarchical value N and the hierarchical value M of each node in tree structure of tree structure;
Judge whether the node that each gauge outfit cell is corresponding has leaf node, is then, the merging rows property value of this gauge outfit cell is set to 1;
Otherwise the merging rows property value=N-M+1 of this gauge outfit cell, wherein M is less than N.
Alternatively, the gauge outfit cell in top-of-form is divided into report name cell and other cells of gauge outfit; The content of report name cell is the root node of tree structure, and the content of other cells of gauge outfit is branch node or the leaf node of tree structure.
Alternatively, computing unit also for increasing one or more node in tree structure, and upgrades the hierarchical relationship between each node;
Or,
In tree structure, delete one or more node, and upgrade the hierarchical relationship between each node.
The method of this generating report forms gauge outfit of the present invention, the report heading form generated can be wanted automatically to calculate the ranks property value that will merge according to user, the report heading of user's needs is generated with merging Column Properties according to the content of report heading cell and the merging rows attribute of gauge outfit cell, the professional ability of method to user of this generating report forms gauge outfit is less demanding, solves report software and is not suitable for the problem that layman processes the report heading of complex format.
Accompanying drawing explanation
Fig. 1 is the process flow diagram of the method for a kind of generating report forms gauge outfit that one embodiment of the invention provides;
Fig. 2 is the tree structure schematic diagram corresponding with table 1 report heading form that one embodiment of the invention provides;
Fig. 3 is the block diagram of the device of a kind of generating report forms gauge outfit that one embodiment of the invention provides.
Embodiment
Core concept of the present invention is: obtain the top-of-form of user for the form of generation, according to user's content that each node inputs in the tree structure corresponding with selected top-of-form, calculate the merging rows property value of cell corresponding to each node and close concurrent property values, according to the content generating report forms gauge outfit in the row property value of report heading cell and Column Properties value and gauge outfit cell, solve complex format report heading Generating Problems, simplify the generative process of report heading, and then reach the object of fast simple, high-level efficiency generating report forms.Further, the form of report heading cell is manually set without the need to user by the method for this generating report forms gauge outfit of the present invention, less demanding to the professional ability of user, meet the demand that domestic consumer makes form.
Fig. 1 is the process flow diagram of the method for a kind of generating report forms gauge outfit that one embodiment of the invention provides, and see Fig. 1, the method for this generating report forms gauge outfit of the present invention comprises:
Step S110, obtains the top-of-form of form to be generated;
Step S120, according to the hierarchical relationship between each node of the tree structure that top-of-form is corresponding, calculates the merging rows property value of gauge outfit cell corresponding to each node and closes concurrent property values;
Step S130, using the content of the content in each node of tree structure as each gauge outfit cell of correspondence, and according to the merging rows property value of each gauge outfit cell and close concurrent property values generating report forms gauge outfit.
By this generating report forms gauge outfit method of the present invention, when needing to generate the report heading having and merge ranks situation, the merging rows property value of each cell is manually set without the need to user and closes the top-of-form of concurrent property values determination form, simplify the manufacturing process of report heading, less demanding to the professional ability of user, applicable layman makes the form of complex table head form.
Table 1 illustrates the one report heading form to be generated that one embodiment of the invention provides, as shown in table 1, user wants making report name to be the form in " crops sales situation statistical form in June (ton) ", and this report heading comprises: report name cell: crops sales situation statistical report form in June (ton); Other cells of report heading: each subdivision unit lattice of name, cereal crops, industrial crops, vegetable crop and cereal crops, industrial crops, vegetable crop.What the top-of-form of form was relatively more conventional is horizontal table, vertically shows, gauge outfit cell is part fixing for the data cells in form, as shown in table 1: top-of-form is horizontal gauge outfit, gauge outfit cell in gauge outfit is the front 4 row cell content of form, rear three row cell content represent data cells, data cells is in upset condition, and gauge outfit cell is then relatively-stationary.
Table 1
Be appreciated that table 1 just schematically show a kind of structure of form to be generated, in actual applications, those skilled in the art according to the user demand of reality, can make the report heading being different from table 1 form.
Fig. 2 is the tree structure schematic diagram of the storage report heading form that one embodiment of the invention provides; The implementation procedure of the method for generating report forms gauge outfit of the present invention is illustrated below in conjunction with table 1 and Fig. 2.
First, apply the method for this generating report forms gauge outfit of the present invention, obtain the top-of-form of table 1 to be generated.
Specifically can present several top-of-form to select for user at the interactive interface with user, by the top-of-form clicking the report heading obtained by generation of user.When user chooses top-of-form, then the tree structure corresponding with this top-of-form is presented to user, start the content inputted in gauge outfit to facilitate user.
Then, start to receive the content that user inputs in each node of the tree structure corresponding with this top-of-form, each node is corresponding with a gauge outfit cell.Certainly, the template of tree structure can also be supplied to user, each node in template can some initial content, and user completes the content input of each node by the content in direct amendment node, removes the trouble creating node from.
Gauge outfit cell in described top-of-form is divided into report name cell and other cells of gauge outfit; The content of report name cell is the root node of tree structure, and its content is report name.The content of other cells of gauge outfit is branch node or the leaf node of tree structure.The quantity of report name cell is one, and the quantity of other cells of gauge outfit is can for multiple.
Tree structure specifically can see the example of Fig. 2, and 201 represent that report name is the root node of tree structure, and 202 represent that the content of other cells of gauge outfit is branch node or the leaf node of tree structure.In Fig. 2, for cereal crops place node, the node at cereal crops place and the node at paddy rice place are the branch nodes of tree structure, have and sell leaf node and stock's leaf node under paddy rice node.Below root node crops in June sales situation statistical report form, there are T1-T13 totally 13 leaf nodes.
Again, the hierarchical relationship between each node of the tree structure according to Fig. 2, calculates the merging rows property value of gauge outfit cell corresponding to each node and closes concurrent property values.
For cereal crops place node, cereal crops node is one-level; Paddy rice node is secondary; The sale node of paddy rice and stock's node are all three grades.
In the present embodiment, see Fig. 2, according to the hierarchical relationship between each node of tree structure, the conjunction concurrent property values calculating gauge outfit cell corresponding to each node comprises:
Conjunction concurrent property values according to gauge outfit cell corresponding to each node of following formulae discovery:
The number of all leaf nodes under the node that conjunction concurrent property values=this gauge outfit cell of the gauge outfit cell that each node is corresponding is corresponding.
Calculate the merging columns (i.e. the value of colspan) of number as this node of all leaf nodes below each node.Such as, the conjunction concurrent property values of root node (crops sales situation statistical report form in June) equals:
T1+T2+T3+T4+T5+T6+T7+T8+T9+T10+T11+T12+T13＝13。
The conjunction concurrent property values of branch node cereal crops equals: T2+T3+T4+T5=4.
The conjunction concurrent property values of branch node corn equals: T4+T5=2.
In the present embodiment, according to store tree structure each node between hierarchical relationship, the merging rows property value calculating gauge outfit cell corresponding to each node comprises:
Calculate maximum hierarchical value N and the hierarchical value M of each node in tree structure of tree structure;
Whether having leaf node under judging the node that each gauge outfit cell is corresponding, is then, and the merging rows property value of this gauge outfit cell is set to 1; Otherwise the merging rows property value=N-M+1 of this gauge outfit cell, wherein M is less than N.
See Fig. 2, calculate the maximum hierarchical value N of tree structure and each node hierarchical value M in tree structure, the maximum hierarchical value N=3 (cereal crops---paddy rice---stock=3) of the tree structure shown in Fig. 2.
Judge whether the node that gauge outfit cell is corresponding has leaf node, is then, the merging rows property value of this node is defaulted as 1 (i.e. the value of rowspan); Such as, in Fig. 2, " paddy rice " node has leaf node then to merge line number=1;
Otherwise the merging line number of this node is the value of N-M+1, and wherein M is less than N.
Such as, " name " node is at the level M=1 of tree structure; The then merging line number=N-M+1=3-1+1=3 of " name " node.
Through above-mentioned steps, calculate the merging rows property value (rowspan) of gauge outfit cell and closed concurrent property values (colspan).
Finally, using the content of the content in each node of tree structure as each gauge outfit cell of correspondence, and according to the merging rows property value of each gauge outfit cell and close concurrent property values and generate the report heading shown in table 1.
The method of this invention is by the gauge outfit pattern shown in table 1, according to user's content that each node inputs in the tree structure corresponding with this top-of-form, calculate the merging rows property value of cell corresponding to each node and close concurrent property values, according to the content generating report forms gauge outfit in the row property value of report heading cell and Column Properties value and gauge outfit cell.By safeguarding the node of one group of Storage Structure of Tree, achieve the merging rows Column Properties value automatically calculating each gauge outfit cell, the effect of Dynamic Maintenance report heading form.Such user, when making form, does not need oneself manually to arrange the form of gauge outfit cell in turn, simplifies more merging rows, merges the manufacturing process of the complex report forms gauge outfits such as row, less demanding to the professional ability of user.In the present embodiment, merge line number and merging rows property value synonym, merge columns and close concurrent property values synonym.
In the present embodiment, based on the Storage Structure of Tree that report heading form is corresponding, the method of this generating report forms gauge outfit can also increase a node or multiple node dynamically in tree structure, and the hierarchical relationship upgraded between each node, or dynamic one or more node of deletion, upgrade the hierarchical relationship between each node, make user simply, conveniently to the form of report heading modify according to real needs and safeguard.
When specific implementation, when the content of input table head unit lattice in the node of user in tree structure, can be real-time report heading is carried out generation display, be convenient to user and see effect in time and correct; Also generation instruction can be sent after user completes the input of whole node, according to generation instruction again using the content of the content of node each in tree structure as the gauge outfit cell of correspondence, and according to the merging rows property value of described each gauge outfit cell and close concurrent property values generating report forms gauge outfit.
Present invention also offers a kind of device of generating report forms gauge outfit, Fig. 3 is the block diagram of the device of a kind of generating report forms gauge outfit that one embodiment of the invention provides.The device 300 of this generating report forms gauge outfit comprises:
Form acquiring unit 301, for obtaining the top-of-form of form to be generated;
Computing unit 302, for according to the hierarchical relationship between each node of tree structure corresponding with top-of-form, calculates the merging rows property value of gauge outfit cell corresponding to each node and closes concurrent property values;
Generation unit 303, for using the content of the content in each node of tree structure as each gauge outfit cell of correspondence, and according to the merging rows property value of each gauge outfit cell and close concurrent property values generating report forms gauge outfit.
In the present embodiment, computing unit 302 comprises: close concurrent property values computing unit;
Close concurrent property values computing unit, the conjunction concurrent property values for according to each gauge outfit cell of following formulae discovery:
The number of all leaf nodes under the node that conjunction concurrent property values=this gauge outfit cell of the gauge outfit cell that each node is corresponding is corresponding.
In the present embodiment, computing unit 302 comprises: merging rows property value computing unit;
Merging rows property value computing unit, for calculating maximum hierarchical value N and the hierarchical value M of each node in tree structure of tree structure; Judge whether the node that each gauge outfit cell is corresponding has leaf node, is then, the merging rows property value of this gauge outfit cell is set to 1;
Otherwise the merging rows property value=N-M+1 of this gauge outfit cell, wherein M is less than N.
In the present embodiment, the gauge outfit cell in top-of-form is divided into report name cell and other cells of gauge outfit; Be the root node of tree structure according to the content of report name cell, the content of other cells of gauge outfit is branch node or the leaf node of tree structure.
In the present embodiment, computing unit 302 also for increasing one or more node in tree structure, and upgrades the hierarchical relationship between each node;
Or,
In tree structure, delete one or more node, and upgrade the hierarchical relationship between each node.
In sum, the method and apparatus of this generating report forms gauge outfit of the present invention uses the hierarchical relationship of recursive calculation tree structure, and according to the colspan property value of hierarchical relationship accounting report and rowspan property value, achieve the merging rows Column Properties value automatically calculating each gauge outfit cell, the node of the data structure of Dynamic Maintenance report heading cell, and then the effect of Dynamic Maintenance report heading form.Simplify the manufacturing process of complex report forms gauge outfit, less demanding to the professional ability of user, solve existing report software and be only suitable for the problem that professional's operation is not suitable for layman's use.
These are only preferred embodiment of the present invention, be not intended to limit protection scope of the present invention.All any amendments done within the spirit and principles in the present invention, equivalent replacement, improvement etc., be all included in protection scope of the present invention.
Claims (10)
1. a method for generating report forms gauge outfit, is characterized in that, the method comprises:
Obtain the top-of-form of form to be generated;
According to the hierarchical relationship between each node of the tree structure corresponding with described top-of-form, calculate the merging rows property value of gauge outfit cell corresponding to each node and close concurrent property values;
Using the content of the content in each node of tree structure as each gauge outfit cell of correspondence, and according to the merging rows property value of described each gauge outfit cell and close concurrent property values generating report forms gauge outfit.
2. the method for claim 1, is characterized in that, the hierarchical relationship between each node of tree structure that described basis is corresponding with described top-of-form, and the conjunction concurrent property values calculating gauge outfit cell corresponding to each node comprises:
Conjunction concurrent property values according to gauge outfit cell corresponding to each node of following formulae discovery:
The number of all leaf nodes under the node that conjunction concurrent property values=this gauge outfit cell of the gauge outfit cell that each node is corresponding is corresponding.
3. the method for claim 1, is characterized in that, the hierarchical relationship between each node of the tree structure that described basis is corresponding with described top-of-form, and the merging rows property value calculating gauge outfit cell corresponding to each node comprises:
Calculate maximum hierarchical value N and the hierarchical value M of each node in described tree structure of described tree structure;
Whether having leaf node under judging the node that each gauge outfit cell is corresponding, is then, and the merging rows property value of this gauge outfit cell is set to 1;
Otherwise the merging rows property value=N-M+1 of this gauge outfit cell, wherein M is less than N.
4. the method for claim 1, is characterized in that,
Gauge outfit cell in described top-of-form is divided into report name cell and other cells of gauge outfit;
The content of described report name cell is the root node of tree structure, and the content of described other cells of gauge outfit is branch node or the leaf node of tree structure.
5. the method according to any one of claim 1-4, is characterized in that, described method also comprises:
In described tree structure, increase one or more node, and upgrade the hierarchical relationship between each node;
Or,
In described tree structure, delete one or more node, and upgrade the hierarchical relationship between each node.
6. a device for generating report forms gauge outfit, is characterized in that, this device comprises:
Form acquiring unit, for obtaining the top-of-form of form to be generated;
Computing unit, for according to the hierarchical relationship between each node of tree structure corresponding with described top-of-form, calculates the merging rows property value of gauge outfit cell corresponding to each node and closes concurrent property values;
Generation unit, for using the content of the content in each node of tree structure as each gauge outfit cell of correspondence, and according to the merging rows property value of described each gauge outfit cell and close concurrent property values generating report forms gauge outfit.
7. device as claimed in claim 6, it is characterized in that, described computing unit comprises: close concurrent property values computing unit;
Described conjunction concurrent property values computing unit, the conjunction concurrent property values for according to each gauge outfit cell of following formulae discovery:
The number of all leaf nodes under the node that conjunction concurrent property values=this gauge outfit cell of the gauge outfit cell that each node is corresponding is corresponding.
8. device as claimed in claim 6, it is characterized in that, described computing unit comprises: merging rows property value computing unit;
Described merging rows property value computing unit, for calculating maximum hierarchical value N and the hierarchical value M of each node in described tree structure of tree structure;
Judge whether the node that each gauge outfit cell is corresponding has leaf node, is then, the merging rows property value of this gauge outfit cell is set to 1;
Otherwise the merging rows property value=N-M+1 of this gauge outfit cell, wherein M is less than N.
9. device as claimed in claim 6, is characterized in that,
Gauge outfit cell in described top-of-form is divided into report name cell and other cells of gauge outfit;
The content of described report name cell is the root node of tree structure, and the content of described other cells of gauge outfit is branch node or the leaf node of tree structure.
10. the device according to any one of claim 6-9, is characterized in that,
Described computing unit also for increasing one or more node in tree structure, and upgrades the hierarchical relationship between each node; Or, in tree structure, delete one or more node, and upgrade the hierarchical relationship between each node.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410504764.4A CN105488073A (en) | 2014-09-26 | 2014-09-26 | Method and device for generating report header |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410504764.4A CN105488073A (en) | 2014-09-26 | 2014-09-26 | Method and device for generating report header |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105488073A true CN105488073A (en) | 2016-04-13 |
Family
ID=55675051
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410504764.4A Pending CN105488073A (en) | 2014-09-26 | 2014-09-26 | Method and device for generating report header |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105488073A (en) |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106407171A (en) * | 2016-11-03 | 2017-02-15 | 华能澜沧江水电股份有限公司 | System and method for generating safety monitoring self-defined report based on tree structure |
| CN108009145A (en) * | 2017-12-18 | 2018-05-08 | 深圳市康必达控制技术有限公司 | Report form generation method and device |
| CN108268480A (en) * | 2016-12-30 | 2018-07-10 | 亿阳信通股份有限公司 | A kind of big data shows method and apparatus |
| CN109522452A (en) * | 2018-11-13 | 2019-03-26 | 南京烽火星空通信发展有限公司 | A kind of processing method of magnanimity semi-structured data |
| CN109558578A (en) * | 2018-11-26 | 2019-04-02 | 成都四方伟业软件股份有限公司 | Report conversion method and device |
| CN109635011A (en) * | 2018-10-31 | 2019-04-16 | 北京辰森世纪科技股份有限公司 | Multistage gauge outfit report processing method, device and equipment based on data service metadata |
| CN109800401A (en) * | 2018-12-25 | 2019-05-24 | 北京数知科技股份有限公司 | Information report automatic generation method and device |
| CN110020267A (en) * | 2017-07-27 | 2019-07-16 | 杭州海康威视数字技术股份有限公司 | List display method and device |
| CN110019224A (en) * | 2017-12-21 | 2019-07-16 | 天津数观科技有限公司 | A kind of crosstab head generation method based on tree search |
| CN110532834A (en) * | 2018-05-24 | 2019-12-03 | 北京庖丁科技有限公司 | Table extracting method, device, equipment and medium based on rich text format document |
| CN111782711A (en) * | 2020-07-01 | 2020-10-16 | 南京认知物联网研究院有限公司 | Water quantity data statistical method |
| CN112784548A (en) * | 2019-11-07 | 2021-05-11 | 珠海金山办公软件有限公司 | Cell merging method, device and storage medium |
| CN114021536A (en) * | 2021-11-17 | 2022-02-08 | 广州天维信息技术股份有限公司 | Processing method, device, equipment and storage medium of multi-level header report |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060059197A1 (en) * | 2002-10-24 | 2006-03-16 | Turbo Data Laboratories Inc. | Method for converting concatenated join tables to tree structure, and conversion program |
| CN101620636A (en) * | 2009-08-21 | 2010-01-06 | 腾讯科技（北京）有限公司 | Method and apparatus for displaying tabular data |
| CN102043769A (en) * | 2010-12-27 | 2011-05-04 | 畅捷通软件有限公司 | Method and device for editing documents |
| CN103886023A (en) * | 2014-02-24 | 2014-06-25 | 国家电网公司 | Storage and extraction method and system of Excel data tables |
-
2014
- 2014-09-26 CN CN201410504764.4A patent/CN105488073A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060059197A1 (en) * | 2002-10-24 | 2006-03-16 | Turbo Data Laboratories Inc. | Method for converting concatenated join tables to tree structure, and conversion program |
| CN101620636A (en) * | 2009-08-21 | 2010-01-06 | 腾讯科技（北京）有限公司 | Method and apparatus for displaying tabular data |
| CN102043769A (en) * | 2010-12-27 | 2011-05-04 | 畅捷通软件有限公司 | Method and device for editing documents |
| CN103886023A (en) * | 2014-02-24 | 2014-06-25 | 国家电网公司 | Storage and extraction method and system of Excel data tables |
Non-Patent Citations (1)
| Title |
|---|
| 白仲贵 等: "Excel报表数据的自动分离引擎", 《计算机工程》 * |
Cited By (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106407171A (en) * | 2016-11-03 | 2017-02-15 | 华能澜沧江水电股份有限公司 | System and method for generating safety monitoring self-defined report based on tree structure |
| CN106407171B (en) * | 2016-11-03 | 2023-09-26 | 华能澜沧江水电股份有限公司 | Tree structure-based security monitoring custom report generation system and method |
| CN108268480A (en) * | 2016-12-30 | 2018-07-10 | 亿阳信通股份有限公司 | A kind of big data shows method and apparatus |
| CN110020267A (en) * | 2017-07-27 | 2019-07-16 | 杭州海康威视数字技术股份有限公司 | List display method and device |
| CN110020267B (en) * | 2017-07-27 | 2021-03-26 | 杭州海康威视数字技术股份有限公司 | List display method and device |
| CN108009145A (en) * | 2017-12-18 | 2018-05-08 | 深圳市康必达控制技术有限公司 | Report form generation method and device |
| CN110019224A (en) * | 2017-12-21 | 2019-07-16 | 天津数观科技有限公司 | A kind of crosstab head generation method based on tree search |
| CN110532834B (en) * | 2018-05-24 | 2022-12-23 | 北京庖丁科技有限公司 | Table extraction method, device, equipment and medium based on rich text format document |
| CN110532834A (en) * | 2018-05-24 | 2019-12-03 | 北京庖丁科技有限公司 | Table extracting method, device, equipment and medium based on rich text format document |
| CN109635011A (en) * | 2018-10-31 | 2019-04-16 | 北京辰森世纪科技股份有限公司 | Multistage gauge outfit report processing method, device and equipment based on data service metadata |
| CN109522452A (en) * | 2018-11-13 | 2019-03-26 | 南京烽火星空通信发展有限公司 | A kind of processing method of magnanimity semi-structured data |
| CN109522452B (en) * | 2018-11-13 | 2023-09-05 | 南京烽火星空通信发展有限公司 | Processing method of massive semi-structured data |
| CN109558578A (en) * | 2018-11-26 | 2019-04-02 | 成都四方伟业软件股份有限公司 | Report conversion method and device |
| CN109800401A (en) * | 2018-12-25 | 2019-05-24 | 北京数知科技股份有限公司 | Information report automatic generation method and device |
| CN112784548A (en) * | 2019-11-07 | 2021-05-11 | 珠海金山办公软件有限公司 | Cell merging method, device and storage medium |
| CN111782711A (en) * | 2020-07-01 | 2020-10-16 | 南京认知物联网研究院有限公司 | Water quantity data statistical method |
| CN114021536A (en) * | 2021-11-17 | 2022-02-08 | 广州天维信息技术股份有限公司 | Processing method, device, equipment and storage medium of multi-level header report |
| CN114021536B (en) * | 2021-11-17 | 2022-08-09 | 广州天维信息技术股份有限公司 | Processing method, device, equipment and storage medium of multi-level header report |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105488073A (en) | Method and device for generating report header | |
| CN105550241B (en) | Multi-dimensional database querying method and device | |
| CN106933889B (en) | Configuration method, display method and client for screened rules | |
| CN108984712B (en) | Service scene-based number making method and device and readable storage medium | |
| CN102521416B (en) | Data correlation query method and data correlation query device | |
| CN106599039B (en) | Statistical representation method supporting free combination nesting of relational database data | |
| CN105843945A (en) | Report generation method and system | |
| CN105160023B (en) | Graphics data inquiry processing method based on Cloud Server | |
| CN111221526A (en) | Data visual editing display platform based on data lake server | |
| US10296505B2 (en) | Framework for joining datasets | |
| CN109376153B (en) | System and method for writing data into graph database based on NiFi | |
| US20230394023A1 (en) | Automated feature engineering for multidimensional data | |
| CN105279269A (en) | SQL generating method and system for supporting table free association | |
| CN106250110B (en) | Method and device for establishing model | |
| CN113255302A (en) | Method for operating tissue architecture diagram, computer device and computer storage medium | |
| CN105204834A (en) | Visual software modeling editor for constructing software model | |
| CN107239923B (en) | Method and device for generating material application form | |
| CN104199882B (en) | A kind of acquisition methods of structural knowledge and its body based on the customization of intelligent masterplate | |
| US20090164432A1 (en) | System and method for generating a product report | |
| CN105867995A (en) | Editing method and device for XML (extensible markup language) file | |
| US9792706B2 (en) | Graph processing system, graph processing method, and non-transitory computer readable medium | |
| JP2006244283A (en) | Database management device and database management method | |
| CN110968679A (en) | Data query method and device | |
| CN111143356B (en) | Report retrieval method and device | |
| CN115455135A (en) | Visual automatic modeling method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160413 |
|
| RJ01 | Rejection of invention patent application after publication |