Supercharge Your Innovation With Domain-Expert AI Agents!

Excel data entry component, entry method and device

An excel and data technology, applied in the computer field, can solve the problems of complicated development work and low work efficiency, and achieve the effect of easy data import, easy data import, easy entry and verification

Active Publication Date: 2020-07-14
北京中亦安图科技股份有限公司
View PDF3 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, when entering different database table data, since each table field has different data verification rules, it will lead to complicated development work and low work efficiency

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
  • Excel data entry component, entry method and device
  • Excel data entry component, entry method and device
  • Excel data entry component, entry method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0042] The specific embodiments of the present invention will be further described below in conjunction with the accompanying drawings. The following examples are only used to illustrate the technical solution of the present invention more clearly, but not to limit the protection scope of the present invention.

[0043] In the current data age, especially in data centers, huge amounts of data are accumulated to support various business functions. Behind such a huge amount of data, the function of data entry cannot be avoided. Data entry is simply explained as entering the desired data into the background database table. The data entry of each table has its own differences, such as different tables, and each field in the table has its own different validation rules. Because of these differences, it is necessary to The corresponding data entry code is written for the table, which will inevitably lead to a reduction in development efficiency, and at the same time make the data e...

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 embodiment of the invention discloses an Excel data entry component, an entry method and an entry device. The method comprises a verification rule base, a data template table, a rule template table, a data verification module and a data entry module, the data template table is used for a user to input field information contained in the target Excel file into the data template table; the rule template table is used for a user to configure a corresponding verification rule for the fields entered in the data template table in the rule template table; the data verification module is used for verifying the field information entered in the data template table by utilizing a verification rule in the rule template table; and the data entry module is used for entering the field information entered in the data template table into the database when the verification result is that the field information passes the verification. In the embodiment of the invention, data import can be realized only by configuring the data template table and the rule template table, so that the data import work becomes easier, more flexible and quicker.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to an Excel data entry component, entry method and device. Background technique [0002] In the current data age, especially in data centers, huge amounts of data are accumulated to support various business functions. Behind such a huge amount of data, the function of data entry cannot be avoided. Data entry is simply explained as entering the desired data into the background database table. The data entry of each table has its own differences, such as different tables, and each field in the table has its own different validation rules. Because of these differences, it is necessary to Write the corresponding data entry code for the table. [0003] However, when entering different database table data, because each table field has different data verification rules, it will lead to complicated development work and low work efficiency. Contents of the invention [0004] Due to th...

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): G06F40/18G06F40/186
CPCY02D10/00
Inventor 欧阳杰星
Owner 北京中亦安图科技股份有限公司
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More