CN113051321B - Data importing method, device, equipment and storage medium - Google Patents
Data importing method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN113051321B CN113051321B CN201911368708.1A CN201911368708A CN113051321B CN 113051321 B CN113051321 B CN 113051321B CN 201911368708 A CN201911368708 A CN 201911368708A CN 113051321 B CN113051321 B CN 113051321B
- Authority
- CN
- China
- Prior art keywords
- data
- custom
- title
- importing
- splicing
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 27
- 230000008676 import Effects 0.000 claims description 9
- 238000012545 processing Methods 0.000 claims description 7
- 238000004590 computer program Methods 0.000 claims description 6
- 238000010586 diagram Methods 0.000 description 4
- 238000009825 accumulation Methods 0.000 description 2
- 230000006978 adaptation Effects 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 238000012552 review Methods 0.000 description 2
- 238000013473 artificial intelligence Methods 0.000 description 1
- 230000006399 behavior Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
Classifications
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention provides a data importing method, device, equipment and storage medium, relates to the technical field of computers, and aims to improve the use experience of a user without restricting content when Excel data is imported. The method is used for importing table data and comprises the following steps: acquiring a table file to be imported into a database; analyzing the table file, and acquiring the positions of effective titles, custom titles, title structures and data rows in the table file based on the analysis result; the custom titles are column names in a table, the title structures are used for representing hierarchical relations among the custom titles, and the effective titles refer to custom titles of the last hierarchy in the custom titles containing the hierarchical relations; based on the effective title, the custom title, the title structure and the position of the data line, re-splicing according to a preset sequence to generate a data table; and importing the data table generated by re-splicing into a database.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a data importing method, device, apparatus, and storage medium.
Background
Excel is a powerful, easy to operate spreadsheet system with artificial intelligence features. Excel has powerful data processing function, a large number of functions and various analysis tools, and can effectively help financial staff to perform effective work.
Most of the existing systems support Excel data import, and the use of the system for processing Excel is common, but the content needs to be restrained, titles and data are corresponding, and the background is processed according to fixed logic.
In summary, in the prior art, when Excel data is imported, the content needs to be constrained, so that inconvenience exists in use, and the use experience of software is affected.
Disclosure of Invention
The embodiment of the invention provides a data importing method, device, equipment and storage medium, which are used for improving the use experience of a user without restricting content when Excel data is imported.
In a first aspect, an embodiment of the present invention provides a data importing method, configured to import table data, including:
Acquiring a table file to be imported into a database;
Analyzing the table file, and acquiring the positions of effective titles, custom titles, title structures and data rows in the table file based on the analysis result; the custom titles are column names in a table, the title structures are used for representing hierarchical relations among the custom titles, and the effective titles refer to custom titles of the last hierarchy in the custom titles containing the hierarchical relations;
based on the effective title, the custom title, the title structure and the position of the data line, re-splicing according to a preset sequence to generate a data table;
and importing the data table generated by re-splicing into a database.
According to the data importing method provided by the embodiment of the invention, an Excel table file to be imported is firstly obtained, then the Excel table file is analyzed, the positions of an effective title, a custom title, a title structure and a data row in the Excel table file are obtained based on the analysis result, wherein the custom title is a column name in the Excel table, the title structure is used for representing the hierarchical relationship among the custom titles, the effective title is the custom title of the last hierarchy in the custom titles containing the hierarchical relationship, the data table is generated by re-splicing based on the positions of the effective title, the custom title, the title structure and the data row according to a preset sequence, and finally the data table generated by re-splicing is imported. Compared with the prior art, when data is imported, the content is not required to be restrained, a large amount of communication cost is saved, and the use experience of a user is greatly improved.
In one possible implementation, importing a data table generated by re-splicing includes:
displaying a data table generated by re-splicing and an editing key for editing the data table generated by re-splicing to a user, wherein the data table generated by re-splicing comprises a corresponding relation between a custom title and column names in a database;
editing the data form generated by the re-splicing based on the selection operation of the editing keys by the user;
And when the user is determined to finish editing the data table generated by the re-splicing, importing the data table edited by the user into a database.
In one possible implementation, the custom header and header structure in the parsing result are represented in the form of a recursive array.
In one possible implementation, the column merge cells are assigned only once when they are assigned in the recursive array when it is determined that the column merge cells are included in the active header.
In a second aspect, an embodiment of the present invention provides a data importing apparatus, configured to import table data, including:
the acquisition unit is used for acquiring the form file to be imported into the database;
The analysis unit is used for analyzing the table file and acquiring the effective title, the custom title, the title structure and the position of the data line in the table file based on the analysis result; the custom titles are column names in a table, the title structures are used for representing hierarchical relations among the custom titles, and the effective titles refer to custom titles of the last hierarchy in the custom titles containing the hierarchical relations;
the processing unit is used for generating a data table by re-splicing according to a preset sequence based on the effective title, the custom title, the title structure and the position of the data line;
and the importing unit is used for importing the data table generated by the re-splicing into the database.
In one possible embodiment, the importing unit is specifically configured to:
displaying a data table generated by re-splicing and an editing key for editing the data table generated by re-splicing to a user, wherein the data table generated by re-splicing comprises a corresponding relation between a custom title and column names in a database;
editing the data form generated by the re-splicing based on the selection operation of the editing keys by the user;
And when the user is determined to finish editing the data table generated by the re-splicing, importing the data table edited by the user into a database.
In a possible embodiment, the parsing unit is further configured to:
the custom header and header structure in the parsing result are expressed in the form of a recursive array.
In a possible embodiment, the parsing unit is further configured to:
when it is determined that a column merge cell is included in the active header, the column merge cell is assigned only once when assigned in the recursive array.
In a third aspect, an embodiment of the present invention further provides a data importing apparatus, including: at least one processor, at least one memory and computer program instructions stored in the memory, which when executed by the processor implement a data import method as provided by the first aspect of the embodiments of the present invention.
In a fourth aspect, embodiments of the present invention also provide a computer-readable storage medium having stored thereon computer program instructions which, when executed by a processor of a data importing apparatus, enable the data importing apparatus to implement a data importing method as provided in the first aspect of the embodiments of the present invention.
Drawings
The above, as well as additional purposes, features, and advantages of exemplary embodiments of the present invention will become readily apparent from the following detailed description when read in conjunction with the accompanying drawings. Several embodiments of the present invention are illustrated by way of example, and not by way of limitation, in the figures of the accompanying drawings and in which:
FIG. 1 is a schematic flow chart of a data importing method according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of a table file according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of another table file according to an embodiment of the present invention;
FIG. 4 is a schematic flow chart of another data importing method according to an embodiment of the present invention;
fig. 5 is a schematic structural diagram of a data importing apparatus according to an embodiment of the present invention;
fig. 6 is a schematic structural diagram of a data importing apparatus according to an embodiment of the present invention.
Detailed Description
The embodiments of the present invention will be described below with reference to the accompanying drawings, and it should be understood that the embodiments described herein are for illustration and explanation of the present invention only, and are not intended to limit the present invention.
In view of the fact that in the prior art, when Excel data is imported, the content needs to be restrained, inconvenience exists in use, and the use experience of software is affected, the embodiment of the invention provides a data importing scheme, so that when Excel data is imported, the content does not need to be restrained, and the use experience of a user is improved.
The following describes the scheme provided by the embodiment of the invention in detail with reference to the accompanying drawings.
As shown in fig. 1, an embodiment of the present invention provides a data importing method, which is used for importing table data, and may include the following steps:
step 101, a table file to be imported into a database is acquired.
Step 102, analyzing the table file, and acquiring the effective title, the custom title, the title structure and the position of the data line in the table file based on the analysis result; the custom titles are column names in a table, the title structures are used for representing hierarchical relations among the custom titles, and the effective titles refer to custom titles of the last hierarchy in the custom titles containing the hierarchical relations.
In one possible implementation, the custom header and header structure in the parsing result are represented in the form of a recursive array.
It should be noted that, in the specific implementation, it is necessary to implement a table file with a behavior title, and since the tree data structure can further store the relationship of the parent and child titles on the basis of the storage value, after parsing the table file, the custom title can be stored by using the data structure of the tree. However, since page display optimization, storing with a tree structure is not well suited, it is more feasible to store custom titles in a recursive array storage format.
In one possible implementation, the column merge cells are assigned only once when they are assigned in the recursive array when it is determined that the column merge cells are included in the active header.
In particular, the repeated columns in the effective title are determined to include the repeated columns, and the repeated columns are prompted to a user for subsequent de-duplication processing of the repeated columns in the data. However, if the valid header contains a column merge cell, it is specially processed, i.e., only once assigned when assigned in the recursive array, and no deduplication is performed.
And 103, based on the effective title, the custom title, the title structure and the positions of the data lines, re-splicing according to a preset sequence to generate a data table.
And step 104, importing the data table generated by the re-splicing into a database.
In one possible implementation, importing a data table generated by re-splicing includes:
displaying a data table generated by re-splicing and an editing key for editing the data table generated by re-splicing to a user, wherein the data table generated by re-splicing comprises a corresponding relation between a custom title and column names in a database;
editing the data form generated by the re-splicing based on the selection operation of the editing keys by the user;
And when the user is determined to finish editing the data table generated by the re-splicing, importing the data table edited by the user into a database.
When the method is implemented, after traversing all data in the table file, displaying a data table generated by re-splicing and an editing key for editing the data table generated by re-splicing to a user, wherein the regenerated data table comprises a corresponding relation between a custom title and a column name in a database, the user reviews the table file again, and can trigger the editing key to delete unnecessary data, and editing the data table generated by re-splicing based on the selection operation of the editing key by the user; when the user is determined to finish editing the data table generated by the re-splicing, importing the data table edited by the user into a database, wherein the data table comprises a custom title, a title structure and corresponding data.
As shown in fig. 2, the content in the table in fig. 2 is spliced again to generate the data table shown in fig. 3 and is imported into the database by the data importing method provided by the embodiment of the present invention, and the specific flow of the data importing method provided by the embodiment of the present invention is described in detail with reference to fig. 2 and 3.
As shown in fig. 4, in step 401, a table file to be imported into a database is acquired.
Step 402, analyzing the table file, and acquiring the effective title, the custom title, the title structure and the position of the data line in the table file based on the analysis result.
The custom titles are column names in the table, such as serial numbers, employee names, certificate types and the like; the title structure is used for representing the hierarchical relation between the custom titles, and three titles of income, deduction and tax are additionally arranged under the condition of initial accumulation; the effective titles refer to the last-level custom titles in the custom titles containing the hierarchical relationship, in fig. 2, the titles in columns a-G have only one layer, then the custom title in each column is the effective title, the three columns H-J contain two layers of titles, and then the last layer is the income, deduction and tax is the effective title.
It should be noted that, as shown in fig. 2, in the H-J column of the self-calibration title, the parent-child titles such as the initial accumulation and income, deduction, and tax are included, so the custom titles are stored in the form of a recursive array to preserve the hierarchical structure between the titles.
In the specific implementation, the parsing of the table file further includes obtaining the positions of the data lines in the table file, firstly presetting a distinguishing threshold, then traversing the table content line by line, determining a certain line as a data line when the data in the certain line is traversed to be greater than or equal to the distinguishing threshold, and finally returning the subscript of the data line, and taking the line as the boundary between the data line and the title.
In fig. 2, the distinguishing threshold may be preset to be 3, when the first and second lines of content are traversed, the digital content is not traversed, when the third line of content is traversed, the numbers in the cells "1", "120106199408294000", "6000", "12" and "30" are all identified, and then the number of the cells containing the digital content in the line is 5 and is greater than the distinguishing threshold 3, so the third line is determined as the boundary between the data line and the title, i.e. the first and second lines of title content, and the data content starts from the third line.
It should be noted that, the data in the table file is traversed until the last line of traversal is completed, which is regarded as the completion of table content parsing. The method comprises the steps of determining that a repeated column exists in an effective title, and prompting the repeated column to a user for carrying out repeated processing on the repeated column in data. However, if the valid header contains a column merge cell, it is specially processed, i.e., only once assigned when assigned in the recursive array, and no deduplication is performed.
In fig. 2, the valid header contains a merging cell because the document number is merged with the E column in too long a D column. When traversing the data lines of columns D and E, the certificate number only needs to be assigned once in the recursion array.
And step 403, after the analysis of the table contents is completed, displaying the data table generated by re-splicing and an editing key for editing the data table generated by re-splicing to a user, wherein the data table generated by re-splicing comprises the corresponding relation between the custom title and the column names in the database, and editing the data table generated by re-splicing based on the selection operation of the editing key by the user.
In practice, after the table contents are parsed, the user can review the table contents again and delete unnecessary data.
Step 404, importing the data table generated by re-splicing into a database and storing.
In specific implementation, the user checks the data in the table, and after confirming that the content in the table is not redundant or missing, the data table generated by re-splicing is imported into the database, and the table file shown in fig. 3 is generated and stored. As shown in fig. 3, the table file generated by the data importing method provided by the embodiment of the present invention imports the data content in fig. 2 accurately, and is not affected by repeated columns and multi-level title structures, so that the title and the data are automatically parsed without discussing constraint conditions with the user, a large amount of communication cost is saved, and the use experience of the user is improved.
In a possible implementation manner, as shown in fig. 5, an embodiment of the present invention further provides a data importing apparatus, configured to import table data, including:
an obtaining unit 51, configured to obtain a table file to be imported into a database;
the parsing unit 52 is configured to parse the table file, and obtain the valid title, the custom title, the title structure, and the position of the data line in the table file based on the parsing result; the custom titles are column names in a table, the title structures are used for representing hierarchical relations among the custom titles, and the effective titles refer to custom titles of the last hierarchy in the custom titles containing the hierarchical relations;
a processing unit 53, configured to re-splice the data table according to a preset sequence based on the effective title, the custom title, the title structure, and the position of the data line;
An importing unit 54, configured to import the data table generated by the re-splicing into a database.
In one possible implementation, the importing unit 54 is specifically configured to:
displaying a data table generated by re-splicing and an editing key for editing the data table generated by re-splicing to a user, wherein the data table generated by re-splicing comprises a corresponding relation between a custom title and column names in a database;
editing the data form generated by the re-splicing based on the selection operation of the editing keys by the user;
And when the user is determined to finish editing the data table generated by the re-splicing, importing the data table edited by the user into a database.
In a possible embodiment, the parsing unit 52 is further configured to:
the custom header and header structure in the parsing result are expressed in the form of a recursive array.
In a possible embodiment, the parsing unit 52 is further configured to:
when it is determined that a column merge cell is included in the active header, the column merge cell is assigned only once when assigned in the recursive array.
Based on the same inventive concept, the embodiment of the invention also provides a data importing device.
As shown in fig. 6, an embodiment of the present invention further provides a data importing apparatus 60, including: at least one processor 61, at least one memory 62, and computer program instructions stored in the memory, which when executed by the processor 61, implement a data import method as provided by embodiments of the present invention.
In an exemplary embodiment, the present embodiment also provides a computer-readable storage medium having stored thereon computer program instructions that, when executed by the processor 61 of the data importing apparatus, enable the data importing apparatus 60 to implement the data importing method as provided by the present embodiment.
Alternatively, the storage medium may be a non-transitory computer readable storage medium, for example, a ROM, random Access Memory (RAM), CD-ROM, magnetic tape, floppy disk, optical data storage device, and the like.
Other embodiments of the disclosure will be apparent to those skilled in the art from consideration of the specification and practice of the disclosure disclosed herein. This application is intended to cover any adaptations, uses, or adaptations of the disclosure following, in general, the principles of the disclosure and including such departures from the present disclosure as come within known or customary practice within the art to which the disclosure pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the disclosure being indicated by the following claims.
It is to be understood that the present disclosure is not limited to the precise arrangements and instrumentalities shown in the drawings, and that various modifications and changes may be effected without departing from the scope thereof. The scope of the present disclosure is limited only by the appended claims.
Claims (10)
1. A data importing method for importing table data, comprising:
Acquiring a table file to be imported into a database;
Analyzing the table file, and acquiring the positions of effective titles, custom titles, title structures and data rows in the table file based on an analysis result; the custom titles are column names in the table, the title structures are used for representing hierarchical relations among the custom titles, and the effective titles are custom titles of the last hierarchy in the custom titles containing the hierarchical relations; the position of the data line is determined based on the position of any line when any line is traversed and the number of cells containing digital content in any line is determined to be greater than or equal to a distinguishing threshold value, wherein the data line is the data line from any line;
based on the effective title, the custom title, the title structure and the positions of the data lines, re-splicing according to a preset sequence to generate a data table;
and importing the data table generated by the re-splicing into the database.
2. The method of claim 1, wherein importing the data table generated by the re-stitching comprises:
Displaying the data form generated by re-splicing and an editing key for editing the data form generated by re-splicing to a user, wherein the data form generated by re-splicing comprises a corresponding relation between the custom title and column names in a database;
editing the data form generated by re-splicing based on the selection operation of the editing key by the user;
and when the user is determined to finish editing the data table generated by the re-splicing, importing the data table edited by the user into the database.
3. The method of claim 1, wherein the custom header and header structure in the parsing result are represented in the form of a recursive array.
4. A method according to claim 3, characterized in that the method further comprises:
when determining that the valid header includes a column merge cell, the column merge cell is assigned only once when assigned in the recursive array.
5. A data importing apparatus for importing table data, comprising:
the acquisition unit is used for acquiring the form file to be imported into the database;
The analysis unit is used for analyzing the table file and acquiring the positions of the effective title, the custom title, the title structure and the data line in the table file based on the analysis result; the custom titles are column names in the table, the title structures are used for representing hierarchical relations among the custom titles, and the effective titles are custom titles of the last hierarchy in the custom titles containing the hierarchical relations; the position of the data line is determined based on the position of any line when any line is traversed and the number of cells containing digital content in any line is determined to be greater than or equal to a distinguishing threshold value, wherein the data line is the data line from any line;
The processing unit is used for re-splicing and generating a data table according to a preset sequence based on the effective title, the custom title, the title structure and the positions of the data rows;
And the importing unit is used for importing the data table generated by the re-splicing into the database.
6. The apparatus according to claim 5, wherein the importing unit is specifically configured to:
Displaying the data form generated by re-splicing and an editing key for editing the data form generated by re-splicing to a user, wherein the data form generated by re-splicing comprises a corresponding relation between the custom title and column names in a database;
editing the data form generated by re-splicing based on the selection operation of the editing key by the user;
and when the user is determined to finish editing the data table generated by the re-splicing, importing the data table edited by the user into the database.
7. The apparatus of claim 5, wherein the parsing unit is further configured to:
the custom header and header structure in the parsing result are expressed in the form of a recursive array.
8. The apparatus of claim 7, wherein the parsing unit is further configured to:
when determining that the valid header includes a column merge cell, the column merge cell is assigned only once when assigned in the recursive array.
9. A data importing apparatus, comprising: at least one processor, at least one memory and computer program instructions stored in the memory, which when executed by the processor, implement the data import method according to any of claims 1-4.
10. A computer readable storage medium having stored thereon computer program instructions which, when executed by a processor of a data importing apparatus, enable the data importing apparatus to implement the data importing method of any one of claims 1-4.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201911368708.1A CN113051321B (en) | 2019-12-26 | 2019-12-26 | Data importing method, device, equipment and storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201911368708.1A CN113051321B (en) | 2019-12-26 | 2019-12-26 | Data importing method, device, equipment and storage medium |
Publications (2)
Publication Number | Publication Date |
---|---|
CN113051321A CN113051321A (en) | 2021-06-29 |
CN113051321B true CN113051321B (en) | 2024-05-28 |
Family
ID=76505502
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201911368708.1A Active CN113051321B (en) | 2019-12-26 | 2019-12-26 | Data importing method, device, equipment and storage medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN113051321B (en) |
Citations (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101452441A (en) * | 2008-12-05 | 2009-06-10 | 山东浪潮齐鲁软件产业股份有限公司 | Electronic table general-purpose data parsing and leading-in method |
CN103020089A (en) * | 2011-09-27 | 2013-04-03 | 深圳市金蝶友商电子商务服务有限公司 | Method and device for importing data in EXCEL file to database |
CN103793784A (en) * | 2014-01-14 | 2014-05-14 | 广东倍智人才管理咨询有限公司 | Method for leading in organizational structure for position value evaluation system |
US9514205B1 (en) * | 2015-09-04 | 2016-12-06 | Palantir Technologies Inc. | Systems and methods for importing data from electronic data files |
CN106919618A (en) * | 2015-12-28 | 2017-07-04 | 航天信息股份有限公司 | Excel data lead-in methods and system |
CN106933835A (en) * | 2015-12-29 | 2017-07-07 | 航天信息软件技术有限公司 | The data lead-in method and system of a kind of compatibility parsing Excel file |
CN107203525A (en) * | 2016-03-16 | 2017-09-26 | 北大方正集团有限公司 | The treating method and apparatus of database |
CN109492196A (en) * | 2018-09-18 | 2019-03-19 | 西安葡萄城信息技术有限公司 | A kind of system and method that Excel list data extracts |
CN109543154A (en) * | 2018-10-11 | 2019-03-29 | 天津字节跳动科技有限公司 | Method for converting types, device, storage medium and the electronic equipment of list data |
CN109558440A (en) * | 2018-10-18 | 2019-04-02 | 平安科技(深圳)有限公司 | Batch data processing method, device, computer equipment and storage medium |
CN109727644A (en) * | 2018-11-12 | 2019-05-07 | 山东省医学科学院基础医学研究所 | Venn figure production method and system based on microbial genome two generations sequencing data |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US9971801B2 (en) * | 2014-03-26 | 2018-05-15 | Interject Data Systems, Inc. | Grid cell data requests |
-
2019
- 2019-12-26 CN CN201911368708.1A patent/CN113051321B/en active Active
Patent Citations (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101452441A (en) * | 2008-12-05 | 2009-06-10 | 山东浪潮齐鲁软件产业股份有限公司 | Electronic table general-purpose data parsing and leading-in method |
CN103020089A (en) * | 2011-09-27 | 2013-04-03 | 深圳市金蝶友商电子商务服务有限公司 | Method and device for importing data in EXCEL file to database |
CN103793784A (en) * | 2014-01-14 | 2014-05-14 | 广东倍智人才管理咨询有限公司 | Method for leading in organizational structure for position value evaluation system |
US9514205B1 (en) * | 2015-09-04 | 2016-12-06 | Palantir Technologies Inc. | Systems and methods for importing data from electronic data files |
CN106919618A (en) * | 2015-12-28 | 2017-07-04 | 航天信息股份有限公司 | Excel data lead-in methods and system |
CN106933835A (en) * | 2015-12-29 | 2017-07-07 | 航天信息软件技术有限公司 | The data lead-in method and system of a kind of compatibility parsing Excel file |
CN107203525A (en) * | 2016-03-16 | 2017-09-26 | 北大方正集团有限公司 | The treating method and apparatus of database |
CN109492196A (en) * | 2018-09-18 | 2019-03-19 | 西安葡萄城信息技术有限公司 | A kind of system and method that Excel list data extracts |
CN109543154A (en) * | 2018-10-11 | 2019-03-29 | 天津字节跳动科技有限公司 | Method for converting types, device, storage medium and the electronic equipment of list data |
CN109558440A (en) * | 2018-10-18 | 2019-04-02 | 平安科技(深圳)有限公司 | Batch data processing method, device, computer equipment and storage medium |
CN109727644A (en) * | 2018-11-12 | 2019-05-07 | 山东省医学科学院基础医学研究所 | Venn figure production method and system based on microbial genome two generations sequencing data |
Non-Patent Citations (1)
Title |
---|
基于Arcgis Engine实现Excel数据采集与批量入库;王彦飞;;信息技术与信息化;20150315(第03期);264-266 * |
Also Published As
Publication number | Publication date |
---|---|
CN113051321A (en) | 2021-06-29 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20160314161A1 (en) | Multi-Version Concurrency Control Method in Database and Database System | |
CN106156239B (en) | Table extraction method and device | |
KR101013810B1 (en) | An excel-based management system for updating db tables and the method thereof | |
US8874519B1 (en) | Method and apparatus for restoring a table in a database | |
CN112528602B (en) | Method, system and storage medium for analyzing structured content of medical document | |
CN108959587B (en) | Data updating method and device based on column storage, server and storage medium | |
US11567995B2 (en) | Branch threading in graph databases | |
CN105373541A (en) | Processing method and system for data operation request of database | |
Vajk et al. | Automatic NoSQL schema development: A case study | |
CN110543495A (en) | cursor traversal storage method and device | |
KR20150043929A (en) | Method and System for Managing Database, and Tree Structure for Database | |
CN113918663A (en) | Operation method of knowledge graph structure based on naming rule and cache mechanism | |
CN109636303B (en) | Storage method and system for semi-automatically extracting and structuring document information | |
CN112860581B (en) | Execution method, device, equipment and storage medium of test case | |
CN106202008B (en) | A kind of MySQL database structured document generation method and device | |
KR101588375B1 (en) | Method and system for managing database | |
CN113051321B (en) | Data importing method, device, equipment and storage medium | |
US8548980B2 (en) | Accelerating queries based on exact knowledge of specific rows satisfying local conditions | |
US20180144060A1 (en) | Processing deleted edges in graph databases | |
CN111190895B (en) | Organization method, device and storage medium of column-type storage data | |
US10599625B2 (en) | Managing storage of data | |
CN108984720B (en) | Data query method and device based on column storage, server and storage medium | |
CN106649863A (en) | Non-structured data management method and apparatus | |
JP2017010376A (en) | Mart-less verification support system and mart-less verification support method | |
CN108984719B (en) | Data deleting method and device based on column storage, server and storage medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |