Method for converting Excel sheet to database table
What is Al technical title?
Al technical title is built by PatSnap Al team. It summarizes the technical point description of the patent document.
An excel and database technology, which is applied in the field of converting Excel tables into database tables, can solve problems affecting the use efficiency and achieve the effect of simplifying the use process
Inactive Publication Date: 2014-08-06
SUZHOU JINGYIHUI INFORMATION TECH
View PDF4 Cites 19 Cited by
Summary
Abstract
Description
Claims
Application Information
AI Technical Summary
This helps you quickly interpret patents by identifying the three key elements:
Problems solved by technology
Method used
Benefits of technology
Problems solved by technology
After research, this method still has certain defects: it is highly restrictive. This invention binds the electronic form to a certain relational database, and stores the cell contents of the electronic form in the relational database. However, if the user’s original database may not be It is not the relational database, the original database may need to be configured, or the user needs to reinstall the database, which will affect the efficiency of use
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
Click on the blue label to locate the original text in one second.
Reading with bidirectional positioning of images and text.
Smart Image
Examples
Experimental program
Comparison scheme
Effect test
Embodiment 1
[0018] figure 2 Embodiment one of a method for converting an Excel table into a database table provided by the present invention, this embodiment has the following steps:
[0019] Step 201, designing an Excel table style.
[0020] According to actual needs, users can design Excel table styles in software with Excel functions, including label fields, fonts, cell merging operations, borders, etc.
[0021] Step 202, directly setting the data type of the specific cell field on the design interface, and confirming the corresponding label field.
[0022] After selecting a specific cell, the user can directly set the cell data type in the toolbar and confirm the corresponding label field of the cell.
[0023] In step 203, the converter acquires database connection parameters and database table name information through Excel.
[0024] The converter is a functional module of the software with the corresponding function of Excel, which automatically obtains the parameter information...
Embodiment 2
[0031] image 3 Embodiment two of a method for converting an Excel table into a database table provided by the present invention, this embodiment has the following steps:
[0032] Step 301, designing an Excel table style.
[0033] According to actual needs, users can design Excel table styles in software with Excel functions, including label fields, fonts, cell merging operations, borders, etc.
[0034] Step 302, setting the data type of the specific cell field on the pop-up window interface, and confirming the corresponding label field.
[0035] After the user selects a specific cell, through the design connection, a pop-up window interface will pop up, set the cell data type in the pop-up window, and confirm the corresponding label field.
[0036] In step 303, the converter acquires database connection parameters and database table name information through Excel.
[0037] The converter is placed in the Excel software in the form of a plug-in, and automatically obtains the...
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 converting an Excel sheet to a database table. The method comprises the following steps: a, receiving a data type and a label field of a specific table cell field of user preference by Excel; b, acquiring database connection parameters and database table name information, converting the data type of the table cell of the set data type of the Excel sheet to the data type capable of being recognized by the database, and in the meantime taking the label field as a column name of the database table; c, connecting the database, according to the information in the step b, automatically creating the database table corresponding to the Excel sheet; d, saving the corresponding relation between the database table and the Excel sheet, and the corresponding relation between the database column and the specific table cell of the Excel sheet. The method disclosed by the invention can realize flexibility of design, and realizes that according to the type of the database, the specific table cell data type can be automatically converted to the type capable of being recognized by the database without change or configuration of the database, so that the use flow can be simplified, and the computer knowledge accumulation requirement on a user tends to generalization.
Description
technical field [0001] The invention relates to the field of computer applications, in particular to a method for converting an Excel table into a database table. Background technique [0002] Microsoft Excel is one of Microsoft's office software. It is a spreadsheet software written and run by Microsoft for computers with Windows and Apple Macintosh operating systems. Excel is an important part of Microsoft Office suite software. It can process various data, perform statistical analysis and assist decision-making operations, and is widely used in many fields such as management, statistics, finance, and finance. [0003] The database is a warehouse that organizes, stores and manages data according to the data structure. With the development of information technology, data management is no longer just storing and managing data, but has transformed into various data management methods required by users. The data in the database has the characteristics of integrity and sharing...
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
Application Date:The date an application was filed.
Publication Date:The date a patent or application was officially published.
First Publication Date:The earliest publication date of a patent with the same application number.
Issue Date:Publication date of the patent grant document.
PCT Entry Date:The Entry date of PCT National Phase.
Estimated Expiry Date:The statutory expiry date of a patent right according to the Patent Law, and it is the longest term of protection that the patent right can achieve without the termination of the patent right due to other reasons(Term extension factor has been taken into account ).
Invalid Date:Actual expiry date is based on effective date or publication date of legal transaction data of invalid patent.
Login to view more 
Login to view more