Method for importing Excel data into database
An excel and database technology, applied in the field of importing Excel data into the database, can solve problems such as high data and time costs, manual input errors, and insufficient functions, and achieve the effects of perfecting functions, increasing economic value, and expanding the scope of use
Pending Publication Date: 2020-09-01
北京航天云路有限公司
View PDF7 Cites 2 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0003] In the existing technology, the possibility of manually importing data and high time costs and manual entry errors often occurs, the functions are not perfect, the use is inconvenient, and the economic value is low
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0023] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. All other embodiments obtained by persons of ordinary skill in the art based on the embodiments of the present invention belong to the protection scope of the present invention.
[0024] Such as figure 1 As shown, a method for importing Excel data to a database according to an embodiment of the present invention includes the following steps:
[0025] S1: Identify the uploaded Excel file, wherein the format of the file is .xls or .xlsx;
[0026] S2: Obtain the configuration information of the table through the table index;
[0027] S3: Obtain the sheet configuration information from the table configuration information, where sheet is a worksheet in the Excel file, and...
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
Login to View More Abstract
The invention discloses a method for importing Excel data into a database. The method comprises the following steps: identifying an uploaded Excel file; obtaining table configuration information through table indexes; obtaining sheet configuration information from the table configuration information; judging the type of the shell configuration table, and reading data; and importing the obtained List data set into a database table according to a table name and a field name configured in the database. By means of the method, the application range is expanded, and numerical verification, numerical calculation and the like are completed at the same time; various Excel data are imported into a database in real time according to front-end requirements, so that the loss of human resources and time cost caused by manual data import is solved, the possibility of manual input errors is reduced, the functions are perfected, the use is convenient, and the economic value is improved.
Description
technical field [0001] The invention relates to the field of computer technology, in particular to a method for realizing the import of Excel data into a database. Background technique [0002] Microsoft Excel is a spreadsheet software written by Microsoft for computers using Windows and Apple Macintosh operating systems. It is the most popular personal computer data processing software. There are many methods for importing data from Excel to the database, but these methods are limited in scope. For different types of Excel files (.xls or .xlxs), Excel tables of different shapes (horizontal or vertical tables, etc.), In the face of different data format requirements of the database, different methods should be used. [0003] In the prior art, manual input of data and the possibility of high time cost and manual input errors often occur, the functions are not perfect, the use is inconvenient, and the economic value is low. Contents of the invention [0004] Aiming at the ...
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
Login to View More Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/22G06F16/25G06F40/177
CPCG06F40/177G06F16/2228G06F16/258
Inventor 黄非高淑敏罗洪涛谢水庚姜桥魏伟
Owner 北京航天云路有限公司