Method and device for generating table, electronic equipment and computer-readable storage medium

文档序号:1185109 发布日期:2020-09-22 浏览:8次 中文

阅读说明:本技术 生成表格的方法、装置、电子设备及计算机可读存储介质 (Method and device for generating table, electronic equipment and computer-readable storage medium ) 是由 刘松青 黄俊杰 张小福 邵河山 王雨功 于 2020-06-30 设计创作,主要内容包括:本申请实施例提供了一种生成表格的方法、装置、电子设备及计算机可读存储介质,涉及数据分析领域。该方法包括:对待操作文件进行解析操作,得到解析结果,解析结果包括该待操作文件中的各个标题栏和各个数据单元之间的对应关系、以及各个标题栏中的各个单元格之间的位置关系和各个数据单元中的各个单元格之间的位置关系,标题栏中的标题内容用于表示与标题栏对应的数据单元中的数据内容所属的类目;基于每一待操作文件的解析结果、以及各个标题栏中的标题内容和各个数据单元中的数据内容,生成预设形式的目标表格。本申请实施例解决了对多文件多表格进行大数据分析时,由于依赖人工操作,导致工作效率和准确性都很低的问题。(The embodiment of the application provides a method and a device for generating a table, electronic equipment and a computer-readable storage medium, and relates to the field of data analysis. The method comprises the following steps: analyzing the file to be operated to obtain an analysis result, wherein the analysis result comprises the corresponding relation between each title bar and each data unit in the file to be operated, the position relation between each cell in each title bar and the position relation between each cell in each data unit, and the title content in the title bar is used for representing the category to which the data content in the data unit corresponding to the title bar belongs; and generating a preset form target table based on the analysis result of each file to be operated, the title content in each title column and the data content in each data unit. The embodiment of the application solves the problem that when big data analysis is carried out on multiple files and multiple tables, the working efficiency and the accuracy are low due to the fact that manual operation is relied on.)

1. A method of generating a table, comprising:

acquiring at least one file to be operated;

analyzing each file to be operated to obtain an analysis result, wherein the analysis result comprises the corresponding relation between each title bar and each data unit in the file to be operated, the position relation between each cell in each title bar and the position relation between each cell in each data unit, and the title content in each title bar is used for representing the category to which the data content in the data unit corresponding to the title bar belongs;

and generating a preset form target table based on the analysis result of each file to be operated, the title content in each title column and the data content in each data unit.

2. The method for generating a table according to claim 1, wherein before the obtaining at least one file to be operated, the method further comprises:

classifying all files to be operated through crawling operation;

the acquiring of the at least one file to be operated includes:

and acquiring at least one file to be operated belonging to the same category.

3. The method for generating the table according to claim 1, wherein the file to be operated includes at least one table to be operated; the table information of the table to be operated comprises at least one field name area and at least one data set area; the field name area comprises at least one title field; the data set region includes at least one data unit;

the analyzing operation of the file to be operated includes:

and regarding each table to be operated in the file to be operated, determining a field name area in the table to be operated, analyzing the determined field name area, determining a data set area in the table to be operated, and analyzing the determined data set area.

4. The method for generating the table according to any one of claims 1 to 3, wherein the generating of the target table in the preset form based on the parsing result of each file to be operated, the title content in each title column and the data content in each data unit comprises:

regarding each title column in the file to be operated, merging and/or deleting redundant data of the title contents in the title column based on the analysis result of the file to be operated and the title contents in the title column;

regarding each data unit in the file to be operated, merging and/or deleting redundant data of the data content in the data unit based on the analysis result of the file to be operated and the data content in the data unit;

and generating a target table in a preset form based on the operation result.

5. An apparatus for generating a table, the apparatus comprising:

the acquisition unit is used for acquiring at least one file to be operated;

the analysis unit is used for analyzing each file to be operated to obtain an analysis result, wherein the analysis result comprises the corresponding relation between each title bar and each data unit in the file to be operated, the position relation between each cell in each title bar and the position relation between each cell in each data unit, and the title content in each title bar is used for representing the category to which the data content in the data unit corresponding to the title bar belongs;

and the generating unit is used for generating a target table in a preset form based on the analysis result of each file to be operated, the title content in each title column and the data content in each data unit.

6. The apparatus of claim 5, further comprising:

the crawling unit is used for classifying all files to be operated through crawling operation;

the acquiring unit is specifically configured to acquire at least one file to be operated that belongs to the same category.

7. The apparatus according to claim 5, wherein the file to be operated includes at least one table to be operated; the table information of the table to be operated comprises at least one field name area and at least one data set area; the field name area comprises at least one title field; the data set region includes at least one data unit;

the analysis unit is specifically configured to, for each to-be-operated form in the to-be-operated file, determine a field name area in the to-be-operated form and perform analysis operation on the determined field name area, and determine a data set area in the to-be-operated form and perform analysis operation on the determined data set area.

8. The apparatus according to any one of claims 5 to 7, wherein the generating unit is specifically configured to:

regarding each title column in the file to be operated, merging and/or deleting redundant data of the title contents in the title column based on the analysis result of the file to be operated and the title contents in the title column;

regarding each data unit in the file to be operated, merging and/or deleting redundant data of the data content in the data unit based on the analysis result of the file to be operated and the data content in the data unit;

and generating a target table in a preset form based on the operation result.

9. An electronic device, comprising:

one or more processors;

a memory;

one or more applications, wherein the one or more applications are stored in the memory and configured to be executed by the one or more processors, the one or more programs configured to: a method of generating a table according to any one of claims 1 to 4 is performed.

10. A computer-readable storage medium, on which a computer program is stored, which program, when being executed by a processor, is adapted to carry out the method of generating a table according to any one of claims 1 to 4.

Technical Field

The present application relates to the field of data analysis technologies, and in particular, to a method and an apparatus for generating a table, an electronic device, and a computer-readable storage medium.

Background

At present, big data index analysis is already an indispensable part of daily work of many units or companies. The market dynamics, the changes of related work inside the company and the trend of future development can be well controlled through the result of big data index analysis.

For example, in the medical field, big data needs to be analyzed, and the big data index analysis service involved in the big data index analysis service is to acquire, analyze and structure national statistical yearbook data, and finally obtain a big data analysis result, wherein the statistical yearbook data is composed of a huge number of Excel files, and therefore, a large number of tables and data are included.

By the present time, tens of thousands of statistical yearbook data Excel files are involved in the medical field, which is seen to be a huge and tedious workload, and the inventor finds that the following defects exist in the prior art:

1. the statistical yearbook data Excel file has no uniform standard template, and the prior art cannot use related tools for uniform processing, so that manual operation is required;

2. the field name area or the data set area in the statistical yearbook data Excel file can appear in a row form or a column form, so that the situation is not fixed, and the prior art can only rely on manual processing on the condition that the appearance form is not fixed;

3. both the field name area and the data set area may include multiple rows and/or multiple columns in succession, and the prior art can only rely on manual processing for such cross-row and cross-column situations.

Therefore, when the large data analysis is performed on the multiple files and the multiple tables in the prior art, the work efficiency and the accuracy are low due to the fact that manual operation is still needed.

Disclosure of Invention

The application provides a method and a device for generating a table, electronic equipment and a computer readable storage medium, which can solve the problem that when large data analysis is carried out on multiple files and multiple tables, the working efficiency and accuracy are low due to the fact that manual operation is relied on. The technical scheme is as follows:

in a first aspect, a method for generating a table is provided, the method including: acquiring at least one file to be operated;

analyzing each file to be operated to obtain an analysis result, wherein the analysis result comprises the corresponding relation between each title bar and each data unit in the file to be operated, the position relation between each cell in each title bar and the position relation between each cell in each data unit, and the title content in each title bar is used for representing the category to which the data content in the data unit corresponding to the title bar belongs;

and generating a target table in a preset form based on the analysis result of each file to be operated, the title content in each title column and the data content in each data unit.

Before at least one file to be operated is obtained, the method further comprises the following steps:

classifying all files to be operated through crawling operation;

acquiring at least one file to be operated, comprising:

and acquiring at least one file to be operated belonging to the same category.

The file to be operated comprises at least one table to be operated; the table information of the table to be operated comprises at least one field name area and at least one data set area; the field name area comprises at least one title field; the data set region includes at least one data unit;

analyzing the file to be operated, comprising:

and regarding each table to be operated in the file to be operated, determining a field name area in the table to be operated, analyzing the determined field name area, determining a data set area in the table to be operated, and analyzing the determined data set area.

The generating a preset form of target table based on the parsing result of each file to be operated, the title content in each title column and the data content in each data unit includes:

regarding each title column in the file to be operated, merging and/or deleting redundant data of the title content in the title column based on the analysis result of the file to be operated and the title content in the title column; regarding each data unit in the file to be operated, merging and/or deleting redundant data of the data content in the data unit based on the analysis result of the file to be operated and the data content in the data unit; and generating a target table in a preset form based on the operation result.

In a second aspect, an apparatus for generating a table is provided, the apparatus comprising:

the acquisition unit is used for acquiring at least one file to be operated;

the analysis unit is used for carrying out analysis operation on each file to be operated to obtain an analysis result, wherein the analysis result comprises the corresponding relation between each title bar and each data unit in the file to be operated, the position relation between each cell in each title bar and the position relation between each cell in each data unit, and the title content in each title bar is used for representing the category to which the data content in the data unit corresponding to the title bar belongs;

and the generating unit is used for generating a target table in a preset form based on the analysis result of each file to be operated, the title content in each title column and the data content in each data unit.

The device still includes:

the crawling unit is used for classifying all files to be operated through crawling operation;

the obtaining unit is specifically configured to obtain at least one file to be operated that belongs to the same category.

The file to be operated comprises at least one table to be operated; the table information of the table to be operated comprises at least one field name area and at least one data set area; the field name area comprises at least one title field; the data set region includes at least one data unit;

the parsing unit is specifically configured to, regarding each to-be-operated form in the to-be-operated file, determine a field name area in the to-be-operated form and perform parsing operation on the determined field name area, and determine a data set area in the to-be-operated form and perform parsing operation on the determined data set area.

The generating unit is specifically configured to:

regarding each title column in the file to be operated, merging and/or deleting redundant data of the title content in the title column based on the analysis result of the file to be operated and the title content in the title column;

regarding each data unit in the file to be operated, merging and/or deleting redundant data of the data content in the data unit based on the analysis result of the file to be operated and the data content in the data unit;

and generating a target table in a preset form based on the operation result.

In a third aspect, an electronic device is provided, which includes:

one or more processors;

a memory;

one or more application programs, wherein the one or more application programs are stored in the memory and configured to be executed by the one or more processors, the one or more programs configured to: the above method of generating a table is performed.

In a fourth aspect, a computer-readable storage medium is provided, which when executed by a processor implements the above-described method of generating a table.

The beneficial effect that technical scheme that this application provided brought is:

according to the technical scheme, data analysis can be performed on a plurality of files to be operated, wherein each file to be operated comprises a plurality of tables, each table comprises a plurality of pages, each page comprises a large amount of data, and each file to be operated comprises a huge amount of data. Under the condition of such huge data volume, through the technical scheme provided by the application, a target table in a preset form can be generated through analyzing the corresponding relation between the title bar and the data cells of each file to be operated, the position relation between the cells in each title bar and the position relation between the cells in each data cell, and the preset form of the target table can be set according to actual needs. Therefore, the technical scheme provided by the application can completely process the tables containing huge data quantity, and generate the target table according to the data in the tables in the preset form, the process does not need any manual operation, meanwhile, the working efficiency and the accuracy of the table processing can be improved, and meanwhile, the row-crossing and column-crossing conditions can be processed according to the position relationship among the cells in each title bar and the position relationship among the cells in each data cell.

Drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings used in the description of the embodiments of the present application will be briefly described below.

FIG. 1 is a diagram illustrating the structure of an original table according to an embodiment of the present application;

fig. 2 is a schematic flowchart of a method for generating a table according to an embodiment of the present application;

FIG. 3 is a diagram illustrating the structure of a target table according to an embodiment of the present application;

fig. 4 is a schematic structural diagram of an apparatus for generating a table according to an embodiment of the present application;

fig. 5 is a schematic structural diagram of an electronic device according to an embodiment of the present application.

Detailed Description

Reference will now be made in detail to embodiments of the present application, examples of which are illustrated in the accompanying drawings, wherein like reference numerals refer to the same or similar elements or elements having the same or similar function throughout. The embodiments described below with reference to the drawings are exemplary only for the purpose of explaining the present application and are not to be construed as limiting the present invention.

As used herein, the singular forms "a", "an", "the" and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise. It will be further understood that the terms "comprises" and/or "comprising," when used in this specification, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof. It will be understood that when an element is referred to as being "connected" or "coupled" to another element, it can be directly connected or coupled to the other element or intervening elements may also be present. Further, "connected" or "coupled" as used herein may include wirelessly connected or wirelessly coupled. As used herein, the term "and/or" includes all or any element and all combinations of one or more of the associated listed items.

To make the objects, technical solutions and advantages of the present application more clear, embodiments of the present application will be described in further detail below with reference to the accompanying drawings.

The present application provides a method, an apparatus, an electronic device and a computer-readable storage medium for generating a table, which are intended to solve the above technical problems of the prior art.

For convenience of subsequent introduction, the names appearing in the present document are explained here accordingly:

the technical scheme provided by the application can be used for operating a plurality of files to be operated, each file to be operated can comprise a plurality of tables to be operated, each table to be operated can comprise a plurality of pages to be operated, and the pages to be operated are also presented in a table form, such as the relationship between the table in the Excel file and the page of 'sheet';

as shown in fig. 1, each table to be operated includes at least one field name area 11, at least one data set area 12; wherein the field name area 11 includes at least one title field; the data set region 12 includes at least one data unit; the title content in the title bar is used for indicating the category to which the data content in the data unit corresponding to the title bar belongs;

the following describes the technical solution of the present application and how to solve the above technical problems with specific embodiments. The following several specific embodiments may be combined with each other, and details of the same or similar concepts or processes may not be repeated in some embodiments. Embodiments of the present application will be described below with reference to the accompanying drawings.

An embodiment of the present application provides a method for generating a table, and as shown in fig. 2, the method includes:

step S21, acquiring at least one file to be operated;

according to the technical scheme, a plurality of files to be operated can be operated at the same time; each file to be operated can also comprise a plurality of tables, and each table can also comprise a plurality of pages, for example, a "sheet" page in an excel table; namely, the file to be operated consists of at least one table;

step S22, for each file to be operated, analyzing the file to be operated to obtain an analysis result;

in this step, the table to be operated includes a field name area and a data set area, each field name area includes a plurality of title fields, and each data set area includes a plurality of data units. Analyzing results of the file to be operated after analyzing the file to be operated comprise corresponding relations between all title columns and all data units of a table in the file to be operated, position relations between all cells in all title columns and position relations between all cells in all data units;

the title content in the title bar is used for indicating the category to which the data content in the data unit corresponding to the title bar belongs; for example, in fig. 1, the title content in the title bar is "unit number", and the data content included in the data unit corresponding to the title bar is "284, 5, 2, 166, 109", and it can be seen that the group of data belongs to the category of "unit number".

Step S23, generating a target table in a preset form based on the parsing result of each file to be operated, the title content in each title bar and the data content in each data cell.

Specifically, before step S21, the method further includes: classifying all the files to be operated through crawling operation; because a plurality of files to be operated can be operated at the same time, the files to be operated need to be classified, so that the files to be operated with the same table structure are taken as one class, and the acquisition of data in the subsequent operation can be facilitated; at this time, the specific operation of obtaining at least one file to be operated in step S21 is:

and acquiring at least one file to be operated belonging to the same category.

Specifically, the parsing operation performed on the file to be operated in step S22 includes:

and regarding each table to be operated in the file to be operated, determining a field name area in the table to be operated, analyzing the determined field name area, determining a data set area in the table to be operated, and analyzing the determined data set area.

Specifically, the specific implementation manner of generating the target table in the preset form based on the analysis result of each file to be operated, the title content in each title column and the data content in each data unit includes:

regarding each title column in the file to be operated, merging and/or deleting redundant data of the title content in the title column based on the analysis result of the file to be operated and the title content in the title column;

for example, in fig. 1, the first title bar includes a plurality of cells, and the title content is "index item", at this time, the redundant title content "item" may be deleted, and finally, the title content left in the title bar is "index", which may serve to operate the title bar across rows and columns;

regarding each data unit in the file to be operated, merging and/or deleting redundant data of the data content in the data unit based on the analysis result of the file to be operated and the data content in the data unit; for example, the data unit corresponding to the title column "pointer item" including a plurality of unit names and an english interpretation of each unit name may delete redundant english interpretations, leaving only the unit name in chinese, and this process may serve the purpose of operating on data units across rows and columns.

Therefore, the analysis process provided by the embodiment of the application can completely operate the column name area and the data set area containing the cross-row and cross-column, and overcomes the defect that only the column name area and the data set area of a single row and a single column can be operated in the prior art.

Therefore, the technical scheme provided by the application can be used for carrying out data analysis on a plurality of files to be operated, wherein each file to be operated comprises a plurality of tables, each table comprises a plurality of pages, each page comprises a large amount of data, and each file to be operated comprises a huge amount of data. Under the condition of such huge data volume, through the technical scheme provided by the application, a target table in a preset form is generated after the corresponding relation between the title bar and the data cells of each file to be operated, the position relation between each cell in each title bar and the position relation between each cell in each data cell are analyzed, and the preset form of the target table can be set according to actual needs. Therefore, the technical scheme provided by the application can completely process the tables containing huge data quantity, and generate the target table according to the data in the tables in the preset form, the process does not need any manual operation, and meanwhile, the working efficiency and the accuracy of the table processing can be improved.

For the above method for generating a table, a specific implementation is provided in the embodiment of the present application, and the method can be applied to a large number of files to be operated with different structures, and the specific process is as follows:

step A, classifying all files to be operated through crawling operation;

in practical application, the files to be operated which belong to the same urban area have the table structure with the same format, so that the files to be operated which belong to the same urban area can be classified according to the source region of the files to be operated, and classified into one class; the table structures of the files to be operated belonging to the same category are the same, for example, the number and the positions of the field name areas and the number and the positions of the data set areas are the same; and the corresponding relationship between each title bar and each data unit, and the positional relationship between each cell in each title bar and the positional relationship between each cell in each data unit are the same, refer to fig. 1, for example, the table includes a field name area 11; the field name area 11 includes a plurality of title bars, and the position relationship among the title bars is arranged in sequence, such as the arrangement sequence of "index item", "unit number", "staff number" and "number of beds"; the position relationship among the data units is shown in fig. 1, the corresponding relationship between the title bar and the data units is shown in fig. 1, and both the field name area 11 and the data set area can be arranged across rows and columns, for example, the field name area 11 shown in fig. 1 includes 3 rows, and the title bar with the title content of "pointer item" further includes a plurality of unit cells.

In the table shown in fig. 1, the field name area 11 is determined by a range surrounded by the first frame 13 and the second frame 14, and the start column identifier (where the start column of the table is located) and the end column identifier (where the end column of the table is located) of the table; in the field name area 11, 4 title bars are included, each title bar having a right border 16 (identified only in the 4 th title bar "number of bed" as an end mark of the title bar); the data set area 12 is determined by the range enclosed by the second border 14 and the third border 15, and the start column (where the start column of the table is located) and the end column identification (where the end column of the table is located) of the table; four data units are included in the data set area, each data unit is composed of a plurality of cells, and the data content in each data unit corresponds to the title bar one by one, for example, the data unit corresponding to the title bar of "staff number" includes data contents of "5371, 338, 134, 381, 3901 and 617"; the end marker for each data unit is represented by the right border (identified only in the 4 th title bar "number of bed bits");

b, acquiring at least one file to be operated belonging to the same category;

step C, performing the following analysis operation on each acquired file to be operated, and obtaining an analysis result; the method comprises the following steps:

step C01, determining the position of the column name area in the table according to the first frame 13, the second frame 14, the start column identifier and the end column identifier; namely, determining a field name area from the table;

step C02, according to the right frame contained in the column name area, determining that the table comprises four title columns, namely 'index item', 'unit number', 'employee number' and 'bed number'; the title column is analyzed from the column name area;

step C03, when it is determined that the title bar includes multiple cells, i.e. contains multiple rows and multiple columns, the title content in the title bar is merged and/or redundant data is deleted; the rule for merging and/or deleting redundant data can be set artificially according to actual conditions, for example, English in the title column "index item" can be deleted, and unnecessary spaces, symbols and other contents can also be deleted;

step C04, determining the position of the data set region in the table according to the second frame 14, the third frame 15, the start column identifier and the end column identifier; namely, determining a data set area from the table;

step C05, according to the right frame contained in the data set area, four data units contained in the table are determined, and each data unit corresponds to a title bar; each data unit comprises a plurality of data units; namely, the data unit is analyzed from the data set region;

when the data unit is determined to include multiple cells, that is, the data unit spans across rows and columns, the data content in the data unit is merged and/or redundant data is deleted, step C06. The rules for merging and/or deleting redundant data can be set artificially according to actual conditions, for example, English, unnecessary spaces, symbols and other contents are deleted;

each title bar and the data unit corresponding to the title bar can be analyzed through the step C;

therefore, the method provided by the step C can determine whether the title bar is across rows and columns according to the position relation among the cells in the title bar; or determining whether the data unit crosses rows and columns according to the position relationship among the cells in the data unit; therefore, the method can operate on the title bars and the data units which are across rows and columns;

step D, generating a target table in a preset form based on the analysis result of each file to be operated, the title content in each title column and the data content in each data unit;

in this step, the preset form of the target table may be set according to actual needs, that is, the title bar and the corresponding data thereof are placed in a classified manner according to the format required by the target table, as shown in fig. 3, and fig. 3 is the target table obtained after the table of fig. 1 is analyzed.

Therefore, the target table can be generated by analyzing the field name area, the data set area, the title bar and the data unit in the table. Meanwhile, the method can finish the analysis and generation processes of the table without any manual intervention.

Specifically, the order of the parsing column name region and the parsing data set region involved in the step C may be adjusted according to actual conditions;

for example, different colors are set for the field name area and the data set area when the form is made, the field name area or the data set area can be directly distinguished according to the color attribute in the resolving process, and then the field name area or the data set area is resolved according to the method.

An embodiment of the present application provides an apparatus for generating a table, as shown in fig. 4, the apparatus includes:

an obtaining unit 41, configured to obtain at least one file to be operated;

the analysis unit 42 is configured to perform analysis operation on each file to be operated to obtain an analysis result, where the analysis result includes a correspondence between each title bar and each data unit in the file to be operated, a position relationship between each cell in each title bar, and a position relationship between each cell in each data unit, and a title content in each title bar is used to indicate a category to which a data content in a data unit corresponding to the title bar belongs;

and the generating unit 43 is configured to generate a target table in a preset form based on the parsing result of each file to be operated, the title content in each title column, and the data content in each data unit.

The device also includes:

the crawling unit 44 is used for classifying all the files to be operated through crawling operation;

the obtaining unit 41 is specifically configured to obtain at least one file to be operated that belongs to the same category.

The file to be operated comprises at least one table to be operated; the table information of the table to be operated comprises at least one field name area and at least one data set area; the field name area comprises at least one title field; the data set region includes at least one data unit;

the parsing unit 42 is specifically configured to, regarding each table to be operated in the file to be operated, determine a field name area in the table to be operated and perform a parsing operation on the determined field name area, and determine a data set area in the table to be operated and perform a parsing operation on the determined data set area.

The generating unit 42 is specifically configured to:

regarding each title column in the file to be operated, merging and/or deleting redundant data of the title content in the title column based on the analysis result of the file to be operated and the title content in the title column;

regarding each data unit in the file to be operated, merging and/or deleting redundant data of the data content in the data unit based on the analysis result of the file to be operated and the data content in the data unit;

and generating a target table in a preset form based on the operation result.

According to the technical scheme, data analysis can be performed on a plurality of files to be operated, wherein each file to be operated comprises a plurality of tables, each table comprises a plurality of pages, each page comprises a large amount of data, and each file to be operated comprises a huge amount of data. Under the condition of such huge data volume, through the technical scheme provided by the application, a target table in a preset form is generated after the corresponding relation between the title bar and the data cells of each file to be operated, the position relation between the cells in each title bar and the position relation between the cells in each data cell are analyzed, and the preset form of the target table can be set according to actual needs. Therefore, the technical scheme provided by the application can completely process the tables containing huge data quantity, and generate the target table according to the data in the tables in the preset form, the process does not need any manual operation, meanwhile, the working efficiency and the accuracy of the table processing can be improved, and meanwhile, the processing of the condition of crossing rows and columns can be carried out according to the position relationship among the title columns and the position relationship among the data units.

An embodiment of the present application provides an electronic device, including: a memory and a processor; at least one program stored in the memory and used by the processor to implement the method for generating a table according to the above-described embodiments, compared to the prior art.

In an alternative embodiment, an electronic device is provided, as shown in fig. 5, the electronic device 4000 shown in fig. 5 comprising: a processor 4001 and a memory 4003. Processor 4001 is coupled to memory 4003, such as via bus 4002. Optionally, the electronic device 4000 may also include a transceiver 4004. In addition, the transceiver 4004 is not limited to one in practical applications, and the structure of the electronic device 4000 is not limited to the embodiment of the present application.

The Processor 4001 may be a CPU (Central Processing Unit), a general-purpose Processor, a DSP (Digital Signal Processor), an ASIC (Application specific integrated Circuit), an FPGA (Field Programmable Gate Array) or other Programmable logic device, a transistor logic device, a hardware component, or any combination thereof. Which may implement or perform the various illustrative logical blocks, modules, and circuits described in connection with the disclosure herein. The processor 4001 may also be a combination that performs a computational function, including, for example, a combination of one or more microprocessors, a combination of a DSP and a microprocessor, or the like.

Bus 4002 may include a path that carries information between the aforementioned components. The bus 4002 may be a PCI (Peripheral Component Interconnect) bus, an EISA (extended industry Standard Architecture) bus, or the like. The bus 4002 may be divided into an address bus, a data bus, a control bus, and the like. For ease of illustration, only one thick line is shown, but this does not mean that there is only one bus or one type of bus.

The Memory 4003 may be a ROM (Read Only Memory) or other types of static storage devices that can store static information and instructions, a RAM (Random Access Memory) or other types of dynamic storage devices that can store information and instructions, an EEPROM (Electrically erasable programmable Read Only Memory), a CD-ROM (Compact disc Read Only Memory) or other optical disc storage, optical disc storage (including Compact disc, laser disc, optical disc, digital versatile disc, blu-ray disc, etc.), a magnetic disc storage medium or other magnetic storage device, or any other medium that can be used to carry or store desired program codes in the form of instructions or data structures and that can be accessed by a computer, but is not limited to.

The memory 4003 is used for storing application codes for executing the scheme of the present application, and the execution is controlled by the processor 4001. Processor 4001 is configured to execute application code stored in memory 4003 to implement what is shown in the foregoing method embodiments.

Among them, electronic devices include but are not limited to: computers, notebooks, servers, etc. may operate any terminal of the system.

The present application provides a computer-readable storage medium, which stores a computer program, and when the computer program runs on a computer, the computer can execute the corresponding content in the foregoing method embodiments. Compared with the prior art, the table generation method can be realized.

It should be understood that, although the steps in the flowcharts of the figures are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and may be performed in other orders unless explicitly stated herein. Moreover, at least a portion of the steps in the flow chart of the figures may include multiple sub-steps or multiple stages that are not necessarily performed at the same time, but may be performed at different times, in different orders, and may be performed alternately or in turns with other steps or at least a portion of the sub-steps or stages of other steps.

The foregoing is only a partial embodiment of the present invention, and it should be noted that, for those skilled in the art, various modifications and decorations can be made without departing from the principle of the present invention, and these modifications and decorations should also be regarded as the protection scope of the present invention.

15页详细技术资料下载
上一篇:一种医用注射器针头装配设备
下一篇:一种评价模板的生成方法及终端

网友询问留言

已有0条留言

还没有人留言评论。精彩留言会获得点赞!

精彩留言,会给你点赞!