CN104978333A - Automatic matching method based on Excel statistical form and web technology - Google Patents
Automatic matching method based on Excel statistical form and web technology Download PDFInfo
- Publication number
- CN104978333A CN104978333A CN201410135873.3A CN201410135873A CN104978333A CN 104978333 A CN104978333 A CN 104978333A CN 201410135873 A CN201410135873 A CN 201410135873A CN 104978333 A CN104978333 A CN 104978333A
- Authority
- CN
- China
- Prior art keywords
- excel
- subject
- data sheet
- report form
- coupling
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses an automatic matching method based on an Excel statistical form and a web technology, and belongs to the technical field of computers. The method comprises the following steps of: selecting the format of an Excel form; selecting an Excel file to be imported; automatically retrieving and displaying the column-to-column corresponding relationship of subjects in the Excel and a database; and manually modifying the corresponding relationship. Compared with the prior art, a general Excel data importing method provided by the invention has the advantages that the file configuration is not needed; the business rule acquaintance is not needed; the row-column matching correspondence of the subjects of system software and Excel contents can be automatically realized; when the complete matching cannot be realized, the column-to-column matching relationship can be modified by the user; the Excel does not need to be modified; and for the subjects which do not need the matching, only the corresponding relationship needs to be deleted, and the system ignores and does not operate the information in the column. The automatic matching method has the characteristics of universality, simplicity, intelligence, practicability and the like.
Description
Technical field
The present invention relates to computer realm, a kind of automatic matching method based on Excel statistical report form and web technology.
Background technology
In the statistical service of garden, need to collect all kinds of statistical indicator and be entered in data statistic analysis system, particularly statistics in the past is all kept in Excel, same statistical indicator, changes all to some extent in different times different regions, when importing data, be difficult to mate with the statistical indicator of database, need to revise in Excel statistical report form correctly could mate, inefficiency, and error easy to operate.In addition for some unwanted data, method in the past needs in Excel, delete this column data could continue operation.So one intelligent can be supported that the matching process of the efficiency of all version Excel is extremely urgent, the statistical work amount of garden can be reduced, improve statistical efficiency.
Summary of the invention
The object of the invention is for the Excel statistical report form of different-format carries out intelligent subject coupling.Need to select Excel statistical report form form, upload Excel statistical report form, select worksheet, carry out Intelligent Matching.
The technical scheme that the present invention solves the problem is as follows:
Step 1: the report form type selecting Excel data sheet, obtain the Excel file uploaded, the type according to Excel data sheet carries out parsing Excel file, obtains the worksheet Sheets of Excel data sheet.
Step 2: the subject in database is taken out, passes to view layer.
Step 3: select the worksheet needing coupling, this worksheet of asynchronous acquisition, carries out Excel data sheet format verification, if format error is pointed out, this worksheet of Correct Analysis process, takes out the subject in data sheet, with the display of row mode order.
Step 4: the object of process in obtaining step 2, mate, the match is successful then shows after the subject of step 3 correspondence, and to show, the match is successful; Ineffective law, rule, etc. is shown as originally, to show without matching result without the subject in the Excel data sheet of coupling.
Step 5: check that whether coupling is complete, if there is subject not mate, input corresponding coupling subject in the text, often input a word, recurrence coupling, provides the subject that can select, without the need to whole input from the object of step 2.
The subject name of the subject Corresponding matching of step 6:Excel data sheet is modified, and the match is successful again for step 4, can delete the content of text of Corresponding matching, again step 5.
Step 7: if do not needed coupling, deletes the text of Eexcel data sheet subject coupling.
Accompanying drawing explanation
Fig. 1 is process flow diagram of the present invention.
Fig. 2,3,4 is Excel data sheet sheet1, sheet2, sheet3 example.
Fig. 5,6,7 is respectively sheet1, sheet3, sheet3 matching result example.
Fig. 8 is for manually to mate example.
Embodiment
Be described principle of the present invention and feature below in conjunction with accompanying drawing, example, only for explaining the present invention, is not in restriction scope of the present invention.
The present invention is based on Excel statistical report form and web technology automatic matching method, as shown in Figure 1, comprise the steps:
Step 1: the report form type selecting Excel data sheet, obtain the Excel file uploaded, the type according to Excel data sheet carries out parsing Excel file, obtains the worksheet Sheets of Excel data sheet, has three worksheets in this example.
Step 2: the subject in database is taken out, passes to view layer.
Step 3: select the worksheet needing coupling, this worksheet of asynchronous acquisition, carries out Excel data sheet format verification, if format error is pointed out, as Fig. 7, this worksheet of Correct Analysis process, take out the subject in data sheet, with the display of row mode order, as Fig. 5, Fig. 6.
Step 4: the object of process in obtaining step 2, mate, the match is successful then shows after the subject of step 3 correspondence, and to show, the match is successful; Ineffective law, rule, etc. is shown as originally, to show without matching result, as Fig. 5, Fig. 6 without the subject in the Excel data sheet of coupling.
Step 5: check that whether coupling is complete, if there is subject not mate, input corresponding coupling subject in the text, often input a word, recurrence coupling, provides the subject that can select, as Fig. 8 from the object of step 2.
The subject name of the subject Corresponding matching of step 6:Excel data sheet is modified, and the match is successful again for step 4, can delete the content of text of Corresponding matching, again step 5.
Step 7: if do not needed coupling, deletes the text of Eexcel data sheet subject coupling.
Claims (8)
1., based on an automatic matching method for Excel statistical report form and web technology, it is characterized in that, comprise the following steps:
Step 1: the report form type selecting Excel data sheet, obtain the Excel file uploaded, the type according to Excel data sheet carries out parsing Excel file, obtains the worksheet Sheets of Excel data sheet.
Step 2: the subject in database is taken out, passes to view layer.
Step 3: select the worksheet needing coupling, this worksheet of asynchronous acquisition, carries out Excel data sheet format verification, if format error is pointed out, this worksheet of Correct Analysis process, takes out the subject in data sheet, with the display of row mode order.
Step 4: the object of process in obtaining step 2, mate, the match is successful then shows after the subject of step 3 correspondence, and to show, the match is successful; Ineffective law, rule, etc. is shown as originally, to show without matching result without the subject in the Excel data sheet of coupling.
Step 5: check that whether coupling is complete, if there is subject not mate, input corresponding coupling subject in the text, often input a word, recurrence coupling, provides the subject that can select, without the need to whole input from the object of step 2.
The subject name of the subject Corresponding matching of step 6:Excel data sheet is modified, and the match is successful again for step 4, can delete the content of text of Corresponding matching, again step 5.
Step 7: if do not needed coupling, deletes the corresponding text of Eexcel data sheet subject coupling.
2. a kind of automatic matching method based on Excel statistical report form and web technology according to claim 1, is characterized in that: step 1 adopts JAVA ExcelAPI (POI) to resolve.
3. a kind of automatic matching method based on Excel statistical report form and web technology according to claim 1, is characterized in that: subjects all for database takes out by step 2, is treated to json object, passes in the view page.
4. a kind of automatic matching method based on Excel statistical report form and web technology according to claim 1, it is characterized in that: step 3 gives tacit consent to first Zhang Gong's tabulation, when worksheet is selected to change, event triggers, utilize ajax asynchronous process, obtain the report form type of Excel data sheet, obtain the Excel file uploaded, obtain the worksheet selected, regularly resolve, result is turned back to the view page.
5. a kind of automatic matching method based on Excel statistical report form and web technology according to claim 1, is characterized in that: the json object of step 4 obtaining step 2, carries out Recursion process, mate the subject in step 3 in row mode one by one.
6. a kind of automatic matching method based on Excel statistical report form and web technology according to claim 1, it is characterized in that: the triggered time during variation of step 5 Chinese version, the json object of obtaining step 2 again, carries out word for word recurrence coupling, matching result is shown to the view page.
7. a kind of automatic matching method based on Excel statistical report form and web technology according to claim 1, it is characterized in that: in step 4,5,6,7, utilize the technical finesses such as js, ajax, greatly alleviate server stress, improve matching efficiency, without the need to revising Excel, intelligent, practical, various demand can be adapted to.
8. a kind of automatic matching method based on Excel statistical report form and web technology according to claim 2, it is characterized in that: step 1 adopts JAVA ExcelAPI (POI) to resolve, all versions such as support 2003,2007,2010 are practical.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410135873.3A CN104978333A (en) | 2014-04-08 | 2014-04-08 | Automatic matching method based on Excel statistical form and web technology |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410135873.3A CN104978333A (en) | 2014-04-08 | 2014-04-08 | Automatic matching method based on Excel statistical form and web technology |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104978333A true CN104978333A (en) | 2015-10-14 |
Family
ID=54274848
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410135873.3A Pending CN104978333A (en) | 2014-04-08 | 2014-04-08 | Automatic matching method based on Excel statistical form and web technology |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104978333A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106126667A (en) * | 2016-06-25 | 2016-11-16 | 国云科技股份有限公司 | A kind of method realizing dynamically filling EXCEL sequence |
| CN106469215A (en) * | 2016-09-06 | 2017-03-01 | 广州视睿电子科技有限公司 | Data lead-in method based on page end and system |
| CN107704441A (en) * | 2016-08-08 | 2018-02-16 | 北京国双科技有限公司 | A kind of delet method and device of Excel worksheets |
| CN107832371A (en) * | 2017-10-27 | 2018-03-23 | 安徽经邦软件技术有限公司 | A kind of Excel intelligent Matchings import system and method based on financial statement |
| CN108197207A (en) * | 2017-12-28 | 2018-06-22 | 南京涵韬信息科技有限公司 | Batch data matches introduction method |
| CN109324963A (en) * | 2018-08-22 | 2019-02-12 | 中国平安人寿保险股份有限公司 | The method and terminal device of automatic test profitable result |
| CN109558552A (en) * | 2018-11-20 | 2019-04-02 | 山东中创软件工程股份有限公司 | A kind of contents access method, device, equipment and the medium of Office file |
| CN113128188A (en) * | 2021-04-29 | 2021-07-16 | 北京开科唯识技术股份有限公司 | Bank payroll generation method, device and medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7117430B2 (en) * | 2001-02-27 | 2006-10-03 | Microsoft Corporation | Spreadsheet error checker |
| CN101710347A (en) * | 2009-12-23 | 2010-05-19 | 金蝶软件（中国）有限公司 | Method and device for processing data in data table |
| CN101908039A (en) * | 2010-06-29 | 2010-12-08 | 北京科技大学 | Report template customizing system |
| CN103606045A (en) * | 2013-11-20 | 2014-02-26 | 国家电网公司 | Report form generation method and report form system |
| CN103646016A (en) * | 2013-12-30 | 2014-03-19 | 金蝶软件（中国）有限公司 | Implementation method of user-defined financial statement and server |
-
2014
- 2014-04-08 CN CN201410135873.3A patent/CN104978333A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7117430B2 (en) * | 2001-02-27 | 2006-10-03 | Microsoft Corporation | Spreadsheet error checker |
| CN101710347A (en) * | 2009-12-23 | 2010-05-19 | 金蝶软件（中国）有限公司 | Method and device for processing data in data table |
| CN101908039A (en) * | 2010-06-29 | 2010-12-08 | 北京科技大学 | Report template customizing system |
| CN103606045A (en) * | 2013-11-20 | 2014-02-26 | 国家电网公司 | Report form generation method and report form system |
| CN103646016A (en) * | 2013-12-30 | 2014-03-19 | 金蝶软件（中国）有限公司 | Implementation method of user-defined financial statement and server |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106126667A (en) * | 2016-06-25 | 2016-11-16 | 国云科技股份有限公司 | A kind of method realizing dynamically filling EXCEL sequence |
| CN107704441A (en) * | 2016-08-08 | 2018-02-16 | 北京国双科技有限公司 | A kind of delet method and device of Excel worksheets |
| CN107704441B (en) * | 2016-08-08 | 2021-01-29 | 北京国双科技有限公司 | Method and device for deleting Excel worksheet |
| CN106469215A (en) * | 2016-09-06 | 2017-03-01 | 广州视睿电子科技有限公司 | Data lead-in method based on page end and system |
| CN107832371A (en) * | 2017-10-27 | 2018-03-23 | 安徽经邦软件技术有限公司 | A kind of Excel intelligent Matchings import system and method based on financial statement |
| CN108197207A (en) * | 2017-12-28 | 2018-06-22 | 南京涵韬信息科技有限公司 | Batch data matches introduction method |
| CN109324963A (en) * | 2018-08-22 | 2019-02-12 | 中国平安人寿保险股份有限公司 | The method and terminal device of automatic test profitable result |
| CN109324963B (en) * | 2018-08-22 | 2024-03-15 | 中国平安人寿保险股份有限公司 | Method for automatically testing profit result and terminal equipment |
| CN109558552A (en) * | 2018-11-20 | 2019-04-02 | 山东中创软件工程股份有限公司 | A kind of contents access method, device, equipment and the medium of Office file |
| CN113128188A (en) * | 2021-04-29 | 2021-07-16 | 北京开科唯识技术股份有限公司 | Bank payroll generation method, device and medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104978333A (en) | Automatic matching method based on Excel statistical form and web technology | |
| US11562012B2 (en) | System and method for providing technology assisted data review with optimizing features | |
| US10614527B2 (en) | System and method for automatic generation of reports based on electronic documents | |
| US20210318851A1 (en) | Systems and Methods for Dataset Merging using Flow Structures | |
| US11182394B2 (en) | Performing database file management using statistics maintenance and column similarity | |
| US20200233905A1 (en) | Systems and Methods for Data Analysis and Visualization Spanning Multiple Datasets | |
| US10599761B2 (en) | Digitally converting physical document forms to electronic surveys | |
| US9760953B1 (en) | Computer implemented methods systems and articles of manufacture for identifying tax return preparation application questions based on semantic dependency | |
| US9286329B2 (en) | Generating analytics application using reusable application modules | |
| CN109635300B (en) | Data verification method and device | |
| AU2019204444B2 (en) | System and method for enrichment of ocr-extracted data | |
| US9292579B2 (en) | Method and system for document data extraction template management | |
| US9411917B2 (en) | Methods and systems for modeling crowdsourcing platform | |
| US20140058881A1 (en) | System and Process for Crop Scouting and Pest Cure Recommendation | |
| JP2018536947A5 (en) | ||
| KR20170073693A (en) | Extracting similar group elements | |
| CN108960672B (en) | Quota and time-limited wind control method and device and computer readable storage medium | |
| CN101976394A (en) | Data acquiring and counting system and method | |
| US9898553B2 (en) | Capturing run-time metadata | |
| CN104021216B (en) | Message proxy server and information publish subscription method and system | |
| WO2016131360A1 (en) | Widget file generation method and apparatus | |
| US20150199779A1 (en) | Patent management systems and methods having expert docketing | |
| US20180075117A1 (en) | System and method of providing a platform for enabling drill-down analysis of tabular data | |
| US11062410B2 (en) | System and method for student attendance management | |
| US20200226162A1 (en) | Automated Reporting System |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20151014 |
|
| WD01 | Invention patent application deemed withdrawn after publication |