CN108427662A - The methods of exhibiting and device of invalid information - Google Patents
The methods of exhibiting and device of invalid information Download PDFInfo
- Publication number
- CN108427662A CN108427662A CN201710075497.7A CN201710075497A CN108427662A CN 108427662 A CN108427662 A CN 108427662A CN 201710075497 A CN201710075497 A CN 201710075497A CN 108427662 A CN108427662 A CN 108427662A
- Authority
- CN
- China
- Prior art keywords
- excel
- data
- invalid
- tables
- excel tables
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/169—Annotation, e.g. comment data or footnotes
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/103—Formatting, i.e. changing of presentation of documents
- G06F40/106—Display of layout of documents; Previewing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Transfer Between Computers (AREA)
Abstract
This application discloses a kind of methods of exhibiting of invalid information and device, wherein method includes：The excel data flows that application system is uploaded to user carry out legitimate verification, and record the excel table location informations corresponding to every invalid data；Corresponding excel tables are generated according to the excel data flows；According to the excel table location informations corresponding to all invalid datas, the excel tables are revised, the revised excel tables only include the row data corresponding to all invalid datas, and invalid data therein is marked using preset identification means；The revised excel tables are uploaded to file server, and the user is notified to download the excel tables.The present invention is suitable for the application scenarios that high-volume data import.
Description
Technical field
The present invention relates to Computer Applied Technologies, more particularly to the methods of exhibiting and device of a kind of invalid information.
Background technology
With flourishing for information technology, the use of application system is further popularized, and system user is to large quantities of
The typing for measuring data still gets used to excel table importings.So system batch import function is very universal, also becomes and much answer
With the necessary functions of system.
Currently, the import feature that application system provides, invalid information is prompted by WEB page, typically in the page
Middle prompt user success quantity and failure quantity, or the form by showing invalid information list in the page, will be illegal
Information shows user, and prompts which information of user illegal.In this way, user looks for according to the invalid information of system page prompts
It is revised to the corresponding information in excel tables, finally for revised information generates new excel tables again and imported into and answer
With in system.
The exhibition scheme of above-mentioned invalid information is only applicable to need to import the smaller application scenarios of data volume, when needs are led
When the data volume entered is larger, if it is more to encounter data invalid information, while after these a large amount of invalid informations are prompted to user,
User's needs find their specific location according to these a large amount of invalid informations in excel tables and modify, in this way, can lead
Family of applying is very heavy to the revision amount of invalid information.Also, it if using the prompting mode of invalid information list, largely counts
According to needing to be stored in the prompt page, the page can be caused to load slow problem.Therefore, the exhibition method of existing invalid information
It is not suitable for the importing of large-scale data.
Invention content
In view of this, the main purpose of the present invention is to provide a kind of methods of exhibiting of invalid information and device, it is suitable for
The scene that high-volume data import.
In order to achieve the above object, technical solution proposed by the present invention is：
A kind of methods of exhibiting of invalid information, including：
The excel data flows that application system is uploaded to user carry out legitimate verification, and record every invalid data institute
Corresponding excel table location informations；
Corresponding excel tables are generated according to the excel data flows；
According to the excel table location informations corresponding to all invalid datas, the excel tables, the revision are revised
Excel tables afterwards only include the row data corresponding to all invalid datas, and invalid data therein uses preset mark side
Formula marks；
The revised excel tables are uploaded to file server, and the user is notified to download the excel tables.
A kind of displaying device of invalid information, including：
Authentication unit, the excel data flows for being uploaded to application system to user carry out legitimate verification, and record every
Excel table location informations corresponding to invalid data；
Excel table generation units, for generating corresponding excel tables according to the excel data flows；According to all described
Excel table location informations corresponding to invalid data, revise the excel tables, and the revised excel tables only include all
Row data corresponding to invalid data, and invalid data therein is marked using preset identification means；
Notification unit for the revised excel tables to be uploaded to file server, and notifies the user to download
The excel tables.
In conclusion the methods of exhibiting and device of invalid information proposed by the present invention, by application system according to verifying
Invalid data generates corresponding excel tables, and user is notified to download the excel tables so that user can be directly according to the excel
Table be would know that the invalid data of the system of being uploaded to, in this way, hereafter user can directly to the invalid data in the excel tables into
Row revision, is uploaded to system, so as to avoid user from upload using revised excel tables as the data newly imported
Original excel tables in find out the heavy operation of invalid data, and prompt page page caused by more than invalid data adds
Carry slow problem.Therefore, the present invention can effectively reduce the workload that user revises invalid data, improve user's batch and import
Working efficiency, be suitable for high-volume data import scene.
Description of the drawings
Fig. 1 is the method flow schematic diagram of the embodiment of the present invention；
Fig. 2 is the apparatus structure schematic diagram of the embodiment of the present invention.
Specific implementation mode
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 further detail.
Core of the invention thought is：System is directly generated according to the full line data where the invalid information detected
Excel tables notify excel tables to user, in this way, user can directly revise on the excel tables notified, revision
Excel tables afterwards can directly be uploaded to application system as the data newly uploaded.In this way, can be inquired to avoid user
The cumbersome problem of user's operation caused by invalid information in excel tables, while also can avoid comprising a large amount of invalid informations
The page loads slow problem, therefore, is suitable for the application scenarios that large-scale data imports.
Fig. 1 is the flow diagram of the embodiment of the present invention, as shown in Figure 1, the displaying for the invalid information that the embodiment is realized
Method includes mainly：
Step 101, user is uploaded to application system excel data flows carry out legitimate verification, and record every it is non-
Excel table location informations corresponding to method data.
In this step, application system needs during the excel data flows imported to user carry out legitimate verification
Record every invalid data cell where excel table location informations i.e. invalid data location information.In this way, can be rear
Face positions invalid data in corresponding excel tables based on these information.
Step 102 generates corresponding excel tables according to the excel data flows.
Here, the excel stream compressions for importing user in application system side is needed to be melted into corresponding excel tables, so as to
The excel tables are handled in subsequent step so that treated, and excel tables are used as being used to indicate illegal number
According to excel tables notify to user.
Specific excel table generating methods are grasped by those skilled in the art, and details are not described herein.
Step 103, the excel table location informations corresponding to all invalid datas, revise the excel tables,
The revised excel tables only include the row data corresponding to all invalid datas, and invalid data therein is using default
Identification means mark.
In this step, the excel tables obtained to the excel data flows uploaded according to user are needed to revise so as to repair
Only include the row data corresponding to all invalid datas in excel tables after ordering, and for the row data not comprising invalid data
It then needs to be removed from it, and in order to make user that invalid data be identified, during revision, it is also necessary to using default
Identification means invalid data is labeled.
Preferably, the identification means may include：Using the row where newly-increased cell instruction invalid data, that is, exist
Every invalid data, which is expert at, increases by a cell, and the instruction information of one's own profession invalid data column is filled in the cell；With/
Or, being highlighted to the cell where invalid data and (such as using the color different from other cells).
Preferably, following methods, which may be used, revises the excel tables：
For invalid data described in every, according to its corresponding excel table location information, in the excel tables
It is marked according to the identification means；
After deleting all valid datas in the excel tables, all blank lines in the excel tables are deleted, are obtained
To the revised excel tables.
Preferably, understanding the reason for knowing that data are illegal for the ease of user, invalid data can be increased in excel tables
Authentication failed reason (i.e. illegal reason), specifically, following methods may be used and realize this purpose：
When carrying out the legitimate verification in a step 101, the illegal reason of every invalid data is recorded；
When carrying out the revision in step 103, increase by an illegal reason cell of row in the excel tables, and will
The illegal reason of every invalid data is filled into the illegal reason cell being expert at.
The revised excel tables are uploaded to file server by step 104, and are notified described in user's download
Excel tables.
The user is notified to download the excel tables preferably, following methods may be used：
According to storage address of the revised excel tables in the file server, download link address is generated；
It is sent to the user by webpage and uploads result prompt message, the upload result prompt message includes：Download link address
The invalid data quantity arrived with this uploading detection.
Fig. 2 is a kind of displaying device of invalid information corresponding with the above method, as shown in Fig. 2, the device includes：
Authentication unit, the excel data flows for being uploaded to application system to user carry out legitimate verification, and record every
Excel table location informations corresponding to invalid data；
Excel table generation units, for generating corresponding excel tables according to the excel data flows；According to all described
Excel table location informations corresponding to invalid data, revise the excel tables, and the revised excel tables only include all
Row data corresponding to invalid data, and invalid data therein is marked using preset identification means；
Notification unit for the revised excel tables to be uploaded to file server, and notifies the user to download
The excel tables.
Preferably, the identification means include：
It (is expert in every invalid data using the row where newly-increased cell instruction invalid data and increases by a unit
Lattice fill the instruction information of one's own profession invalid data column in the cell)；And/or
Cell where invalid data is highlighted.
Preferably, excel table generation units, are used for for invalid data described in every, according to its corresponding excel
Table location information marks in the excel tables according to the identification means；Delete all legal numbers in the excel tables
According to all blank lines later, deleted in the excel tables, the revised excel tables are obtained.
Preferably, the authentication unit, is further used for, when carrying out the legitimate verification, recording every invalid data
Illegal reason；
Excel table generation units are further used for when carrying out the revision, and it is non-to increase by a row in the excel tables
Method reason cell, and the illegal reason of every invalid data is filled into the illegal reason cell being expert at.
Preferably, the notification unit, is used for the storage address according to the excel tables in the file server,
Generate download link address；It is sent to the user by webpage and uploads result prompt message, the upload result prompt message
Including：The invalid data quantity that download link address and this uploading detection arrive.
Through the above scheme as can be seen that the present invention can concisely grip invalid information when user's batch imports data
That wants is prompted to user, in this way, user can directly change invalid data in invalid information excel tables, after changing again
Excel tables be uploaded to system as the data newly imported.It is positioned in mass data illegally in this way, user can be solved
The problem of difficulty data, avoids user from remaking the excel tables imported again, and user positions invalid data and revised
Tedious work becomes simple, effectively improves the working efficiency that user's batch imports.
In conclusion the above is merely preferred embodiments of the present invention, being not intended to limit the scope of the present invention.
All within the spirits and principles of the present invention, any modification, equivalent replacement, improvement and so on should be included in the present invention's
Within protection domain.
Claims (10)
1. a kind of methods of exhibiting of invalid information, which is characterized in that including：
The excel data flows that application system is uploaded to user carry out legitimate verification, and record corresponding to every invalid data
Excel table location informations；
Corresponding excel tables are generated according to the excel data flows；
According to the excel table location informations corresponding to all invalid datas, the excel tables are revised, it is described revised
Excel tables only include the row data corresponding to all invalid datas, and invalid data therein uses preset identification means mark
Note；
The revised excel tables are uploaded to file server, and the user is notified to download the excel tables.
2. according to the method described in claim 1, it is characterized in that, the identification means include：
It is expert in every invalid data and increases by a cell, the instruction letter of filling one's own profession invalid data column in the cell
Breath；And/or
Cell where invalid data is highlighted.
3. according to the method described in claim 1, it is characterized in that, the revision excel tables include：
For invalid data described in every, according to its corresponding excel table location information, in the excel tables according to
The identification means mark；
After deleting all valid datas in the excel tables, all blank lines in the excel tables are deleted, institute is obtained
State revised excel tables.
4. according to the method described in claim 1, it is characterized in that, the method further includes：
When carrying out the legitimate verification, the illegal reason of every invalid data is recorded；
When carrying out the revision, increase by an illegal reason cell of row in the excel tables, and by every invalid data
Illegal reason is filled into the illegal reason cell being expert at.
5. according to the method described in claim 1, it is characterized in that, described notify the user to download the excel tables and include：
According to storage address of the revised excel tables in the file server, download link address is generated；
It is sent to the user by webpage and uploads result prompt message, the upload result prompt message includes：Download link
The invalid data quantity that address and this uploading detection arrive.
6. a kind of displaying device of invalid information, which is characterized in that including：
Authentication unit, for user is uploaded to application system excel data flows carry out legitimate verification, and record every it is non-
Excel table location informations corresponding to method data；
Excel table generation units, for generating corresponding excel tables according to the excel data flows；According to all described illegal
Excel table location informations corresponding to data, revise the excel tables, and the revised excel tables only include all illegal
Row data corresponding to data, and invalid data therein is marked using preset identification means；
Notification unit for the revised excel tables to be uploaded to file server, and notifies described in user's download
Excel tables.
7. device according to claim 6, which is characterized in that the identification means include：
It is expert in every invalid data and increases by a cell, the instruction letter of filling one's own profession invalid data column in the cell
Breath；And/or
Cell where invalid data is highlighted.
8. device according to claim 6, which is characterized in that excel table generation units, for for illegal described in every
Data mark in the excel tables according to the identification means according to its corresponding excel table location information；It deletes
After all valid datas in the excel tables, all blank lines in the excel tables are deleted, after obtaining the revision
Excel tables.
9. device according to claim 6, which is characterized in that the authentication unit is further used for carrying out the conjunction
When method is verified, the illegal reason of every invalid data is recorded；
Excel table generation units are further used for when carrying out the revision, and it is illegal former to increase by a row in the excel tables
It is filled into the illegal reason cell being expert at because of cell, and by the illegal reason of every invalid data.
10. device according to claim 6, the notification unit are used for according to the excel tables in the file service
Storage address in device generates download link address；By webpage to the user send upload result prompt message, it is described on
Passing result prompt message includes：The invalid data quantity that download link address and this uploading detection arrive.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710075497.7A CN108427662A (en) | 2017-02-13 | 2017-02-13 | The methods of exhibiting and device of invalid information |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710075497.7A CN108427662A (en) | 2017-02-13 | 2017-02-13 | The methods of exhibiting and device of invalid information |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108427662A true CN108427662A (en) | 2018-08-21 |
Family
ID=63147200
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710075497.7A Pending CN108427662A (en) | 2017-02-13 | 2017-02-13 | The methods of exhibiting and device of invalid information |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108427662A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111159985A (en) * | 2019-12-24 | 2020-05-15 | 平安养老保险股份有限公司 | Data export method, data export device, computer equipment and computer-readable storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7117430B2 (en) * | 2001-02-27 | 2006-10-03 | Microsoft Corporation | Spreadsheet error checker |
| CN102299965A (en) * | 2011-08-31 | 2011-12-28 | 深圳市五巨科技有限公司 | Method and device for importing EXCEL data |
| CN103034647A (en) * | 2011-10-09 | 2013-04-10 | 镇江雅迅软件有限责任公司 | Excel data import based on multi-threading technology |
| CN105094852A (en) * | 2015-09-07 | 2015-11-25 | 浪潮软件集团有限公司 | Tool for importing and exporting data EXCEL |
| CN105868171A (en) * | 2015-01-21 | 2016-08-17 | ***（深圳）有限公司 | Checking method and device of Excel file |
-
2017
- 2017-02-13 CN CN201710075497.7A patent/CN108427662A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7117430B2 (en) * | 2001-02-27 | 2006-10-03 | Microsoft Corporation | Spreadsheet error checker |
| CN102299965A (en) * | 2011-08-31 | 2011-12-28 | 深圳市五巨科技有限公司 | Method and device for importing EXCEL data |
| CN103034647A (en) * | 2011-10-09 | 2013-04-10 | 镇江雅迅软件有限责任公司 | Excel data import based on multi-threading technology |
| CN105868171A (en) * | 2015-01-21 | 2016-08-17 | ***（深圳）有限公司 | Checking method and device of Excel file |
| CN105094852A (en) * | 2015-09-07 | 2015-11-25 | 浪潮软件集团有限公司 | Tool for importing and exporting data EXCEL |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111159985A (en) * | 2019-12-24 | 2020-05-15 | 平安养老保险股份有限公司 | Data export method, data export device, computer equipment and computer-readable storage medium |
| CN111159985B (en) * | 2019-12-24 | 2024-01-26 | 平安养老保险股份有限公司 | Data deriving method, apparatus, computer device and computer readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104049978B (en) | A kind of method and system for realizing code visualization editor combination | |
| CN104657419B (en) | A kind of processing method and system customizing letter paper template | |
| CN104796412B (en) | End-to-end cloud service system and access method to its sensitive data | |
| RU2006134682A (en) | DEVICE FOR DATA TRANSFER, METHOD FOR MANAGING THEM AND DEVICE FOR INPUT-OUTPUT OF THE IMAGE | |
| CN104158802A (en) | Platform authorization method, platform service side, application client side and system | |
| CN110175316B (en) | Media number interaction method, system and storage medium based on blockchain | |
| CN105677663A (en) | Method and system for unified management of self-service tax-conducting terminals | |
| WO2019075778A1 (en) | Seal management method and device, computer device and storage medium | |
| CN106878084A (en) | A kind of authority control method and device | |
| CN107707679A (en) | File uploading method and device | |
| CN105825143A (en) | Application program data writing and reading method and device | |
| CN105095791A (en) | Data security protection method and system | |
| CN107749854A (en) | Client-based single-point logging method and system | |
| CN108427662A (en) | The methods of exhibiting and device of invalid information | |
| CN105940370A (en) | Providing print view of document for editing in web-based application | |
| CN105138867A (en) | Method and device for protecting image copyright | |
| CN109067587A (en) | The determination method and device of key message infrastructure | |
| CN106502977B (en) | A kind of sheet disposal method and form system based on B/S framework | |
| CN104318164A (en) | Application program verification method | |
| US20140075577A1 (en) | File security control system and method | |
| CN107766743A (en) | Method to set up and device, terminal device, the storage medium of file access authority | |
| CN106027303A (en) | Credit investigation characteristic acquisition method and device thereof | |
| JP2006003998A5 (en) | ||
| CN116342311A (en) | Reimbursement system and method of use thereof | |
| CN103605480B (en) | Web server and disk resource access control method thereof |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180821 |