CN108984494A - A kind of Excel software data integration method - Google Patents
A kind of Excel software data integration method Download PDFInfo
- Publication number
- CN108984494A CN108984494A CN201710126391.5A CN201710126391A CN108984494A CN 108984494 A CN108984494 A CN 108984494A CN 201710126391 A CN201710126391 A CN 201710126391A CN 108984494 A CN108984494 A CN 108984494A
- Authority
- CN
- China
- Prior art keywords
- source
- content
- excel software
- label
- target labels
- 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
Classifications
-
- 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/174—Form filling; Merging
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)
- Stored Programmes (AREA)
Abstract
A kind of Excel software data integration method of the present invention, for a kind of Excel software data integration system, the integration system is by the Data Integration in an Excel software into another Excel software, it is characterized in that, one Excel software includes source label and source content, the source label and source content are corresponding relationship, it include target labels and object content in another described Excel software, the object content and the target labels are corresponding relationship, when needing for the source content in one Excel software to be transported to the object content in another described Excel software, the integration system compares the content of the source label and the target labels, search identical content in the two, and carry the source content in the label of source Into the corresponding object content of target labels identical with source label.Data integrated system can preferably integrate the data and data comparison of multiple softwares through the invention, and user is helped to realize office automation facilitation.
Description
Technical field
The invention belongs to Excel software datas to integrate field, and in particular to the Data Integration of multiple Excel softwares to one
It rises.
Background technique
For the data in multiple Excel tables, we, which lead to, needs to be integrated into an Excel software, common
Way is to copy to source content in object content, but often arise a problem that, the arrangement mode of source content with
The arrangement mode of object content is different, if is simply copied into object content, then can be with object content pair
Should not on, for example, the content of class has corresponded in name, thus need the duplication of user one by one, heavy workload, and
It is easy error, how to design a simple third party software to solve this problem.
Summary of the invention
The present invention is intended to provide a kind of Excel software data integration method, helps user by multiple software datas according to new
Arrangement mode be integrated together, and be able to carry out data comparison and analysis.
A kind of Excel software data integration method is used for a kind of Excel software data integration system, the integration system
By the Data Integration in an Excel software into another Excel software, which is characterized in that one Excel software package
Source label and source content are included, the source label and source content are corresponding relationship, are wrapped in another described Excel software
Include target labels and object content, the object content and the target labels are corresponding relationship, when need will be one
When the source content in Excel software is transported to the object content in another described Excel software, the integration system
The content of the source label and the target labels is compared, identical content in the two is searched, and carries and comes in the label of source
Source contents are into the corresponding object content of target labels identical with source label.
Preferably, source label and target labels respectively there are two, during the comparison, two source labels difference
It is compared with corresponding target labels.
Preferably, source label includes lateral source label and vertical source label, and the target labels include lateral mesh
Label and vertical target labels are marked, during the comparison, the transverse direction source label and the vertical target labels pair
Than the vertical source label and the lateral target labels compare.
Preferably, comparison process uses fuzzy contrast, has phase by searching in the source label and target labels
Judge with content, there is judgement after comparison identical has identical element then to judge that source label is identical as target labels.
Preferably, in comparison process, the Chinese figure and Arabic numerals of the source label and the target labels it
Between mutually convert.Judge that Chinese figure equivalent in meaning is identical with Arabic numerals.
Preferably, source content is placed on behind object content after carrying.
Preferably, when needing to compare source content and object content, integration system compares source label and target
Label adjusts source content later, by its it is corresponding with object content after compare, find out in corresponding source content and target
Different region in appearance, integration system is by region color marking different after comparison.
Preferably, when having Merge Cells in source label, target labels, source content, integration system will merge single
First lattice are divided into corresponding individual unit lattice.
Preferably, when source content is transported in object content, content original in object content is covered.
The content in multiple Excel softwares is integrated into one by a kind of Excel software data integration method through the invention
It in Excel software, can fast and accurately complete to carry, and can be in two Excel softwares of rapid comparison by this method
Content different zones.Mistake or other purposes are searched to user.The method used in the present invention will greatly improve work
The efficiency and accuracy of Data Integration of the personnel in Excel software.
Detailed description of the invention
Fig. 1 is an Excel software in a kind of Excel software data integration method of the present invention.
Fig. 2 is another Excel software in a kind of Excel software data integration method of the present invention.
Specific embodiment
The present invention relates to a kind of Excel software data integration methods, for Excel software data integration system to multiple
Data in Excel software are mobile, the content in multiple Excel softwares copied in an Excel software, below by way of one
For content in a Excel software is transported in another Excel software, the scheme that the present invention uses is explained in detail.
As illustrated in fig. 1 and 2, in an Excel software content as shown in Figure 1, content in another Excel software as schemed
Shown in 2, sets in Fig. 1 1. region and correspond to that source label 1,2. region is 3. source content as source label 2.The area Tu2Zhong①
Domain corresponds to target labels 1, and it is target labels 2 that 2. region is corresponding in Fig. 2, and 3. region is object content in Fig. 2.Source label
1 is lateral source label, and source label 2 is vertical source label, and target labels 1 are lateral target labels, and target labels 2 are perpendicular
To target labels.It needs to move the source content in an Excel software into the target labels 1 in another Excel software
With 2 composed by label setting object content in.If will be in an Excel software according to the method that existing duplication is pasted
Sourcing object copy in object content, overturn the corresponding relationship in 1-12 month.So can be using in the present invention
Method carry source content.Specific scheme is as follows:
The content in source label 1 and target labels 1 is compared, the content in source label 2 and target labels 2 is compared.Such as Fig. 1 institute
Show, firstly, first content (position B2) in the label of source, which is by comparison to observe above-mentioned 1 January
Month the last one contents (position M2) of target labels will be in corresponding source in source label January during carrying
Appearance copies within the scope of the corresponding object content of target labels the last one contents.And so on, it is right in the source label 2-12 month
The source content answered successively is transported in the target labels 2-12 month corresponding object content.Compare source label 2 and target labels 2
In content such as source label 1 and 1 comparison process of target labels.It is arranged again according to the sequence in source label 2 and target labels 2
Sequence (source label 2 and target labels 2 in Fig. 1 and Fig. 2 are consistent, therefore, the sequence after carrying will not convert).Source content
When being carried to targeted content area, when having been filled with content in object content, integration system is defaulted as being placed on existing content
Behind, when existing content is no, i.e., it is believed that being referred to behind target labels behind above-mentioned existing content.In addition,
User is also an option that the existing content of covering.When practical application, when source label only one when, as long as only compare one
Source label and target labels.
It can mutually be recognized between Chinese figure and Arabic numerals during comparison, for example, when in the label of source
For " January ", and in target labels it is " January ", it is identical that both integration system, which can also identify them and judge,.
User can choose fuzzy contrast during comparison.Judgement has identical element then to judge source label and target
Label is identical.For example, the content in the label of source is " one class of student, two classes of students, class Three student ... ", and it is in target labels
" one class, two classes, class Three ... ", if user has selected fuzzy contrast, integration system judges that " one class of student " and " one class " is right
It should get up, " two classes of students " and " two classes " are mapped, behind and so on.
In addition, comparison process discovery source label and the inconsistent place of target labels will be identified in mesh with red
Label and object content are marked, for reminding user.
In addition, integration system is also equipped with the function of comparison source content and object content during integration.Specific function
It is as follows to be able to achieve mode: at this point, targeted content area has actual content (being not all space at object content).In comparison source
After label and target labels, continues to compare source content and object content, integration system will be according to source label and target labels
Result adjustment source content after comparison compares after so that it is mapped with object content with object content, and then searches and
Different zones between source contents and object content, and use different regions in targeted content area or source content region
Other color marks get up.This way of contrast, when solving artificial contrast, source label and target labels sort different and produce
Raw work, and the mistake of artificial contrast's generation is avoided well.
The specific range of above-mentioned source label, target labels and source content can be selected by user.Such as user can
Only to carry the 1-11 month corresponding source content into object content.For in the object content in another Excel software
Substantial, user can choose the existing content of covering, also can choose after the content of carrying is placed on existing content
Face.
The case where for Merge Cells, such as 1 continuous three cell span of source label are a cell, integration
A cell after merging can be divided into three the same cells of content when comparison by system.For in source content
Merge Cells are also method as above processing.
A kind of Excel software data integration method will will be in multiple Excel softwares by this method through the invention
Appearance is integrated into an Excel software, can fast and accurately complete to carry, and can be rapid comparison two by this method
Content different zones in Excel software.Mistake or other purposes are searched to user.The method used in the present invention will be big
The efficiency and accuracy of Data Integration of the big raising staff in Excel software.
Above-mentioned specific embodiment is only to provide a kind of detailed case study on implementation, we should not be by protection model of the invention
Limited to this is enclosed, the simple inference or replacement that those skilled in the art make according to the present invention all should belong to guarantor of the invention
Protect range.
Claims (9)
1. a kind of Excel software data integration method, is used for a kind of Excel software data integration system, the integration system will
Data Integration in one Excel software is into another Excel software, which is characterized in that one Excel software includes
Source label and source content, the source label and source content are corresponding relationship, include in another described Excel software
Target labels and object content, the object content and the target labels are corresponding relationship, when needing one Excel
When the source content in software is transported to the object content in another described Excel software, the integration system comparison
The content of the source label and the target labels is searched identical content in the two, and is carried in the source in the label of source
Hold into the corresponding object content of target labels identical with source label.
2. a kind of Excel software data integration method as described in claim 1, which is characterized in that the source label and mesh
Mark label respectively there are two, during the comparison, two source labels respectively with corresponding target labels compare.
3. a kind of Excel software data integration method as claimed in claim 2, which is characterized in that the source label includes
Lateral source label and vertical source label, the target labels include lateral target labels and vertical target labels, described
During comparison, the transverse direction source label and the vertical target labels are compared, the vertical source label and the cross
It is compared to target labels.
4. a kind of Excel software data integration method as described in claim 1, which is characterized in that the comparison process uses
Fuzzy contrast has identical content to judge by searching in the source label and target labels, and judgement has phase after comparison
Then judge that source label is identical as target labels with element.
5. a kind of Excel software data integration method as described in claim 1, which is characterized in that in the comparison process, institute
It states and is mutually converted between source label and the Chinese figure and Arabic numerals of the target labels, judge Chinese equivalent in meaning
Number is identical with Arabic numerals.
6. a kind of Excel software data integration method as described in claim 1, it is characterised in that: the source content is carried
It is placed on behind object content afterwards.
7. a kind of Excel software data integration method as described in claim 1, it is characterised in that: when needing to compare in source
When appearance with object content, integration system comparison source label and target labels adjust source content later, by itself and target
It is compared after content is corresponding, region different in corresponding source content and object content is found out, after integration system will compare
Different region color markings.
8. such as any one Excel software data integration method in claim 1-6, which is characterized in that when source label, mesh
When having Merge Cells in mark label, source content, Merge Cells are divided into corresponding individual unit lattice by integration system.
9. a kind of Excel software data integration method as described in claim 6, which is characterized in that source content is transported to
When in object content, content original in object content is covered.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710126391.5A CN108984494A (en) | 2017-06-04 | 2017-06-04 | A kind of Excel software data integration method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710126391.5A CN108984494A (en) | 2017-06-04 | 2017-06-04 | A kind of Excel software data integration method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108984494A true CN108984494A (en) | 2018-12-11 |
Family
ID=64500878
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710126391.5A Pending CN108984494A (en) | 2017-06-04 | 2017-06-04 | A kind of Excel software data integration method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108984494A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111898350A (en) * | 2019-05-05 | 2020-11-06 | 珠海金山办公软件有限公司 | Cell circulating pasting method and device, electronic equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101976236A (en) * | 2010-09-26 | 2011-02-16 | 用友软件股份有限公司 | Method and device for importing floating row data through worksheet |
| CN102200968A (en) * | 2011-05-30 | 2011-09-28 | 深圳市五巨科技有限公司 | Method and device for removing duplications of EXCEL form data |
| KR20140110602A (en) * | 2013-03-08 | 2014-09-17 | 주식회사 엠로 | Excel function providing method in supply chain management program |
| CN105739985A (en) * | 2016-02-02 | 2016-07-06 | 锐达互动科技股份有限公司 | Method for importing selected Excel table into whiteboard software |
-
2017
- 2017-06-04 CN CN201710126391.5A patent/CN108984494A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101976236A (en) * | 2010-09-26 | 2011-02-16 | 用友软件股份有限公司 | Method and device for importing floating row data through worksheet |
| CN102200968A (en) * | 2011-05-30 | 2011-09-28 | 深圳市五巨科技有限公司 | Method and device for removing duplications of EXCEL form data |
| KR20140110602A (en) * | 2013-03-08 | 2014-09-17 | 주식회사 엠로 | Excel function providing method in supply chain management program |
| CN105739985A (en) * | 2016-02-02 | 2016-07-06 | 锐达互动科技股份有限公司 | Method for importing selected Excel table into whiteboard software |
Non-Patent Citations (1)
| Title |
|---|
| 佚名: ""VLOOKUP函数将一个excel表格的数据匹配到另一个表中"", 《脚本之家，HTTPS://M.JB51.NET/OFFICE/EXCEL/350609.HTML》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111898350A (en) * | 2019-05-05 | 2020-11-06 | 珠海金山办公软件有限公司 | Cell circulating pasting method and device, electronic equipment and storage medium |
| CN111898350B (en) * | 2019-05-05 | 2023-06-20 | 珠海金山办公软件有限公司 | Cell cycle pasting method and device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104572597A (en) | Automatic word analysis report generation method and device | |
| CN105589869B (en) | A kind of generation method and device of GIS-Geographic Information System annotation | |
| CN113051347B (en) | Method, system, equipment and storage medium for synchronizing data between heterogeneous databases | |
| CN104504045A (en) | GIS (geographic information system) positioning analysis system based on power customer address word segments | |
| CN104463449A (en) | Student schoolwork supervising system | |
| CN103440347B (en) | A kind of heterogeneous Disaster Event universal modeling method and system | |
| CN102646198B (en) | Mode recognition method of mixed linear SVM (support vector machine) classifier with hierarchical structure | |
| Gaska et al. | A GIS based graph oriented algorithmic model for poly-optimization of waste management system | |
| Guo et al. | Cyber-physical systems: Architecture, security and application | |
| CN108984494A (en) | A kind of Excel software data integration method | |
| CN104461423A (en) | Resource information distribution display method and device based on GIS | |
| CN105005953A (en) | Training school management system | |
| CN108959220A (en) | Templating data input management method and device | |
| Parvanova et al. | Data Integration Approaches for Representing Stem Cell Studies | |
| Pourshahabi et al. | Providing a Native Model for Promoting the Development Level of Sistan and Baluchestan Province with Sustainable Development Approach | |
| Cai et al. | Integrating GIS and microscopic traffic simulation to analyze impacts of transportation infrastructure construction | |
| CN102929908B (en) | The sort method and system of electronic map Search Hints information | |
| CN110275969A (en) | A kind of data presentation technique in hundred billion grades of knowledge picture libraries | |
| CN106776966A (en) | Data analysis method and device | |
| Eldrandaly | GIS and spatial decision making | |
| CN106874587A (en) | The mobilism tag system and implementation method merged for IP parameterized units | |
| CN102681830A (en) | Method and equipment for comparing program texts | |
| Zhou et al. | A dynamic integration method for borderland database using OSM data | |
| Rahmati Govari et al. | Algorithmic Approaches in space Layout (with an Emphasis on Graph Theory) | |
| He et al. | Design and implementation of a J2EE-Based platform for network teaching |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20181211 |