CN111444691A - Method for rapidly processing import form of Word table data - Google Patents
Method for rapidly processing import form of Word table data Download PDFInfo
- Publication number
- CN111444691A CN111444691A CN202010207422.1A CN202010207422A CN111444691A CN 111444691 A CN111444691 A CN 111444691A CN 202010207422 A CN202010207422 A CN 202010207422A CN 111444691 A CN111444691 A CN 111444691A
- Authority
- CN
- China
- Prior art keywords
- data
- word
- information
- reading
- period
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 29
- 230000008676 import Effects 0.000 title claims abstract description 20
- 230000003247 decreasing effect Effects 0.000 claims description 6
- 238000013479 data entry Methods 0.000 abstract description 2
- 238000012986 modification Methods 0.000 description 5
- 230000004048 modification Effects 0.000 description 5
- 238000010586 diagram Methods 0.000 description 2
- 230000004075 alteration Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
Images
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a method for rapidly processing a Word table data import form, provides a method for realizing the import of Word data into the form, and aims to help solve the problem of importing the form from the Word. The method firstly identifies Word table data, sets corresponding rules of table and database fields, and then puts the data into corresponding fields of the table according to the corresponding rules, and comprises the following steps: s1, defining a form and related field information which can not be changed due to the addition of the form, wherein the form name and the field information of the form are stored in a data form configuration table; s2, defining Word table data information, and storing the Word table information in a Word form configuration table; s3, defining the association information of the data form and the Word form. The workload of operators is reduced, and the accuracy of data entry is improved.
Description
Technical Field
The invention relates to a realization method for quickly processing a Word import form, which is applied to converting Word data into a database system in an information system.
Background
With the popularization of information system applications, a lot of user data needs to be imported into a background database. The customer will fill in data using Word. If the information is imported into an information system, the information is often input manually by a user, so that time and labor are wasted, errors are prone to occur, and especially when the number of words is large, the workload is huge.
The invention provides a method for realizing import of Word data into a form, and aims to help solve the problem of importing the form from the Word.
Disclosure of Invention
The technical task of the invention is to solve the defects of the prior art and provide a method for rapidly processing the import form of Word table data.
The technical scheme adopted by the invention for solving the technical problems is as follows:
a method for quickly processing Word table data import form includes identifying Word table data, setting corresponding rule of table and database field, then putting data into corresponding field of form according to corresponding rule, including following steps:
s1, defining a form and related field information which can not be changed due to the addition of the form, wherein the form name and the field information of the form are stored in a data form configuration table;
s2, defining Word table data information, and storing the Word table information in a Word form configuration table;
s3, defining the association information of the data form and the Word form.
Optionally, the configuration of the data form in step S1 specifically includes:
s1.1, one row of data is stored in the data of one configuration table;
s1.2, each field information of the configuration table field is stored in a row of data, and the field type needs to be configured;
s1.3 configuration field rows are increased or decreased as needed.
Optionally, the Word form configuration in step S2 specifically includes:
s2.1, one line of data is stored in the data of a Word table;
s2.2, each field information of the configuration table field stores a row of data in the data;
s2.3 the configuration field rows are increased or decreased as required.
Optionally, the step S3 configuring the associated information specifically includes:
one relationship configuration information is stored in the data as a line of data.
Optionally, the method further comprises the following steps:
s4, reading data configuration information of the data form and acquiring the field type;
and S5, reading the corresponding information of the table and the Word table.
Optionally, in step S5,
s5.1, organizing the data in a character string format, and converting according to the type of the configuration field;
s5.2 some characters can not be stored in the database and need to be replaced before being imported.
Optionally, the rules include period apportionment rules and in-period apportionment rules.
Optionally, the period apportionment rule execution process is as follows:
firstly, reading a main table row A101 of the apportionment rule information during the reading period, and reading whether the apportionment type defines a rule A102 by self;
if the judgment result of A102 is yes, reading the data information of the apportioned rows, and reading the proportion value A103 of each apportioned row;
if the judgment result of A102 is no, inquiring a corresponding index value A104 according to a read fixed rule value and a cost source pointed by the rule, accumulating the index value A105, and calculating a corresponding ratio A113 according to traversing each sharing row;
then, multiplying the proportion values in A103 and A113 by the cost number of the apportionment item to obtain the period actual cost A114 of the apportionment item;
finally, the period allocation result information is stored in a period allocation result table a 115.
Optionally, the in-phase allocation flow is executed as follows:
firstly, reading an in-period sharing rule information main table line A201, and reading whether a sharing type self-defines a rule A202;
if the judgment result of A202 is yes, reading the data information of the apportioned rows, and reading the proportion value A203 of each apportioned row;
if the judgment result of A202 is no, inquiring a corresponding index value A204 according to a read fixed rule value and a cost source pointed by the rule, accumulating the index value A205, and calculating a corresponding ratio A206 according to traversing each sharing row;
then, reading a period apportionment rule table A207, and judging whether the apportionment item has period apportionment;
if the judgment of A207 is yes, reading the cost numbers of all the sharing items in the period sharing result table, accumulating, adding the accumulated number to the cost value of the sharing item, and multiplying the accumulated number by the proportion of A206 to obtain a sharing number A208;
if A202 judges no, the cost value of the apportionment item is directly used and multiplied by the proportion of A206 to obtain an apportionment number A209;
finally, the split numbers calculated by A208 and A209 are stored in an in-period split result table.
Optionally, the step S3 includes:
s3.1 setting local File Source Properties
The Word is related to a plurality of tables, and the number of the tables introduced into the Word needs to be determined;
s3.2, setting table attributes, including:
setting column information of a tab (sheet) of an Excel data source, comprising the following steps: column number, title grid number, title name;
compared with the prior art, the method for rapidly processing the Word table data import form has the following beneficial effects:
the workload of operators is reduced, and the accuracy of data entry is improved.
Drawings
In order to more clearly describe the working principle of the method for rapidly processing the import form of the Word table data, the following is further illustrated by the attached diagram.
FIG. 1 is a schematic illustration of the period apportionment flow arrangement implementation of the present invention;
FIG. 2 is a schematic diagram of the intra-stage apportionment flow collation implementation of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The invention relates to a method for rapidly processing Word table data import form, which firstly identifies the Word table data, sets the corresponding rule of the table and the database field, and then puts the data into the corresponding field of the form according to the corresponding rule, and comprises the following steps:
s1, defining a form and related field information which can not be changed due to the addition of the form, wherein the form name and the field information of the form are stored in a data form configuration table;
s2, defining Word table data information, and storing the Word table information in a Word form configuration table;
s3, defining the association information of the data form and the Word form.
Optionally, the configuration of the data form in step S1 specifically includes:
s1.1, one row of data is stored in the data of one configuration table;
s1.2, each field information of the configuration table field is stored in a row of data, and the field type needs to be configured;
s1.3 configuration field rows are increased or decreased as needed.
Optionally, the Word form configuration in step S2 specifically includes:
s2.1, one line of data is stored in the data of a Word table;
s2.2, each field information of the configuration table field stores a row of data in the data;
s2.3 the configuration field rows are increased or decreased as required.
Optionally, the step S3 configuring the associated information specifically includes:
one relationship configuration information is stored in the data as a line of data.
Optionally, the method further comprises the following steps:
s4, reading data configuration information of the data form and acquiring the field type;
and S5, reading the corresponding information of the table and the Word table.
Optionally, in step S5,
s5.1, organizing the data in a character string format, and converting according to the type of the configuration field;
s5.2 some characters can not be stored in the database and need to be replaced before being imported.
Optionally, the rules include period apportionment rules and in-period apportionment rules.
With reference to fig. 1, the period apportionment rule is implemented as follows:
firstly, reading a main table row A101 of the apportionment rule information during the reading period, and reading whether the apportionment type defines a rule A102 by self;
if the judgment result of A102 is yes, reading the data information of the apportioned rows, and reading the proportion value A103 of each apportioned row;
if the judgment result of A102 is no, inquiring a corresponding index value A104 according to a read fixed rule value and a cost source pointed by the rule, accumulating the index value A105, and calculating a corresponding ratio A113 according to traversing each sharing row;
then, multiplying the proportion values in A103 and A113 by the cost number of the apportionment item to obtain the period actual cost A114 of the apportionment item;
finally, the period allocation result information is stored in a period allocation result table a 115.
With reference to fig. 2, the execution process of the in-phase sharing process is as follows:
firstly, reading an in-period sharing rule information main table line A201, and reading whether a sharing type self-defines a rule A202;
if the judgment result of A202 is yes, reading the data information of the apportioned rows, and reading the proportion value A203 of each apportioned row;
if the judgment result of A202 is no, inquiring a corresponding index value A204 according to a read fixed rule value and a cost source pointed by the rule, accumulating the index value A205, and calculating a corresponding ratio A206 according to traversing each sharing row;
then, reading a period apportionment rule table A207, and judging whether the apportionment item has period apportionment;
if the judgment of A207 is yes, reading the cost numbers of all the sharing items in the period sharing result table, accumulating, adding the accumulated number to the cost value of the sharing item, and multiplying the accumulated number by the proportion of A206 to obtain a sharing number A208;
if A202 judges no, the cost value of the apportionment item is directly used and multiplied by the proportion of A206 to obtain an apportionment number A209;
finally, the split numbers calculated by A208 and A209 are stored in an in-period split result table.
Optionally, the step S3 includes:
s3.1 setting local File Source Properties
The Word is related to a plurality of tables, and the number of the tables introduced into the Word needs to be determined;
s3.2, setting table attributes, including:
setting column information of a tab (sheet) of an Excel data source, comprising the following steps: column number, title grid number, title name;
while the preferred embodiments of the present application have been described, additional variations and modifications in those embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. Therefore, it is intended that the appended claims be interpreted as including preferred embodiments and all alterations and modifications as fall within the scope of the application.
It will be apparent to those skilled in the art that various changes and modifications may be made in the present application without departing from the spirit and scope of the application. Thus, if such modifications and variations of the present application fall within the scope of the claims of the present application and their equivalents, the present application is intended to include such modifications and variations as well.
In addition to the technical features described in the specification, the technology is known to those skilled in the art.
Claims (10)
1. A method for rapidly processing Word table data import form is characterized in that the method firstly identifies the Word table data, sets corresponding rules of table and database fields, and then puts the data into corresponding fields of the form according to the corresponding rules, and comprises the following steps:
s1, defining a form and related field information which can not be changed due to the addition of the form, wherein the form name and the field information of the form are stored in a data form configuration table;
s2, defining Word table data information, and storing the Word table information in a Word form configuration table;
s3, defining the association information of the data form and the Word form.
2. The method for rapidly processing the Word table data import form according to claim 1, wherein the data form configuration in step S1 specifically comprises:
s1.1, one row of data is stored in the data of one configuration table;
s1.2, each field information of the configuration table field is stored in a row of data, and the field type needs to be configured;
s1.3 configuration field rows are increased or decreased as needed.
3. The method for rapidly processing the Word table data import form according to claim 1 or 2, wherein the Word form configuration in the step S2 specifically comprises:
s2.1, one line of data is stored in the data of a Word table;
s2.2, each field information of the configuration table field stores a row of data in the data;
s2.3 the configuration field rows are increased or decreased as required.
4. The method for rapidly processing the Word table data import form according to claim 1 or 2, wherein the step S3 configuration of the associated information is specifically:
one relationship configuration information is stored in the data as a line of data.
5. The method for rapidly processing the import form of Word table data according to claim 1 or 2, further comprising the following steps:
s4, reading data configuration information of the data form and acquiring the field type;
and S5, reading the corresponding information of the table and the Word table.
6. The method for rapidly processing the import form of Word table data according to claim 5, wherein in step S5,
s5.1, organizing the data in a character string format, and converting according to the type of the configuration field;
s5.2 some characters can not be stored in the database and need to be replaced before being imported.
7. The method for rapidly processing the import form of Word table data according to claim 1, 2 or 6, wherein the rules comprise period distribution rules and in-period distribution rules.
8. The method of claim 7, wherein the period apportionment rule is executed by:
firstly, reading a main table row A101 of the apportionment rule information during the reading period, and reading whether the apportionment type defines a rule A102 by self;
if the judgment result of A102 is yes, reading the data information of the apportioned rows, and reading the proportion value A103 of each apportioned row;
if the judgment result of A102 is no, inquiring a corresponding index value A104 according to a read fixed rule value and a cost source pointed by the rule, accumulating the index value A105, and calculating a corresponding ratio A113 according to traversing each sharing row;
then, multiplying the proportion values in A103 and A113 by the cost number of the apportionment item to obtain the period actual cost A114 of the apportionment item;
finally, the period allocation result information is stored in a period allocation result table a 115.
9. The method for rapidly processing the import form of Word table data according to claim 7, wherein the in-term sharing process is performed as follows:
firstly, reading an in-period sharing rule information main table line A201, and reading whether a sharing type self-defines a rule A202;
if the judgment result of A202 is yes, reading the data information of the apportioned rows, and reading the proportion value A203 of each apportioned row;
if the judgment result of A202 is no, inquiring a corresponding index value A204 according to a read fixed rule value and a cost source pointed by the rule, accumulating the index value A205, and calculating a corresponding ratio A206 according to traversing each sharing row;
then, reading a period apportionment rule table A207, and judging whether the apportionment item has period apportionment;
if the judgment of A207 is yes, reading the cost numbers of all the sharing items in the period sharing result table, accumulating, adding the accumulated number to the cost value of the sharing item, and multiplying the accumulated number by the proportion of A206 to obtain a sharing number A208;
if A202 judges no, the cost value of the apportionment item is directly used and multiplied by the proportion of A206 to obtain an apportionment number A209;
finally, the split numbers calculated by A208 and A209 are stored in an in-period split result table.
10. The method for rapidly processing the import form of Word table data according to claim 1, 2, 6, 8 or 9, wherein the step S3 is:
s3.1 setting local File Source Properties
The Word is related to a plurality of tables, and the number of the tables introduced into the Word needs to be determined;
s3.2, setting table attributes, including:
setting column information of a tab (sheet) of an Excel data source, comprising the following steps: column number, title grid number, title name;
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010207422.1A CN111444691B (en) | 2020-03-23 | 2020-03-23 | Method for rapidly processing Word form data import form |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010207422.1A CN111444691B (en) | 2020-03-23 | 2020-03-23 | Method for rapidly processing Word form data import form |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111444691A true CN111444691A (en) | 2020-07-24 |
| CN111444691B CN111444691B (en) | 2023-10-13 |
Family
ID=71629402
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010207422.1A Active CN111444691B (en) | 2020-03-23 | 2020-03-23 | Method for rapidly processing Word form data import form |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111444691B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106528821A (en) * | 2016-11-16 | 2017-03-22 | 济南浪潮高新科技投资发展有限公司 | Method for importing change column data into database |
| CN109189835A (en) * | 2018-08-21 | 2019-01-11 | 北京京东尚科信息技术有限公司 | The method and apparatus of the wide table of data are generated in real time |
| US20190095492A1 (en) * | 2017-09-28 | 2019-03-28 | Sap Se | Real-time or event-based analysis of process data |
| WO2019179021A1 (en) * | 2018-03-22 | 2019-09-26 | 平安科技（深圳）有限公司 | Method and apparatus for importing excel data into database, and computer device and storage medium |
-
2020
- 2020-03-23 CN CN202010207422.1A patent/CN111444691B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106528821A (en) * | 2016-11-16 | 2017-03-22 | 济南浪潮高新科技投资发展有限公司 | Method for importing change column data into database |
| US20190095492A1 (en) * | 2017-09-28 | 2019-03-28 | Sap Se | Real-time or event-based analysis of process data |
| WO2019179021A1 (en) * | 2018-03-22 | 2019-09-26 | 平安科技（深圳）有限公司 | Method and apparatus for importing excel data into database, and computer device and storage medium |
| CN109189835A (en) * | 2018-08-21 | 2019-01-11 | 北京京东尚科信息技术有限公司 | The method and apparatus of the wide table of data are generated in real time |
Non-Patent Citations (1)
| Title |
|---|
| 游樱;: "电子表格在财务信息整理中的应用及控制" * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111444691B (en) | 2023-10-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106844324B (en) | Method for exporting variable column data into Excel format | |
| CN103995908A (en) | Method and device for importing data | |
| CN107622102A (en) | Entity card number generation method and terminal device | |
| CN106844320B (en) | Financial statement integration method and equipment | |
| CN110728123A (en) | Report generation method, system and related equipment | |
| CN115391439B (en) | Document data export method, device, electronic equipment and storage medium | |
| CN106708822A (en) | File storage method and device | |
| CN114357085B (en) | Financial data storage method and device based on block chain and storage medium | |
| CN106855862A (en) | A kind of quick comparative approach and device | |
| CN106599291A (en) | Method and device for grouping data | |
| CN111401023B (en) | Report generation method, report generation device, server and storage medium | |
| CN111444691A (en) | Method for rapidly processing import form of Word table data | |
| CN105930323A (en) | File generating method and apparatus | |
| CN111291543B (en) | Data display method and device, storage medium and processor | |
| CN109324963B (en) | Method for automatically testing profit result and terminal equipment | |
| CN112580915A (en) | Project milestone determination method and device, storage medium and electronic equipment | |
| CN110765100A (en) | Label generation method and device, computer readable storage medium and server | |
| CN114138787A (en) | Bar code identification method, equipment and medium | |
| CN114817209A (en) | Monitoring rule processing method and device, processor and electronic equipment | |
| CN110008264B (en) | Data acquisition method and device of cost accounting system | |
| CN106021349A (en) | A foreign exchange data submitting method and device | |
| CN112070349A (en) | Order allocation method, device, equipment and storage medium | |
| CN112286936A (en) | Account checking method, system and related equipment | |
| CN107168942B (en) | Automatic report generation method and device | |
| CN112070525B (en) | Data processing method, device, equipment and storage medium |
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 | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20230907 Address after: No. 1036, Shandong high tech Zone wave road, Ji'nan, Shandong Applicant after: Inspur Genersoft Co.,Ltd. Address before: 250100 No. 2877 Kehang Road, Sun Village Town, Jinan High-tech District, Shandong Province Applicant before: SHANDONG INSPUR GENESOFT INFORMATION TECHNOLOGY Co.,Ltd. |
|
| TA01 | Transfer of patent application right | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |