CN110287469A

CN110287469A - Data processing method, device, electronic equipment and storage medium

Info

Publication number: CN110287469A
Application number: CN201910569348.5A
Authority: CN
Inventors: 晏凯
Original assignee: Beijing Orion Star Technology Co Ltd
Current assignee: Beijing Orion Star Technology Co Ltd
Priority date: 2019-06-27
Filing date: 2019-06-27
Publication date: 2019-09-27
Anticipated expiration: 2039-06-27
Also published as: CN110287469B

Abstract

The application proposes a kind of data processing method, device, electronic equipment and storage medium, and wherein method includes: that display data compare set interface；Compare the user's operation in set interface in response to the data, determines the first data area and the second data area to be compared；The first data content of storage is successively read from first data area, and the second data content of storage is read from position corresponding with first data content position in second data area；According to first data content and second data content, data comparison result is determined, and show the data comparison result.The method achieve depending on the user's operation, comparison in difference is carried out to the data content in data area, comparison result is accurate and reliable, and it is high-efficient, time and the energy of user are saved, user experience is improved.

Description

Data processing method, device, electronic equipment and storage medium

Technical field

This application involves field of computer technology more particularly to a kind of data processing method, device, electronic equipment and storages Medium.

Background technique

With the development of network and computer technology, spreadsheet gradually replaces traditional paper register book, extensive Storage, processing etc. applied to the every field such as computer, finance, such as progress data are frequently utilized that spreadsheet.And In the application process of spreadsheet, the data difference compared in two tables of data often may require that.

For example, the procurement staff of company may increase other information in the bill of materials that supplier provides, this mistake The case where initial data in journey in bill of materials may be tampered, buy so as to cause over-bought or less, this just needs to compare Compared with the data in the original physical inventory of initial data and supplier's offer in the modified bill of materials of procurement staff Difference, to ensure the accuracy of the data in modified physical inventory.

In the related technology, generally by the way of artificial, compare the data difference in tables of data, however, in data difference When unobvious or staff is not careful, often there is a situation where comparison result mistakes, and when data volume is big, adopt Manually mode, the low efficiency longer than the relatively more expensive time that carry out data.

Summary of the invention

The embodiment of the present application proposes a kind of data processing method, device, electronic equipment and storage medium, for solving correlation When comparing the data difference in tables of data in technology manually, processing time length, low efficiency, the technology of accuracy difference are asked Topic.

For this purpose, the application one side embodiment proposes a kind of data processing method, set this method comprises: display data compare Set interface；Compare the user's operation in set interface in response to the data, determines the first data area and second to be compared Data area；Successively read the first data content of storage from first data area, and from second data field The second data content of storage is read in domain on position corresponding with first data content position；According to described first Data content and second data content, determine data comparison result, and show the data comparison result.

The application another aspect embodiment proposes a kind of data processing equipment, which includes: display module, for showing Registration is according to comparing set interface；First determining module, for comparing the user's operation in set interface in response to the data, really Fixed first data area and the second data area to be compared；Read module, for successively being read from first data area Take the first data content of storage, and from second data area it is corresponding with first data content position The second data content of storage is read on position；Second determining module, for according to first data content and described second Data content determines data comparison result；The display module is also used to show the data comparison result.

The another aspect embodiment of the application proposes a kind of electronic equipment, including memory, processor and is stored in storage On device and the computer program that can run on a processor, when the processor executes described program, to realize first aspect reality Apply data processing method described in example.

The another aspect embodiment of the application proposes a kind of computer readable storage medium, is stored thereon with computer journey Sequence, when which is executed by processor, to realize data processing method described in first aspect embodiment.

Technical solution disclosed in the present application, has the following beneficial effects:

It realizes depending on the user's operation, comparison in difference is carried out to the data content in data area, comparison result is accurate Reliably, high-efficient, time and the energy of user are saved, user experience is improved.

The additional aspect of the application and advantage will be set forth in part in the description, and will partially become from the following description It obtains obviously, or recognized by the practice of the application.

Detailed description of the invention

The application is above-mentioned and/or additional aspect and advantage will become from the following description of the accompanying drawings of embodiments Obviously and it is readily appreciated that, in which:

Fig. 1 is the flow diagram of the data processing method of the application one embodiment；

Fig. 2-Fig. 3 is the exemplary diagram of the data processing method of the application one embodiment；

Fig. 4 is the flow diagram of the data processing method of another embodiment of the application；

Figure 5-8 is the exemplary diagram of the data processing method of the application one embodiment；

Fig. 9 is the flow diagram of the data processing method of another embodiment of the application；

Figure 10-Figure 11 is the exemplary diagram of the data processing method of another embodiment of the application；

Figure 12 is the structural schematic diagram of the data processing equipment of the application one embodiment；

Figure 13 is the structural schematic diagram of the data processing equipment of another embodiment of the application；

Figure 14 is the structural schematic diagram of the electronic equipment of the application one embodiment.

Specific embodiment

Embodiments herein is described below in detail, examples of the embodiments are shown in the accompanying drawings, wherein from beginning to end Same or similar label indicates same or similar element or element with the same or similar functions.Below with reference to attached The embodiment of figure description is exemplary, it is intended to for explaining the application, and should not be understood as the limitation to the application.

Each embodiment compares the data difference in tables of data mainly in the related technology manually in the application When, time length, low efficiency, the problem of accuracy difference are handled, proposes a kind of data processing method.

Data processing method provided by the embodiments of the present application shows that data compare set interface, then in response to number first According to the user's operation compared in set interface, the first data area and the second data area to be compared are determined, then successively from The first data content of storage is read in one data area, and from the second data area with the first data content position The second data content that storage is read on corresponding position determines number finally according to the first data content and the second data content According to comparison result, and display data comparison result, it realizes depending on the user's operation, the data content in data area is carried out Comparison in difference, comparison result is accurate and reliable, high-efficient, saves time and the energy of user, improves user experience.

Below with reference to the accompanying drawings the data processing method of the embodiment of the present application, device, electronic equipment and computer-readable are described Storage medium.

First in conjunction with attached drawing 1, data processing method provided by the embodiments of the present application is specifically described.

As shown in Figure 1, the data processing method of the application may comprise steps of:

Step 101, display data compare set interface.

Step 102, compare the user's operation in set interface in response to data, determine the first data area to be compared and Second data area.

Specifically, data processing method provided by the embodiments of the present application, it can be by data provided by the embodiments of the present application Device is managed to execute.Wherein, data processing equipment can be configured in any electronic equipment having data processing function, with right Data in tables of data are compared processing.It is helped specifically, electronic equipment can be mobile phone, computer, tablet computer, individual digital Reason etc..

It should be noted that the first data area and the second data area in the application are data location to be compared Domain can be the data region to be compared in the tables of data of any type, any pattern, for example, can be web page In tables of data in data region to be compared, or in the tables of data in the documents such as office or wps to Compare data region, the application is with the data location that the first data area and the second data area are in Excel table It is illustrated for domain.

In the exemplary embodiment, the first data area and the second data area may belong to the same tables of data, alternatively, First data area and the second data area also may belong to different tables of data, the application to this with no restriction.

Wherein, when the first data area and the second data area belong to different tables of data, the first data area and Position of two data areas in tables of data may be the same or different, the application to this with no restriction.

For example, as shown in Fig. 2, the first data area is the first tables of data of left side (worksheet i.e. in book 1 Sheet2 the region in) in box, the second data area are the second tables of data of right side (the worksheet Sheet2 i.e. in book 2) Region in middle box, the first data area and the second data area can be that the 1st row 1 column to 8 rows 2 arrange；Alternatively, such as Fig. 3 Shown, position of first data area in the first tables of data (the worksheet Sheet2 i.e. in book 1) can be the 1st row 1 Column to 8 rows 2 arrange, and position of second data area in the second tables of data (the worksheet Sheet2 i.e. in book 2) can be 2nd row 2 column to 9 rows 3 arrange.

It should be noted that in one possible implementation, the first data area and the second data area are in data The line number and columns respectively included in table can be equal, for example, in above-mentioned example the first data area and the second data area in number According in table include 8 rows 2 arrange.Alternatively, the line number that is respectively included in tables of data of the first data area and the second data area and Columns can also be unequal, at this point, data processing equipment can with display reminding information, prompt user modify the first data area or The location information of second data area；Alternatively, data processing equipment can also only compare in two data areas to be compared Partial data, for example, position of first data area in worksheet 1 is that the 1st row 1 is arranged to 8 rows 2 column, the second data area exists Position in worksheet 2 is that the 2nd row 2 is arranged to 8 rows 3 column, then data processing equipment can only compare the 1st row 1 in worksheet 1 and arrange extremely 7 rows 2 column and the data that the 2nd row 2 column are arranged to 8 rows 3 in worksheet 2, herein with no restriction.

When specific implementation, data processing equipment may include human-computer interaction interface, include data ratio in human-computer interaction interface Compared with set interface, user can be operated by comparing in set interface in data, be arranged to storage data wherein into Row compares.Correspondingly, in the embodiment of the present application, it can first show that data compare set interface, compare then in response to data User's operation in set interface determines the first data area and the second data area to be compared.

Step 103, the first data content of storage is successively read from the first data area, and from the second data area In the second data content of storage is read on position corresponding with the first data content position.

It in the embodiment of the present application, can be one by certain data definitions in data area by preset mode Data content.For example, can be a data content by the data definition in a cell by taking Excel as an example.

Wherein, the first data content position can refer to position of first data content in the first data area.Than Such as, as shown in figure 3, the first data area is the region in the box of left side book 1, then where the first data content " ccd " Position is that the 3rd row 1 of the first data area arranges.

Specifically, can be corresponding with the first data content position from the second data area in the following manner The second data content of storage is read on position:

Step 103a, obtains relative position of first data content in the first data area, and relative position includes opposite In the row offset value and column offset value of the first data area designating unit lattice.

Wherein, relative position of first data content in the first data area, can be opposite by the first data content The row offset value of designating unit lattice and column offset value characterize in the first data area.

Wherein it is possible to using cell any in the first data area as designating unit lattice.

As an example it is assumed that as shown in figure 3, the first data area is the region in the book 1 in left side in box, first Data area designating unit lattice be the first data area in the upper left corner cell, i.e., data content be " aaa " cell.Then Since the first data content " aaa " and designating unit lattice do not have row offset value and column offset value, the first data content " aaa " Relative position be 0 row 0 column.Since the first data content " ccd " and designating unit lattice offset by 2 rows 0 column, the first data The relative position of content " ccd " is 2 rows 0 column.

Step 103b obtains the physical location of the second data area designating unit lattice.

It should be noted that being read from position corresponding with the first data content position in the second data area When the second data content of storage, the first data area designating unit lattice and the second data area designating unit lattice are same position Cell, such as the cell in the respectively first data area upper left corner and the cell in the upper left corner in the second data area, Or the cell in the respectively first data area lower left corner and the cell, etc. in the lower left corner in the second data area.

Wherein, the physical location of the second data area designating unit lattice can refer to that the second data area designating unit lattice exist Physical location in tables of data.

As an example it is assumed that as shown in figure 3, the second data area is the region in the book 2 on right side in box, second Data area designating unit lattice be the second data area in the upper left corner cell, i.e., data content be " aaa " cell.Then The physical location of second data area designating unit lattice is 2 row B column.

Step 103c determines the corresponding physical location of the second data content according to physical location and relative position.

Step 103d reads the second data according to the corresponding physical location of the second data content from the second data area Content.

Specifically, the line number of physical location is added with the row offset value of relative position, by the row number of physical location and phase The column offset value of position is added, the corresponding physical location of the second data content can be obtained, so as to according in the second data Hold corresponding physical location, the second data content is read from the second data area.

As an example it is assumed that above-mentioned example is continued with, since the first data content " aaa " is in the first data area Relative position is 0 row 0 column, and the physical location of the second data area designating unit lattice is 2 row B column, then respectively by physical location Line number is added with the row offset value of relative position, and the row number of physical location is added with the column offset value of relative position, can be obtained It is 2 row B column to the corresponding physical location of the second data content, so as to according to the corresponding physical location of the second data content, The second data content " aaa " is read from the second data area.

Alternatively, since relative position of the first data content " 666 " in the first data area is 5 rows 1 column, the second data The physical location of region designating unit lattice is 2 row B column, then respectively by the row offset value phase of the line number of physical location and relative position Add, the row number of physical location is added with the column offset value of relative position, the corresponding actual bit of available second data content 7 row C column are set to, so as to read the second number from the second data area according to the corresponding physical location of the second data content According to content " 666 ".

It is understood that for the first data content and the second number in the first data area shown in above-mentioned example According to the identical situation of the second data content arrangement mode in region, in the second data area with the first data content position Corresponding position can refer in the second data area that the line number and row number with the first data content in the first data area are homogeneous Same position.

As an example it is assumed that the second data area is the region in the box of the book 2 on the right side of Fig. 2, then the second data In region, position corresponding with the first data content position " ccd " that the 3rd row 1 of the first data area arranges, for the second number It is arranged according to the 3rd row 1 in region, i.e. position " ccc " in the second data area.

Step 104, according to the first data content and the second data content, data comparison result, and display data ratio are determined Relatively result.

Specifically, can according to different comparative types, to the data in the first data area and the second data area into Row compares.

Specifically, comparative type may include a variety of, for example can compare for content, i.e., it will be each in the first data content First character is compared with each second character in same position in the second data content, to determine the first data content and the Each character in two data contents whether there is difference.Wherein, character includes but is not limited to: Chinese character, letter, number, punctuate symbol Number, oeprator, additional character (Special symbols).Wherein, additional character refers to relative to tradition or common symbol Outside, the less character of frequency of use and be difficult to the symbol directly inputted, such as: tab, mathematic sign, unit symbol, katakana, Currency symbol etc..

As an example it is assumed that the first data content is " ccd ", the second data content is " ccc ", then can be successively by first Each first character " c ", " c ", " d " in data content " ccd " respectively with each second character in the second data content " ccc " " c ", " c ", " c " are compared, and whether there is difference with each character determined in the first data content and the second data content.

Alternatively, comparative type may be that quantity compares, i.e., will include in the first data content or the second data content Reference sum in data amount check and another data content is compared, to determine in the first data content or the second data content Whether the number for the data for including and the reference sum in another data content are consistent.Specifically, can be by the first data content Or the second data in data content are separated with blank character, so as to determine data amount check according to the quantity of blank character.

As an example it is assumed that the first data content includes " aaa " " bbb " " ccc " 3 data, the second data content is 4, Reference sum 4 in data amount check 3 and the second data content in first data content can be subjected to comparison in difference, with determination Whether the reference sum in the second data content is consistent with the data amount check for including in the first data content.

In the embodiment of the present application, user can preassign comparative type, so that data processing equipment reads storage It, can be according to preassigned comparative type, by the first data content and second after first data content and the second data content Data content is compared, and display data comparison result.

That is, can also include: response selection operation before step 101, the selected relatively class of selection operation be determined Type.

Correspondingly, step 101 may include: set interface compared with obtaining data corresponding with identified comparative type, And it shows.

Step 104 may include: to carry out data ratio to the first data content and the second data content according to comparative type Compared with to obtain data comparison result, and showing data comparison result.

In the embodiment of the present application, data comparison result may include following at least one information: the first number having differences According to content and the second data content, position of the first data content having differences in the first data area is had differences Position of second data content in the second data area.

Specifically, when the first data content is identical with the second data content, can export " data are all identical " or Person's " data are consistent ", so that user understands the first data content and the second data content and do not have difference.First data content and When two data contents are not exactly the same, the knot such as " the 1st row data are incorrect " or " the 1st row data have differences " can be exported Fruit so that user understands the first data content and the second data content has differences, and understands the data having differences in data Position in region；Alternatively, can also export, " the 1st row data are incorrect！Book 1 is 111, and book 2 is the knots such as 112 " Fruit, so that user can also understand and have differences while understanding the first data content and the second data content has differences Data position in the data area and specific difference condition.

It should be noted that comparison result can be shown with written form, in exemplary embodiment in the embodiment of the present application In, comparison result can also be broadcasted with speech form, or can also export comparison result in other forms, the application to this not It is restricted.

In addition, the data processing method of the embodiment of the present application, can be realized by Labview language, can also pass through ratio Such as VB, C++, C#, Python language are realized, herein with no restriction.

In addition, in practical applications, the data in two tables of data can be compared by the data processing method of the application The difference of content, can also data content in more multiple tables of data difference, the application to this with no restriction.

As can be seen from the above description, data processing method provided by the embodiments of the present application, can be according to preassigned ratio Compared with type, the first data content in the first data area is compared with the second data content in the second data area, And show comparison result, to realize the comparison in difference to the first data content and the second data content, separately below to compare class Type is that content compares with for quantity comparison, and the data processing method of the application is further detailed.

It is to be carried out to the data processing method of the application further for content compares by comparative type below with reference to Fig. 4 Explanation.The data processing method of the embodiment of the present application may comprise steps of:

Step 201, selection operation is responded, determines the selected comparative type of selection operation.

Wherein, the comparative type in the embodiment of the present application compares for content.

Step 202, set interface compared with obtaining data corresponding with identified comparative type, and show.

Step 203, compare the user's operation in set interface in response to data, determine the first data area to be compared and Second data area.

Specifically, data compare set interface can be as shown in Figure 5 when comparative type compares for content.Data, which compare, to be set Pressing for data processing can be carried out to the input frame and trigger data processing unit that it is edited by setting settable user in interface Button.The 1st row 1 that user needs to compare worksheet Sheet2 in book 1 arranges the data that arrange to 8 rows 2, and works in book 2 When the difference for the data that the 1st row 1 column of table Sheet2 are arranged to 8 rows 2, input service book 1 and book 2 can be distinguished in input frame Store path, title, worksheet names, the initial position of data area to be compared, final position etc. information.In user After clicking the progress data processing of " starting to compare " trigger data processing unit, data processing equipment compares setting in response to data User's operation in interface determines the first data area and the second data area to be compared.

Step 204, the first data content of storage is successively read from the first data area, and from the second data area In the second data content of storage is read on position corresponding with the first data content position.

Step 205, content deltas comparison is carried out to the first data content and the second data content, compares knot to obtain data Fruit, and display data comparison result.

It is understood that the quantity arranged in the first data area can be one or more, arranged in the second data area Quantity may be one or more, the application to this with no restriction.

In the embodiment of the present application, certain in the first data area can be arranged to each row (or each column) of (either certain row) Corresponding cell, will be corresponding with the first reference cell lattice in the second data area respectively as a first reference cell lattice Cell is as the second reference cell lattice.Wherein, the first reference cell lattice or the column (or row) where the second reference cell lattice, Can be can be as the column (or row) where the data content of the index of all data contents in data area.

For example, the data in tables of data 1 are the score of all students of class, the first data area is in tables of data 1 comprising 8 Row 2 arranges, and the 1st column data is student name, and the 2nd column data is the corresponding score of different students, since student name being capable of conduct The index of the score of all classmates therefore can be using each row cell of the column where student name as one first Reference cell lattice.

In the embodiment of the present application, due to that can be used as the data content of index usually in the first row of data area, because This, can be using the corresponding cell of each row of the first row of the first data area as a first reference cell lattice, will The corresponding cell of each row of the first row of second data area is respectively as a second reference cell lattice.

Then since the initial position of the first data area, each first benchmark list for being successively read in the first data area The first data content in first lattice, and successively read since the initial position of the second data area according to identical reading order Take the second data content stored in each second reference cell lattice in the second data area.It again will be in each first reference cell lattice The first data content be compared with the second data content in each second reference cell lattice, to obtain data comparison result.

It should be noted that the different positions due to when carrying out data edition, in different data table or same tables of data It sets, the arrangement mode of each row data may be different.For example, the 1st row 1 of " aaa " in the first data area arranges in tables of data 1, The 2nd row 1 of " bbb " in the first data area arranges, and in tables of data 2, the 2nd row 1 of " aaa " in the second data area arranges, The 1st row 1 of " bbb " in the second data area arranges.If then by the 1st row 1 arranges in the first data area " aaa " and the second data field " bbb " of the 1st row 1 column of corresponding position is compared in domain, by " bbb " and the second number that the 2nd row 1 arranges in the first data area It is compared according to " aaa " of the 2nd row 1 column of corresponding position in region, will lead to comparison result inaccuracy.Therefore, in the application In embodiment, in order to improve the accuracy of comparison result, by the first data content and each second in each first reference cell lattice When the second data content in reference cell lattice is compared, in the first data in any one first reference cell lattice Hold, needs the first data content in the first reference cell lattice successively and in all second reference cell lattice for reading Second data content is compared, to obtain in the first data content and the second reference cell lattice in the first reference cell lattice The data comparison result of second data content.

When specific implementation, step 204 can be accomplished by the following way: since the initial position of the first data area, The first data content being successively read in each first reference cell lattice in the first data area；According to identical reading order, Since the initial position of the second data area, it is successively read storage each second reference cell lattice in the second data area Nei Second data content.

Correspondingly, step 205 can be accomplished by the following way: for the first number in any one first reference cell lattice According to content, by the first data content in the first reference cell lattice successively with the second number in the second reference cell lattice for reading It is compared according to content, obtains the second data in the first data content and the second reference cell lattice in the first reference cell lattice The data comparison result of content.

Wherein, the initial position of the first data area can be set as needed, can be by the first number in the embodiment of the present application Initial position according to the corresponding first reference cell lattice of the first row in region as the first data area.Read the first data area Each first reference cell lattice in the first data content when, reading order can be and first read the first of the first data area The first data content in the first capable reference cell lattice, then read in the first data in the first reference cell lattice of the second row Hold, until the first data content in the first reference cell lattice of last line is read, it is of course also possible to be other sequences, The application to this with no restriction.

It should be noted that reading out each first when the quantity arranged in the first data area and the second data area is 1 After the second data content in the first data content and each second reference cell lattice in reference cell lattice, for any one first The first data content in reference cell lattice, by its successively with the second data content in each second reference cell lattice for reading It is compared, the comparison result of all first data contents and all second data contents can be obtained.Specifically, for each The first data content in first reference cell lattice, exist in each second reference cell lattice in the second data area and its Identical second data content, then can show the result of " data are all identical " or " data are consistent ".If some first base The first data content in quasi- cell is all different with the second data content in the second all reference cell lattice, then can be with There are mistakes for the first data content for determining in the first reference cell lattice.

For example, as shown in Figure 6, it is assumed that the first data area is the region in the box of left side workbook 1, the second number It is the region in the box of right side workbook 2 according to region, since the first data area and the second data area only have a column, because This first reference cell lattice is the corresponding cell of each row in the first data area, and the second reference cell lattice are the second data The corresponding cell of each row in region.Then according to the reading order from the 1st row to eighth row, the first data area is read respectively Each row cell in the first data content be successively read each in the second data area and according to identical reading order The second data content stored in row cell.It then will be in the first data in the first data area in the cell of the 1st row Hold " aaa " to be compared with the second data content in row cell each in the second data area, then will be in the first data area The second data content in the first data content " bbb " and the second data area in the cell of 2nd row in each row cell It is compared, until by the first data content " hhh " and the second data content in the first data area in the cell of eighth row In the second data content in each row cell be compared, the inconsistent ratio of the data so as to obtain the 2nd row, the 3rd row Relatively result.

In the exemplary embodiment, when the quantity arranged in the first data area and the second data area is multiple, due to the In one data area in addition to the first reference cell lattice column, the first data content is also stored in the cell of other column, the In two data areas in addition to the second reference cell lattice column, the second data content is also stored in the cell of other column, because This by the second data content in the first data content and all second reference cell lattice in all first reference cell lattice into After going relatively, it is also necessary to compare in the first data area, the first number of other column in addition to the first reference cell lattice column According in content, with the second data area, between the second data content of other column in addition to the second reference cell lattice column Difference.

Correspondingly, step 204 can also include:

If the second data content in the first data content and any second reference cell lattice in the first reference cell lattice Unanimously, the first data content in the first data area in first content unit corresponding with the first reference cell lattice is read, with And it reads in the second data in the second data area in the second content element corresponding with any second reference cell lattice Hold.

Wherein it is possible to by the first data area, in other each columns in addition to the first reference cell lattice column, every row Corresponding cell is as a first content unit, by the second data area, in addition to the second reference cell lattice column Other each columns in, the corresponding cell of every row is as second content element.Correspondingly, with first in the first data area The first data content in the corresponding first content unit of reference cell lattice, can in the first data area with the first benchmark list The first data content in the first content cell of first lattice colleague.In second data area with any second reference cell The second data content in corresponding second content element of lattice, can in the second data area with any second reference cell The second data content in the second content cell of lattice colleague.

Specifically, if the first data content in the first reference cell lattice and the second number in any second reference cell lattice It is consistent according to content, then it can read in the first data area in first content unit corresponding with the first reference cell lattice One data content, and read in the second data area in the second content element corresponding with the second reference cell lattice second Data content, then by the first data content in the first content unit and the second data content in second content element It is compared, obtains the first data content in the first content unit and the second data content in second content element Data comparison result.

I.e. step 205 can also include: will be in the first data content and the second content element in first content unit Second data content is compared, and obtains the second number in the first data content and the second content element in first content unit According to the data comparison result of content.

For example, as shown in Figure 7, it is assumed that the first data area is the region in the box of left side workbook 1, A column 1st row to the corresponding each unit lattice of eighth row are respectively a first reference cell lattice.Second data area is right side workbook 2 Box in region, A column the 1st row to the corresponding each unit lattice of eighth row be a second reference cell lattice.According to from the 1st Row arrives the reading order of eighth row, reads first in the 1st row to the corresponding each unit lattice of eighth row of the first data area respectively Data content, and according to identical reading order is successively read the 1st row in the second data area to the corresponding each list of eighth row After the second data content stored in first lattice, in the cell that the 1st row A read out in the first data area can be arranged the Each second data content in one data content " aaa " and the 1st row in the second data area to the corresponding cell of eighth row carries out Compare, then the first data content " bbb " in the cell of the 2nd row A read out in the first data area column is counted with second It is compared according to each second data content in region in the 1st row to the corresponding cell of eighth row, until by the first data area The first data content " hhh " in the cell of middle eighth row A column and the 1st row in the second data area are to the corresponding unit of eighth row Each second data content in lattice is compared.

Since the first data content " aaa " that the 1st row A is arranged in the first data area is arranged with the 1st row A in the second data area The second data content " aaa " unanimously, then can read in the first data area with the 1st row A column cell go together first The first data content " 111 " in the content cell cells of column (i.e. the 1st row B), and read in the second data area with the 1st The second data content " 112 " of the 1st row B column of the cell colleague of row A column, and " 111 " and " 112 " are compared, thus Obtain the data comparison result of the 1st row in the 1st row and the second data area in the first data area.

In the same fashion, then it can be concluded that in the first data area and the second data area other rows comparison knot Fruit.For example, can determine the first data content " eee " and the second data that the 5th row A is arranged in the first data area by comparing The second data content " eee " that the 6th row A is arranged in region unanimously, then can read the list in the first data area with the 5th row A column The first data content " 556 " in the first content cell (i.e. the cells of the 5th row B column) of first lattice colleague, and read second The second data content " 555 " for the 6th row B column gone together in data area with the cell of the 6th row A column, and by " 556 " and " 555 " are compared, and obtain the data comparison result of the 6th row in the 5th row and the second data area in the first data area.

It should be noted that in the present embodiment, the first data content and any second base in the first reference cell lattice When the second data content in quasi- cell is consistent, in the second data area with the first data content in the first reference cell lattice The corresponding position in position, the as position where any second reference cell lattice, in the second data area with the first base The corresponding position in the first data content position in the corresponding first content cell of quasi- cell, as with this any Position where corresponding second content cell of two benchmark cells.For example, as shown in fig. 7, in the second data area, with The corresponding position in the position the first data content " eee " in cell that the 5th row A is arranged in one data area, for the second number Position where the cell arranged according to the 6th row A in region；In second data area, arranged with the 5th row B in the first data area The corresponding position in the first data content " 556 " position in cell is the unit of the 6th row B column in the second data area Position where lattice.

It is worth noting that, when above-described embodiment is to carry out data assignment in tables of data, it will be as index Data content is arranged in be illustrated in same row, in practical applications, can be using will as the data content of index Arrangement is in the same row.For example, the 1st row 1 column are classified as the name of all students in class, the 2nd row 1 column to the 2nd row 8 to the 1st row 8 It is classified as the corresponding score of all students.Then in specific implementation, each column of certain row in the first data area can also be corresponded to Cell respectively as a first reference cell lattice, by the corresponding cell point of each column of certain row in the second data area Not Zuo Wei a second reference cell lattice, in mode similar to the above embodiments, to the first data area and the second data field Data in domain are compared.

Specifically, can in the following manner, the content deltas for obtaining the first data content and the second data content compares As a result: successively carrying out the second character in each first character and the second data content in the first data content in same position Compare, to obtain data comparison result.

For example, as shown in Figure 2 and Figure 5, it is assumed that the comparative type that user selects compares for content, and user is in data ratio It is corresponding compared with the operation carried out in set interface as shown in figure 5, corresponding first data area is the region on the left of Fig. 2 in box The second data area be region on the right side of Fig. 2 in box.

Then read out in the first data content and the second data area in the first data area with the first data content institute After the second data content on the corresponding position in position, the first data content and the second data content can be subjected to interior tolerance Different comparison, to obtain data comparison result.With " bbb " for arranging the 2nd row A in the first data area, in the second data area 2nd row A column " bbb " carry out content comparison for, due to each first character in the first data content be " b ", " b ", " b ", " " (i.e. space), each second character in the second data content are " b ", " b ", " b ", then can be first by the first data content The 1st the first character " b " in " bbb " is compared with the 1st the second character " b " in the second data content " bbb ", then will The 2nd the second character " b " in the 2nd the first character " b " and the second data content " bbb " in first data content " bbb " Be compared, then by the first data content " bbb " the 3rd the first character " b " and the second data content " bbb " in the 3rd A second character " b " is compared, then by the first data content " bbb " the 4th the first character " " and the second data content The 4th the second character in " bbb " is compared.It, then can be true due to not including the 4th the second character in the second data content Each character in fixed first data content and the second data content has differences.It will be in each first data in the first data area Hold after being compared in a manner described with each second data content in the second data area, it can be shown in 5 lower section of display diagram Data comparison result.

Similar, as shown in figures 3 and 8, it is assumed that the comparative type that user selects compares for content, and user compares in data The operation that carries out in set interface is corresponding as shown in figure 8, corresponding first data area is the region on the left of Fig. 3 in box Second data area is the region on the right side of Fig. 3 in box.Then read out the first data content and second in the first data area It, can will be in the first data after the second data content in data area on position corresponding with the first data content position Hold and the second data content carries out content deltas comparison, and obtains data comparison result shown in the lower section Fig. 8.

It should be noted that in the embodiment of the present application, it can be every time by the first data content read and the second number After carrying out content relatively according to content, that is, show a comparison result, it can also be by all the first data content and all After second data content carries out content relatively, disposably show all comparison results, the application to this with no restriction.

It is understood that by data processing method provided by the embodiments of the present application, two data fields to be compared Data content in domain distinguishes very little, such as only the difference in more spaces or a few space when, also can accurately be compared Compared with as a result, and since such case is difficult to discover out by way of manually comparing, number provided by the embodiments of the present application According to processing mode, compared to artificial manner of comparison, not only accuracy rate is high, also improves data-handling efficiency, save user when Between and energy, improve user experience.

It is to be carried out to the data processing method of the application further for quantity compares by comparative type below with reference to Fig. 9 Explanation.The data processing method of the embodiment of the present application may comprise steps of:

Step 301, selection operation is responded, determines the selected comparative type of selection operation.

Wherein, the comparative type in the embodiment of the present application compares for quantity.

It is understood that often may require that the quantity of certain data in statistics table in practice.For example, The each of certain element uses position in writing circuit plate, and counts number of positions, in this, as the foundation for purchasing the element；Alternatively, The attendance time of certain employee is recorded, and counts number of days of turning out for work, in this, as the granting standard, etc. of full work attendance bonus.This is just needed Guarantee the correctness of the data bulk counted in tables of data.

Step 302, set interface compared with obtaining data corresponding with identified comparative type, and show.

Step 303, compare the user's operation in set interface in response to data, determine the first data area to be compared and Second data area.

Specifically, data compare set interface can be as shown in Figure 10 when comparative type compares for quantity.Data, which compare, to be set Setting can be set user and can carry out data processing to input frame and trigger data processing unit that it is edited in interface Button.It, can be in input frame when user needs to judge whether the number of devices that counts is correct in stock table that supplier provides The store path of input stock table, title, worksheet names, the initial position of data area to be compared, final position respectively Etc. information.After user clicks the progress data processing of " starting to compare " trigger data processing unit, data processing equipment Compare the user's operation in set interface in response to data, determines the first data area and the second data area to be compared.

Step 304, the first data content of storage is successively read from the first data area, and from the second data area In the second data content of storage is read on position corresponding with the first data content position.

Wherein, the second data content is the reference sum for the data amount check for including in the first data content.

It in the embodiment of the present application, may include one or more data in the first data content, the second data content can The reference sum for thinking the data amount check for including in the first data content, thus the quantity of the data processing method by the application Whether the mode compared, the reference sum compared in the second data content are a with the reality for the data for including in the first data content Whether number is equal, that is, can determine whether the second data content is correct to the statistics of the data amount check in the first data content.

It should be noted that if each first data content in the first data area is located at the list that do not go together of same column It, usually will be every when being counted due to the number for the data for usually including to each data content in certain column data content in first lattice The corresponding statistical result of a data content is arranged in the other column gone together with the data content, therefore, in the embodiment of the present application, Position corresponding with the first data content position in second data area, can be in the second data area with this first number According to the position where the cell of content colleague.

Similar, if in the cell for the different lines that each first data content in the first data area is located at colleague When, then position corresponding with the first data content position in the second data area, can be in the second data area and is somebody's turn to do Position where the cell of first data content same column.

Wherein, the specific implementation process and principle of above-mentioned steps 301-304 is referred to retouching in detail for above-described embodiment It states, details are not described herein again.

Step 305, it according to the quantity for the blank character for including in the first data content, determines in the first data content and includes The number of data.

Wherein, it is separated between each data in the first data content by blank character.

Wherein, the type of blank character, can according to need any setting, the application to this with no restriction.Such as comma, sky The symbol that lattice, pause mark etc. can arbitrarily separate data cell.

It is understood that when recording data in tables of data, it will usually utilize a blank character by two data cells It separates, in this application, the type of blank character can be preset, thus after reading the first data content, it can basis The quantity for the blank character for including in first data content determines the number for the data for including in the first data content.Wherein, first The number for the data for including in data content is that the quantity for the blank character for including adds 1 in the first data content.

It should be noted that do not include separator in the first data content when the first data content includes 1 data, because This, includes data in the first data content, but when not including separator, that is, can determine the number of the data of the first data content It is 1.

Step 306, compare the number for the data for including in the first data content and the reference sum in the second data content It is whether consistent, to obtain data comparison result.

For example, as shown in Figure 10 and Figure 11, it is assumed that the comparative type that user selects compares for quantity, and user is in data It is as shown in Figure 10 to compare the operation carried out in set interface, corresponding first data area is 5 rows in stock table shown in Figure 11 The column data that 13 column start, corresponding second data area are a column data of 14 column in Figure 11.Wherein, 5 rows in Figure 11 The data of 13 column are the data of Ref.Des device position column, and device position number is used to characterize device in the circuit board Using position, the data of 14 column are the data of QTY dosage column, and each row of data of the column is used to count the device position of corresponding row Set number amount.Then, data processing equipment can read the first data content of the 5th row 13 column and the reference sum of 5 rows 14 column 1, since the reference sum that the number that 5 rows 13 arrange the data for including is 0,5 rows 14 column is 1, then it can determine the first data content In include data number and the second data content reference sum it is unequal, thus " the 5th row shown in exporting below Figure 10 Data are incorrect！Practical is 0, but Qty is shown as 1 ", what the first data content and 6 rows 14 for then reading the 6th row 13 column arranged With reference to sum 1, and export that " the 6th row data are incorrect！Practical is 0, but Qty is shown as 1 " comparison result, then reads the 7th The reference sum 14 of the first data content and 7 rows 14 column that row 13 arranges, and according to the number of blank character comma in the first data content Amount 13 determines that the number for the data that the first data content includes is 14, the number for the data for then including by the first data content It 14 and 14 is compared with reference to sum, the actual number for the data for including due to the first data content is equal with reference to sum, then It can not show the comparison result, continue the reference sum for reading the first data content and 8 rows 14 column that eighth row 13 arranges, until Completion compared with all data that all data that 5 rows 13 arrange beginning are started with 5 rows 14 column are whole.

The data processing equipment of the embodiment of the present application proposition is described with reference to the accompanying drawings.

As shown in figure 12, the data processing equipment include: display module 11, the first determining module 12, read module 13 and Second determining module 14.

Wherein, display module 11, for showing that data compare set interface；

First determining module 12 determines to be compared for comparing the user's operation in set interface in response to the data The first data area and the second data area；

Read module 13, for successively reading the first data content of storage, Yi Jicong from first data area It is read in the second data of storage on position corresponding with first data content position in second data area Hold；

Second determining module 14, for determining data ratio according to first data content and second data content Relatively result；

The display module 11 is also used to show the data comparison result.

Specifically, data processing equipment provided by the embodiments of the present application, can execute described in the application previous embodiment Data processing method.

In one possible implementation, the quantity arranged in first data area is one or more, described The quantity arranged in second data area is one or more.

In alternatively possible implementation, first data area and second data area belong to same Tables of data；Or

First data area and second data area belong to different tables of data.

In alternatively possible implementation, data comparison result comprises at least one of the following information: having differences First data content and the second data content, position of the first data content having differences in first data area, Position of the second data content having differences in second data area.

It should be noted that the implementation process and technical principle of the data processing equipment of the present embodiment are referring to aforementioned to first The explanation of the data processing method of aspect embodiment, details are not described herein again.

Data processing equipment provided by the embodiments of the present application shows that data compare set interface, then in response to number first According to the user's operation compared in set interface, the first data area and the second data area to be compared are determined, then successively from The first data content of storage is read in one data area, and from the second data area with the first data content position The second data content that storage is read on corresponding position determines number finally according to the first data content and the second data content According to comparison result, and display data comparison result, it realizes depending on the user's operation, the data content in data area is carried out Comparison in difference, comparison result is accurate and reliable, high-efficient, saves time and the energy of user, improves user experience.

In the exemplary embodiment, a kind of data processing equipment is additionally provided.

Referring to Fig.1 shown in 3, in the data processing equipment of the application, the second determining module 14, comprising:

Content comparing unit 141, for carrying out content deltas to first data content and second data content Compare, to obtain the data comparison result.

In one possible implementation, read module 13 are specifically used for: the start bit from first data area Beginning is set, the first data content being successively read in each first reference cell lattice in first data area；According to identical Reading order, since the initial position of second data area, be successively read in second data area each The second data content stored in two benchmark cells；

Correspondingly, content comparing unit 141, is specifically used for: for the first data in any one first reference cell lattice Content, by the first data content in the first reference cell lattice successively and in the second reference cell lattice for reading Second data content is compared, and obtains the first data content and second reference cell in the first reference cell lattice The data comparison result of the second data content in lattice.

In alternatively possible implementation, read module 13 is also used to: if in the first reference cell lattice One data content is consistent with the second data content in any second reference cell lattice, read in first data area with institute The first data content in the corresponding first content unit of the first reference cell lattice is stated, and is read in second data area The second data content in the second content element corresponding with any second reference cell lattice；

Correspondingly, content comparing unit 141, is also used to: by the first content unit the first data content and institute The second data content stated in the second content element is compared, obtain the first data content in the first content unit with The data comparison result of the second data content in second content element.

In alternatively possible implementation, the content comparing unit 141 is specifically used for: successively by described first Each first character in data content is compared with the second character in same position in second data content, to obtain The data comparison result.

In alternatively possible implementation, above-mentioned second determining module 14, further includes: determination unit 142 is used for root According to the quantity for the blank character for including in first data content, for the data for including in first data content is determined Number, wherein separated between each data in first data content by blank character；

Quantity comparing unit 143, the number and described second of the data for including in first data content Whether the reference sum in data content is consistent, to obtain the data comparison result.

In alternatively possible implementation, described device, further includes: third determining module 15, for responding selection Operation, determines the selected comparative type of the selection operation；

The display module 11, is specifically used for: set interface compared with obtaining data corresponding with identified comparative type, And it shows；

Second determining module 14, is specifically used for: according to the comparative type, to the first data content and described second Data content carries out data comparison, to obtain the data comparison result.

In order to realize above-described embodiment, the application also proposes a kind of electronic equipment.Figure 14 is the application one embodiment The structural schematic diagram of electronic equipment.The electronic equipment that Figure 14 is shown is only an example, should not be to the function of the embodiment of the present application Any restrictions can be brought with use scope.

As shown in figure 14, above-mentioned electronic equipment includes: memory 1001, processor 1002 and is stored on memory 1001 And the computer program that can be run on processor 1002, when the processor 220 executes described program, realize that first aspect is real Apply data processing method described in example.

In one possible implementation, electronic equipment further include:

Communication interface 1003, for the communication between memory 1001 and processor 1002.

Memory 1001, for storing the computer program that can be run on processor 1002.

Memory 1001 may include high speed RAM memory, it is also possible to further include nonvolatile memory (non- Volatile memory), a for example, at least magnetic disk storage.

Processor 1002 realizes data processing method described in above-described embodiment when for executing described program.

If memory 1001, processor 1002 and the independent realization of communication interface 1003, communication interface 1003, memory 1001 and processor 1002 can be connected with each other by bus and complete mutual communication.The bus can be industrial standard Architecture (Industry Standard Architecture, referred to as ISA) bus, external equipment interconnection (Peripheral Component, referred to as PCI) bus or extended industry-standard architecture (Extended Industry Standard Architecture, referred to as EISA) bus etc..The bus can be divided into address bus, data/address bus, control Bus processed etc..Only to be indicated with a thick line in Figure 14, it is not intended that an only bus or a type of convenient for indicating Bus.

Optionally, in specific implementation, if memory 1001, processor 1002 and communication interface 1003, are integrated in one It is realized on block chip, then memory 1001, processor 1002 and communication interface 1003 can be completed mutual by internal interface Communication.

Processor 1002 may be a central processing unit (Central Processing Unit, referred to as CPU), or Person is specific integrated circuit (Application Specific Integrated Circuit, referred to as ASIC) or quilt It is configured to implement one or more integrated circuits of the embodiment of the present application.

It should be noted that the implementation process and technical principle of the electronic equipment of the present embodiment are referring to aforementioned to first aspect The explanation of the data processing method of embodiment, details are not described herein again.

To realize above-described embodiment, the application also proposes a kind of computer readable storage medium.

The wherein computer readable storage medium, is stored thereon with computer program, when which is executed by processor, with Realize data processing method described in first aspect embodiment.

To realize above-described embodiment, the application also proposes a kind of computer program, when the instruction in computer program product When being executed by processor, data processing method as in the foregoing embodiment is executed.

In the description of this specification, reference term " one embodiment ", " some embodiments ", " example ", " specifically show The description of example " or " some examples " etc. means specific features, structure, material or spy described in conjunction with this embodiment or example Point is contained at least one embodiment or example of the application.

In addition, term " first ", " second " are used for descriptive purposes only and cannot be understood as indicating or suggesting relative importance Or implicitly indicate the quantity of indicated technical characteristic.Define " first " as a result, the feature of " second " can be expressed or Implicitly include at least one this feature.

Any process described otherwise above or method description are construed as in flow chart or herein, and expression includes It is one or more for realizing specific logical function or process the step of executable instruction code module, segment or portion Point, and the range of the preferred embodiment of the application includes other realization, wherein can not press shown or discussed suitable Sequence, including according to related function by it is basic simultaneously in the way of or in the opposite order, Lai Zhihang function, this should be by the application Embodiment person of ordinary skill in the field understood.

It should be appreciated that each section of the application can be realized with hardware, software, firmware or their combination.Above-mentioned embodiment party In formula, the software or firmware that multiple steps or method can be executed in memory and by suitable instruction execution system with storage are real It is existing.It, and in another embodiment, can be in following technology well known in the art for example, if realized with hardware Any one or their combination are realized: having a discrete logic for realizing the logic gates of logic function to data-signal Circuit, the specific integrated circuit with suitable combinational logic gate circuit, programmable gate array (PGA), field-programmable gate array Arrange (FPGA) etc..

Those skilled in the art are understood that realize all or part of step that above-described embodiment method carries It suddenly is that relevant hardware can be instructed to complete by program, the program can store in a kind of computer readable storage medium In, which when being executed, includes the steps that one or a combination set of embodiment of the method.

Storage medium mentioned above can be read-only memory, disk or CD etc..Although having been shown and retouching above Embodiments herein is stated, it is to be understood that above-described embodiment is exemplary, and should not be understood as the limit to the application System, those skilled in the art can be changed above-described embodiment, modify, replace and become within the scope of application Type.

Claims

1. a kind of data processing method characterized by comprising

Display data compare set interface；

Compare the user's operation in set interface in response to the data, determines the first data area and the second data to be compared Region；

The first data content of storage is successively read from first data area, and from second data area with The second data content of storage is read on the corresponding position in first data content position；

According to first data content and second data content, data comparison result is determined, and show the data ratio Relatively result.

2. the method according to claim 1, wherein described count according to first data content with described second According to content, data comparison result is determined, comprising:

Content deltas comparison is carried out to first data content and second data content, compares knot to obtain the data Fruit.

3. according to the method described in claim 2, it is characterized in that, successively reading the of storage from first data area One data content, and read from position corresponding with first data content position in second data area Second data content of storage, comprising:

Since the initial position of first data area, each first benchmark list for being successively read in first data area The first data content in first lattice；According to identical reading order, since the initial position of second data area, successively Read the second data content stored in each second reference cell lattice in second data area；

Content deltas comparison is carried out to first data content and second data content, compares knot to obtain the data Fruit, comprising:

For the first data content in any one first reference cell lattice, by the first data in the first reference cell lattice Content is successively compared with the second data content in the second reference cell lattice read, obtains first benchmark The data comparison result of the second data content in the first data content and the second reference cell lattice in cell.

4. according to the method described in claim 3, it is characterized in that, successively reading the of storage from first data area One data content, and read from position corresponding with first data content position in second data area Second data content of storage, further includes:

If the second data content in the first data content and any second reference cell lattice in the first reference cell lattice Unanimously, the first data in first data area in first content unit corresponding with the first reference cell lattice are read Content, and read in second data area in the second content element corresponding with any second reference cell lattice Second data content；

The first data content in the first content unit and the second data content in second content element are carried out It compares, obtains the first data content in the first content unit and the second data content in second content element Data comparison result.

5. according to the method described in claim 2, it is characterized in that, described to first data content and second data Content carries out content deltas comparison, to obtain the data comparison result, comprising:

Successively by each first character in first data content and second in same position in second data content Character is compared, to obtain the data comparison result.

6. the method according to claim 1, wherein described count according to first data content with described second According to content, data comparison result is determined, comprising:

According to the quantity for the blank character for including in first data content, the data for including in first data content are determined Number, wherein separated between each data in first data content by blank character；

Compare the number for the data for including in first data content and reference in second data content it is total whether Unanimously, to obtain the data comparison result.

7. method according to claim 1-6, which is characterized in that the data comparison result include it is following at least A kind of information: the first data content and the second data content having differences, the first data content having differences is described Position in one data area, position of the second data content having differences in second data area.

8. a kind of data processing equipment characterized by comprising

Display module, for showing that data compare set interface；

First determining module determines to be compared first for comparing the user's operation in set interface in response to the data Data area and the second data area；

Read module, for successively reading the first data content of storage from first data area, and from described The second data content of storage is read in two data areas on position corresponding with first data content position；

Second determining module, for determining data comparison result according to first data content and second data content；

The display module is also used to show the data comparison result.

9. a kind of electronic equipment characterized by comprising

Memory, processor and storage are on a memory and the computer program that can run on a processor, the processor are held Such as data processing method of any of claims 1-7 is realized when row described program.

10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the program is by processor Such as data processing method of any of claims 1-7 is realized when execution.