CN105868171A - Checking method and device of Excel file - Google Patents
Checking method and device of Excel file Download PDFInfo
- Publication number
- CN105868171A CN105868171A CN201510031262.9A CN201510031262A CN105868171A CN 105868171 A CN105868171 A CN 105868171A CN 201510031262 A CN201510031262 A CN 201510031262A CN 105868171 A CN105868171 A CN 105868171A
- Authority
- CN
- China
- Prior art keywords
- excel file
- verification
- mistake
- row
- verification rule
- 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.)
- Granted
Links
Landscapes
- Machine Translation (AREA)
Abstract
The invention provides a checking method and device of an Excel file, and relates to the technical field of business support. The checking method of the Excel file comprises the following steps: analyzing an Excel file to be detected, and obtaining data contents of the Excel file to be detected; according to the data contents of the Excel file to be detected, selecting a corresponding use case template, and obtaining a checking rule of the use case template, wherein the checking rule comprises the checking rule of the use case template and the checking rule of a use case major key; and according to the checking rule of the use case template, checking the header column number and the header name of the Excel file to be detected, and carrying out checking on the data contents of the Excel file to be detected according to the checking rule of the use case template if the header column number and the header name is in accordance with the checking rule of the use case template. The scheme in the method and device can locate wrong data in the Excel file by checking the use case template, labels the wrong data to generate a wrong Excel file and can directly revise the wrong data so as to lower a data error rate and greatly improve working efficiency.
Description
Technical field
The present invention relates to business support technical field, particularly relate to method of calibration and the dress of a kind of Excel file
Put.
Background technology
In field tests, test data management is very the key link, the use-case data of Excel form
Performing and safeguarding is topmost mode in current test job.If only single-set operation and data volume compare
Little, safeguard that an Excel file is fairly simple, but to carry out maintenance test data by a system, then
Excel just seems particularly significant with the succinct, easy-to-use of the interaction of system.All test execution personnel are
Wish as best one can time flower to be designed and in test execution rather than be used in by number of cases in the coverage of use-case
During repeatedly searching amendment.
But, in existing test data are submitted to, the system page can provide the specific descriptions literary composition of data problem
Word, its prompting interface is as it is shown in figure 1, but have ignored the time of orientation problem in Excel, especially
Depositing in a case of a considerable amount of data, positioning problems reparation are the numerous and diverse work with time-consuming of comparison one by one.Separately
Outward, when prior art processes Excel Issues of data-verifying, also tend to ignore a crucial factor, i.e.
Interaction between people and Excel, system three, particularly Excel data volume is the biggest, and man-machine interaction is more
Difficulty, wherein, is primarily present following problem:
1, check information interface and data manipulation interface are frequently switched；
2, data locking speed is slow；
3, data comparison efficiency is low；
4, amendment error rate is high；
5, return original repeat revise efficiency low.
Summary of the invention
The technical problem to be solved in the present invention is to provide method of calibration and the device of a kind of Excel file, it is possible to
Need not frequently switch and check check information interface and data manipulation interface, it is achieved to Excel file to be verified
In wrong data position, reduce data error rate.
In order to solve above-mentioned technical problem, the present invention adopts the following technical scheme that
According to one aspect of the present invention, it is provided that the method for calibration of a kind of Excel file, including:
Excel file to be detected is resolved, obtains the data content of described Excel file to be verified；
Data content according to described Excel file to be verified selects corresponding use-case template, obtains described use
The verification rule of example template, wherein, described verification rule includes: the verification rule of use-case template and use-case master
The verification rule of key；
Verification rule according to described use-case template, gauge outfit columns and the table to described Excel file to be verified
First place claims to verify, if described gauge outfit columns and gauge outfit title meet the verification rule of described use-case template,
Then according to the verification rule of example template, the data content of described Excel file to be verified is verified.
Alternatively, described method of calibration also includes: if described gauge outfit columns and gauge outfit title do not meet described use
The verification rule of example template, then output error message.
Alternatively, if described gauge outfit columns and gauge outfit title meet the verification rule of described use-case template, then root
The step verified the data content of described Excel file to be verified according to the verification rule of example template includes:
Verification rule according to described use-case template, to any row data in described Excel file to be verified
Content verifies；
If there is at least one mistake, then generation error Excel file in described any row data content.
Alternatively, if at least one mistake, then generation error Excel literary composition occurs in described any row data content
The step of part includes:
If at least one mistake occurs in described any row data content, then to occurring that error unit lattice position,
Record described error unit table rows number, row number, and described error unit lattice are expert at add to mistake gather；
By data genaration mistake Excel file in described mistake set, and to the mistake in mistake Excel file
Cell carries out colour code and error reason mark by mistake.
Alternatively, according to the verification rule of example template, the data content of described Excel file to be verified is carried out
The step of verification also includes: if any row data content is all by verification, then according to the school of described use-case major key
Test rule to verify by check row major key further.
Alternatively, if any row data content is all by verification, then according to the verification rule of described use-case major key
Further the step verified by check row major key is included:
Verification rule according to described use-case major key verifies by check row major key；
Do not existed by check row major key if described, then add newly-increased set by described to by check row, and
Increase data genaration in described newly-increased set newly Excel file.
Alternatively, existed by check row major key if described, then by described added to by check row to be modified
Set, and by data genaration Excel file to be modified in described newly-increased set.
According to another aspect of the present invention, additionally provide the calibration equipment of a kind of Excel file, including:
Parsing module, for resolving Excel file to be detected, obtains described Excel to be detected literary composition
The data content of part；
Select module, select corresponding use-case mould for the data content according to described Excel file to be verified
Plate, obtains the verification rule of described use-case template, and wherein, described verification rule includes: the school of use-case template
Test the verification rule of rule and use-case major key；
Correction verification module, for the verification rule according to described use-case template, to described Excel file to be verified
Gauge outfit columns and gauge outfit title verify, if described gauge outfit columns and gauge outfit title meet described use-case mould
The verification rule of plate, then according to the regular data content to described Excel file to be verified of verification of example template
Verify.
Alternatively, described calibration equipment also includes: output module, if for described gauge outfit columns and gauge outfit name
Claim the verification rule not meeting described use-case template, then output error message.
Alternatively, described correction verification module includes:
First verification unit, for the verification rule according to described use-case template, to described Excel to be verified
Any row data content in file verifies；
, if there is at least one mistake, then generation error for described any row data content in signal generating unit
Excel file.
Alternatively, described signal generating unit includes:
, if there is at least one mistake for described any row data content, then to mistake occur in locator unit
Cell positions by mistake, records described error unit table rows number, row number, and by described error unit lattice institute
It is expert at and adds mistake set to；
First generates subelement, for by data genaration mistake Excel file in described mistake set and right
Error unit lattice in mistake Excel file carry out colour code and error reason mark.
Alternatively, described correction verification module also includes:
Second verification unit, if for any row data content all by verification, then according to described use-case major key
Verification rule verify by check row major key further.
Alternatively, described second verification unit includes:
Syndrome unit, carries out school for the verification rule according to described use-case major key to by check row major key
Test；
Second generates subelement, if not existed by check row major key for described, then by described by verification
Row adds newly-increased set to, and increases data genaration in described newly-increased set newly Excel file.
Alternatively, described second verification unit also includes:
3rd generates subelement, if being existed by check row major key for described, then passes through check row by described
Add set to be modified to, and by data genaration Excel file to be modified in described newly-increased set.
The invention has the beneficial effects as follows:
The method of calibration of the Excel file in the present invention program, first solves Excel file to be verified
Analysis, obtains the data content in Excel file to be verified, then according to the number in Excel file to be verified
Use-case template is verified accordingly according to content choice, regular to be verified according to the verification of the use-case template selected
Excel file verifies, and wherein, verification rule includes: the verification rule of use-case template and use-case major key
Verification rule.Then according to the verification rule of use-case template, the gauge outfit columns to Excel file to be verified
And gauge outfit title verifies, if gauge outfit columns and gauge outfit title meet the verification rule of use-case template, then root
According to the verification rule of example template, the data content of Excel file to be verified is verified.Side in the present invention
To in Excel file to be verified, case can occur that wrong data positions, and can extract wrong data
And generate new Excel file, it is achieved that read and operate interface and carry out simultaneously, it is to avoid changing interface is given
The data accumulating that user brings and the requirement of Data Comparison, reduce error rate, improve work efficiency.
Accompanying drawing explanation
Fig. 1 represents wrong data check results schematic diagram in prior art；
Fig. 2 represents Excel file method of calibration flow chart in the embodiment of the present invention；
Fig. 3 represents the verification operation flow chart of Excel file in the embodiment of the present invention；
Fig. 4 represents the structured flowchart of Excel file calibration equipment in the embodiment of the present invention；
Fig. 5 represents the structured flowchart of correction verification module in the embodiment of the present invention；
Fig. 6 represents the structured flowchart of signal generating unit in the embodiment of the present invention；
Fig. 7 represents the structured flowchart of the second verification unit in the embodiment of the present invention.
Detailed description of the invention
For making the object, technical solutions and advantages of the present invention clearer, below in conjunction with accompanying drawing and specifically real
Execute example to describe the present invention.
Embodiment one
The embodiment of the invention discloses the method for calibration of a kind of Excel file, as in figure 2 it is shown, the method 200
Comprise the following steps:
Step S201, Excel file to be verified is resolved, obtain the data of Excel file to be verified
Content；
Step S203, select corresponding use-case template according to the data content of Excel file to be verified, obtain
The verification rule of use-case template, wherein, verification rule includes: the verification rule of use-case template and use-case major key
Verification rule, specifically, in use-case template, the verification rule of every item data is with the form of Map object guarantor
Deposit, the major key verification rule of use-case template has all already present major key set of this use-case template, and
Preserve with the form of Map object equally；
Step S205, according to the verification of use-case template rule, to the gauge outfit columns of Excel file to be verified and
Gauge outfit title verifies, if gauge outfit columns and gauge outfit title meet the verification rule of use-case template, then basis
The data content of Excel file to be verified is verified by the verification rule of example template.
Specifically, in embodiments of the present invention, the first sheet page of traversal to Excel file to be verified,
The regular gauge outfit columns to Excel file sheet page to be verified of verification according to use-case template and gauge outfit title
Verify, if gauge outfit columns and gauge outfit title do not meet the verification rule of use-case template, then output error letter
Breath, and error message is saved in predefined global variable, this global variable is used for preserving to be waited to increase newly
Data, data to be modified and the set of wrong data.Wherein, if gauge outfit columns and gauge outfit title meet use-case
The verification rule of template, then carried out the data content of Excel file to be measured according to the verification rule of example template
Verification, when verifying, specifically includes following steps:
Verification rule according to use-case template, is carried out any row data content in Excel file to be verified
Verification；
If there is at least one mistake, then generation error Excel file in any row data content.
Wherein, if at least one mistake, the then step of generation error Excel file occurs in any row data content
Suddenly include:
If at least one mistake occurs in any row data content, then to occurring that error unit lattice position, note
Record error unit table rows number, row number, and error unit lattice are expert at add to mistake gather；
By data genaration mistake Excel file in mistake set and single to the mistake in mistake Excel file
Unit's lattice carry out colour code and error reason mark.
Specifically, in embodiments of the present invention, for Excel file to be verified, with behavior unit, according to
The verification rule of use-case template, verifies each cell data one by one, if any row data content occurs at least
One mistake, then add the row data mistake set to, then resolving the row data, working as chance
To with use-case template verification rule do not correspond data time, record this cell place line number and row number, and
It is saved in predefined global variable.When generation error Excel file, according to the error number of record
According to line number and row number, utilize the function that cell can be highlighted by Excel, mistake Excel
File carries out colour code to wrong data place cell, greatly improves user's Wrong localization data
Speed, and also utilize excel that cell is marked annotation function, it is possible to by the error reason of wrong data
Mark is to cell to be modified, it is achieved that i.e. looking into of data manipulation i.e. changes, and greatly improves efficiency.
In embodiments of the present invention, according to the verification rule of use-case template, in Excel file to be verified
When any row data content verifies, if any row data content is all by verification, then according to use-case major key
Verification rule verify by check row major key further, it specifically includes:
Verification rule according to use-case major key verifies by check row major key；
If not existed by check row major key, then will add newly-increased set to by check row, and by newly-increased collection
In conjunction, data genaration increases Excel file newly；If being existed by check row major key, then will be added by check row
To set to be modified, and by data genaration Excel file to be modified in newly-increased set.
Specifically, in embodiments of the present invention, the verification according to use-case major key is regular to Excel to be verified
When file verifies, the major key set stored by the verification rule of inquiry use-case major key, it is possible to will not
The full line data being present in major key set add newly-increased data acquisition system to, will be present in the full line that major key is concentrated
Data are added in data acquisition system to be modified, and using current data as up-to-date standard.
Specifically, when carrying out verification operation, as it is shown on figure 3, first complete Excel file to be verified with
The unification of use-case template, i.e. resolves user and presents a paper, return all of sheet page and sheet page data,
According to Excel file type to be verified, sheet page data is read out, and is arranged on this and verified
Global variable in journey, for preserving data to be increased newly, data to be modified and the set of wrong data.Then
Select corresponding use-case template, obtain verification rule and the use-case major key verification rule of this use-case template, and right
Excel file to be verified verifies.Because Excel file type to be verified is different, therefore when verifying,
Its title and columns also differ, therefore according to the must value of title to Excel file to be verified
Gauge outfit verify, if title meet use-case template verification rule, the most further to be verified
The data content of Excel file verifies.When carrying out data check, if wrong data being detected, then
In the global variable that error message is preserved, and newly-increased data, data to be modified and wrong data are carried out
Shunting storage, generates newly-increased Excel file, Excel file to be modified and mistake Excel file respectively,
Above-mentioned check results is backed within client, it is simple to user processes.Side in the embodiment of the present invention
Case changes user and checks data check information and data manipulation interface manner simultaneously, by prior art two
The operation interface separated is merged, and can be according to verification rule by the number in Excel file to be verified
According to extracting, generation error Excel file, newly-increased Excel file and Excel file to be modified,
The problem of checking in prior art that decreases describes the plenty of time spent by orientation problem.It addition, user can be from
Mistake Excel file is directly found out data and the error reason of correspondence of concrete mistake, improves data fixed
Position and the efficiency of comparing；And can directly the data in mistake Excel file be modified, again
Submission verifies again, and data volume that each submission all can make system process is more last successively decreases rapidly, greatly
Promote greatly data-handling efficiency, solve the problem that data volume larger process process is complicated.
Embodiment two
The embodiment of the present invention discloses the calibration equipment of a kind of Excel file, as shown in Figure 4, this device
400 include:
Parsing module 401, for resolving Excel file to be detected, obtains Excel to be detected literary composition
The data content of part；
Select module 403, select corresponding use-case mould for the data content according to Excel file to be verified
Plate, obtains the verification rule of use-case template, and wherein, verification rule includes: the verification of use-case template rule and
The verification rule of use-case major key；
Correction verification module 405, for the verification rule according to use-case template, the table to Excel file to be verified
Head columns and gauge outfit title verify, if gauge outfit columns and gauge outfit title meet the verification rule of use-case template,
Then according to the verification rule of example template, the data content of Excel file to be verified is verified.
Output module 407, if do not meet the verification rule of use-case template for gauge outfit columns and gauge outfit title,
Then output error message.
Specifically, as it is shown in figure 5, be the structured flowchart of correction verification module 405 in the embodiment of the present invention, wherein
Correction verification module 405 includes:
First verification unit 4051, for the verification rule according to use-case template, to Excel file to be verified
In any row data content verify；
, if there is at least one mistake, then generation error for any row data content in signal generating unit 4053
Excel file.
Specifically, as shown in Figure 6, for the structured flowchart of signal generating unit in the embodiment of the present invention 4053, life
Unit 4053 is become to include:
, if there is at least one mistake, then to appearance for any row data content in locator unit 40531
Error unit lattice position, misregistration cell line number, row number, and are expert at by error unit lattice and add
It is added to mistake set；
First generates subelement 40533, is used for data genaration mistake Excel file in mistake set, and
Error unit lattice in mistake Excel file are carried out colour code and error reason mark.
Further, as it is shown in figure 5, be the structured flowchart of correction verification module 405, school in the embodiment of the present invention
Test module 405 also to include:
Second verification unit 4055, if for any row data content all by verification, then according to use-case master
The verification rule of key verifies by check row major key further.
Specifically, as it is shown in fig. 7, be the structured flowchart of the second verification unit 4055 in the embodiment of the present invention,
Second verification unit 4055 includes:
Syndrome unit 40551, is carried out by check row major key for the verification rule according to use-case major key
Verification；
Second generates subelement 40553, if for not existed by check row major key, then will pass through check row
Add newly-increased set to, and increase data genaration in newly-increased set newly Excel file；And
3rd generates subelement 40555, if for being existed by check row major key, then will be added by check row
It is added to set to be modified, and by data genaration Excel file to be modified in newly-increased set.
Above-described is the preferred embodiment of the present invention, it should be pointed out that for the ordinary people of the art
For Yuan, some improvements and modifications can also be made under without departing from principle premise of the present invention, these
Improvements and modifications are the most within the scope of the present invention.
Claims (14)
1. the method for calibration of an Excel file, it is characterised in that including:
Excel file to be verified is resolved, obtains the data content of described Excel file to be verified；
Data content according to described Excel file to be verified selects corresponding use-case template, obtains described use
The verification rule of example template, wherein, described verification rule includes: the verification rule of use-case template and use-case master
The verification rule of key；
Verification rule according to described use-case template, gauge outfit columns and the table to described Excel file to be verified
First place claims to verify, if described gauge outfit columns and gauge outfit title meet the verification rule of described use-case template,
Then according to the verification rule of example template, the data content of described Excel file to be verified is verified.
2. method of calibration as claimed in claim 1, it is characterised in that also include: if described gauge outfit row
Number and gauge outfit title do not meet the verification rule of described use-case template, then output error message.
3. method of calibration as claimed in claim 1, it is characterised in that if described gauge outfit columns and gauge outfit
Title meets the verification rule of described use-case template, then the verification according to example template is regular to described to be verified
The step that the data content of Excel file carries out verifying includes:
Verification rule according to described use-case template, to any row data in described Excel file to be verified
Content verifies；
If there is at least one mistake, then generation error Excel file in described any row data content.
4. method of calibration as claimed in claim 3, it is characterised in that if described any row data content
At least one mistake occur, then the step of generation error Excel file includes:
If at least one mistake occurs in described any row data content, then to occurring that error unit lattice position,
Record described error unit table rows number, row number, and described error unit lattice are expert at add to mistake gather；
By data genaration mistake Excel file in described mistake set, and to the mistake in mistake Excel file
Cell carries out colour code and error reason mark by mistake.
5. method of calibration as claimed in claim 3, it is characterised in that also include:
If any row data content is all by verification, then the verification rule according to described use-case major key is the most right
Verified by check row major key.
6. method of calibration as claimed in claim 5, it is characterised in that if any row data content is the most logical
Cross verification, then according to the verification rule of described use-case major key further to being verified by check row major key
Step includes:
Verification rule according to described use-case major key verifies by check row major key；
Do not existed by check row major key if described, then add newly-increased set by described to by check row, and
Increase data genaration in described newly-increased set newly Excel file.
7. method of calibration as claimed in claim 6, it is characterised in that also include: pass through school described in if
Test row major key to exist, then add set to be modified by described to by check row, and by described newly-increased set
Data genaration Excel file to be modified.
8. the calibration equipment of an Excel file, it is characterised in that including:
Parsing module, for resolving Excel file to be detected, obtains described Excel to be detected literary composition
The data content of part；
Select module, select corresponding use-case mould for the data content according to described Excel file to be verified
Plate, obtains the verification rule of described use-case template, and wherein, described verification rule includes: the school of use-case template
Test the verification rule of rule and use-case major key；
Correction verification module, for the verification rule according to described use-case template, to described Excel file to be verified
Gauge outfit columns and gauge outfit title verify, if described gauge outfit columns and gauge outfit title meet described use-case mould
The verification rule of plate, then according to the regular data content to described Excel file to be verified of verification of example template
Verify.
9. calibration equipment as claimed in claim 8, it is characterised in that also include:
Output module, if not meeting the verification rule of described use-case template for described gauge outfit columns and gauge outfit title
Then, then output error message.
10. calibration equipment as claimed in claim 8, it is characterised in that described correction verification module includes:
First verification unit, for the verification rule according to described use-case template, to described Excel to be verified
Any row data content in file verifies；
, if there is at least one mistake, then generation error for described any row data content in signal generating unit
Excel file.
11. calibration equipments as claimed in claim 10, it is characterised in that described signal generating unit includes:
, if there is at least one mistake for described any row data content, then to mistake occur in locator unit
Cell positions by mistake, records described error unit table rows number, row number, and by described error unit lattice institute
It is expert at and adds mistake set to；
First generates subelement, for by data genaration mistake Excel file in described mistake set and right
Error unit lattice in mistake Excel file carry out colour code and error reason mark.
12. calibration equipments as claimed in claim 10, it is characterised in that described correction verification module also includes:
Second verification unit, if for any row data content all by verification, then according to described use-case major key
Verification rule verify by check row major key further.
13. calibration equipments as claimed in claim 12, it is characterised in that described second verification unit bag
Include:
Syndrome unit, carries out school for the verification rule according to described use-case major key to by check row major key
Test；
Second generates subelement, if not existed by check row major key for described, then by described by verification
Row adds newly-increased set to, and increases data genaration in described newly-increased set newly Excel file.
14. calibration equipments as claimed in claim 13, it is characterised in that described second verification unit is also
Including:
3rd generates subelement, if being existed by check row major key for described, then passes through check row by described
Add set to be modified to, and by data genaration Excel file to be modified in described newly-increased set.
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 true CN105868171A (en) | 2016-08-17 |
| CN105868171B 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) |
Cited By (15)
| 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 |
| CN108629004A (en) * | 2018-05-03 | 2018-10-09 | 广东电网有限责任公司 | Summarized data acquisition method and device and electronic equipment |
| CN108804478A (en) * | 2017-05-05 | 2018-11-13 | 北京京东尚科信息技术有限公司 | 2-D data processing method, device and computer readable storage medium |
| CN109241501A (en) * | 2018-08-15 | 2019-01-18 | 北京北信源信息安全技术有限公司 | Document analysis method and apparatus |
| CN109325045A (en) * | 2018-09-21 | 2019-02-12 | 中国银行股份有限公司 | A kind of method and device of issuing bank |
| CN109446493A (en) * | 2018-10-17 | 2019-03-08 | 网易（杭州）网络有限公司 | Data processing method, device, storage medium and electronic device |
| CN109635300A (en) * | 2018-12-14 | 2019-04-16 | 泰康保险集团股份有限公司 | Data verification method and device |
| CN110929110A (en) * | 2019-11-13 | 2020-03-27 | 北京北信源软件股份有限公司 | Electronic document detection method, device, equipment and storage medium |
| CN111159997A (en) * | 2019-12-31 | 2020-05-15 | 无锡识凌科技有限公司 | Intelligent verification method for enterprise bid document |
| CN111736805A (en) * | 2019-03-25 | 2020-10-02 | 北京沃东天骏信息技术有限公司 | Method and device for processing Excel table |
| CN111931460A (en) * | 2020-07-02 | 2020-11-13 | 上海微亿智造科技有限公司 | 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 |
| CN114742022A (en) * | 2022-04-21 | 2022-07-12 | 深圳我家云网络科技有限公司 | Custom field content importing method and related equipment |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7117430B2 (en) * | 2001-02-27 | 2006-10-03 | Microsoft Corporation | Spreadsheet error checker |
| CN101894099A (en) * | 2010-06-29 | 2010-11-24 | 北京科技大学 | Report template customization method |
| 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 |
| CN103164328A (en) * | 2011-12-12 | 2013-06-19 | 中国移动通信集团陕西有限公司 | Method and device and system for regression testing of service function |
| CN103268335A (en) * | 2013-05-13 | 2013-08-28 | 中国农业银行股份有限公司 | Report data filling method and system |
| 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 |
-
2015
- 2015-01-21 CN CN201510031262.9A patent/CN105868171B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7117430B2 (en) * | 2001-02-27 | 2006-10-03 | Microsoft Corporation | Spreadsheet error checker |
| CN101894099A (en) * | 2010-06-29 | 2010-11-24 | 北京科技大学 | Report template customization method |
| 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 |
| CN103164328A (en) * | 2011-12-12 | 2013-06-19 | 中国移动通信集团陕西有限公司 | Method and device and system for regression testing of service function |
| CN103838740A (en) * | 2012-11-21 | 2014-06-04 | 方欣科技有限公司 | Report engine method |
| CN103927236A (en) * | 2013-01-11 | 2014-07-16 | 深圳市腾讯计算机系统有限公司 | Online verification method and device |
| CN103268335A (en) * | 2013-05-13 | 2013-08-28 | 中国农业银行股份有限公司 | Report data filling method and system |
| 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 |
Cited By (22)
| 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 |
| CN108804478A (en) * | 2017-05-05 | 2018-11-13 | 北京京东尚科信息技术有限公司 | 2-D data processing method, device and computer readable storage medium |
| CN108629004A (en) * | 2018-05-03 | 2018-10-09 | 广东电网有限责任公司 | Summarized data acquisition method and 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 |
| CN109325045A (en) * | 2018-09-21 | 2019-02-12 | 中国银行股份有限公司 | A kind of method and device of issuing bank |
| CN109446493A (en) * | 2018-10-17 | 2019-03-08 | 网易（杭州）网络有限公司 | Data processing method, device, storage medium and electronic device |
| 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 |
| CN109635300A (en) * | 2018-12-14 | 2019-04-16 | 泰康保险集团股份有限公司 | Data verification method and device |
| CN111736805A (en) * | 2019-03-25 | 2020-10-02 | 北京沃东天骏信息技术有限公司 | Method and device for processing Excel table |
| CN111736805B (en) * | 2019-03-25 | 2024-04-05 | 北京沃东天骏信息技术有限公司 | Method and device for processing Excel table |
| CN110929110A (en) * | 2019-11-13 | 2020-03-27 | 北京北信源软件股份有限公司 | Electronic document detection method, device, equipment and storage medium |
| CN111159997A (en) * | 2019-12-31 | 2020-05-15 | 无锡识凌科技有限公司 | Intelligent verification method for enterprise bid document |
| CN111159997B (en) * | 2019-12-31 | 2024-04-05 | 无锡识凌科技有限公司 | Intelligent verification method for enterprise bidding document |
| CN111931460A (en) * | 2020-07-02 | 2020-11-13 | 上海微亿智造科技有限公司 | Variable-row-supporting Excel file analysis method and system |
| 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 |
| CN114742022A (en) * | 2022-04-21 | 2022-07-12 | 深圳我家云网络科技有限公司 | Custom field content importing method and related equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105868171B (en) | 2019-04-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105868171A (en) | Checking method and device of Excel file | |
| CN102831121B (en) | Method and system for extracting webpage information | |
| CN103631969B (en) | A kind of generation method and device of report data | |
| CN103473056B (en) | A kind of remote measurement configuration file automatic generation method | |
| CN103365998B (en) | A kind of similar character string search method | |
| CN106547729B (en) | A kind of dynamic creation method and system of data sheet | |
| CN104063365B (en) | The method that object is inserted into PDF document | |
| CN104361025B (en) | A kind of multi-source Spatial Data fusion and integrated method | |
| CN103777934B (en) | A kind of method and system generating controller CAN alternation of bed based on MATLAB | |
| CN107797916A (en) | DDL sentences checking method and device | |
| CN103198071B (en) | Datagram table generating method and device thereof | |
| CN106095964A (en) | A kind of method that data are carried out visualization filing and search | |
| CN104574141A (en) | Service influence degree analysis method | |
| CN104636401A (en) | Method and device for data rollback of SCADA (supervisory control and data acquisition) system | |
| CN105354272A (en) | Indicator calculating method and system based on dimension combinations | |
| CN105260300A (en) | Service test method based on CAS (General Classification Standards of China Accounting Standards) application platform | |
| CN101976394A (en) | Data acquiring and counting system and method | |
| CN107908843B (en) | Management system based on drawing of map label information | |
| CN109582286A (en) | Data standard method of calibration and its device based on Freemarker technology | |
| CN105573972A (en) | Report check formula generation method and apparatus | |
| CN109783784A (en) | A kind of data processing method and form builder based on the combination of minimum list | |
| CN111178615B (en) | Method and system for constructing enterprise risk identification model | |
| CN107391377B (en) | Method for testing software integration based on combined flow chart | |
| CN107169294A (en) | The secondary judgement processing method of Excel forms in a kind of ATS for Environmental Test | |
| CN103942224A (en) | Method and device for acquiring annotation rule of webpage blocks |
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 |