CN112528613A - Data table generation method and related equipment thereof - Google Patents
Data table generation method and related equipment thereof Download PDFInfo
- Publication number
- CN112528613A CN112528613A CN202011519738.0A CN202011519738A CN112528613A CN 112528613 A CN112528613 A CN 112528613A CN 202011519738 A CN202011519738 A CN 202011519738A CN 112528613 A CN112528613 A CN 112528613A
- Authority
- CN
- China
- Prior art keywords
- data
- service data
- service
- sequence number
- hierarchy
- 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
- 238000000034 method Methods 0.000 title claims abstract description 36
- 238000012163 sequencing technique Methods 0.000 claims abstract description 52
- 238000004364 calculation method Methods 0.000 claims description 16
- 230000001174 ascending effect Effects 0.000 claims description 3
- 230000002085 persistent effect Effects 0.000 claims description 3
- 230000001052 transient effect Effects 0.000 claims description 2
- 238000005429 filling process Methods 0.000 abstract description 7
- 238000010586 diagram Methods 0.000 description 12
- 238000000638 solvent extraction Methods 0.000 description 4
- 230000015572 biosynthetic process Effects 0.000 description 3
- 238000004891 communication Methods 0.000 description 3
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000004590 computer program Methods 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000003313 weakening effect Effects 0.000 description 1
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/174—Form filling; Merging
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Artificial Intelligence (AREA)
- Health & Medical Sciences (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the application discloses a data table generation method, which is used for reducing time consumption and resource consumption in a data filling process. The method in the embodiment of the application comprises the following steps: obtaining a service data set and a header area of a table to be filled in by the service data set, wherein the service data set comprises a plurality of pieces of service data, and the header area comprises an independent data column and an associated data column; determining a hierarchy corresponding to each service data and a sequencing sequence number of each service data according to a preset hierarchy division rule; filling cells corresponding to the independent data columns based on each piece of service data to obtain initial data records corresponding to each piece of service data; based on the independent data columns of the initial data records, filling the cells corresponding to the associated data columns of the initial data records to obtain complete data records corresponding to the initial data records; and carrying out increasing sequencing on all the complete data records according to the sequencing serial number to obtain a target table.
Description
Technical Field
The embodiment of the application relates to the field of data processing, in particular to a data table generation method and related equipment.
Background
In the prior art, filling data in the empty table is performed by sequentially traversing each row of cells. In the filling process, for each cell to be filled currently, it is necessary to determine whether data of other cells can be used for filling the current cell, that is, it is determined whether independent data of other cells is not needed to be used or associated data of other cells is needed to be used, if the cell to be filled currently is associated data and data of other cells related to the cell is not filled yet, the cell to be filled currently needs to be skipped, until all cells are traversed and data of other cells related to the cell are filled already, the cell to be filled currently can be filled with data.
It can be seen that, in the above filling process, each cell is subjected to a series of judgment and retrieval, which consumes time and resources, and when a large amount of independent data is filled, the same way is used, which wastes time and resources.
Disclosure of Invention
The embodiment of the application provides a data table generation method, which is used for reducing time consumption and resource consumption in a data filling process.
A first implementation manner of the first aspect of the embodiments of the present application provides a data table generating method, including:
obtaining a service data set and a header area of a table to be filled in by the service data set, wherein the service data set comprises a plurality of pieces of service data, and the header area comprises an independent data column and an associated data column;
determining a hierarchy corresponding to each piece of service data and a sequencing serial number of each piece of service data according to a preset hierarchy division rule;
filling the cells corresponding to the independent data columns based on each piece of service data to obtain initial data records corresponding to each piece of service data;
filling the cells corresponding to the associated data columns of the initial data records based on the independent data columns of the initial data records to obtain complete data records corresponding to the initial data records;
and carrying out increasing sorting on all the complete data records according to the sorting sequence number to obtain a target table.
With reference to the first implementation manner of the first aspect of the embodiments of the present application, a second implementation manner of the first aspect of the embodiments of the present application includes:
dividing the service data corresponding to the same hierarchy into the same group to obtain a plurality of hierarchy groups;
and synchronously filling the cells corresponding to the independent data columns of the service data of each hierarchy group based on the service data of each hierarchy group to obtain initial data records corresponding to the service data in each hierarchy group.
With reference to the first implementation manner of the first aspect of the embodiments of the present application, the third implementation manner of the first aspect of the embodiments of the present application includes:
if the associated data columns in the initial data records have preset associated operation rules, determining target cells corresponding to the associated operation rules in a plurality of cells of the initial data records, wherein the target cells correspond to the cells of the independent data columns;
and calculating the target cell according to the association calculation rule, and filling a calculation result into the cell corresponding to the association data column of the initial data record to obtain a complete data record corresponding to the initial data record.
With reference to the first implementation manner of the first aspect of the embodiments of the present application, a fourth implementation manner of the first aspect of the embodiments of the present application includes:
determining a higher-level sequencing serial number corresponding to each piece of service data and a level class of a level corresponding to the service data according to the level dividing rule, wherein different level classes have a preset sequential searching order;
and according to the sorting rule corresponding to the hierarchy type, carrying out increasing sorting on all the complete data records according to a sorting sequence number to obtain a target table.
With reference to the fourth implementation manner of the first aspect of the example of the present application, the fifth implementation manner of the first aspect of the example of the present application includes:
determining a preset initial sequencing serial number as a current sequencing serial number, and determining a preset first position as a current position;
arranging the complete data records with the same sequencing serial number as the current sequencing serial number at the current position, sequentially searching the complete data records with the upper sequencing serial number equal to the current sequencing serial number and the sequencing serial number smaller than the current sequencing serial number plus 1 from the complete data records corresponding to different hierarchy categories according to the sequence searching order of different hierarchy categories, and sequentially sequencing the searched complete data records at the subsequent position of the current position;
adding 1 to the current sorting sequence number to serve as a new current sorting sequence number, and taking the next position of the subsequent position as a new current position;
if the new current sorting sequence number is less than or equal to the maximum sorting sequence number of the service data, returning to execute the step of arranging the complete data record with the same sorting sequence number as the new current sorting sequence number at the new current position;
and if the new current sorting sequence number is greater than the maximum sorting sequence number of the service data, finishing the increasing sorting and obtaining the target table.
With reference to the fifth implementation manner of the first aspect of the embodiments of the present application, the sixth implementation manner of the first aspect of the embodiments of the present application includes: the hierarchy class includes a subclass and a following class, and the search order of the subclass is prior to the search order of the following class.
A first implementation manner of the second aspect of the embodiments of the present application provides a data table generating method, including:
acquiring a service data set and a header area of a table to be filled in by the service data set; the business data set comprises a plurality of pieces of business data, and the header area comprises an independent data column and an associated data column;
filling the cells corresponding to the independent data columns based on each piece of service data to obtain data records corresponding to each piece of service data;
and executing the following filling steps on the cells corresponding to the associated data columns of the data records to obtain a target table:
if the associated data columns in the data records have preset associated operation rules, determining target cells corresponding to the associated operation rules in a plurality of cells of the data records, wherein the target cells correspond to the cells of the independent data columns;
and calculating the target cell according to the association calculation rule, and filling the calculation result into the cell corresponding to the associated data column of the data record.
A first implementation manner of the third aspect of the embodiments of the present application provides a data table generating apparatus, including:
the device comprises a first acquisition unit, a second acquisition unit and a third acquisition unit, wherein the first acquisition unit is used for acquiring a service data set and a header area of a table to be filled in by the service data set, the service data set comprises a plurality of pieces of service data, and the header area comprises an independent data column and an associated data column;
the determining unit is used for determining the hierarchy corresponding to each piece of service data and the sequencing serial number of each piece of service data according to a preset hierarchy dividing rule;
a second obtaining unit, configured to fill cells corresponding to the independent data columns based on each piece of service data to obtain an initial data record corresponding to each piece of service data;
a third obtaining unit, configured to fill cells corresponding to associated data columns of each initial data record based on an independent data column of each initial data record, so as to obtain a complete data record corresponding to each initial data record;
and the fourth obtaining unit is used for carrying out increasing sorting on all the complete data records according to the sorting sequence number to obtain a target table.
With reference to the first implementation manner of the third aspect of the embodiments of the present application, in a second implementation manner of the third aspect of the embodiments of the present application, the second obtaining unit includes:
the first acquisition subunit is used for dividing the service data corresponding to the same hierarchy into the same group to obtain a plurality of hierarchy groups;
and the second acquisition subunit is used for synchronously filling the cells corresponding to the independent data columns of the service data of each hierarchy group based on the service data of each hierarchy group to obtain initial data records corresponding to the service data in each hierarchy group.
With reference to the first implementation manner of the third aspect of the embodiments of the present application, in a third implementation manner of the third aspect of the embodiments of the present application, the third obtaining unit includes:
a first determining subunit, configured to determine, if an associated data column in the initial data record has a preset associated operation rule, a target cell corresponding to the associated operation rule among the cells of the initial data record, where the target cell corresponds to a cell of the independent data column;
and the third obtaining subunit is configured to perform operation on the target cell according to the association operation rule, and fill an operation result into a cell corresponding to an associated data column of the initial data record to obtain a complete data record corresponding to the initial data record.
With reference to the first implementation manner of the third aspect of the embodiments of the present application, in a fourth implementation manner of the third aspect of the embodiments of the present application, the fourth obtaining unit includes:
a second determining subunit, configured to determine, according to the hierarchy partitioning rule, a higher-level ranking sequence number corresponding to each piece of service data and a hierarchy type of a hierarchy corresponding to the service data, where different hierarchy types have a preset sequential search order;
and the fourth obtaining subunit is configured to perform increasing sorting on each complete data record according to a sorting rule corresponding to the hierarchy type and a sorting sequence number to obtain a target table.
With reference to the fourth implementation manner of the third aspect of the embodiments of the present application, in a fifth implementation manner of the third aspect of the embodiments of the present application, the fourth obtaining subunit includes:
the first determining module is used for determining a preset initial sequencing serial number as a current sequencing serial number and determining a preset first position as a current position;
the sorting module is used for arranging the complete data records with the same sorting sequence number as the current sorting sequence number at the current position, sequentially searching the complete data records with the upper-level sorting sequence number equal to the current sorting sequence number and the sorting sequence number smaller than the current sorting sequence number plus 1 from the complete data records corresponding to different hierarchy categories according to the searching sequence of different hierarchy categories, and sequentially sorting the searched complete data records at the subsequent position of the current position;
a second determining module, configured to add 1 to the current sorting sequence number to obtain a new current sorting sequence number, and obtain a position subsequent to the subsequent position as a new current position;
a returning module, configured to return to execute the step of arranging the complete data record with the same sequence number as the new current sequence number at the new current position if the new current sequence number is less than or equal to the maximum sequence number of the service data;
and the acquisition module is used for finishing the increasing sorting and obtaining the target table if the new current sorting serial number is greater than the maximum sorting serial number of the service data.
With reference to the fifth implementation manner of the third aspect of the embodiments of the present application, a sixth implementation manner of the third aspect of the embodiments of the present application includes: the hierarchy class includes a subclass and a following class, and the search order of the subclass is prior to the search order of the following class.
In a fourth aspect of the embodiments of the present application, there is provided a data table producing apparatus, including:
the device comprises a first acquisition unit, a second acquisition unit and a third acquisition unit, wherein the first acquisition unit is used for acquiring a service data set and a header area of a table to be filled in by the service data set, the service data set comprises a plurality of pieces of service data, and the header area comprises an independent data column and an associated data column;
a second obtaining unit, configured to fill cells corresponding to the independent data columns based on each piece of service data to obtain data records corresponding to each piece of service data;
a third obtaining unit, configured to perform the following filling steps on cells corresponding to the associated data columns of each data record to obtain a target table:
if the associated data columns in the data records have preset associated operation rules, determining target cells corresponding to the associated operation rules in a plurality of cells of the data records, wherein the target cells correspond to the cells of the independent data columns;
and calculating the target cell according to the association calculation rule, and filling the calculation result into the cell corresponding to the associated data column of the data record.
In a sixth aspect of embodiments of the present application, a computer-readable storage medium is provided, which includes instructions that, when executed on a computer, cause the computer to perform any one of the embodiments of the first aspect or the second aspect.
In a seventh aspect of the embodiments of the present application, there is provided a computer program product, wherein when the computer program product is executed on a computer, the computer executes the method in any one of the foregoing first aspects.
In an eighth aspect of embodiments of the present application, a data table generating device includes:
the system comprises a central processing unit, a memory, an input/output interface, a wired or wireless network interface and a power supply;
the memory is a transient memory or a persistent memory;
the central processor is configured to communicate with the memory, and to invoke instruction operations in the memory on the data table generating device to perform any one of the embodiments of the first or second aspects.
According to the technical scheme, the embodiment of the application has the following advantages:
after a business data set containing business data and a header area containing an independent data column and an associated data column are obtained, the level and the sorting sequence number corresponding to each piece of business data are determined according to a preset level division rule, the cells corresponding to the independent data column are filled based on each piece of business data to obtain an initial data record corresponding to each piece of business data, then the cells corresponding to the associated data column of each initial data record are filled based on the independent data column of each initial data record to obtain a complete data record corresponding to the initial data record, and finally each complete data record is progressively sorted according to the sorting sequence number to obtain a target table. A series of judgment retrieval is not needed when one cell is filled in the prior art, and time consumption and resource consumption are reduced.
Drawings
FIG. 1 is a schematic flow chart diagram illustrating a data table generating method according to an embodiment of the present application;
FIG. 2 is another schematic flow chart diagram illustrating a data table generating method according to an embodiment of the present application;
FIG. 3 is another schematic flow chart diagram illustrating a data table generating method according to an embodiment of the present application;
FIG. 4 is another schematic flow chart diagram illustrating a data table generating method according to an embodiment of the present application;
FIG. 5 is another schematic flow chart diagram illustrating a data table generating method according to an embodiment of the present application;
FIG. 6 is a schematic flow chart diagram illustrating a data table generating method according to an embodiment of the present application;
FIG. 7 is a schematic structural diagram of a data table generating apparatus according to an embodiment of the present application;
FIG. 8 is a schematic structural diagram of a data table generating apparatus according to an embodiment of the present application;
fig. 9 is a schematic structural diagram of a data table generating device in the embodiment of the present application.
Detailed Description
The embodiment of the application provides a data table generation method, which is used for reducing time consumption and resource consumption in a data filling process.
Referring to fig. 1, an embodiment of the present application provides a method for generating a data table, including:
the embodiment is used for filling the acquired service data set with data in the service data set to a table containing a header area and performing sorting processing to obtain a target table after arrangement, where the header area includes an independent data column and an associated data column, data in the independent data column can be directly acquired from the service data set, and data in the associated data column is obtained based on data operation in the independent data column.
101. The method comprises the steps of obtaining a service data set and a header area of a table to be filled in by the service data set, wherein the service data set comprises a plurality of pieces of service data, and the header area comprises an independent data column and an associated data column.
The method comprises the steps of obtaining a business data set and a header area of a table, wherein the business data set comprises a plurality of pieces of business data, the header area comprises an independent data column and an associated data column, each piece of business data comprises the independent data column and the associated data column, data to be filled of the independent data column corresponding to each piece of business data can be directly obtained from the data set, and the associated data column corresponding to each piece of business data is obtained based on data logic operation after the independent data columns are filled.
102. And determining the hierarchy corresponding to each piece of service data and the sequencing serial number of each piece of service data according to a preset hierarchy division rule.
Acquiring a preset hierarchy dividing rule for determining the hierarchy and the sequencing sequence number of each piece of service data, and determining the hierarchy and the sequencing sequence number corresponding to each piece of service data under a plurality of pieces of service data according to the preset hierarchy dividing rule. The sequence number of each service data is used to arrange the complete data record corresponding to each service data according to the size of the sequence number in step 105.
Illustratively, for 3 pieces of service data, for example, service data a, service data B, and service data C, it is determined that service data a is at a first level and its sequencing sequence number is 1, service data B is at a third level and its sequencing sequence number is 3, and service data C is at a third level and its sequencing sequence number is 2.
103. And filling the cells corresponding to the independent data columns based on each piece of service data to obtain initial data records corresponding to each piece of service data.
And filling data into the cells of the independent data columns corresponding to each piece of service data simultaneously based on each piece of service data, so as to obtain initial data records corresponding to each piece of service data, wherein the initial data records with the same hierarchy can be at adjacent positions in the table, and the sequencing serial numbers of the initial data records in the same hierarchy are sequentially increased.
It should be noted that each initial data record also includes an independent data column and an associated data column, and the initial data record in this step is filled with data only in the independent data column of the initial data record, and the associated data column is not filled yet.
For example, for 3 pieces of service data, for example, service data a, service data B, and service data C, there is a same header area, and the same header area contains a plurality of same header contents, for example, 3 header contents a, B, and C, for 3 pieces of service data, and for each piece of service data, the plurality of header contents can be divided into an independent data column and an associated data column associated with each piece of service data, so that for each piece of service data, there may be a same or different independent data column and a same or different associated data column, for example, for service data a, its independent data column is the header content of a, and header contents B and C are the associated data columns of service data a; for the service data B, the independent data column is the header content of B, and the associated data column is the header content of c; for the service data C, the independent data column is the header content of C, and the associated data column is the header content of a and b. When the step is executed, for the service data A, filling the cells under the header content of the independent data column a of the service data A to form an initial data record A corresponding to the service data A; for the service data B, filling a cell under the header content of the independent data column B of the service data B to form an initial data record B corresponding to the service data B; and for the service data C, filling the cells under the header content of the independent data column C of the service data C to form an initial data record C corresponding to the service data C.
104. And filling the cells corresponding to the associated data columns of the initial data records based on the independent data columns of the initial data records to obtain complete data records corresponding to the initial data records.
After obtaining a plurality of initial data records, based on the independent data column of each initial data record, filling data into the cells under the associated data column of each initial data record, wherein the data is determined by the data of the cells under the independent data column of each initial data record, thereby completing the filling of the associated data column of the initial data record to obtain a complete data record.
It should be noted that the data associated with the cells under the associated data column is determined based on the data associated with the cells under the independent data column. As can be seen from steps 103 and 104, in this embodiment, data is first filled into cells of independent data columns of each service data, the data directly originates from a service data set, and then data calculated based on the cell filling data of the independent data columns is filled into associated data columns of each service data, which is different from the judgment and retrieval in the cell filling process in the prior art.
Illustratively, 3 pieces of service data are also taken as description objects, and when the step is executed, for an initial data record a, cells under the header contents of the associated data columns b and c of the initial data record a are filled, so that the initial data record a forms a complete data record a; for the initial data record B, filling the cells under the header contents of the associated data columns a and c of the initial data record B, and forming a complete data record B by the initial data record B; for the initial data record C, the cells under the header content of the associated data columns a and b of the initial data record C are filled, and the initial data record C thus forms the complete data record C.
105. And carrying out increasing sorting on all the complete data records according to the sorting sequence number to obtain a target table.
And carrying out increasing sorting on all the complete data records according to the sorting sequence number so as to obtain a target table.
Illustratively, 3 pieces of service data are also taken as description objects, and when the step is executed, according to the service data a with the sequencing sequence number of 1, the service data B with the sequencing sequence number of 3, and the service data C with the sequencing sequence number of 2, the service data a, the service data B and the service data C are sorted in an increasing order by the sequencing sequence number, so that a target table sequentially consisting of the complete data record a, the complete data record C and the complete data record B can be obtained.
It should be noted that, the steps 104 and 105 may be performed alternately, that is, the target table may be obtained by sorting while obtaining the complete data record.
In this embodiment, the formation of the target table is based on sorting the complete data records, wherein the formation of the complete data records is based on data acquisition of independent data columns of the initial data records by logical operations, therefore, the initial data record is the basis for obtaining the complete data record, i.e. the initial data record is formed uniformly in advance in this embodiment, the complete data records are formed uniformly based on the data of the initial data records, the respective formation of the initial data records and the complete data records of the embodiment increases relative independence and weakens association in the processing sequence, and is based on the increase of relative independence and the weakening of association in the processing sequence, compared with the prior art, the time consumption and the resource consumption of the filling process are reduced, and the developer is easy to handle based on the reduction of constraint limits on subsequent content addition and maintenance.
Based on the embodiment shown in fig. 1, the following embodiment is a detailed description of step 103, please refer to fig. 2, and the embodiment includes:
201. and dividing the service data corresponding to the same hierarchy into the same group to obtain a plurality of hierarchy groups.
After the hierarchy of a plurality of pieces of business data is determined, the business data of the same hierarchy is divided into the same group, and therefore a plurality of hierarchy groups are obtained. Wherein, the number of the service data of different hierarchy groups is different.
202. And synchronously filling the cells corresponding to the independent data columns of the service data of each hierarchy group based on the service data of each hierarchy group to obtain initial data records corresponding to the service data in each hierarchy group.
After determining the service data divided by the hierarchy groups, each hierarchy group synchronously fills the cells of the independent data columns under the hierarchy group with data, and the data is sourced from the service data, so that an initial data record of the service data under the corresponding hierarchy group is obtained.
Based on the embodiment of fig. 1, the following embodiment is described as step 104, and reference to fig. 3 includes:
301. if the associated data column in the initial data record has a preset associated operation rule, determining a target cell corresponding to the associated operation rule in a plurality of cells of the initial data record, wherein the target cell corresponds to the cell of the independent data column.
And if the associated data of the initial data records have a preset associated operation rule, determining a target cell corresponding to the associated operation rule in the cells of the plurality of initial data records, wherein the target cell corresponds to the cell of the independent data column, and the associated operation rule is obtained by logically operating the cell data of the plurality of initial data records.
For example, for 3 pieces of service data, for example, service data a, service data B, and service data C, there is a same header area, where the same multiple header contents, for example, 3 header contents a, B, and C, are contained for 3 pieces of service data below the area, and for each piece of service data, the multiple header contents can be divided into an independent data column and an associated data column associated with each piece of service data, so that there may be an identical or different independent data column and an identical or different associated data column for each piece of service data, for service data a, the independent data column is a header content, the header contents B and C are associated data columns of service data a, and the two associated data columns of header contents B and C each have an associated operation rule related to service data a; for the service data B, the independent data column is the header content of B, the associated data column is the header content of c, and the associated data column of the header content c is related to the associated operation rule of the service data B; for the business data C, the independent data column is the header content of C, the associated data column is the header content of a and B, and the two associated data columns of the header content a and B respectively have associated operation rules related to the business data C, so that for the business data a and the business data B, the two associated data columns have the same associated data column C and correspondingly have different associated operation rules.
302. And calculating the target cell according to the association calculation rule, and filling a calculation result into the cell corresponding to the association data column of the initial data record to obtain a complete data record corresponding to the initial data record.
After the target cell is determined, the target cell is subjected to logical operation according to the association operation rule, and the cell corresponding to the initial data record association data column is filled with the result of the logical operation, so that the initial data record becomes a complete data record.
Based on the embodiment shown in fig. 1, the following embodiment is a detailed description of step 105, please refer to fig. 4, and the embodiment includes:
401. and determining a higher-level sequencing serial number corresponding to each piece of service data and a level class of a level corresponding to the service data according to the level dividing rule, wherein different level classes have a preset sequential searching order.
And determining a superior sorting sequence number and a hierarchical category of each piece of service data according to a hierarchical division rule, wherein the superior sorting sequence number represents sorting association among the service data, and the hierarchical category represents a preset sequential search order for sorting.
It should be noted that, the upper ranking sequence number and the hierarchy category of the service data are determined based on a hierarchy partitioning rule, the hierarchy category is used to describe the relationship between the service data of each hierarchy, the relationship may be transferred to the corresponding initial data record and the complete data record, and a preset sequential search order for ranking is formed through the relationship. The upper-level sorting sequence number of the service data may also be transferred to the corresponding initial data record and the complete data record, it should be noted that the service data may also have no upper-level sorting sequence number, and the same is true for the corresponding initial data record and the complete data record, and whether the service data has the upper-level sorting sequence number depends on the actual situation, and is not limited herein.
402. And according to the sorting rule corresponding to the hierarchy type, carrying out increasing sorting on all the complete data records according to a sorting sequence number to obtain a target table.
After the hierarchy category is determined, according to a sorting rule corresponding to the hierarchy category, all the complete data records are subjected to ascending sorting according to a sorting sequence number to obtain a target table.
Further, based on the embodiment of fig. 4, the following embodiment is a detailed description of step 402, please refer to fig. 5, which includes:
501. and determining the preset initial sequencing serial number as the current sequencing serial number, and determining the preset first position as the current position.
And determining a preset initial sorting sequence number as a current sorting sequence number, and determining a preset first position as a current position, wherein the initial sorting sequence number and the first position can be preset according to an actual situation, and are not limited herein.
502. And arranging the complete data records with the same sequencing serial number as the current sequencing serial number at the current position, sequentially searching the complete data records with the upper sequencing serial number equal to the current sequencing serial number and the sequencing serial number smaller than the current sequencing serial number plus 1 from the complete data records corresponding to different hierarchy categories according to the sequence searching order of different hierarchy categories, and sequentially sequencing the searched complete data records at the subsequent position of the current position.
After the current sorting sequence number and the current position are determined, the current sorting sequence number is used as a guide to obtain a complete data record with the same sorting sequence number as the current sorting sequence number, the complete data record is arranged at the current position, then the complete data record with the upper-level sorting sequence number equal to the current sorting sequence number is searched according to the searching sequence of different hierarchy categories, the sorting sequence number of the complete data record is smaller than the result of adding 1 to the current sorting sequence number, and finally the searched complete data record is sequentially sorted at the subsequent position of the current position.
It should be noted that the hierarchical categories are divided into subclasses and following classes, and the search order of the subclasses is prior to the search order of the following classes, so that in the search process, the complete data records of the subclasses are searched first, and then the complete data records of the following classes are searched, wherein the upper ranking sequence numbers corresponding to the complete data records of the subclasses and the complete data records of the following classes are the same as the current ranking sequence number, and the ranking sequence numbers corresponding to the complete data records of the subclasses and the complete data records of the following classes are smaller than the result of adding 1 to the current ranking sequence number. It should be noted that the complete data record of the subclass and the corresponding complete data record of the current sorting sequence number have a parent-child relationship, wherein the complete data record corresponding to the current sorting sequence number is the complete data record of the parent class, and similarly, the complete data record of the following class and the corresponding complete data record corresponding to the current sorting sequence number have a following relationship, wherein the complete data record corresponding to the current sorting sequence number is the followed complete data record. When a plurality of complete data records of the subclasses or/and the following classes exist in the step, the complete data records of all the subclasses are sorted first, and then the complete data records of all the following classes are sorted, wherein when the complete data records of all the subclasses are sorted, the sorting sequence numbers of the complete data records of all the subclasses are sorted in an increasing mode, and when the complete data records of all the following classes are sorted, the sorting sequence numbers of the complete data records of all the following classes are sorted in an increasing mode.
503. And adding 1 to the current sorting sequence number to serve as a new current sorting sequence number, and taking the position behind the subsequent position as a new current position.
And after the complete data record associated with the current sorting sequence number is sorted, adding 1 to the current sorting sequence number to serve as a new current sorting sequence number, and taking the next position of the subsequent position as a new current position.
504. And if the new current sorting sequence number is less than or equal to the maximum sorting sequence number of the service data, returning to execute the step of arranging the complete data record with the same sorting sequence number as the new current sorting sequence number at the new current position.
And judging whether the new current sorting sequence number is less than or equal to the maximum sorting sequence number of the service data, if so, returning to execute the step of arranging the complete data record with the same sorting sequence number as the new current sorting sequence number at the new current position, namely step 502.
505. And if the new current sorting sequence number is greater than the maximum sorting sequence number of the service data, finishing the increasing sorting and obtaining the target table.
And judging whether the new current sorting sequence number is less than or equal to the maximum sorting sequence number of the service data, if not, namely judging that the new current sorting sequence number is greater than the maximum sorting sequence number of the service data, finishing the increasing sorting and obtaining a final target table.
Referring to fig. 6, an embodiment of the present application provides another data table generating method, including:
601. the method comprises the steps of obtaining a service data set and a header area of a table to be filled in by the service data set, wherein the service data set comprises a plurality of pieces of service data, and the header area comprises an independent data column and an associated data column.
This step is similar to step 101, and is not described herein in detail.
602. And filling the cells corresponding to the independent data columns based on each piece of service data to obtain data records corresponding to each piece of service data.
After obtaining each service data, filling the cells corresponding to the independent data columns of the table to obtain the data records corresponding to each service data, wherein the arrangement of each data record is determined by the table.
603. And executing the following filling steps on the cells corresponding to the associated data columns of the data records to obtain a target table.
604. And if the associated data columns in the data records have preset associated operation rules, determining target cells corresponding to the associated operation rules in the cells of the data records, wherein the target cells correspond to the cells of the independent data columns.
This step is similar to step 301, and is not described herein in detail.
605. And calculating the target cell according to the association calculation rule, and filling the calculation result into the cell corresponding to the associated data column of the data record.
This step is similar to step 302 and will not be described herein.
Further, the present embodiment includes a structure diagram of a data table generating device, please refer to fig. 7, which includes:
a first obtaining unit 701, configured to obtain a service data set and a header area of a table to be filled with the service data set, where the service data set includes multiple pieces of service data, and the header area includes an independent data column and an associated data column;
a determining unit 702, configured to determine, according to a preset hierarchy partitioning rule, a hierarchy corresponding to each piece of service data and a sequence number of each piece of service data;
a second obtaining unit 703, configured to fill the cells corresponding to the independent data columns based on each piece of service data, so as to obtain initial data records corresponding to each piece of service data;
a third obtaining unit 704, configured to fill cells corresponding to associated data columns of each initial data record based on an independent data column of each initial data record, so as to obtain a complete data record corresponding to each initial data record;
the fourth obtaining unit 705 is configured to perform ascending sorting on each complete data record according to the sorting sequence number, so as to obtain a target table.
In one implementation, the second obtaining unit 703 includes:
the first acquisition subunit is used for dividing the service data corresponding to the same hierarchy into the same group to obtain a plurality of hierarchy groups;
and the second acquisition subunit is used for synchronously filling the cells corresponding to the independent data columns of the service data of each hierarchy group based on the service data of each hierarchy group to obtain initial data records corresponding to the service data in each hierarchy group.
In one implementation, the third obtaining unit 704 includes:
a first determining subunit, configured to determine, if an associated data column in the initial data record has a preset associated operation rule, a target cell corresponding to the associated operation rule among the cells of the initial data record, where the target cell corresponds to a cell of the independent data column;
and the third obtaining subunit is configured to perform operation on the target cell according to the association operation rule, and fill an operation result into a cell corresponding to an associated data column of the initial data record to obtain a complete data record corresponding to the initial data record.
In one implementation, the fourth obtaining unit 705 includes:
a second determining subunit, configured to determine, according to the hierarchy partitioning rule, a higher-level ranking sequence number corresponding to each piece of service data and a hierarchy type of a hierarchy corresponding to the service data, where different hierarchy types have a preset sequential search order;
and the fourth obtaining subunit is configured to perform increasing sorting on each complete data record according to a sorting rule corresponding to the hierarchy type and a sorting sequence number to obtain a target table.
In one implementation, the fourth obtaining subunit includes:
the first determining module is used for determining a preset initial sequencing serial number as a current sequencing serial number and determining a preset first position as a current position;
the sorting module is used for arranging the complete data records with the same sorting sequence number as the current sorting sequence number at the current position, sequentially searching the complete data records with the upper-level sorting sequence number equal to the current sorting sequence number and the sorting sequence number smaller than the current sorting sequence number plus 1 from the complete data records corresponding to different hierarchy categories according to the searching sequence of different hierarchy categories, and sequentially sorting the searched complete data records at the subsequent position of the current position;
a second determining module, configured to add 1 to the current sorting sequence number to obtain a new current sorting sequence number, and obtain a position subsequent to the subsequent position as a new current position;
a returning module, configured to return to execute the step of arranging the complete data record with the same sequence number as the new current sequence number at the new current position if the new current sequence number is less than or equal to the maximum sequence number of the service data;
and the acquisition module is used for finishing the increasing sorting and obtaining the target table if the new current sorting serial number is greater than the maximum sorting serial number of the service data.
In one implementation, a data table generating apparatus includes: the hierarchy class includes a subclass and a following class, and the search order of the subclass is prior to the search order of the following class.
The present embodiment includes a structure diagram of a data table generating device, please refer to fig. 8, which includes:
a first obtaining unit 801, configured to obtain a service data set and a header area of a table to be filled with the service data set, where the service data set includes multiple pieces of service data, and the header area includes an independent data column and an associated data column;
a second obtaining unit 802, configured to fill cells corresponding to the independent data columns based on each piece of service data to obtain data records corresponding to each piece of service data;
a third obtaining unit 803, configured to perform the following filling steps on the cells corresponding to the associated data columns of each data record, to obtain a target table:
if the associated data columns in the data records have preset associated operation rules, determining target cells corresponding to the associated operation rules in a plurality of cells of the data records, wherein the target cells correspond to the cells of the independent data columns;
and calculating the target cell according to the association calculation rule, and filling the calculation result into the cell corresponding to the associated data column of the data record.
Fig. 9 is another schematic structural diagram of a data table generating device according to an embodiment of the present application, where the data table generating device 901 may include one or more Central Processing Units (CPUs) 902 and a memory 906, and the memory 906 stores one or more application programs or data therein.
The memory 906 may be volatile storage or persistent storage, among other things. The program stored in the memory 906 may include one or more modules, each of which may include a series of instruction operations in the data table generating apparatus 901. Still further, the central processor 902 may be arranged in communication with the memory 906 for executing a series of instruction operations in the memory 906 on the data table generating device 901.
The spreadsheet generating device 901 may also include one or more power supplies 903, one or more wired or wireless network interfaces 904, one or more input-output interfaces 905, and/or one or more operating systems, such as Windows Server, Mac OS XTM, UnixTM, LinuxTM, FreeBSDTM, etc.
The data table generating device 901 may perform operations in the embodiment shown in any one of fig. 1 to fig. 6, which are not described herein again.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the several embodiments provided in the present application, it should be understood that the disclosed system, apparatus and method may be implemented in other manners. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be substantially implemented or contributed to by the prior art, or all or part of the technical solution may be embodied in a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a read-only memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and the like.
Claims (10)
1. A method for generating a data table, comprising:
obtaining a service data set and a header area of a table to be filled in by the service data set, wherein the service data set comprises a plurality of pieces of service data, and the header area comprises an independent data column and an associated data column;
determining a hierarchy corresponding to each piece of service data and a sequencing serial number of each piece of service data according to a preset hierarchy division rule;
filling the cells corresponding to the independent data columns based on each piece of service data to obtain initial data records corresponding to each piece of service data;
filling the cells corresponding to the associated data columns of the initial data records based on the independent data columns of the initial data records to obtain complete data records corresponding to the initial data records;
and carrying out increasing sorting on all the complete data records according to the sorting sequence number to obtain a target table.
2. The method according to claim 1, wherein the step of filling the cells corresponding to the independent data columns based on each piece of the service data to obtain an initial data record corresponding to each piece of the service data includes:
dividing the service data corresponding to the same hierarchy into the same group to obtain a plurality of hierarchy groups;
and synchronously filling the cells corresponding to the independent data columns of the service data of each hierarchy group based on the service data of each hierarchy group to obtain initial data records corresponding to the service data in each hierarchy group.
3. The method according to claim 1, wherein the step of filling cells corresponding to the associated data columns of each initial data record based on the independent data columns of each initial data record to obtain complete data records corresponding to each initial data record comprises:
if the associated data columns in the initial data records have preset associated operation rules, determining target cells corresponding to the associated operation rules in a plurality of cells of the initial data records, wherein the target cells correspond to the cells of the independent data columns;
and calculating the target cell according to the association calculation rule, and filling a calculation result into the cell corresponding to the association data column of the initial data record to obtain a complete data record corresponding to the initial data record.
4. The method of claim 1, wherein the step of incrementally sorting the complete data records according to a sorting order number to obtain a target table comprises:
determining a higher-level sequencing serial number corresponding to each piece of service data and a level class of a level corresponding to the service data according to the level dividing rule, wherein different level classes have a preset sequential searching order;
and according to the sorting rule corresponding to the hierarchy type, carrying out increasing sorting on all the complete data records according to a sorting sequence number to obtain a target table.
5. The method according to claim 4, wherein the step of performing ascending sorting on each complete data record according to a sorting rule corresponding to the hierarchy category according to a sorting sequence number to obtain a target table comprises:
determining a preset initial sequencing serial number as a current sequencing serial number, and determining a preset first position as a current position;
arranging the complete data records with the same sequencing serial number as the current sequencing serial number at the current position, sequentially searching the complete data records with the upper sequencing serial number equal to the current sequencing serial number and the sequencing serial number smaller than the current sequencing serial number plus 1 from the complete data records corresponding to different hierarchy categories according to the sequence searching order of different hierarchy categories, and sequentially sequencing the searched complete data records at the subsequent position of the current position;
adding 1 to the current sorting sequence number to serve as a new current sorting sequence number, and taking the next position of the subsequent position as a new current position;
if the new current sorting sequence number is less than or equal to the maximum sorting sequence number of the service data, returning to execute the step of arranging the complete data record with the same sorting sequence number as the new current sorting sequence number at the new current position;
and if the new current sorting sequence number is greater than the maximum sorting sequence number of the service data, finishing the increasing sorting and obtaining the target table.
6. The method of claim 5, comprising: the hierarchy class includes a subclass and a following class, and the search order of the subclass is prior to the search order of the following class.
7. A method for generating a data table, comprising:
obtaining a service data set and a header area of a table to be filled in by the service data set, wherein the service data set comprises a plurality of pieces of service data, and the header area comprises an independent data column and an associated data column;
filling the cells corresponding to the independent data columns based on each piece of service data to obtain data records corresponding to each piece of service data;
and executing the following filling steps on the cells corresponding to the associated data columns of the data records to obtain a target table:
if the associated data columns in the data records have preset associated operation rules, determining target cells corresponding to the associated operation rules in a plurality of cells of the data records, wherein the target cells correspond to the cells of the independent data columns;
and calculating the target cell according to the association calculation rule, and filling the calculation result into the cell corresponding to the associated data column of the data record.
8. A data table generating apparatus, comprising:
the device comprises a first acquisition unit, a second acquisition unit and a third acquisition unit, wherein the first acquisition unit is used for acquiring a service data set and a header area of a table to be filled in by the service data set, the service data set comprises a plurality of pieces of service data, and the header area comprises an independent data column and an associated data column;
the determining unit is used for determining the hierarchy corresponding to each piece of service data and the sequencing serial number of each piece of service data according to a preset hierarchy dividing rule;
a second obtaining unit, configured to fill cells corresponding to the independent data columns based on each piece of service data to obtain an initial data record corresponding to each piece of service data;
a third obtaining unit, configured to fill cells corresponding to associated data columns of each initial data record based on an independent data column of each initial data record, so as to obtain a complete data record corresponding to each initial data record;
and the fourth obtaining unit is used for carrying out increasing sorting on all the complete data records according to the sorting sequence number to obtain a target table.
9. A data table generating apparatus, characterized by comprising:
the system comprises a central processing unit, a memory, an input/output interface, a wired or wireless network interface and a power supply;
the memory is a transient memory or a persistent memory;
the central processor is configured to communicate with the memory, and to invoke on the data table generating device an operation of instructions in the memory to perform the method of any of claims 1 to 7.
10. A computer-readable storage medium comprising instructions that, when executed on a computer, cause the computer to perform the method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011519738.0A CN112528613A (en) | 2020-12-21 | 2020-12-21 | Data table generation method and related equipment thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011519738.0A CN112528613A (en) | 2020-12-21 | 2020-12-21 | Data table generation method and related equipment thereof |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112528613A true CN112528613A (en) | 2021-03-19 |
Family
ID=75001990
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011519738.0A Pending CN112528613A (en) | 2020-12-21 | 2020-12-21 | Data table generation method and related equipment thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112528613A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113128187A (en) * | 2021-04-19 | 2021-07-16 | 上海宜员网络技术有限公司 | Form generation method, device and system |
Citations (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1209607A2 (en) * | 2000-11-28 | 2002-05-29 | International Business Machines Corporation | Method and system for filling a range of cells in an electronic spreadsheet by samples |
| CN101794280A (en) * | 2010-03-11 | 2010-08-04 | 北京中科辅龙计算机技术股份有限公司 | Form automatic generation method and system based on form template set |
| CN103500157A (en) * | 2013-09-02 | 2014-01-08 | 用友软件股份有限公司 | Device and method for filling form based on dynamic formula |
| CN106921614A (en) * | 2015-12-24 | 2017-07-04 | 北京国双科技有限公司 | Business data processing method and device |
| CN109800401A (en) * | 2018-12-25 | 2019-05-24 | 北京数知科技股份有限公司 | Information report automatic generation method and device |
| US20190272314A1 (en) * | 2013-06-15 | 2019-09-05 | Microsoft Technology Licensing, Llc | Conversion of data ranges to table objects |
| CN110347758A (en) * | 2019-07-17 | 2019-10-18 | 中铁二局集团勘测设计院有限责任公司 | A kind of generation method of Chinese style report |
| CN110427604A (en) * | 2019-08-15 | 2019-11-08 | 北京明略软件系统有限公司 | Table integration method and device |
| CN110738037A (en) * | 2019-10-15 | 2020-01-31 | 深圳逻辑汇科技有限公司 | Method, apparatus, device and storage medium for automatically generating electronic form |
| CN111191429A (en) * | 2019-09-27 | 2020-05-22 | 深圳逻辑汇科技有限公司 | System and method for automatic filling of data table |
| CN111414410A (en) * | 2019-01-07 | 2020-07-14 | 阿里巴巴集团控股有限公司 | Data processing method, device, equipment and storage medium |
| CN111538731A (en) * | 2020-05-14 | 2020-08-14 | 山东慧泰智能科技有限公司 | Industrial data automatic generation report system |
| CN111737539A (en) * | 2020-08-24 | 2020-10-02 | 成都四方伟业软件股份有限公司 | Complex report engine method and device |
| CN111797604A (en) * | 2020-06-30 | 2020-10-20 | 深圳壹账通智能科技有限公司 | Report generation method, device, equipment and computer readable storage medium |
| CN111881660A (en) * | 2020-06-29 | 2020-11-03 | 金蝶医疗软件科技有限公司 | Report generation method and device, computer equipment and storage medium |
| CN111914524A (en) * | 2020-06-05 | 2020-11-10 | 深圳小库科技有限公司 | Method and device for automatically generating table data |
| CN112035092A (en) * | 2020-08-21 | 2020-12-04 | 北京字节跳动网络技术有限公司 | Form processing method, device, equipment and readable medium |
-
2020
- 2020-12-21 CN CN202011519738.0A patent/CN112528613A/en active Pending
Patent Citations (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1209607A2 (en) * | 2000-11-28 | 2002-05-29 | International Business Machines Corporation | Method and system for filling a range of cells in an electronic spreadsheet by samples |
| CN101794280A (en) * | 2010-03-11 | 2010-08-04 | 北京中科辅龙计算机技术股份有限公司 | Form automatic generation method and system based on form template set |
| US20190272314A1 (en) * | 2013-06-15 | 2019-09-05 | Microsoft Technology Licensing, Llc | Conversion of data ranges to table objects |
| CN103500157A (en) * | 2013-09-02 | 2014-01-08 | 用友软件股份有限公司 | Device and method for filling form based on dynamic formula |
| CN106921614A (en) * | 2015-12-24 | 2017-07-04 | 北京国双科技有限公司 | Business data processing method and device |
| CN109800401A (en) * | 2018-12-25 | 2019-05-24 | 北京数知科技股份有限公司 | Information report automatic generation method and device |
| CN111414410A (en) * | 2019-01-07 | 2020-07-14 | 阿里巴巴集团控股有限公司 | Data processing method, device, equipment and storage medium |
| CN110347758A (en) * | 2019-07-17 | 2019-10-18 | 中铁二局集团勘测设计院有限责任公司 | A kind of generation method of Chinese style report |
| CN110427604A (en) * | 2019-08-15 | 2019-11-08 | 北京明略软件系统有限公司 | Table integration method and device |
| CN111191429A (en) * | 2019-09-27 | 2020-05-22 | 深圳逻辑汇科技有限公司 | System and method for automatic filling of data table |
| CN110738037A (en) * | 2019-10-15 | 2020-01-31 | 深圳逻辑汇科技有限公司 | Method, apparatus, device and storage medium for automatically generating electronic form |
| CN111538731A (en) * | 2020-05-14 | 2020-08-14 | 山东慧泰智能科技有限公司 | Industrial data automatic generation report system |
| CN111914524A (en) * | 2020-06-05 | 2020-11-10 | 深圳小库科技有限公司 | Method and device for automatically generating table data |
| CN111881660A (en) * | 2020-06-29 | 2020-11-03 | 金蝶医疗软件科技有限公司 | Report generation method and device, computer equipment and storage medium |
| CN111797604A (en) * | 2020-06-30 | 2020-10-20 | 深圳壹账通智能科技有限公司 | Report generation method, device, equipment and computer readable storage medium |
| CN112035092A (en) * | 2020-08-21 | 2020-12-04 | 北京字节跳动网络技术有限公司 | Form processing method, device, equipment and readable medium |
| CN111737539A (en) * | 2020-08-24 | 2020-10-02 | 成都四方伟业软件股份有限公司 | Complex report engine method and device |
Non-Patent Citations (2)
| Title |
|---|
| JOHN MICHALOUDIS: "Autofill Formula in an Excel Table", Retrieved from the Internet <URL:https://www.myexcelonline.com/blog/autofill-formulas-in-an-excel-table/> * |
| WANGBAOXI9: "填报表用ajax实现关联单元格自动填充", Retrieved from the Internet <URL:https://www.doc88.com/p-6743811126496.html> * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113128187A (en) * | 2021-04-19 | 2021-07-16 | 上海宜员网络技术有限公司 | Form generation method, device and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Wei et al. | A capacity constrained multiobjective cell formation method | |
| CN107807982B (en) | Consistency checking method and device for heterogeneous database | |
| CN110292775B (en) | Method and device for acquiring difference data | |
| CN107609217B (en) | Processing method and device for collision check data | |
| CN106844324B (en) | Method for exporting variable column data into Excel format | |
| CN104834731A (en) | Recommendation method and device for self-media information | |
| CN105550225A (en) | Index construction method and query method and apparatus | |
| CN106598999A (en) | Method and device for calculating text theme membership degree | |
| CN103177414A (en) | Structure-based dependency graph node similarity concurrent computation method | |
| CN113327136A (en) | Attribution analysis method and device, electronic equipment and storage medium | |
| CN106202224B (en) | Search processing method and device | |
| CN112506486A (en) | Search system establishing method and device, electronic equipment and readable storage medium | |
| CN110738720A (en) | Special effect rendering method and device, terminal and storage medium | |
| CN112541584A (en) | Deep neural network model parallel mode selection method | |
| CN112528613A (en) | Data table generation method and related equipment thereof | |
| CN114398194A (en) | Data collection method and device, electronic equipment and readable storage medium | |
| CN108334532B (en) | Spark-based Eclat parallelization method, system and device | |
| CN106599291A (en) | Method and device for grouping data | |
| CN112199407B (en) | Data packet ordering method, device, equipment and storage medium | |
| CN106855862A (en) | A kind of quick comparative approach and device | |
| CN102902769A (en) | Database benchmark test system of cloud computing platform and method thereof | |
| CN114817845B (en) | Data processing method, device, electronic equipment and storage medium | |
| CN107104829B (en) | Physical equipment matching distribution method and device based on network topology data | |
| CN115130043A (en) | Database-based data processing method, device, equipment and storage medium | |
| CN115033616A (en) | Data screening rule verification method and device based on multi-round sampling |
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 |