CN102200968A - Method and device for removing duplications of EXCEL form data - Google Patents
Method and device for removing duplications of EXCEL form data Download PDFInfo
- Publication number
- CN102200968A CN102200968A CN2011101429557A CN201110142955A CN102200968A CN 102200968 A CN102200968 A CN 102200968A CN 2011101429557 A CN2011101429557 A CN 2011101429557A CN 201110142955 A CN201110142955 A CN 201110142955A CN 102200968 A CN102200968 A CN 102200968A
- Authority
- CN
- China
- Prior art keywords
- data
- tabulation
- array
- title
- module
- 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
Images
Landscapes
- Document Processing Apparatus (AREA)
Abstract
The invention belongs to the technical field of computer software, and in particular relates to a method and device for removing duplications of EXCEL form data. The method for removing duplications of the EXCEL form data comprises the following steps of: a, reading a preset or agreed heading line of an EXCEL list and setting an agreed format for a heading needing data duplication removal; b, comparing other lists according to a target list, and locating the line data with equal positions in the same agreed format heading corresponding to other lists and the target list; and c, outputting the compared data to a newly created EXCEL form. The technical scheme provided by the invention has the following advantages or beneficial effects that: according to the method and the device provided by the invention for removing duplications of the EXCEL form data, the list needing the duplication removal is selected, the agreed format is preset, the program immediately performs the duplication removal on the list when reading the format identical to the agreed format, and the using experience of a user is improved.
Description
Technical field
The invention belongs to computer software technical field, relate in particular to the heavy method and apparatus of a kind of Microsoft Excel data row.
Background technology
Excel is as an office software, and its strong functions has satisfied the most user demand of people substantially, but for some finer demands, still can not realize.For example, two list of songs with the Excel table storage are arranged, be respectively tabulation 1 and tabulation 2, field in the tabulation has: song title, singer's name, types of songs, singer's type, languages, speech author, speech copyright ratio, bent author, bent copyright ratio, album name, need find out song title in two tabulations, record that singer's name is all the same with copyright now; Perhaps need all records in the batch processing tabulation 1, and indicate state after each bar record and the tabulation 2 relatively (state as: 1, tabulation 2 does not exist, 2, tabulation 2 exists), again or need row to overlap and tabulate 1 and tabulation 2, and indicate merge the state of all records of back after relatively (state as: 1, only tabulate and 1 exist, 2, only tabulate and 2 exist, 3, all exist), for the demand, existing Excel form can't be realized.
Though, in the existing method the Excel form built-in a function vlookup, this function can be related by a row conduct wherein in two tabulations, find out two the tabulation duplicate records and be presented at one of them the tabulation in, but the association when this method can not realize that multiple row equates can not be arranged and overlapped and tabulation, and can't realize showing in batches the state after each bar record relatively, cause the user demand that to satisfy the user, influence user's experience.
Summary of the invention
The invention provides the heavy method and apparatus of a kind of Microsoft Excel data row, be intended to solve in the prior art because the association of EXCEL can not realize that multiple row equates the time, can not arrange and overlap and tabulation, and can't realize that batch shows the state after each bar writes down relatively, cause and to satisfy user's user demand, influence the problem of user's experience.
The present invention is achieved in that the heavy method of a kind of Microsoft Excel data row, comprises
Step a: read the header line of the EXCEL tabulation that sets in advance or arrange, the agreement form is set for needing the heavy title of data row;
Step b:, find out other tabulations and the object listing line data that the position equates in the title of corresponding same agreement form according to relatively other tabulations of object listing;
Step c: the data after will comparing output to newly-built Microsoft Excel.
Technical scheme of the present invention also comprises: also comprise between described step a and the described step b: read object listing, obtain all titles in the object listing, and judge the title of the form of whether having an agreement in the object listing, if do not arrange the title of form in the object listing, prompting user title agreement form is not provided with heavily failure of data row; The title of form if having an agreement in the object listing is kept at the caption position of arranging form in the object listing in the middle p1 array, and reads all line data in the object listing, and all line data of object listing are kept among the tabulation list1.
Technical scheme of the present invention also comprises: also comprise between described step a and the described step b: read other tabulations, obtain all titles in other tabulations, find out other the tabulation in the p1 array in corresponding title, the position of this title is kept in the p2 array, and judge whether the p1 array is the same with the size of p2 array, if p1 array and p2 array is in different size, prompting user list title is not quite identical, heavily failure of data row; If the p1 array is big or small the same with the p2 array, then reads all line data in other tabulations, and other all line data of tabulating are kept among the tabulation list2.
Technical scheme of the present invention also comprises: described step b also comprises: traversal of lists list1, and judge whether also have line data among the tabulation list1, if also have line data among the tabulation list1, list1 takes out this line data from tabulation, and judge whether tabulation list2 has and this line data data that the position equates in the p1 array in the p2 array; If do not have line data, execution in step c among the tabulation list1.
Technical scheme of the present invention also comprises: described step b also comprises: if tabulation list2 does not have and this line data data that the position equates in the p1 array in the p2 array, the state of pointing out this line data is that only object listing exists; If tabulation list2 has in the p2 array and this line data data that the position equates in the p1 array, the state of pointing out this line data is that a plurality of tabulations exist, and the display list title.
Technical scheme of the present invention also comprises: described step c also comprises: the data mode after showing relatively in newly-built Microsoft Excel.
Technical scheme of the present invention also comprises: in described step a, the described EXCEL tabulation that needs data row to weigh comprises two or more, when needing the heavy EXCEL tabulation of data rows when a plurality of, also comprise between described step a and the described step b: reading needs the heavy a plurality of listed files titles of data row, and travel through each listed files, judge whether also to exist the alternative document tabulation, if also there is the alternative document tabulation, then read this document tabulation, obtain the title in this document tabulation, the caption position corresponding with the p1 array in this document tabulation is kept in the p2 array; If there is no alternative document tabulation, then newly-built new tabulation.
Another technical scheme of the present invention: the heavy device of a kind of Microsoft Excel data row: comprise that tabulation is provided with module, the 3rd data judge module and data outputting module, described tabulation is provided with the header line that module is used to read the EXCEL tabulation that sets in advance or arrange, for needing the heavy title of data row that the agreement form is set, and definite object listing, described the 3rd data judge module is used for judging the line data whether other tabulations and object listing have the position to equate according to relatively other tabulations of object listing in the title of corresponding same agreement form; Described data outputting module is used for a newly-built new Microsoft Excel, and the data after the comparison are outputed to new Microsoft Excel, and the data mode after showing relatively.
Technical scheme of the present invention also comprises: the heavy device of Microsoft Excel data row of the present invention also comprises form judge module, first memory module, data read module, second memory module, the first data judge module and the 3rd memory module,
Described form judge module is used for obtaining all titles of object listing, and judge whether the boldface type of adding title is arranged in the object listing, if do not add the boldface type title in the object listing, there is not overstriking by information indicating module prompting title font, if the boldface type of adding title is arranged in the object listing, by first memory module storage title data;
Described first memory module is used for object listing is added the location storage of boldface type title in the p1 array;
Described data read module is used for all line data of object listing are kept at tabulation list1;
Described second memory module is used for finding out other tabulations title corresponding with the p1 array, and the position of this title is kept in the p2 array;
The described first data judge module is used to judge whether the p1 array is the same with the size of p2 array, if p1 array and p2 array is in different size, points out user's title not quite identical by the information indicating module; If the p1 array is big or small the same with the p2 array, read line data by the 3rd memory module;
Described the 3rd memory module is used for other all line data of tabulating are kept at tabulation list2.
Technical scheme of the present invention also comprises: the heavy device of Microsoft Excel data row of the present invention also comprises the second data judge module, condition prompting module and the 4th memory module,
The described second data judge module is used for judging whether tabulation list1 also has line data, if also have line data among the tabulation list1, extracts line data by data extraction module,
Described condition prompting module is used for the judged result prompting user data state according to the 3rd data judge module,
Described the 4th memory module is used for newly-built new tabulation newlist, the data of the row's of depositing anharmonic ratio after.
Technical scheme of the present invention has following advantage or beneficial effect: method that Microsoft Excel data row of the present invention is heavy and device are by selecting heavy tabulation and the field of needs row, and set in advance a kind of agreement form and be used for representing that whether association equates, when program reads when arranging the identical form of form, promptly this tabulation is arranged anharmonic ratio, comparative result outputed in the new Excel form merge, and the data mode after last lattice of form show relatively, make things convenient for the data after the user sees own comparison fast; The present invention is convenient to use, satisfies user's user demand, promotes user's experience.
Description of drawings
Accompanying drawing 1 is the process flow diagram of the heavy method of the Microsoft Excel data row of first embodiment of the invention;
Accompanying drawing 2 is process flow diagrams of the heavy method of the Microsoft Excel data row of second embodiment of the invention;
Accompanying drawing 3 is process flow diagrams of the heavy method of the Microsoft Excel data row of third embodiment of the invention;
Accompanying drawing 4 is structural representations of the heavy device of the Microsoft Excel data row of first embodiment of the invention;
Accompanying drawing 5 is structural representations of the heavy device of the Microsoft Excel data row of second embodiment of the invention;
Accompanying drawing 6 is structural representations of the heavy device of the Microsoft Excel data row of third embodiment of the invention.
Embodiment
In order to make purpose of the present invention, technical scheme and advantage clearer,, the present invention is further elaborated below in conjunction with drawings and Examples.Should be appreciated that specific embodiment described herein only in order to explanation the present invention, and be not used in qualification the present invention.
Seeing also Fig. 1, is that the Microsoft Excel data of first embodiment of the invention are arranged the process flow diagram of heavy method.The heavy method of Microsoft Excel data row of first embodiment of the invention may further comprise the steps:
Step 100: read the header line of the EXCEL tabulation that sets in advance or arrange, the agreement form is set for needing the heavy title of data row;
In step 100, agreement needs the first behavior title of the heavy EXCEL tabulation of data row usually, also can be according to user's needs, and any behavior header line of setting or agreement EXCEL tabulation.
Step 110:, find out other tabulations and the object listing line data that the position equates in the title of corresponding same agreement form according to relatively other tabulations of object listing;
In step 110, finding out other line data that equate with the object listing position of tabulating specifically comprises: the position of agreement form title in the object listing is kept in the p1 array, find out other the tabulation in the p1 array in corresponding title, and the position of this title is kept in the p2 array, read the line data of object listing and other tabulations, judge whether other tabulations have in the p2 array and the object listing data that the position equates in the p1 array, other tabulations are the line data that other tabulations equate with the object listing position with the object listing data that the position equates in the p1 array in the p2 array.
Step 120: the data after will comparing output to newly-built Microsoft Excel.
In step 120, the data mode after also showing relatively in newly-built Microsoft Excel can be presented at the data mode after the comparison last hurdle of newly-built Microsoft Excel, certainly according to user's needs, and the setting that Shows Status Bar.
Seeing also Fig. 2, is that the Microsoft Excel data of second embodiment of the invention are arranged the process flow diagram of heavy method.The heavy method of Microsoft Excel data row of second embodiment of the invention may further comprise the steps:
Step 200: first provisional capital of two EXCEL tabulations is made as title, need in the title determines the heavy key word of data row, a kind of agreement form is set for needing the heavy key word in title of data row, and definite object listing;
In step 200, can be according to user's needs, be provided with or arrange any behavior header line of EXCEL tabulation, in addition, the EXCEL tabulation allows multiple row and exists, for being provided with the agreement form, key word is used to judge whether association equates that this agreement form can be provided with according to different demands by the user; For example: the agreement form is for to judge that whether key word is for adding boldface type, so just need to carry out the heavy key word font of data row in the title with all EXCEL tabulations and carry out overstriking, when reading the key word that adds boldface type, program just shows that this key word need carry out data row and weigh, the user can set up one or more needs on their own according to different demands and carry out the heavy critical field of data row, not necessarily mates all header fields entirely;
In second embodiment of the invention, suppose that two EXCEL tabulations are respectively tabulation 1 and tabulation 2, wherein, tabulation 1 is an object listing, and tabulation 2 is for needing tabulation relatively, and the agreement form is the title font-weight.
Step 210: read object listing 1, obtain all titles in the tabulation 1, and judge in the tabulation 1 whether the boldface type of adding title is arranged, do not add the boldface type title if tabulate in 1, execution in step 220 has the boldface type of adding title, execution in step 230 if tabulate in 1;
Step 220: prompting user title font does not have overstriking, heavily failure of data row, and execution in step 380;
In this step, if judge that the related agreement form that whether equates is an extended formatting, then the extended formatting that is provided with according to the user carries out corresponding prompt.
Step 230: the position that adds the boldface type title in the object listing 1 is kept in the p1 array;
Step 240: read all line data in the object listing 1, and 1 all line data of will tabulating are kept among the tabulation list1;
Step 250: read tabulation 2, obtain all titles in the tabulation 2;
Step 260: find out in the tabulation 2 with the p1 array in corresponding title, and the position of this title is kept in the p2 array;
Step 270: judge whether the p1 array is the same with the size of p2 array, if p1 array and p2 array is in different size, execution in step 280; If the p1 array is big or small the same with the p2 array, execution in step 290;
Step 280: two tabulations of prompting user title is not quite identical, heavily failure of data row, and execution in step 380;
Step 290: read all line data in the tabulation 2, and 2 all line data of will tabulating are kept among the tabulation list2;
Step 300: newly-built new tabulation newlist is used to deposit the data after the comparison;
Step 310: traversal of lists list1, and judge whether also have line data among the tabulation list1, if also have line data, execution in step 320 among the tabulation list1; If do not have line data, execution in step 370 among the tabulation list1;
Step 320: list1 takes out this line data from tabulation;
Wherein, in second embodiment of the invention, suppose that this line data is col.
Step 330: judge whether tabulation list2 has the data that the position equates in the p1 array with col in the p2 array, in the p2 array if tabulation list2 does not have and the col data that the position equates in the p1 array, execution in step 340; If tabulation list2 has the data that the position equates in the p1 array with col, execution in step 350 in the p2 array;
Step 340: the state of prompting col is 1 existence of only tabulating, and execution in step 360;
Step 350: the state of prompting col all exists for tabulation 1 and tabulation 2;
Step 360: the state of col is saved among the tabulation newlist, and execution in step 310 again;
Wherein, in another embodiment of the present invention, step 300 can also be carried out synchronously with step 360.
Step 370: traversal of lists newlist, a newly-built new Microsoft Excel outputs to the data after the comparison in the new Microsoft Excel and to merge, and the data mode after will comparing is presented at last lattice of new Microsoft Excel;
Step 380: finish this secondary data row and weigh.
The present invention not only is confined to the data row of two Microsoft Excels heavy, and the data row who is equally applicable to a plurality of Microsoft Excels is heavy, specifically sees also Fig. 3, is that the Microsoft Excel data of third embodiment of the invention are arranged the process flow diagram of heavy method.The heavy method of Microsoft Excel data row of third embodiment of the invention may further comprise the steps:
Step 400: need first provisional capital of the heavy EXCEL tabulation of data row to be made as title all, need in all tabulation titles to determine the heavy key word of data row, a kind of agreement form is set for needing the heavy key word in title of data row, and definite object listing;
In step 400, can be according to user's needs, be provided with or arrange any behavior header line of EXCEL tabulation, in addition, the EXCEL tabulation allows multiple row and exists, for being provided with the agreement form, key word is used to judge whether association equates that this agreement form can be provided with according to different demands by the user; For example: the agreement form is for to judge that whether key word is for adding boldface type, so just need to carry out the heavy key word font of data row in the title with all EXCEL tabulations and carry out overstriking, when reading the key word that adds boldface type, program just shows that this key word need carry out data row and weigh, the user can set up one or more needs on their own according to different demands and carry out the heavy critical field of data row, not necessarily mates all header fields entirely;
In third embodiment of the invention, list of hypotheses 1 is an object listing, and the agreement form is the title font-weight.
Step 410: read object listing 1, obtain all titles in the tabulation 1, and judge in the tabulation 1 whether the boldface type of adding title is arranged, do not add the boldface type title if tabulate in 1, execution in step 420 has the boldface type of adding title, execution in step 430 if tabulate in 1;
Step 420: prompting user title font does not have overstriking, heavily failure of data row, and execution in step 580;
In this step, if judge that the related agreement form that whether equates is an extended formatting, then the extended formatting that is provided with according to the user carries out corresponding prompt.
Step 430: the position that adds the boldface type title in 1 of will tabulating is kept in the p1 array;
Step 440: read all line data in the tabulation 1, and all line data are kept among the tabulation list1;
Step 450: reading other needs the heavy a plurality of listed files titles of data row, and travels through each listed files;
Step 460: judge whether also to exist the alternative document tabulation, if also have alternative document tabulation, execution in step 470; If there is no alternative document tabulation, execution in step 500;
Step 470: read this document tabulation, obtain the title in this document tabulation, the caption position corresponding with the p1 array in this document tabulation is kept in the p2 array;
Step 480: judge that whether the p1 array is the same with the size of p2 array, if p1 array and p2 array is in different size, re-executes step 460; If the p1 array is big or small the same with the p2 array, execution in step 490;
Step 490: read all line data of this document tabulation, and the position of transposing line data, be kept among the tabulation list2 by the position corresponding with the p1 array, and execution in step 460 again;
Step 500: newly-built new tabulation newlist is used to the data of the row's of depositing anharmonic ratio after;
Step 510: traversal of lists list1, and judge whether also have line data among the tabulation list1, if also have line data, execution in step 520 among the tabulation list1; If do not have line data, execution in step 570 among the tabulation list1;
Step 520: list1 takes out line data from tabulation;
Wherein, in third embodiment of the invention, suppose that this line data is col;
Step 530: judge whether tabulation list2 has the data that the position equates in the p1 array with col in the p2 array, in the p2 array if tabulation list2 does not have and the col data that the position equates in the p1 array, execution in step 540; If tabulation list2 has the data that the position equates in the p1 array with col, execution in step 550 in the p2 array;
Step 540: the state of prompting col is 1 existence of only tabulating, and execution in step 560;
Step 550: the state of prompting col is that a plurality of tabulations exist, and shows the List name that has col;
Step 560: the state of col is saved among the tabulation newlist, and execution in step 510 again;
Wherein, in another embodiment of the present invention, step 500 can also be carried out synchronously with step 560.
Step 570: traversal of lists newlist, a newly-built new Microsoft Excel outputs to the data after the comparison in the new Microsoft Excel and to merge, and the data mode after will comparing is presented at last lattice of new Microsoft Excel;
Step 580: finish this secondary data row and weigh.
Seeing also Fig. 4, is the structural representation of the Microsoft Excel data row device heavily of first embodiment of the invention.The heavy device of Microsoft Excel data row of first embodiment of the invention comprises that tabulation is provided with module, the 3rd data judge module and data outputting module, wherein,
Tabulation is provided with the header line that module is used to read the EXCEL tabulation that sets in advance or arrange, and for needing the heavy title of data row the agreement form is set, and definite object listing;
The 3rd data judge module is used for judging the line data whether other tabulations and object listing have the position to equate according to relatively other tabulations of object listing in the title of corresponding same agreement form;
Data outputting module is used for a newly-built new Microsoft Excel, and the data after the comparison are outputed to new Microsoft Excel, and the data mode after showing relatively.
Seeing also Fig. 5, is the structural representation of the Microsoft Excel data row device heavily of second embodiment of the invention.The heavy device of Microsoft Excel data row of second embodiment of the invention comprises that tabulation is provided with module, form judge module, information indicating module, first memory module, second memory module, data read module, the first data judge module, the 3rd memory module, the second data judge module, data extraction module, the 3rd data judge module, condition prompting module, the 4th memory module and data outputting module, wherein
Tabulation is provided with the header line that module is used to read the EXCEL tabulation that sets in advance or arrange, and need in the title to determine the heavy key word of data row, for needing the heavy key word in title of data row a kind of agreement form is set, and definite object listing; Wherein, the EXCEL tabulation allows multiple row and exists, and is used to judge for key word is provided with the agreement form whether association equates that this agreement form can be provided with according to different demands by the user; For example: the agreement form is for to judge that whether key word is for adding boldface type, so just need to carry out the heavy key word font of data row in the title with all EXCEL tabulations and carry out overstriking, when reading the key word that adds boldface type, program just shows that this key word need carry out data row and weigh, the user can set up one or more needs on their own according to different demands and carry out the heavy critical field of data row, not necessarily mates all header fields entirely;
In second embodiment of the invention, two EXCEL tabulations are respectively tabulation 1 and tabulation 2, and wherein, tabulation 1 is an object listing, and tabulation 2 is for needing tabulation relatively, and the agreement form is the title font-weight.
The form judge module is used to read object listing 1, obtain all titles in the tabulation 1, and judge in the tabulation 1 whether the boldface type of adding title is arranged, do not add the boldface type title if tabulate in 1, there is not overstriking by information indicating module prompting title font, the boldface type of adding title is arranged if tabulate in 1, by first memory module storage title data;
The information indicating module is used to point out user's title font not have overstriking, heavily failure of data row; Wherein, if judge that the related agreement form that whether equates is an extended formatting, then the extended formatting that is provided with according to the user carries out corresponding prompt.In second embodiment of the invention, the information indicating module also is used to point out two tabulations of user title not quite identical, heavily failure of data row.
First memory module is used for object listing 1 is added the location storage of boldface type title in the p1 array;
Data read module is used for reading all line data of object listing 1, and 1 all line data of will tabulating are kept among the tabulation list1;
Second memory module is used to read tabulation 2, obtains all titles in the tabulation 2, finds out the title corresponding with the p1 array in the tabulation 2, and the position of this title is kept in the p2 array;
The first data judge module is used to judge whether the p1 array is the same with the size of p2 array, if p1 array and p2 array is in different size, points out user's title not quite identical by the information indicating module; If the p1 array is big or small the same with the p2 array, read line data by the 3rd memory module;
The 3rd memory module is used for reading all line data of tabulation 2, and 2 all line data of will tabulating are kept among the tabulation list2;
The second data judge module is used for traversal of lists list1, and judges whether also have line data among the tabulation list1, if also have line data among the tabulation list1, extract line data by data extraction module; If do not have line data among the tabulation list1, by the data after the data outputting module output relatively;
Data extraction module is used for taking out line data from tabulation list1; In second embodiment of the invention, suppose that this line data is col.
The 3rd data judge module is used for judging whether tabulation list2 has the data that the position equates in the p1 array with col in the p2 array, if tabulation list2 does not have and the col data that the position equates in the p1 array in the p2 array, pointing out the state of col by the condition prompting module is 1 existence of only tabulating; If tabulation list2 has the data that the position equates in the p1 array with col in the p2 array, then the state by condition prompting module prompting col is that tabulation 1 and tabulation 2 all exist;
The condition prompting module is used for the judged result prompting user data state according to the 3rd data judge module, and preserves data mode by the 4th memory module;
The 4th memory module is used for newly-built new tabulation newlist, the data of the row's of depositing anharmonic ratio after, and rejudge whether also have line data among the tabulation list1 by the second data judge module;
Data outputting module is used for traversal of lists newlist, and a newly-built new Microsoft Excel outputs to the data after the comparison in the new Microsoft Excel and to merge, and the data mode after will comparing is presented at last lattice of new Microsoft Excel.
Seeing also Fig. 6, is the structural representation of the Microsoft Excel data row device heavily of third embodiment of the invention.The heavy device of Microsoft Excel data row of third embodiment of the invention comprises that tabulation is provided with module, form judge module, information indicating module, first memory module, data read module, tabulation read module, tabulation judge module, second memory module, the first data judge module, the 3rd memory module, the second data judge module, data extraction module, the 3rd data judge module, condition prompting module, the 4th memory module and data outputting module, wherein
Tabulation is provided with module and is used for needing first provisional capital of the heavy EXCEL tabulation of data row to be made as title all, tabulation is provided with module also can be according to user's needs, be provided with or arrange any behavior header line of EXCEL tabulation, need in all tabulation titles to determine the heavy key word of data row, for the key word in title that needs data row to weigh is provided with a kind of agreement form, and definite object listing; Wherein, the EXCEL tabulation allows multiple row and exists, and is used to judge for key word is provided with the agreement form whether association equates that this agreement form can be provided with according to different demands by the user; For example: the agreement form is for to judge that whether key word is for adding boldface type, so just need to carry out the heavy key word font of data row in the title with all EXCEL tabulations and carry out overstriking, when reading the key word that adds boldface type, program just shows that this key word need carry out data row and weigh, the user can set up one or more needs on their own according to different demands and carry out the heavy critical field of data row, not necessarily mates all header fields entirely; In third embodiment of the invention, list of hypotheses 1 is an object listing, and the agreement form is the title font-weight.
The form judge module is used to read object listing 1, obtains all titles in the tabulation 1, and judges in the tabulation 1 whether the boldface type of adding title is arranged, and does not add the boldface type title if tabulate in 1, does not have overstriking by information indicating module prompting title font; The boldface type of adding title is arranged if tabulate in 1, add the boldface type title by the storage of first memory module;
The information indicating module is used to point out user's title font not have overstriking, heavily failure of data row; Wherein, if judge that the related agreement form that whether equates is an extended formatting, then the extended formatting that is provided with according to the user carries out corresponding prompt.
First memory module is used for preserving the position that object listing 1 adds the boldface type title, and in third embodiment of the invention, first memory module is the p1 array.
Data read module is used for reading all line data of object listing 1, and all line data are kept among the tabulation list1;
The tabulation read module is used to read other and needs the heavy a plurality of listed files titles of data row, and travels through each listed files;
The tabulation judge module is used to judge whether also exist the alternative document tabulation, if also there is the alternative document tabulation, reads this tabulation by second memory module; If there is no alternative document tabulation is by the newly-built new tabulation newlist of the 4th memory module;
Second memory module is used to read this document tabulation, obtains the title in this document tabulation, and the caption position corresponding with the p1 array in this document tabulation is kept in the p2 array;
The first data judge module is used to judge whether the p1 array is the same with the size of p2 array, if p1 array and p2 array is in different size, rejudges by the tabulation judge module and whether also to have the alternative document tabulation; If the p1 array is big or small the same with the p2 array, read all line data of this document tabulation by the 3rd memory module;
The 3rd memory module is used to read all line data of this document tabulation, and the position of transposing line data is kept in the list2 tabulation by the position corresponding with the p1 array, and rejudges by the tabulation judge module and whether also to have the alternative document tabulation;
The second data judge module is used for traversal of lists list1, and judges whether also have line data among the tabulation list1, if also have line data among the tabulation list1, extract line data by data extraction module; If do not have line data among the tabulation list1, by the data after the data outputting module output relatively;
Data extraction module is used for taking out line data from tabulation list1; In third embodiment of the invention, suppose that this line data is col;
The 3rd data judge module is used for judging whether tabulation list2 has the data that the position equates in the p1 array with col in the p2 array, if tabulation list2 does not have and the col data that the position equates in the p1 array in the p2 array, pointing out the state of col by the condition prompting module is 1 existence of only tabulating; If tabulation list2 has the data that the position equates in the p1 array with col in the p2 array, pointing out the state of col by the condition prompting module is that a plurality of tabulations exist;
The condition prompting module is used for the judged result prompting user data state according to the 3rd data judge module, shows the List name that has data, and preserves data mode by the 4th memory module;
The 4th memory module is used for newly-built new tabulation newlist, the data of the row's of depositing anharmonic ratio after, and rejudge whether also have line data among the tabulation list1 by the second data judge module;
Data outputting module is used for traversal of lists newlist, and a newly-built new Microsoft Excel outputs to the data after the comparison in the new Microsoft Excel and to merge, and the data mode after will comparing is presented at last lattice of new Microsoft Excel.
Method that Microsoft Excel data row of the present invention is heavy and device are by selecting heavy tabulation and the field of needs row, and set in advance a kind of agreement form and be used for representing that whether association equates, program travels through all tabulations one by one, read the value of all tabulations respectively, and be kept at respectively in the corresponding memory object, compare one by one then, when reading when arranging the identical form of form, promptly this tabulation is arranged anharmonic ratio, draw the state after the comparison, comparative result is kept in the new Excel form, and the data mode after last lattice of form show relatively, make things convenient for the data after the user sees own comparison fast.The data row that the present invention can be used for a plurality of Microsoft Excels is heavy, convenient to use, can promote user's experience greatly.
The above only is preferred embodiment of the present invention, not in order to restriction the present invention, all any modifications of being done within the spirit and principles in the present invention, is equal to and replaces and improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. the heavy method of Microsoft Excel data row comprises
Step a: read the header line of the EXCEL tabulation that sets in advance or arrange, the agreement form is set for needing the heavy title of data row;
Step b:, find out other tabulations and the object listing line data that the position equates in the title of corresponding same agreement form according to relatively other tabulations of object listing;
Step c: the data after will comparing output to newly-built Microsoft Excel.
2. the heavy method of Microsoft Excel data row according to claim 1, it is characterized in that, also comprise between described step a and the described step b: determine and read object listing, obtain all titles in the object listing, and judge the title of the form of whether having an agreement in the object listing, if do not arrange the title of form in the object listing, prompting user title agreement form is not provided with heavily failure of data row; The title of form if having an agreement in the object listing is kept at the caption position of arranging form in the object listing in the p1 array, and reads all line data in the object listing, and all line data of object listing are kept among the tabulation list1.
3. the heavy method of Microsoft Excel data row according to claim 2, it is characterized in that, also comprise between described step a and the described step b: read other tabulations, obtain all titles in other tabulations, find out in other tabulations with the p1 array in corresponding title, the position of this title is kept in the p2 array, and judge whether the p1 array is the same with the size of p2 array, if p1 array and p2 array is in different size, prompting user list title is not quite identical, heavily failure of data row; If the p1 array is big or small the same with the p2 array, then reads all line data in other tabulations, and other all line data of tabulating are kept among the tabulation list2.
4. the heavy method of Microsoft Excel data row according to claim 3, it is characterized in that, described step b also comprises: traversal of lists list1, and judge whether also have line data among the tabulation list1, if also have line data among the tabulation list1, list1 takes out this line data from tabulation, and judges whether tabulation list2 has in the p2 array and this line data data that the position equates in the p1 array; If do not have line data, execution in step c among the tabulation list1.
5. the heavy method of Microsoft Excel data row according to claim 4, it is characterized in that, described step b also comprises: if tabulation list2 does not have and this line data data that the position equates in the p1 array in the p2 array, the state of pointing out this line data is that only object listing exists; If tabulation list2 has in the p2 array and this line data data that the position equates in the p1 array, the state of pointing out this line data is that a plurality of tabulations exist, and the display list title.
6. the heavy method of Microsoft Excel data row according to claim 1 is characterized in that described step c also comprises: the data mode after showing relatively in newly-built Microsoft Excel.
7. the heavy method of Microsoft Excel data row according to claim 1, it is characterized in that, in described step a, the described EXCEL tabulation that needs data row to weigh comprises two or more, when needing the heavy EXCEL tabulation of data rows when a plurality of, also comprise between described step a and the described step b: reading needs the heavy a plurality of listed files titles of data row, and travel through each listed files, judge whether also to exist the alternative document tabulation, if also there is the alternative document tabulation, then read this document tabulation, obtain the title in this document tabulation, the caption position corresponding with the p1 array in this document tabulation is kept in the p2 array; If there is no alternative document tabulation, then newly-built new tabulation.
8. Microsoft Excel data are arranged heavy device, it is characterized in that, comprise that tabulation is provided with module, the 3rd data judge module and data outputting module, described tabulation is provided with the header line that module is used to read the EXCEL tabulation that sets in advance or arrange, for needing the heavy title of data row that the agreement form is set, and definite object listing, described the 3rd data judge module is used for judging the line data whether other tabulations and object listing have the position to equate according to relatively other tabulations of object listing in the title of corresponding same agreement form; Described data outputting module is used for a newly-built new Microsoft Excel, and the data after the comparison are outputed to new Microsoft Excel, and the data mode after showing relatively.
9. the heavy device of Microsoft Excel data row according to claim 8 is characterized in that, also comprises form judge module, first memory module, data read module, second memory module, the first data judge module and the 3rd memory module,
Described form judge module is used for obtaining all titles of object listing, and judge whether the boldface type of adding title is arranged in the object listing, if do not add the boldface type title in the object listing, there is not overstriking by information indicating module prompting title font, if the boldface type of adding title is arranged in the object listing, by first memory module storage title data;
Described first memory module is used for object listing is added the location storage of boldface type title in the p1 array;
Described data read module is used for all line data of object listing are kept at tabulation list1;
Described second memory module is used for finding out other tabulations title corresponding with the p1 array, and the position of this title is kept in the p2 array;
The described first data judge module is used to judge whether the p1 array is the same with the size of p2 array, if p1 array and p2 array is in different size, points out user's title not quite identical by the information indicating module; If the p1 array is big or small the same with the p2 array, read line data by the 3rd memory module;
Described the 3rd memory module is used for other all line data of tabulating are kept at tabulation list2.
10. according to Claim 8 or the heavy device of 9 described Microsoft Excel data row, it is characterized in that, also comprise the second data judge module, condition prompting module and the 4th memory module,
The described second data judge module is used for judging whether tabulation list1 also has line data, if also have line data among the tabulation list1, extracts line data by data extraction module,
Described condition prompting module is used for the judged result prompting user data state according to the 3rd data judge module,
Described the 4th memory module is used for newly-built new tabulation newlist, the data of the row's of depositing anharmonic ratio after.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011101429557A CN102200968A (en) | 2011-05-30 | 2011-05-30 | Method and device for removing duplications of EXCEL form data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011101429557A CN102200968A (en) | 2011-05-30 | 2011-05-30 | Method and device for removing duplications of EXCEL form data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102200968A true CN102200968A (en) | 2011-09-28 |
Family
ID=44661654
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011101429557A Pending CN102200968A (en) | 2011-05-30 | 2011-05-30 | Method and device for removing duplications of EXCEL form data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102200968A (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105653587A (en) * | 2015-12-21 | 2016-06-08 | 厦门市美亚柏科信息股份有限公司 | Heterogeneous data cleaning method and system thereof |
| CN106708795A (en) * | 2016-12-18 | 2017-05-24 | 杨昕 | Method and device for setting title formats in batch |
| CN108153719A (en) * | 2016-12-02 | 2018-06-12 | 北京国双科技有限公司 | Merge the method and apparatus of electrical form |
| CN108984494A (en) * | 2017-06-04 | 2018-12-11 | 深圳市北斗智研科技有限公司 | A kind of Excel software data integration method |
| CN109284254A (en) * | 2018-10-16 | 2019-01-29 | 浪潮天元通信信息系统有限公司 | A kind of general excel document handling method |
| CN109325105A (en) * | 2018-11-23 | 2019-02-12 | 泰康保险集团股份有限公司 | Code matches method, apparatus and storage medium |
| CN109669937A (en) * | 2018-09-25 | 2019-04-23 | 深圳壹账通智能科技有限公司 | Table data comparison method, device, equipment and computer readable storage medium |
| CN109828985A (en) * | 2018-12-27 | 2019-05-31 | 大唐软件技术股份有限公司 | A kind of list difference querying method and device |
| CN115270737A (en) * | 2022-09-22 | 2022-11-01 | 广州市保伦电子有限公司 | Format modification method and device for target object |
-
2011
- 2011-05-30 CN CN2011101429557A patent/CN102200968A/en active Pending
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105653587A (en) * | 2015-12-21 | 2016-06-08 | 厦门市美亚柏科信息股份有限公司 | Heterogeneous data cleaning method and system thereof |
| CN105653587B (en) * | 2015-12-21 | 2019-02-19 | 厦门市美亚柏科信息股份有限公司 | Heterologous isomeric data cleaning method and its system |
| CN108153719A (en) * | 2016-12-02 | 2018-06-12 | 北京国双科技有限公司 | Merge the method and apparatus of electrical form |
| CN106708795A (en) * | 2016-12-18 | 2017-05-24 | 杨昕 | Method and device for setting title formats in batch |
| CN108984494A (en) * | 2017-06-04 | 2018-12-11 | 深圳市北斗智研科技有限公司 | A kind of Excel software data integration method |
| CN109669937A (en) * | 2018-09-25 | 2019-04-23 | 深圳壹账通智能科技有限公司 | Table data comparison method, device, equipment and computer readable storage medium |
| CN109284254A (en) * | 2018-10-16 | 2019-01-29 | 浪潮天元通信信息系统有限公司 | A kind of general excel document handling method |
| CN109325105A (en) * | 2018-11-23 | 2019-02-12 | 泰康保险集团股份有限公司 | Code matches method, apparatus and storage medium |
| CN109325105B (en) * | 2018-11-23 | 2021-06-29 | 泰康保险集团股份有限公司 | Code matching method, device and storage medium |
| CN109828985A (en) * | 2018-12-27 | 2019-05-31 | 大唐软件技术股份有限公司 | A kind of list difference querying method and device |
| CN109828985B (en) * | 2018-12-27 | 2021-06-25 | 大唐软件技术股份有限公司 | Form difference query method and device |
| CN115270737A (en) * | 2022-09-22 | 2022-11-01 | 广州市保伦电子有限公司 | Format modification method and device for target object |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102200968A (en) | Method and device for removing duplications of EXCEL form data | |
| US8972437B2 (en) | Auto-population of a table | |
| US20150067476A1 (en) | Title and body extraction from web page | |
| US8752009B2 (en) | Source code comparison device, source code comparison method and source code comparison program | |
| WO2012102884A2 (en) | Associating captured image data with a spreadsheet | |
| WO2014169334A1 (en) | Methods and systems for improved document comparison | |
| US8095575B1 (en) | Word processor data organization | |
| CN103200293A (en) | Method of automatically combining tautonomy contacts in process of guiding contacts into contact list | |
| US20090265313A1 (en) | Automatically Extracting Data From Semi-Structured Documents | |
| CN103164388A (en) | Method and device for obtaining structuring information in layout files | |
| US7370060B2 (en) | System and method for user edit merging with preservation of unrepresented data | |
| CN103488482A (en) | Method and device for generating test cases | |
| CN105302626B (en) | Analytic method of XPS (XPS) structured data | |
| CN102012857A (en) | Device and method for automatically testing web page | |
| CN101763348B (en) | Dynamic table type data acquisition system and method | |
| CN102867039A (en) | Adding and reading method and device of multimedia annotations | |
| US20160299907A1 (en) | Stochastic document clustering using rare features | |
| CN104462532A (en) | Method and device for extracting webpage text | |
| CN105786788A (en) | Method and device for generating forms by using WORD program | |
| CN104603779A (en) | Text mining device, text mining method, and computer-readable recording medium | |
| CN113204401B (en) | Browser rendering method, terminal and storage medium | |
| CN111045654A (en) | Vue-based method and device for quickly generating common instructions, computer equipment and storage medium | |
| CN114297143A (en) | File searching method, file displaying device and mobile terminal | |
| CN101533391A (en) | System for searching similar matched sentences and method thereof | |
| CN104536947A (en) | Layout document processing method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20110928 |