CN105868171B - A kind of method of calibration and device of Excel file - Google Patents
A kind of method of calibration and device of Excel file Download PDFInfo
- Publication number
- CN105868171B CN105868171B CN201510031262.9A CN201510031262A CN105868171B CN 105868171 B CN105868171 B CN 105868171B CN 201510031262 A CN201510031262 A CN 201510031262A CN 105868171 B CN105868171 B CN 105868171B
- Authority
- CN
- China
- Prior art keywords
- verified
- excel file
- verification
- rule
- data
- 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.)
- Active
Links
Landscapes
- Machine Translation (AREA)
Abstract
The present invention provides a kind of method of calibration of Excel file and devices, are related to business support technical field, and the method for calibration of the Excel file includes: to parse to Excel file to be verified, obtain the data content of Excel file to be verified；Corresponding use-case template is selected according to the data content of Excel file to be verified, obtains the verification rule of use-case template, wherein verification rule includes: the verification rule of use-case template and the verification rule of use-case major key；According to the verification of use-case template rule, the gauge outfit columns and gauge outfit title of Excel file to be verified are verified, if gauge outfit columns and gauge outfit title meet the verification rule of use-case template, the data content of Excel file to be verified is verified according to the verification of example template rule.Scheme in the present invention can be by verifying with use-case template, wrong data in Excel file is positioned, wrong data is labeled generation error Excel file, wrong data can directly be modified, data error rate is reduced, is greatly improved work efficiency.
Description
Technical field
The present invention relates to business support technical field more particularly to the methods of calibration and device of a kind of Excel file.
Background technique
In testing field, test data management is that very the key link, the case data of Excel format are executed and tieed up
Shield is most important mode in current test job.If only single-set operation and data volume is smaller, safeguards an Excel text
Part is fairly simple, but to by a system, come maintenance test data, then the interactive process of Excel and system is succinct, easy
With just seeming particularly significant.All test execution personnel are intended to that time flower is designed and tested in the coverage of use-case as best one can
In execution, rather than be used in case data repeatedly searches modify during.
However, the system page can provide the specific descriptions text of data problem, mention in the submission of existing test data
Show interface as shown in Figure 1, but in the case where having ignored time of the orientation problem in Excel especially in the presence of mass data,
Positioning problems and to repair be more many and diverse and time-consuming work one by one.In addition, the prior art handles Excel Issues of data-verifying
When, also tend to ignore a crucial factor, i.e. people and interacting between Excel, system three, especially Excel data
Amount is bigger, and human-computer interaction is more difficult, wherein the main problems are as follows:
1, frequent switching check information interface and data operation interface；
2, data locating speed is slow；
3, data comparison efficiency is low；
4, modification error rate is high；
5, it returns original and repeats modification low efficiency.
Summary of the invention
The technical problem to be solved in the present invention is to provide a kind of method of calibration of Excel file and devices, can not need
Frequent switching checks check information interface and data operation interface, realizes and carries out to the wrong data in Excel file to be verified
Positioning reduces data error rate.
In order to solve the above-mentioned technical problem, the present invention adopts the following technical scheme:
According to one aspect of the present invention, a kind of method of calibration of Excel file is provided, comprising:
Excel file to be verified is parsed, the data content of the Excel file to be verified is obtained；
Corresponding use-case template is selected according to the data content of the Excel file to be verified, obtains the use-case template
Verification rule, wherein the verification rule include: use-case template verification rule and use-case major key verification it is regular；
According to the verification of use-case template rule, to the gauge outfit columns and gauge outfit title of the Excel file to be verified
It is verified, if the gauge outfit columns and gauge outfit title meet the verification rule of the use-case template, according to use-case template
Verification rule verifies the data content of the Excel file to be verified.
Optionally, the method for calibration further include: if the gauge outfit columns and gauge outfit title do not meet the use-case template
Verification rule, then output error message.
Optionally, if the gauge outfit columns and gauge outfit title meet the verification rule of the use-case template, according to example mould
Verification rule the step of verifying to the data content of the Excel file to be verified of plate includes:
According to the verification of use-case template rule, to any row data content in the Excel file to be verified into
Row verification；
If there is at least one mistake, generation error Excel file in any row data content.
Optionally, if the step of at least one mistake, generation error Excel file occurs in any row data content
Include:
If at least one mistake occurs in any row data content, position, records to there are error unit lattice
The error unit table rows number, row number, and the error unit lattice are expert at and are added to wrong set；
By data generation error Excel file in the mistake set, and to the error unit lattice in wrong Excel file
Carry out color identifier and error reason mark.
Optionally, the data content of the Excel file to be verified is verified according to the verification of use-case template rule
The step of further include: if any row data content passes through verification, the verification rule according to the use-case major key is further right
It is verified by check row major key.
Optionally, if any row data content passes through verification, further according to the verification of use-case major key rule
Include: to the step of being verified by check row major key
It is verified according to the verification rule of the use-case major key to by check row major key；
If described be not present by check row major key, newly-increased set is added to by check row by described, and will be described
Data generate newly-increased Excel file in newly-increased set.
Optionally, if described exist by check row major key, set to be modified is added to by check row by described, and
Data in the newly-increased set are generated into Excel file to be modified.
According to another aspect of the invention, a kind of calibration equipment of Excel file is additionally provided, comprising:
Parsing module obtains the data of the Excel file to be verified for parsing to Excel file to be verified
Content；
Selecting module is obtained for selecting corresponding use-case template according to the data content of the Excel file to be verified
The verification rule of the use-case template, wherein the verification rule includes: the school of the verification rule and use-case major key of use-case template
Test rule；
Correction verification module arranges the gauge outfit of the Excel file to be verified for the verification rule according to the use-case template
Several and gauge outfit title is verified, if the gauge outfit columns and gauge outfit title meet the verification rule of the use-case template, root
The data content of the Excel file to be verified is verified according to the verification rule of use-case template.
Optionally, the calibration equipment further include: output module, if not met for the gauge outfit columns and gauge outfit title
The verification of the use-case template is regular, then output error message.
Optionally, the correction verification module includes:
First verification unit, for the verification rule according to the use-case template, in the Excel file to be verified
Any row data content is verified；
Generation unit, if there is at least one mistake, generation error Excel text for any row data content
Part.
Optionally, the generation unit includes:
Locator unit, if there is at least one mistake for any row data content, to there is error unit
Lattice are positioned, and record the error unit table rows number, row number, and the error unit lattice are expert at and are added to Error Set
It closes；
First generates subelement, for data generation error Excel file in gathering the mistake, and to mistake
Error unit lattice in Excel file carry out color identifier and error reason mark.
Optionally, the correction verification module further include:
Second verification unit, if passing through verification for any row data content, according to the verification of the use-case major key
Rule is further verified to by check row major key.
Optionally, second verification unit includes:
Subelement is verified, for verifying according to the verification rule of the use-case major key to by check row major key；
Second generation subelement is added described by check row if being not present for described by check row major key
Newly-increased Excel file is generated to newly-increased set, and by data in the newly-increased set.
Optionally, second verification unit further include:
Third generates subelement and is added to described by check row if existing for described by check row major key
Set to be modified, and data in the newly-increased set are generated into Excel file to be modified.
The beneficial effects of the present invention are:
The method of calibration of Excel file in the present invention program first parses Excel file to be verified, obtains
Data content in Excel file to be verified, then according to the corresponding verification of data content selection in Excel file to be verified
Use-case template verifies Excel file to be verified according to the verification rule of the use-case template of selection, wherein verification rule
It include: the verification rule of use-case template and the verification rule of use-case major key.Then according to the verification of use-case template rule, school is treated
The gauge outfit columns and gauge outfit title for testing Excel file are verified, if gauge outfit columns and gauge outfit title meet the school of use-case template
Rule is tested, then the data content of Excel file to be verified is verified according to the verification of use-case template rule.In the present invention
Scheme can be positioned to there is wrong data in Excel file to be verified, and can be extracted wrong data and be generated new
Excel file, realize reading and carried out simultaneously with operation interface, avoid changing interface to user's bring data accumulating with
The requirement of data comparison, reduces error rate, improves work efficiency.
Detailed description of the invention
Fig. 1 shows wrong data check results schematic diagrames in the prior art；
Fig. 2 indicates Excel file method of calibration flow chart in the embodiment of the present invention；
Fig. 3 indicates the verification operation flow chart of Excel file in the embodiment of the present invention；
Fig. 4 indicates the structural block diagram of Excel file calibration equipment in the embodiment of the present invention；
Fig. 5 indicates the structural block diagram of correction verification module in the embodiment of the present invention；
Fig. 6 indicates the structural block diagram of generation unit in the embodiment of the present invention；
Fig. 7 indicates the structural block diagram of the second verification unit in the embodiment of the present invention.
Specific embodiment
To make the object, technical solutions and advantages of the present invention clearer, right below in conjunction with the accompanying drawings and the specific embodiments
The present invention is described in detail.
Embodiment one
The embodiment of the invention discloses a kind of methods of calibration of Excel file, as shown in Fig. 2, this method 200 includes following
Step:
Step S201, Excel file to be verified is parsed, obtains the data content of Excel file to be verified；
Step S203, corresponding use-case template is selected according to the data content of Excel file to be verified, obtains use-case template
Verification rule, wherein verification rule include: use-case template verification rule and use-case major key verification rule, specifically, use
The verification rule of every item data is saved in the form of Map object in example template, has this in the major key verification rule of use-case template
All already present major key set of use-case template, and saved equally in the form of Map object；
Step S205, according to the verification of use-case template rule, to the gauge outfit columns and gauge outfit title of Excel file to be verified
It is verified, if gauge outfit columns and gauge outfit title meet the verification rule of use-case template, according to the verification of use-case template rule
The data content of Excel file to be verified is verified.
Specifically, in embodiments of the present invention, first to sheet pages of traversal of Excel file to be verified, according to use-case mould
The verification rule of plate verifies sheet pages of Excel file to be verified of gauge outfit columns and gauge outfit title, if gauge outfit columns and
Gauge outfit title does not meet the verification rule of use-case template, then output error message, and error message is saved in predetermined
In global variable, which is used to save the set of data to be increased newly, data to be modified and wrong data.Wherein, if table
Head columns and gauge outfit title meet the verification rule of use-case template, then according to the verification rule of example template to Excel text to be verified
The data content of part is verified, when being verified, specifically includes the following steps:
According to the verification of use-case template rule, any row data content in Excel file to be verified is verified；
If there is at least one mistake, generation error Excel file in any row data content.
Wherein, if any row data content includes: the step of there is at least one mistake, generation error Excel file
If at least one mistake occurs in any row data content, positioned to there are error unit lattice, misregistration
Cell line number, row number, and error unit lattice are expert at and are added to wrong set；
By data generation error Excel file in mistake set, and the error unit lattice in wrong Excel file are carried out
Color identifier and error reason mark.
Specifically, in embodiments of the present invention, for Excel file to be verified, with behavior unit, according to use-case template
Verification rule, verifies each cell data, if at least one mistake occurs in any row data content, by the row data one by one
It is added to wrong set, then the row data is being parsed, when encounters the number that is not consistent of verification rule with use-case template
According to when, record line number where the cell and row number, and be saved in global variable predetermined.In generation error Excel
When file, according to the line number and row number of the wrong data of record, using Excel can to the function that cell is highlighted,
Color identifier is carried out to cell where wrong data in wrong Excel file, user is greatly improved and positions error number
According to speed, and annotation function also is marked to cell using excel, the error reason of wrong data can be marked to be repaired
Change cell, realizes looking into for data manipulation and change, greatly improve efficiency.
In embodiments of the present invention, according to the verification of use-case template rule, to any line number in Excel file to be verified
It is further right according to the verification rule of use-case major key if any row data content passes through verification when being verified according to content
It is verified, is specifically included by check row major key:
It is verified according to the verification rule of use-case major key to by check row major key；
If being not present by check row major key, newly-increased set will be added to by check row, and will count in newly-increased set
Excel file is increased newly according to generating；If existing by check row major key, set to be modified will be added to by check row, and will
Data generate Excel file to be modified in newly-increased set.
Specifically, in embodiments of the present invention, it is carried out according to the verification rule of use-case major key to Excel file to be verified
When verification, by inquiring the stored major key set of verification rule of use-case major key, it can would not exist in major key set
Full line data are added to newly-increased data acquisition system, and the full line data that will be present in major key concentration are added in data acquisition system to be modified,
And using current data as newest standard.
Specifically, when carrying out verification operation, as shown in figure 3, completing Excel file to be verified and use-case template first
Unified, i.e., parsing user presents a paper, and sheet pages and sheet all page datas is returned to, according to Excel file to be verified
The global variable that type is read out sheet page data, and is arranged in this checking procedure, for saving to newly-increased number
According to, data to be modified and the set of wrong data.Then corresponding use-case template is selected, the verification rule of the use-case template is obtained
Rule is verified with use-case major key, and Excel file to be verified is verified.Because Excel file type to be verified is different, therefore
When being verified, title and columns be not also identical, therefore according to the must value of title to Excel file to be verified
Gauge outfit verified, if title meet use-case template verification rule, further to the number of Excel file to be verified
It is verified according to content.When carrying out data check, if detecting wrong data, by the global variable of error message preservation
In, and newly-increased data, data to be modified and wrong data are subjected to shunting storage, generate newly-increased Excel file, to be repaired respectively
Change Excel file and wrong Excel file, above-mentioned check results are backed within into client, are handled convenient for user.
Scheme in the embodiment of the present invention changes user while checking data check information and data operation interface mode, by existing skill
The operation interface of two separation is merged in art, and can be regular by the data in Excel file to be verified according to verification
It is extracted, generation error Excel file, newly-increased Excel file and Excel file to be modified reduce in the prior art
The problem of checking describes the plenty of time spent by orientation problem.In addition, user can directly find out specifically from wrong Excel file
The data of mistake and corresponding error reason improve the efficiency of data positioning and comparing；And it can be directly to mistake
Data in Excel file are modified, and are resubmited and are verified again, submit the data volume that system can all handled every time
It is more last to successively decrease rapidly, data-handling efficiency is greatly promoted, solves the problems, such as that data volume larger process process is complicated.
Embodiment two
A kind of calibration equipment of Excel file is disclosed in the embodiment of the present invention, as shown in figure 4, the device 400 includes:
Parsing module 401, for being parsed to Excel file to be verified, in the data for obtaining Excel file to be verified
Hold；
Selecting module 403 is obtained for selecting corresponding use-case template according to the data content of Excel file to be verified
The verification rule of use-case template, wherein verification rule includes: the verification rule of use-case template and the verification rule of use-case major key；
Correction verification module 405, for according to the verification of use-case template rule, gauge outfit columns to Excel file to be verified and
Gauge outfit title is verified, if gauge outfit columns and gauge outfit title meet the verification rule of use-case template, according to use-case template
Verification rule verifies the data content of Excel file to be verified.
Output module 407 exports mistake if not meeting the verification rule of use-case template for gauge outfit columns and gauge outfit title
False information.
Specifically, as shown in figure 5, for correction verification module 405 in the embodiment of the present invention structural block diagram, wherein correction verification module
405 include:
First verification unit 4051, for the verification rule according to use-case template, to any in Excel file to be verified
Row data content is verified；
Generation unit 4053, if there is at least one mistake, generation error Excel text for any row data content
Part.
Specifically, as shown in fig. 6, being the structural block diagram of generation unit 4053 in the embodiment of the present invention, generation unit 4053
Include:
Locator unit 40531, if there is at least one mistake for any row data content, to there is error unit
Lattice are positioned, misregistration cell line number, row number, and error unit lattice are expert at and are added to wrong set；
First generates subelement 40533, for data generation error Excel file in gathering mistake, and to mistake
Error unit lattice in Excel file carry out color identifier and error reason mark.
Further, as shown in figure 5, being the structural block diagram of correction verification module 405 in the embodiment of the present invention, correction verification module 405
Further include:
Second verification unit 4055, if passing through verification for any row data content, according to the verification of use-case major key
Rule is further verified to by check row major key.
Specifically, as shown in fig. 7, being the structural block diagram of the second verification unit 4055 in the embodiment of the present invention, the second verification
Unit 4055 includes:
Subelement 40551 is verified, for verifying according to the verification rule of use-case major key to by check row major key；
Second generates subelement 40553, if will be added to newly by check row for being not present by check row major key
Increase set, and data in newly-increased set are generated into newly-increased Excel file；And
Third generates subelement 40555, if for existing by check row major key, it is to be repaired by being added to by check row
Change set, and data in newly-increased set are generated into Excel file to be modified.
Above-described is the preferred embodiment of the present invention, it should be pointed out that the ordinary person of the art is come
It says, can also make several improvements and retouch under the premise of not departing from principle of the present invention, these improvements and modifications also exist
In protection scope of the present invention.
Claims (12)
1. a kind of method of calibration of Excel file characterized by comprising
Excel file to be verified is parsed, the data content of the Excel file to be verified is obtained；
Corresponding use-case template is selected according to the data content of the Excel file to be verified, obtains the school of the use-case template
Test rule, wherein the verification rule includes: the verification rule of use-case template and the verification rule of use-case major key；
To sheet pages of traversal of Excel file to be verified, according to the verification of use-case template rule, to described to be verified
The gauge outfit columns and gauge outfit title of sheet pages of Excel file are verified, if the gauge outfit columns and gauge outfit title meet institute
The verification rule of use-case template is stated, then according to the verification rule of use-case template to the data content of the Excel file to be verified
It is verified；If gauge outfit columns and gauge outfit title do not meet the verification rule of use-case template, output error message, and by mistake
Information preservation is into global variable predetermined, and the global variable is for saving data, data to be modified and mistake to be increased newly
The set of data；Wherein, the data content of the Excel file to be verified is verified according to the verification of use-case template rule
The step of include:
According to the verification of use-case template rule, school is carried out to any row data content in the Excel file to be verified
It tests；
If there is at least one mistake, generation error Excel file in any row data content.
2. method of calibration as described in claim 1, which is characterized in that further include: if the gauge outfit columns and gauge outfit title are not
Meet the verification rule of the use-case template, then output error message.
3. method of calibration as described in claim 1, which is characterized in that if at least one mistake occurs in any row data content
Accidentally, then the step of generation error Excel file includes:
If at least one mistake occurs in any row data content, positioned to there are error unit lattice, described in record
Error unit table rows number, row number, and the error unit lattice are expert at and are added to wrong set；
By data generation error Excel file in the mistake set, and the error unit lattice in wrong Excel file are carried out
Color identifier and error reason mark.
4. method of calibration as described in claim 1, which is characterized in that further include:
If any row data content passes through verification, according to the verification rule of the use-case major key further to passing through check row
Major key is verified.
5. method of calibration as claimed in claim 4, which is characterized in that if any row data content passes through verification, basis
The verification rule of the use-case major key further includes: to the step of verification by check row major key
It is verified according to the verification rule of the use-case major key to by check row major key；
If described be not present by check row major key, newly-increased set is added to by check row by described, and will be described newly-increased
Data generate newly-increased Excel file in set.
6. method of calibration as claimed in claim 5, which is characterized in that further include: if described exist by check row major key,
Set to be modified is added to by check row by described, and data in the newly-increased set are generated into Excel file to be modified.
7. a kind of calibration equipment of Excel file characterized by comprising
Parsing module obtains the data content of the Excel file to be verified for parsing to Excel file to be verified；
Selecting module, for selecting corresponding use-case template according to the data content of the Excel file to be verified, described in acquisition
The verification rule of use-case template, wherein the verification rule includes: that the verification of the verification rule and use-case major key of use-case template is advised
Then；
Correction verification module, it is right according to the verification of use-case template rule for the sheet pages of traversal to Excel file to be verified
Sheet pages of the gauge outfit columns and gauge outfit title of the Excel file to be verified are verified, if the gauge outfit columns and gauge outfit
Title meets the verification rule of the use-case template, then according to the verification rule of use-case template to the Excel file to be verified
Data content verified；If gauge outfit columns and gauge outfit title do not meet the verification rule of use-case template, output error letter
Breath, and error message is saved in global variable predetermined, and the global variable is for saving data to be increased newly, to be modified
The set of data and wrong data；
Wherein, the correction verification module according to the verification rule of use-case template to the data content of the Excel file to be verified into
When row verification, comprising:
First verification unit, for the verification rule according to the use-case template, to any in the Excel file to be verified
Row data content is verified；
Generation unit, if there is at least one mistake, generation error Excel file for any row data content.
8. calibration equipment as claimed in claim 7, which is characterized in that further include:
Output module exports if not meeting the verification rule of the use-case template for the gauge outfit columns and gauge outfit title
Error message.
9. calibration equipment as claimed in claim 7, which is characterized in that the generation unit includes:
Locator unit, if there is at least one mistake for any row data content, to occur error unit lattice into
Row positioning, records the error unit table rows number, row number, and the error unit lattice are expert at and are added to wrong set；
First generates subelement, for data generation error Excel file in gathering the mistake, and to wrong Excel text
Error unit lattice in part carry out color identifier and error reason mark.
10. calibration equipment as claimed in claim 7, which is characterized in that the correction verification module further include:
Second verification unit, if passing through verification for any row data content, according to the verification of use-case major key rule
Further verified to by check row major key.
11. calibration equipment as claimed in claim 10, which is characterized in that second verification unit includes:
Subelement is verified, for verifying according to the verification rule of the use-case major key to by check row major key；
Second generation subelement is added to described newly by check row if being not present for described by check row major key
Increase set, and data in the newly-increased set are generated into newly-increased Excel file.
12. calibration equipment as claimed in claim 11, which is characterized in that second verification unit further include:
Third generates subelement, if existing for described by check row major key, by it is described be added to by check row it is to be repaired
Change set, and data in the newly-increased set are generated into Excel file to be modified.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510031262.9A CN105868171B (en) | 2015-01-21 | 2015-01-21 | A kind of method of calibration and device of Excel file |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510031262.9A CN105868171B (en) | 2015-01-21 | 2015-01-21 | A kind of method of calibration and device of Excel file |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105868171A CN105868171A (en) | 2016-08-17 |
| CN105868171B true CN105868171B (en) | 2019-04-30 |
Family
ID=56623189
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510031262.9A Active CN105868171B (en) | 2015-01-21 | 2015-01-21 | A kind of method of calibration and device of Excel file |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105868171B (en) |
Families Citing this family (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108427662A (en) * | 2017-02-13 | 2018-08-21 | 北京京东尚科信息技术有限公司 | The methods of exhibiting and device of invalid information |
| CN108628872A (en) * | 2017-03-17 | 2018-10-09 | 广州康昕瑞基因健康科技有限公司 | Genetic analysis database batch data introduction method and system |
| CN108804478B (en) * | 2017-05-05 | 2021-05-25 | 北京京东尚科信息技术有限公司 | Two-dimensional data processing method and device and computer readable storage medium |
| CN108629004A (en) * | 2018-05-03 | 2018-10-09 | 广东电网有限责任公司 | Summarize data capture method, device and electronic equipment |
| CN109241501A (en) * | 2018-08-15 | 2019-01-18 | 北京北信源信息安全技术有限公司 | Document analysis method and apparatus |
| CN109325045B (en) * | 2018-09-21 | 2021-09-28 | 中国银行股份有限公司 | Method and device for opening bank |
| CN109446493B (en) * | 2018-10-17 | 2022-06-24 | 网易（杭州）网络有限公司 | Data processing method, data processing apparatus, storage medium, and electronic apparatus |
| CN109635300B (en) * | 2018-12-14 | 2023-12-19 | 泰康保险集团股份有限公司 | Data verification method and device |
| CN111736805B (en) * | 2019-03-25 | 2024-04-05 | 北京沃东天骏信息技术有限公司 | Method and device for processing Excel table |
| CN110929110B (en) * | 2019-11-13 | 2023-02-21 | 北京北信源软件股份有限公司 | Electronic document detection method, device, equipment and storage medium |
| CN111159997B (en) * | 2019-12-31 | 2024-04-05 | 无锡识凌科技有限公司 | Intelligent verification method for enterprise bidding document |
| CN111931460B (en) * | 2020-07-02 | 2021-09-10 | 上海微亿智造科技有限公司 | Variable-row-supporting Excel file analysis method and system |
| CN112988870A (en) * | 2021-03-19 | 2021-06-18 | 浪潮云信息技术股份公司 | Implementation method and tool for reading excel file |
| CN113792017A (en) * | 2021-11-17 | 2021-12-14 | 中建电子商务有限责任公司 | Method and system for checking template content imported into excel |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102012935A (en) * | 2010-12-06 | 2011-04-13 | 江西省电力公司信息通信中心 | Method for processing data among systems by using Excel |
| CN102299965A (en) * | 2011-08-31 | 2011-12-28 | 深圳市五巨科技有限公司 | Method and device for importing EXCEL data |
| CN103838740A (en) * | 2012-11-21 | 2014-06-04 | 方欣科技有限公司 | Report engine method |
| CN103927236A (en) * | 2013-01-11 | 2014-07-16 | 深圳市腾讯计算机系统有限公司 | Online verification method and device |
| CN104239162A (en) * | 2014-09-09 | 2014-12-24 | 北京国双科技有限公司 | Data check method and data check device |
| CN104361119A (en) * | 2014-12-02 | 2015-02-18 | 中国农业银行股份有限公司 | Data cleaning method and system |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7117430B2 (en) * | 2001-02-27 | 2006-10-03 | Microsoft Corporation | Spreadsheet error checker |
| CN101894099B (en) * | 2010-06-29 | 2011-07-27 | 北京科技大学 | Report template customization method |
| CN103164328B (en) * | 2011-12-12 | 2016-06-22 | 中国移动通信集团陕西有限公司 | The regression testing method of a kind of business function, Apparatus and system |
| CN103268335A (en) * | 2013-05-13 | 2013-08-28 | 中国农业银行股份有限公司 | Report data filling method and system |
-
2015
- 2015-01-21 CN CN201510031262.9A patent/CN105868171B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102012935A (en) * | 2010-12-06 | 2011-04-13 | 江西省电力公司信息通信中心 | Method for processing data among systems by using Excel |
| CN102299965A (en) * | 2011-08-31 | 2011-12-28 | 深圳市五巨科技有限公司 | Method and device for importing EXCEL data |
| CN103838740A (en) * | 2012-11-21 | 2014-06-04 | 方欣科技有限公司 | Report engine method |
| CN103927236A (en) * | 2013-01-11 | 2014-07-16 | 深圳市腾讯计算机系统有限公司 | Online verification method and device |
| CN104239162A (en) * | 2014-09-09 | 2014-12-24 | 北京国双科技有限公司 | Data check method and data check device |
| CN104361119A (en) * | 2014-12-02 | 2015-02-18 | 中国农业银行股份有限公司 | Data cleaning method and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105868171A (en) | 2016-08-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105868171B (en) | A kind of method of calibration and device of Excel file | |
| CN102331967B (en) | Method for managing chip verification test cases | |
| CN104361139B (en) | Data importing device and method | |
| CN110908890A (en) | Automatic test method and device for interface | |
| CN106383859A (en) | Test flight data analysis processing method | |
| CN102662930A (en) | Corpus tagging method and corpus tagging device | |
| CN101859303A (en) | Metadata management method and management system | |
| CN107870827A (en) | Data quality control method and device based on verification | |
| CN109426611A (en) | A kind of method for testing software and device | |
| CN107506190A (en) | XML file amending method and device based on Spring frameworks | |
| CN103399848A (en) | Engine test data standardized specific format leading-in processing method | |
| CN104375940A (en) | Debugging method for javaScript file | |
| CN105573972B (en) | The generation method and device of report check formula | |
| CN110377566A (en) | Arrange the method and system of the S parameter test file of PCB | |
| CN109815224A (en) | Data quality checking and the method and apparatus of cleaning | |
| CN107391377B (en) | Method for testing software integration based on combined flow chart | |
| CN104317600B (en) | A kind of configurable curve drawing generating method and system | |
| CN103699482B (en) | Method and device for testing reasonableness of controls | |
| CN106777025B (en) | Analysis method and system of database physical model | |
| EP4184313A1 (en) | Demand conformity analysis method and system, and electronic device and storage medium | |
| CN102651097A (en) | Electronic evaluating system and electronic evaluating method | |
| CN109614602A (en) | A kind of rapid generation of profile measurement report | |
| CN105227333B (en) | The method and apparatus of network element device data maintenance | |
| CN108829968A (en) | Circuit diagram checking method based on Python spread function | |
| CN107894940A (en) | A kind of log analysis device and method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: 518048 Shenzhen Riverside Road, Futian District, Shenzhen, Guangdong, 1141 Applicant after: Medium shift information technology Co., Ltd. Address before: 518048 Guangdong province Futian District Shenzhen City Binhe Road, No. 9023, building 11, 41 layers of the country through the Applicant before: China Mobile (Shenzhen) Co., Ltd. |
|
| CB02 | Change of applicant information | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |