CN110134926A - A kind of EXCEL introduction method with form validation - Google Patents
A kind of EXCEL introduction method with form validation Download PDFInfo
- Publication number
- CN110134926A CN110134926A CN201910428857.6A CN201910428857A CN110134926A CN 110134926 A CN110134926 A CN 110134926A CN 201910428857 A CN201910428857 A CN 201910428857A CN 110134926 A CN110134926 A CN 110134926A
- Authority
- CN
- China
- Prior art keywords
- excel
- list
- data
- introduction method
- import
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 30
- 238000010200 validation analysis Methods 0.000 title claims abstract description 23
- 230000008676 import Effects 0.000 claims abstract description 30
- 238000012795 verification Methods 0.000 claims description 12
- 239000013589 supplement Substances 0.000 claims description 9
- 238000004321 preservation Methods 0.000 claims description 3
- 238000010276 construction Methods 0.000 description 4
- 238000009825 accumulation Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 235000013399 edible fruits Nutrition 0.000 description 1
- 230000001502 supplementing effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/151—Transformation
- G06F40/157—Transformation using dictionaries or tables
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of EXCEL introduction method with form validation belongs to information-based online technical field.EXCEL introduction method with form validation of the invention provides list and imports allocation list, data import configuration according to EXCEL and are quickly introduced under line, the corresponding relationship of flexible setting form fields and EXCEL column, data check is provided to the data of importing and data are fed, while support list and two kinds of button ways of presentation of list.The EXCEL introduction method with form validation of the invention can quickly introduce business datum under line, both alleviated the workload of business personnel, in turn avoided the mismatch problem of Data duplication typing, have good application value.
Description
Technical field
The present invention relates to information-based online technical fields, specifically provide a kind of EXCEL introduction method with form validation.
Background technique
Attention with country to construction enterprises' informationization, each construction enterprises online information system one after another, big portion's information
After online implementing, business event personnel not only need to complete business under the daily line of enterprise and register, it is also necessary to complete company information
Change the typing of system data, not only the burden of increased business event personnel, while producing the mismatch of data typing twice
Problem.
Based on the status of construction enterprises' information system data inputting, this EXCEL introduction method with form validation can be fast
Business datum under fast lead-in wire had both alleviated the workload of business personnel, in turn avoided the mismatch problem of Data duplication typing.
Summary of the invention
Technical assignment of the invention is that in view of the above problems, business number under line can be quickly introduced by providing one kind
According to, both alleviated the workload of business personnel, in turn avoid the mismatch problem of Data duplication typing with form validation
EXCEL introduction method.
To achieve the above object, the present invention provides the following technical scheme that
A kind of EXCEL introduction method with form validation, this method provide list and import allocation list, under line data according to
EXCEL imports configuration and is quickly introduced, and the corresponding relationship of flexible setting form fields and EXCEL column proposes the data of importing
It is fed for data check and data, while support list and two kinds of button ways of presentation of list.
Data can be quickly introduced according to EXCEL to day configuration under the line of enterprise in charge of construction.Business data is by line
Lower data become data on line, and data information can be stored more easily, accumulated, analyzed, be shared, and sufficiently excavate business data valence
Value.
Preferably, this method specifically includes the following steps:
S1, program deployment is carried out；
S2, EXCEL importing configuration is carried out；
S3, the judgement of button deployment way is carried out, if button deployment way is list, thens follow the steps S4, otherwise execute step
Rapid S9；
S4, into list list interface；
S5, button selection EXCEL file import；
S6, it obtains EXCEL file stream and parses；
S7, EXCEL configuration file is obtained, carries out data importing, verification, supplement；
S8, document preservation is carried out, and executes step S14；
S9, into list selection interface；
S10, button selection EXCEL file import；
S11, it obtains EXCEL file stream and parses；
S12, Read EXCEL configuration file carry out data importing, verification, supplement；
S13, data are automatically stored, and execute step S14；
S14, data are analyzed.
Preferably, configuration information includes that list configuration association part and EXCEL import column and form fields control section.
Preferably, list style information, list model information is arranged in list configuration association part, table name is imported
Start information imports detail list major key, if directly saves, update mode, updates check field, detail list ID, if enables.
It is arranged preferably, EXCEL imports column with form fields control section setting template, form fields number, list word
Section, data type, default value, if do not fill out, value type, value field/value word string/format string, value table, check word
Section, is associated with this literary name section, remarks.
Preferably, configuration EXCEL is arranged and form fields corresponding relationship and related school after the list essential information setting
Test information.
Preferably, carrying out data importing to the list for wanting data under lead-in wire, the information of configuration is imported according to EXCEL,
It clicks and imports button progress data importing.
It is supplemented preferably, carrying out verification to data while importing data with data, verification is not needed by part
It is perfect after supplementing corresponding information or importing.
Compared with prior art, the EXCEL introduction method of the invention with form validation has beneficial effect following prominent
Fruit: the EXCEL introduction method with form validation helps business data quickly to become data on line, data letter from data under line
Breath can be stored more easily, be accumulated, analyzed, shared, and is sufficiently excavated business data value, can also be completed enterprise business data
Rapid Accumulation and ensure that the standard of data format is unified, enterprise's big data is accumulated and data analysis from now on has
Significance has good application value.
Detailed description of the invention
Fig. 1 is the flow chart of the EXCEL introduction method of the present invention with form validation.
Specific embodiment
Below in conjunction with drawings and examples, to the EXCEL introduction method of the invention with form validation and system make into
One step is described in detail.
Embodiment
EXCEL introduction method with form validation of the invention, this method provide list and import allocation list, data root under line
It imports configuration according to EXCEL to be quickly introduced, the corresponding relationship of flexible setting form fields and EXCEL column, to the data of importing
Data check is provided and data are fed, while support list and two kinds of button ways of presentation of list.
As shown in Figure 1, the EXCEL introduction method with form validation specifically includes the following steps:
S1, program deployment is carried out.
S2, EXCEL importing configuration is carried out.
S3, the judgement of button deployment way is carried out, if button deployment way is list, thens follow the steps S4, otherwise execute step
Rapid S9.
S4, into list list interface.
S5, button selection EXCEL file import.
S6, it obtains EXCEL file stream and parses.
S7, EXCEL configuration file is obtained, carries out data importing, verification, supplement.
S8, document preservation is carried out, and executes step S14.
S9, into list selection interface.
S10, button selection EXCEL file import.
S11, it obtains EXCEL file stream and parses.
S12, Read EXCEL configuration file carry out data importing, verification, supplement.
S13, data are automatically stored, and execute step S14.
S14, data are analyzed.
Wherein configuration information includes that list configuration association part and EXCEL import column and form fields control section.
List style information, list model information is arranged in list configuration association part, and table name imports start information, imports
Detail list major key, if directly save, update mode, update check field, detail list ID, if enable.
The corresponding list essential information configuration in list configuration association part is as shown in table 1.
Table 1
EXCEL imports column and arranges with form fields control section setting template, form fields number, form fields, data class
Type, default value, if do not fill out, value type, value field/value word string/format string, value table, check field, association is originally
Literary name section, remarks.
After the setting of list essential information, configuration EXCEL column and form fields corresponding relationship and associated check information.Table structure
As shown in table 2.
Table 2
Data importing is carried out to the list for wanting data under lead-in wire, the information of configuration is imported according to EXCEL, clicks to import and press
Button carries out data importing.Verification is carried out to data while importing data to supplement with data, and verification is not needed to mend by part
It is perfect after filling corresponding information or importing.
Embodiment described above, the only present invention more preferably specific embodiment, those skilled in the art is at this
The usual variations and alternatives carried out within the scope of inventive technique scheme should be all included within the scope of the present invention.
Claims (8)
1. a kind of EXCEL introduction method with form validation, it is characterised in that: this method provides list and imports allocation list, under line
Data import configuration according to EXCEL and are quickly introduced, the corresponding relationship of flexible setting form fields and EXCEL column, to importing
Data data check and data are provided feed, while support list and two kinds of button ways of presentation of list.
2. the EXCEL introduction method according to claim 1 with form validation, it is characterised in that: this method specifically includes
Following steps:
S1, program deployment is carried out；
S2, EXCEL importing configuration is carried out；
S3, the judgement of button deployment way is carried out, if button deployment way is list, thens follow the steps S4, it is no to then follow the steps S9；
S4, into list list interface；
S5, button selection EXCEL file import；
S6, it obtains EXCEL file stream and parses；
S7, EXCEL configuration file is obtained, carries out data importing, verification, supplement；
S8, document preservation is carried out, and executes step S14；
S9, into list selection interface；
S10, button selection EXCEL file import；
S11, it obtains EXCEL file stream and parses；
S12, Read EXCEL configuration file carry out data importing, verification, supplement；
S13, data are automatically stored, and execute step S14；
S14, data are analyzed.
3. the EXCEL introduction method according to claim 2 with form validation, it is characterised in that: configuration information includes table
Single configuration association part and EXCEL import column and form fields control section.
4. the EXCEL introduction method according to claim 3 with form validation, it is characterised in that: the list configuration is closed
Connection part setting list style information, list model information, table name import start information, import detail list major key, if directly
It saves, update mode, updates check field, detail list ID, if enable.
5. according to right want 4 described in the EXCEL introduction method with form validation, it is characterised in that: EXCEL import column and list
Field control section is arranged template and arranges, form fields number, form fields, data type, default value, if do not fill out, value class
Type, value field/value word string/format string, value table, check field are associated with this literary name section, remarks.
6. the EXCEL introduction method according to claim 5 with form validation, it is characterised in that: the list is believed substantially
After breath setting, configuration EXCEL column and form fields corresponding relationship and associated check information.
7. the EXCEL introduction method according to claim 6 with form validation, it is characterised in that: to wanting under lead-in wire number
According to list carry out data importing, according to EXCEL import configuration information, click import button carry out data importing.
8. the EXCEL introduction method according to claim 7 with form validation, it is characterised in that: importing the same of data
When to data carry out verification with data supplement, to verification by part need to supplement corresponding information or import after it is perfect.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910428857.6A CN110134926A (en) | 2019-05-22 | 2019-05-22 | A kind of EXCEL introduction method with form validation |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910428857.6A CN110134926A (en) | 2019-05-22 | 2019-05-22 | A kind of EXCEL introduction method with form validation |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110134926A true CN110134926A (en) | 2019-08-16 |
Family
ID=67572458
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910428857.6A Pending CN110134926A (en) | 2019-05-22 | 2019-05-22 | A kind of EXCEL introduction method with form validation |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110134926A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111191432A (en) * | 2019-12-26 | 2020-05-22 | 广东飞企互联科技股份有限公司 | Smart park big data rapid import method |
| CN113592633A (en) * | 2021-08-04 | 2021-11-02 | 上海通联金融服务有限公司 | Method for credit card approval and approval business |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104317974A (en) * | 2014-11-21 | 2015-01-28 | 武汉理工大学 | Reconfigurable multi-source data importing method in ERP system |
| WO2018205869A1 (en) * | 2017-05-09 | 2018-11-15 | 钱叶敢 | Form self-defined method and device |
| CN109739923A (en) * | 2019-04-03 | 2019-05-10 | 深圳市沃易科技有限公司 | A kind of method and system that data import |
-
2019
- 2019-05-22 CN CN201910428857.6A patent/CN110134926A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104317974A (en) * | 2014-11-21 | 2015-01-28 | 武汉理工大学 | Reconfigurable multi-source data importing method in ERP system |
| WO2018205869A1 (en) * | 2017-05-09 | 2018-11-15 | 钱叶敢 | Form self-defined method and device |
| CN109739923A (en) * | 2019-04-03 | 2019-05-10 | 深圳市沃易科技有限公司 | A kind of method and system that data import |
Non-Patent Citations (1)
| Title |
|---|
| 王春刚: "基于配置文件的通用数据导入设计与实现", 《计算机与现代化》 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111191432A (en) * | 2019-12-26 | 2020-05-22 | 广东飞企互联科技股份有限公司 | Smart park big data rapid import method |
| CN111191432B (en) * | 2019-12-26 | 2023-09-08 | 广东飞企互联科技股份有限公司 | Rapid importing method for big data of intelligent park |
| CN113592633A (en) * | 2021-08-04 | 2021-11-02 | 上海通联金融服务有限公司 | Method for credit card approval and approval business |
| CN113592633B (en) * | 2021-08-04 | 2024-03-29 | 上海通联金融服务有限公司 | Method for credit card approval and approval business |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102779040B (en) | A kind of method and apparatus generating customizing form | |
| CN103593456B (en) | Worksheet self-defining method for designing and device | |
| CN110991157B (en) | Engineering quality assessment system design method based on electronic file trusted technology | |
| CN103955345B (en) | A kind of data-printing method and system | |
| CN105487864A (en) | Method and device for automatically generating code | |
| CN115658041B (en) | Low-code enhanced service implementation method based on online service flow arrangement | |
| CN110543303B (en) | Visual service platform | |
| CN105653507A (en) | Chart generation method and device | |
| CN110222321A (en) | Report form generation method, device, computer installation and computer readable storage medium | |
| CN106776962A (en) | A kind of general Excel data import multiple database physical table methods | |
| CN107273117A (en) | A kind of quick Code automatic build system for programming friendly | |
| CN103838706A (en) | Flexible management information system with process and form customization function | |
| CN110134926A (en) | A kind of EXCEL introduction method with form validation | |
| CN105607880A (en) | Printing method and device for examined and approved documents | |
| CN109710250A (en) | It is a kind of for constructing the visualization engine system and method for user interface | |
| CN103186632A (en) | Method and device for customizing operation and maintenance form | |
| CN107767008A (en) | Flow collocation method and device | |
| CN103530407A (en) | Method and device for generating rich text document | |
| CN107665457A (en) | A kind of method and system of commodity editor restocking | |
| CN109542438A (en) | One kind being based on visual chart development approach | |
| CN104298705A (en) | Converting method of relational data and unstructured data | |
| CN103677841B (en) | IETM code generation method and device based on element-level template | |
| CN115576950A (en) | Report generation method based on JSON configuration file | |
| CN114153442A (en) | Large-screen visualization page configuration method and system based on visualization component | |
| CN108182965B (en) | Electronic medical record generation system and method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190816 |
|
| RJ01 | Rejection of invention patent application after publication |