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

Method for converting Excel sheet to database table

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

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
  • Method for converting Excel sheet to database table
  • Method for converting Excel sheet to database table
  • Method for converting Excel sheet to database table

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

No 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
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30G06F17/21
CPCG06F16/258G06F40/177
Inventor 牟春林
Owner SUZHOU JINGYIHUI INFORMATION TECH
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