Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

A method and apparatus for importing excel file data into a database

A file data and database technology, applied in the computer field, can solve the problem of wasting manpower and material resources

Inactive Publication Date: 2019-03-08
INSPUR QILU SOFTWARE IND
View PDF4 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, this artificial import method wastes manpower and material resources

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • A method and apparatus for importing excel file data into a database
  • A method and apparatus for importing excel file data into a database
  • A method and apparatus for importing excel file data into a database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0041] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative work belong to the protection of the present invention. scope.

[0042] Such as figure 1 As shown, the embodiment of the present invention provides a method for importing excel file data into a database, which may include the following steps:

[0043] Step 101: determine the excel file to be processed, wherein the excel file includes at least one sheet, and at least one type of table header is recorded in each sheet...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention provides a method and device for importing the excel file data into a database. The invention makes sure that the excel files with several types of headers are recorded in each sheet, the the number of headers of each header is not less than 1, that there are several columns of data recorded under each header, and that the header contents of different headers are different. The stepof determining the mapping relationship includes ensuring that any header pair of the file should have a data table in the database, and each column pair under the header should have a column in the corresponding data table; parsing the file into an xml file and splitting out a plurality of folders based on the file, wherein different folders correspond to different header categories, each foldercomprises a plurality of groups of sub-files, each group of sub-files comprises a plurality of sub-files, each group of sub-files corresponds to different headers, and each group of sub-files recordsall data corresponding to the header and under the header; importing the data from each group of subfiles into the corresponding data table according to the mapping relationship, so that that data canbe imported from excel file to database automatically.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method and a device for importing excel file data into a database. Background technique [0002] As we all know, excel is a common file storage method, and the database storage method is also widely used, so it is inevitable for data processing and data collection to import the data in the excel file into the database. [0003] At present, an excel file can include multiple table headers. When the data under different table headers needs to be imported into different data tables of the database, the staff often needs to manually import them as needed. [0004] However, this artificial import method wastes manpower and material resources. Contents of the invention [0005] The invention provides a method and a device for importing excel file data into a database, which can realize the automatic import of data from the excel file to the database. [0006] In order to achiev...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/25
Inventor 赵金柱
Owner INSPUR QILU SOFTWARE IND
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com