General method for importing Excel data independent of rule configurations
An EXCEL, general method technology, applied in the computer field, can solve problems such as non-reusability, program crash, illegal data, etc.
Inactive Publication Date: 2013-02-27
INSPUR COMMON SOFTWARE
View PDF2 Cites 4 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0002] Enterprise management software that relies on relational data is becoming more and more common. This type of information system software focuses on enterprise business management, data analysis, and decision support, but there is still a gap in the ease of use of data editing compared to Excel.
Whether it is the data preparation stage of the implementation of the management software or the normal business operation stage, there are many users who tend to use Excel to prepare data and then enter it into the management software. This repetitive data entry work is meaningless and annoying. Disgusted, so the demand to import the data in Excel directly into the management software has always been very high, and the management software has strict requirements on the data content, and it is not allowed to receive illegal data, otherwise it will cause the program to crash. The traditional approach It is to develop a special import program for specific functions. It needs to configure the import rule file and develop a data verification program. It is complicated and cannot be reused.
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
[0023] as attached figure 1 Shown, the general method of the import EXCEL data that does not depend on rule configuration of the present invention comprises the following steps:
[0024] 1. Developer software implements general import components:
[0025] A. Define interface functions
[0026] / / Define the interface function
[0027] global function integer f_xls2dw (u_dw p_dw, boolean p_append)
[0028] B. Implement internal logic
[0029] / *1. Get Excel document* /
[0030] GetFileOpenName("Please select an Excel document",FullPathName,FileName,"",filetype)
[0031] / *2. Open the Excel document* /
[0032] Ole_xls.Application.Workbooks.Open(ls_FullPathName)
[0033] / *3. Match the column correspondence between the data-bound control DataWindow and Excel* /
[0034] / / Loop through the columns of the data-bound control DataWindow
[0035] FOR n = 1 TO Datawindow.column.count
[0036] ls_colname = p_dw.Describe("#" + String(n) + ".Name")
[0037] FOR nn ...
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 general method for importing Excel data independent of rule configurations, and belongs to the technical field of computers. The method comprises the following steps of: A, building a general importing module, which essentially realizes the selection of Excel documents needing to be imported, the building of line-line corresponding relation records between the Excel and data binding controls, the filling of the Excel data in the data binding controls and the realization of data verification; and B, needing to import the related functions of the data by using the general importing module built in the step A. Compared with the prior art, the general method for importing the Excel data disclosed by the invention can automatically realize the line matching and corresponding of the Excel contents and the data binding controls of the information system software, can automatically verify the data by the original service rule codes of the data binding controls and can ensure the rationality and the effectiveness of the imported data, although the configuration files are not needed and the service rules do not need to be acquainted. And the general method also has the characteristics of generality, simplicity, intelligence, practicability and the like.
Description
technical field [0001] The invention relates to the field of computer technology, in particular to a general method for importing EXCEL data independent of rule configuration. Background technique [0002] Enterprise management software that relies on relational data is becoming more and more common. This type of information system software focuses on enterprise business management, data analysis, and decision support, but there is still a gap compared to Excel in terms of ease of use for data editing. Whether it is the data preparation stage of the implementation of the management software or the normal business operation stage, there are many users who tend to use Excel to prepare data and then enter it into the management software. This repetitive data entry work is meaningless and annoying. Disgusted, so the demand to import the data in Excel directly into the management software has always been very high, and the management software has strict requirements on the data c...
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): G06F9/44
Inventor 舒鹏飞
Owner INSPUR COMMON SOFTWARE