CN110941610B - Excel data file processing method and device - Google Patents
Excel data file processing method and device Download PDFInfo
- Publication number
- CN110941610B CN110941610B CN201911023088.8A CN201911023088A CN110941610B CN 110941610 B CN110941610 B CN 110941610B CN 201911023088 A CN201911023088 A CN 201911023088A CN 110941610 B CN110941610 B CN 110941610B
- Authority
- CN
- China
- Prior art keywords
- excel
- data file
- excel data
- target
- file
- 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
- 238000003672 processing method Methods 0.000 title abstract description 10
- 238000000034 method Methods 0.000 claims description 26
- 238000012795 verification Methods 0.000 claims description 13
- 238000004590 computer program Methods 0.000 claims description 11
- 230000011218 segmentation Effects 0.000 claims description 6
- 238000005192 partition Methods 0.000 description 6
- 238000010586 diagram Methods 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000007781 pre-processing Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Storage Device Security (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a processing method and a processing device for Excel data files, wherein the processing method comprises the following steps: acquiring all right values corresponding to the target Excel data file and Excel table row numbers corresponding to each right value; establishing an associated data relation table according to each authority value and the corresponding Excel table row number, and storing all the associated data relation tables in a relation database; and acquiring an Excel data viewing request uploaded by a user, and splitting the target Excel data file into a right Excel data file corresponding to the Excel data viewing request according to the Excel data viewing request and the associated data relationship table stored in the relationship database. The invention can enable the user to intuitively see the Excel data within the authority range of the user at the first time, and can save a great deal of labor and time to split the original Excel data file.
Description
Technical Field
The invention relates to the technical field of table data processing application, in particular to a method and a device for processing an Excel data file.
Background
Currently, an Excel data file may be a data file of any format and of a large data volume of a multishell (table). For the Excel data file with large data volume, the viewable data ranges of users with different authorities are different, so that the original Excel data file with large data volume needs to be preprocessed and then sent to the corresponding user, and the users with different authorities can only view the data within the authority range and cannot view the data outside the authority range. In the prior art, most solutions to the above problems all require writing Excel data files with large data volume into corresponding databases, and then performing related operations on the data in the databases to obtain the Excel data files with corresponding viewing rights of related users. The Excel data file preprocessing method in the prior art is long in time consumption, a user cannot intuitively see data within the authority range of the user in the first time, the uploading processing of the Excel data files with different headers by the similar technology is complex, and when developers do not mediate, the users cannot process the diversified headers and sheets by themselves.
Disclosure of Invention
The embodiment of the invention provides a processing method and a processing device for Excel data files, which are used for solving the following problems in the prior art: in order to enable users with different authorities to only view data in the authority range, but not view data outside the authority range, a great deal of labor and time are required to split the original Excel data file, and the users cannot intuitively see the Excel data in the authority range at the first time.
In order to solve the technical problems, a first technical scheme adopted by the embodiment of the invention is as follows:
a method for processing an Excel data file, comprising: acquiring all right values corresponding to a target Excel data file and an Excel table row number corresponding to each right value, wherein the target Excel data file is an Excel data file conforming to a preset file rule; establishing an association data relation table according to each authority value and the corresponding Excel table row number, and storing all the association data relation tables in a relation database; and acquiring an Excel data viewing request uploaded by a user, and splitting the target Excel data file into a right Excel data file corresponding to the Excel data viewing request according to the Excel data viewing request and the associated data relationship table stored in the relationship database.
Optionally, the obtaining an Excel data viewing request uploaded by a user, splitting the target Excel data file into an authority Excel data file corresponding to the Excel data viewing request according to the Excel data viewing request and the association data relationship table stored in the relationship database, and includes: judging whether the user has corresponding permission to view the target Excel data file according to the Excel data viewing request uploaded by the user; if yes, acquiring the target weight value corresponding to the user according to the Excel data viewing request uploaded by the user; matching the target authority value corresponding to the user with the association data relation table of the relation database to obtain a target Excel table row number corresponding to the target authority value; splitting the target Excel data file into the authority Excel data file corresponding to the Excel data viewing request according to the target Excel table row number.
Optionally, after splitting the target Excel data file into the right Excel data file corresponding to the Excel data viewing request, the method includes: transmitting the right Excel data file to a designated address for a user to view, and storing the right Excel data file to a designated database.
Optionally, before the obtaining all the rights values corresponding to the target Excel data file and the Excel table row numbers corresponding to each rights value, the method includes: acquiring an original Excel data file uploaded by a user, and judging whether the original Excel data file accords with a preset file rule; if yes, the original Excel data file is used as the target Excel data file, otherwise, the original Excel data file is returned to an address corresponding to the user.
Optionally, the preset file rule includes a data file verification rule and a data format splitting rule, and the determining whether the original Excel data file meets the preset file rule includes: judging whether the original Excel data file accords with the data file verification rule or not, and judging whether the original Excel data file accords with the data format splitting rule or not; and if the original Excel data file accords with the data file verification rule and the data format splitting rule, judging that the original Excel data file accords with a preset file rule.
Optionally, the determining whether the original Excel data file meets the data file verification rule includes: judging whether the original Excel data file has hidden tables and Excel rows or not; if not, judging that the original Excel data file accords with the preset file rule.
Optionally, the determining whether the original Excel data file meets the data format splitting rule includes: judging whether a first column of each Sheet table of the original Excel data file is a right segmentation column or not, wherein the right segmentation column comprises a company right code format or a personal right code format corresponding to a user; if yes, judging that the original Excel data file accords with the data format splitting rule.
In order to solve the technical problems, a second technical scheme adopted by the embodiment of the invention is as follows:
an Excel data file processing apparatus, comprising: the data acquisition module is used for acquiring all the authority values corresponding to the target Excel data files and the Excel table row numbers corresponding to each authority value, wherein the target Excel data files are Excel data files conforming to preset file rules; the relation table establishing module is used for establishing an associated data relation table according to each authority value and the corresponding Excel table row number, and storing all the associated data relation tables in a relation database; the file splitting module is used for acquiring an Excel data viewing request uploaded by a user, and splitting the target Excel data file into an authority Excel data file corresponding to the Excel data viewing request according to the Excel data viewing request and the associated data relation table stored in the relation database.
In order to solve the above technical problems, a third technical solution adopted in the embodiment of the present invention is as follows:
a computer readable storage medium having stored thereon a computer program which when executed implements a method of processing an Excel data file as described above.
In order to solve the above technical problems, a fourth technical solution adopted in the embodiment of the present invention is as follows:
a computer device comprising a processor, a memory and a computer program stored on the memory and executable on the processor, the processor implementing a method of processing an Excel data file as described above when executing the computer program.
The embodiment of the invention has the beneficial effects that: different from the situation of the prior art, the embodiment of the invention establishes the association data relation table according to all the authority values corresponding to the target Excel data file and the Excel table row number corresponding to each authority value, then obtains the Excel data viewing request uploaded by the user according to each authority value and the Excel table row number corresponding to each authority value, and finally splits the target Excel data file into the authority Excel data file corresponding to the Excel data viewing request according to the Excel data viewing request and the association data relation table, thereby solving the following problems in the prior art: in order to enable users with different authorities to only view data in the authority range, but not view data outside the authority range, a great deal of labor and time are required to split the original Excel data file, and the users cannot intuitively see the Excel data in the authority range at the first time.
Drawings
FIG. 1 is a flowchart illustrating an embodiment of a method for processing an Excel data file according to the first embodiment of the present invention;
FIG. 2 is a partial frame diagram of an Excel data file processing apparatus according to the second embodiment of the present invention;
FIG. 3 is a partial structural framework of an implementation of a computer readable storage medium according to a third embodiment of the present invention;
FIG. 4 is a partial structural frame diagram of an implementation of a computer device according to a fourth embodiment of the present invention.
Detailed Description
Example 1
Referring to fig. 1, fig. 1 is a flowchart illustrating an implementation of an Excel data file processing method according to an embodiment of the present invention, and as can be obtained with reference to fig. 1, the Excel data file processing method of the present invention includes the following steps:
step S101: and acquiring all the authority values corresponding to the target Excel data files and the Excel table row numbers corresponding to each authority value, wherein the target Excel data files are Excel data files conforming to preset file rules.
In this step, optionally, each authority value corresponds to a plurality of Excel table row numbers, and the plurality of Excel table row numbers are all arranged together or distributed in different places.
Step S102: and establishing an associated data relation table according to each authority value and the corresponding Excel table row number, and storing all the associated data relation tables in a relation database.
Step S103: and acquiring an Excel data viewing request uploaded by a user, splitting the target Excel data file into an authority Excel data file corresponding to the Excel data viewing request according to the Excel data viewing request and the associated data relation table stored in the relation database, namely splitting the target Excel data file into an Excel data file corresponding to the authority of the user, so that the user can only view the data in the authority range of the user and cannot view the data outside the authority range of the user.
In this embodiment, optionally, the obtaining an Excel data viewing request uploaded by the user, and splitting the target Excel data file into an authority Excel data file corresponding to the Excel data viewing request according to the Excel data viewing request and the association data relationship table stored in the relationship database, includes:
first, according to the Excel data viewing request uploaded by the user, judging whether the user has the corresponding authority to view the target Excel data file.
Second, if the user has the corresponding authority to view the target Excel data file, acquiring the target authority value corresponding to the user according to the Excel data viewing request uploaded by the user.
Thirdly, matching the target authority value corresponding to the user with the association data relation table of the relation database to obtain a target Excel table row number corresponding to the target authority value.
Fourth, according to the target Excel table row number, splitting the target Excel data file into the right Excel data file corresponding to the Excel data viewing request, namely deleting all the content irrelevant to the target Excel table row number in the target Excel data file.
In this embodiment, optionally, after splitting the target Excel data file into the right Excel data file corresponding to the Excel data viewing request, the method includes:
transmitting the right Excel data file to a designated address for a user to view, and storing the right Excel data file to a designated database.
In this embodiment, optionally, before obtaining all the authority values corresponding to the target Excel data file and the Excel table row number corresponding to each authority value, the method includes:
first, an original Excel data file uploaded by a user is obtained, and whether the original Excel data file accords with a preset file rule is judged.
Secondly, if the original Excel data file accords with a preset file rule, taking the original Excel data file as the target Excel data file, otherwise, returning the original Excel data file to an address corresponding to a user, and requesting the user to upload the original Excel data file again.
In this embodiment, optionally, the preset file rule includes a data file verification rule and a data format splitting rule, and the determining whether the original Excel data file meets the preset file rule includes:
first, judging whether the original Excel data file accords with the data file verification rule, and judging whether the original Excel data file accords with the data format splitting rule.
Second, if the original Excel data file accords with the data file verification rule and the data format splitting rule at the same time, judging that the original Excel data file accords with a preset file rule.
In this embodiment, optionally, the determining whether the original Excel data file meets the data file verification rule includes:
first, it is determined whether the original Excel data file has a hidden table and an Excel row, where the hidden table and the Excel row are not displayed, which may cause the result of error resolution.
Second, if the original Excel data file does not have hidden tables and Excel rows, determining that the original Excel data file accords with the preset file rule.
In this embodiment, optionally, the determining whether the original Excel data file meets the data format splitting rule includes:
first, it is determined whether the first column of each Sheet table of the original Excel data file is a rights partition column, and the rights partition column contains data in a format of company rights code format or personal rights code format corresponding to the user. If the rights corresponding to the rights partition column are divided according to the sub-company, the format of the data contained in the rights partition column must be in company rights code format, and if the rights corresponding to the rights partition column are divided according to the individual, the format of the data contained in the rights partition column must be in individual rights code format.
Second, if the first column of each Sheet table of the original Excel data file is the authority splitting column, determining that the original Excel data file accords with the data format splitting rule.
According to the embodiment of the invention, through obtaining all the authority values corresponding to the target Excel data file and the Excel table row numbers corresponding to each authority value, then establishing a correlation data relation table according to each authority value and the Excel table row numbers corresponding to each authority value, obtaining an Excel data viewing request uploaded by a user, and finally splitting the target Excel data file into the authority Excel data file corresponding to the Excel data viewing request according to the Excel data viewing request and the correlation data relation table, the following problems in the prior art are solved: in order to enable users with different authorities to only view data in the authority range, but not view data outside the authority range, a great deal of labor and time are required to split the original Excel data file, and the users cannot intuitively see the Excel data in the authority range at the first time.
Example two
Referring to fig. 2, fig. 2 is a partial structural frame diagram of an Excel data file processing apparatus according to an embodiment of the present invention, and as can be obtained with reference to fig. 2, an Excel data file processing apparatus 100 according to the present invention includes:
the data obtaining module 110 is configured to obtain all the authority values corresponding to the target Excel data files and the row numbers of the Excel table corresponding to each authority value, where the target Excel data files are Excel data files that conform to a preset file rule.
The relationship table establishing module 120 is configured to establish an association data relationship table according to each authority value and the corresponding Excel table row number, and store all the association data relationship tables in a relationship database.
The file splitting module 130 is configured to obtain an Excel data viewing request uploaded by a user, and split the target Excel data file into an authority Excel data file corresponding to the Excel data viewing request according to the Excel data viewing request and the association data relationship table stored in the relationship database.
According to the embodiment of the invention, through obtaining all the authority values corresponding to the target Excel data file and the Excel table row numbers corresponding to each authority value, then establishing a correlation data relation table according to each authority value and the Excel table row numbers corresponding to each authority value, obtaining an Excel data viewing request uploaded by a user, and finally splitting the target Excel data file into the authority Excel data file corresponding to the Excel data viewing request according to the Excel data viewing request and the correlation data relation table, the following problems in the prior art are solved: in order to enable users with different authorities to only view data in the authority range, but not view data outside the authority range, a great deal of labor and time are required to split the original Excel data file, and the users cannot intuitively see the Excel data in the authority range at the first time.
Example III
Referring to fig. 3, a computer readable storage medium 10 according to an embodiment of the present invention may be seen, where the computer readable storage medium 10 includes: ROM/RAM, magnetic disk, optical disk, etc., on which a computer program 11 is stored, which computer program 11, when executed, implements the processing method of Excel data files as described in embodiment one. Since the processing method of the Excel data file has been described in detail in the first embodiment, a description thereof will not be repeated here.
According to the method for processing the Excel data file, which is achieved by the embodiment of the invention, through obtaining all the authority values corresponding to the target Excel data file and the Excel table row numbers corresponding to each authority value, establishing an associated data relation table according to each authority value and the Excel table row numbers corresponding to each authority value, obtaining an Excel data viewing request uploaded by a user, and finally splitting the target Excel data file into the authority Excel data file corresponding to the Excel data viewing request according to the Excel data viewing request and the associated data relation table, so that the following problems in the prior art are solved: in order to enable users with different authorities to only view data in the authority range, but not view data outside the authority range, a great deal of labor and time are required to split the original Excel data file, and the users cannot intuitively see the Excel data in the authority range at the first time.
Example IV
Referring to fig. 4, a computer device 20 according to an embodiment of the present invention includes a processor 21, a memory 22, and a computer program 221 stored in the memory 22 and capable of running on the processor 21, wherein the processor 21 implements the method for processing an Excel data file according to the first embodiment when executing the computer program 221. Since the processing method of the Excel data file has been described in detail in the first embodiment, a description thereof will not be repeated here.
According to the method for processing the Excel data file, which is achieved by the embodiment of the invention, through obtaining all the authority values corresponding to the target Excel data file and the Excel table row numbers corresponding to each authority value, establishing an associated data relation table according to each authority value and the Excel table row numbers corresponding to each authority value, obtaining an Excel data viewing request uploaded by a user, and finally splitting the target Excel data file into the authority Excel data file corresponding to the Excel data viewing request according to the Excel data viewing request and the associated data relation table, so that the following problems in the prior art are solved: in order to enable users with different authorities to only view data in the authority range, but not view data outside the authority range, a great deal of labor and time are required to split the original Excel data file, and the users cannot intuitively see the Excel data in the authority range at the first time.
The foregoing description is only of embodiments of the present invention, and is not intended to limit the scope of the invention, and all equivalent structures or equivalent processes using the descriptions and the drawings of the present invention or directly or indirectly applied to other related technical fields are included in the scope of the present invention.
Claims (7)
1. A method for processing an Excel data file, comprising:
acquiring all right values corresponding to a target Excel data file and an Excel table row number corresponding to each right value, wherein the target Excel data file is an Excel data file conforming to a preset file rule;
establishing an association data relation table according to each authority value and the corresponding Excel table row number, and storing all the association data relation tables in a relation database;
acquiring an Excel data viewing request uploaded by a user, and splitting the target Excel data file into a right Excel data file corresponding to the Excel data viewing request according to the Excel data viewing request and the associated data relationship table stored in the relationship database;
the obtaining an Excel data viewing request uploaded by a user, splitting the target Excel data file into an authority Excel data file corresponding to the Excel data viewing request according to the Excel data viewing request and the association data relationship table stored in the relationship database, and the method comprises the following steps:
judging whether the user has corresponding permission to view the target Excel data file according to the Excel data viewing request uploaded by the user;
if yes, acquiring a target weight value corresponding to the user according to the Excel data viewing request uploaded by the user;
matching the target authority value corresponding to the user with the association data relation table of the relation database to obtain a target Excel table row number corresponding to the target authority value;
splitting the target Excel data file into the authority Excel data file corresponding to the Excel data viewing request according to the target Excel table row number;
namely deleting all the contents irrelevant to the row number of the target Excel table in the target Excel data file;
before the obtaining all the authority values corresponding to the target Excel data file and the Excel table row numbers corresponding to each authority value, the method comprises the following steps:
acquiring an original Excel data file uploaded by a user, and judging whether the original Excel data file accords with a preset file rule;
if yes, the original Excel data file is used as the target Excel data file, otherwise, the original Excel data file is returned to an address corresponding to a user;
the preset file rules comprise data file verification rules and data format splitting rules;
the determining whether the original Excel data file accords with the data format splitting rule includes:
judging whether a first column of each Sheet table of the original Excel data file is a right segmentation column or not, wherein the right segmentation column comprises a company right code format or a personal right code format corresponding to a user;
if yes, judging that the original Excel data file accords with the data format splitting rule.
2. The method for processing an Excel data file according to claim 1, wherein after splitting the target Excel data file into the right Excel data file corresponding to the Excel data viewing request, the method comprises:
transmitting the right Excel data file to a designated address for a user to view, and storing the right Excel data file to a designated database.
3. The method for processing an Excel data file according to claim 1, wherein the determining whether the original Excel data file meets a preset file rule comprises:
judging whether the original Excel data file accords with the data file verification rule or not, and judging whether the original Excel data file accords with the data format splitting rule or not;
and if the original Excel data file accords with the data file verification rule and the data format splitting rule, judging that the original Excel data file accords with a preset file rule.
4. The method for processing an Excel data file according to claim 3, wherein the determining whether the original Excel data file meets the data file verification rule comprises:
judging whether the original Excel data file has hidden tables and Excel rows or not;
if not, judging that the original Excel data file accords with the preset file rule.
5. An Excel data file processing apparatus, comprising:
the data acquisition module is used for acquiring all the authority values corresponding to the target Excel data files and the Excel table row numbers corresponding to each authority value, wherein the target Excel data files are Excel data files conforming to preset file rules;
the relation table establishing module is used for establishing an associated data relation table according to each authority value and the corresponding Excel table row number, and storing all the associated data relation tables in a relation database;
the file splitting module is used for acquiring an Excel data viewing request uploaded by a user, and splitting the target Excel data file into an authority Excel data file corresponding to the Excel data viewing request according to the Excel data viewing request and the associated data relation table stored in the relation database;
the obtaining an Excel data viewing request uploaded by a user, splitting the target Excel data file into an authority Excel data file corresponding to the Excel data viewing request according to the Excel data viewing request and the association data relationship table stored in the relationship database, and the method comprises the following steps:
judging whether the user has corresponding permission to view the target Excel data file according to the Excel data viewing request uploaded by the user;
if yes, acquiring a target weight value corresponding to the user according to the Excel data viewing request uploaded by the user;
matching the target authority value corresponding to the user with the association data relation table of the relation database to obtain a target Excel table row number corresponding to the target authority value;
splitting the target Excel data file into the authority Excel data file corresponding to the Excel data viewing request according to the target Excel table row number;
namely deleting all the contents irrelevant to the row number of the target Excel table in the target Excel data file;
before the obtaining all the authority values corresponding to the target Excel data file and the Excel table row numbers corresponding to each authority value, the method comprises the following steps:
acquiring an original Excel data file uploaded by a user, and judging whether the original Excel data file accords with a preset file rule;
if yes, the original Excel data file is used as the target Excel data file, otherwise, the original Excel data file is returned to an address corresponding to a user;
the preset file rules comprise data file verification rules and data format splitting rules;
the determining whether the original Excel data file accords with the data format splitting rule includes:
judging whether a first column of each Sheet table of the original Excel data file is a right segmentation column or not, wherein the right segmentation column comprises a company right code format or a personal right code format corresponding to a user;
if yes, judging that the original Excel data file accords with the data format splitting rule.
6. A computer-readable storage medium, characterized in that a computer program is stored thereon, which computer program, when executed, implements the method for processing an Excel data file according to any one of claims 1 to 4.
7. A computer device comprising a processor, a memory and a computer program stored on the memory and executable on the processor, the processor implementing the method of processing an Excel data file according to any one of claims 1 to 4 when the computer program is executed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911023088.8A CN110941610B (en) | 2019-10-25 | 2019-10-25 | Excel data file processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911023088.8A CN110941610B (en) | 2019-10-25 | 2019-10-25 | Excel data file processing method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110941610A CN110941610A (en) | 2020-03-31 |
| CN110941610B true CN110941610B (en) | 2023-12-12 |
Family
ID=69907018
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911023088.8A Active CN110941610B (en) | 2019-10-25 | 2019-10-25 | Excel data file processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110941610B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113204790B (en) * | 2021-05-25 | 2024-03-01 | 北京字跳网络技术有限公司 | View authority processing method, device, equipment and medium |
| CN115409436A (en) * | 2022-11-03 | 2022-11-29 | 博和利统计大数据(天津)集团有限公司 | Economic operation target setting method, device, equipment and readable storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2008243023A (en) * | 2007-03-28 | 2008-10-09 | Fujitsu Ltd | System for preventing abuse of authority |
| GB2555569A (en) * | 2016-10-03 | 2018-05-09 | Haddad Elias | Enhanced computer objects security |
| CN109255587A (en) * | 2018-08-30 | 2019-01-22 | 苏宁易购集团股份有限公司 | A kind of cooperative processing method and device of operational data |
| CN110309746A (en) * | 2019-06-21 | 2019-10-08 | 国网辽宁省电力有限公司鞍山供电公司 | High-grade information security area list data information extracting method without communication interconnection |
-
2019
- 2019-10-25 CN CN201911023088.8A patent/CN110941610B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2008243023A (en) * | 2007-03-28 | 2008-10-09 | Fujitsu Ltd | System for preventing abuse of authority |
| GB2555569A (en) * | 2016-10-03 | 2018-05-09 | Haddad Elias | Enhanced computer objects security |
| CN109255587A (en) * | 2018-08-30 | 2019-01-22 | 苏宁易购集团股份有限公司 | A kind of cooperative processing method and device of operational data |
| CN110309746A (en) * | 2019-06-21 | 2019-10-08 | 国网辽宁省电力有限公司鞍山供电公司 | High-grade information security area list data information extracting method without communication interconnection |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110941610A (en) | 2020-03-31 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20200311342A1 (en) | Populating values in a spreadsheet using semantic cues | |
| CN110908997A (en) | Data blood margin construction method and device, server and readable storage medium | |
| US9218568B2 (en) | Disambiguating data using contextual and historical information | |
| CN110413634B (en) | Data query method, system, device and computer readable storage medium | |
| US20190339820A1 (en) | Displaying a subset of menu items based on a prediction of the next user-actions | |
| CN110941610B (en) | Excel data file processing method and device | |
| CN106095766A (en) | Use selectivity again to talk and correct speech recognition | |
| CN111339427A (en) | Book information recommendation method, device and system and storage medium | |
| CN112286934A (en) | Database table importing method, device, equipment and medium | |
| CN112883030A (en) | Data collection method and device, computer equipment and storage medium | |
| CN111723161A (en) | Data processing method, device and equipment | |
| US10164931B2 (en) | Content personalization based on attributes of members of a social networking service | |
| CN115827084A (en) | Data processing method, device, equipment and storage medium | |
| CN114722036A (en) | Data processing method and device, electronic equipment and readable storage medium | |
| CN110825764A (en) | SQL script generation method, system, storage medium and processor | |
| US20150081576A1 (en) | Generating a supplemental description of an entity | |
| CN114072787A (en) | System and method for fast data entry to facilitate document review | |
| US20170242836A1 (en) | Architecture, system and method for storing files and data in organized grid format | |
| CN117669494A (en) | Text line height adjusting method and device and electronic equipment | |
| US20180075006A1 (en) | System and method for logical identification of differences between spreadsheets | |
| CA2954663C (en) | Entity recognition for enhanced document productivity | |
| CN112231377A (en) | Data mapping method, system, device, server and storage medium | |
| CN111880773A (en) | Data processing method and device, electronic equipment and storage medium | |
| CN112286970B (en) | Information processing method, system, computer device and computer readable storage medium | |
| US20240095551A1 (en) | Systems and methods for successive feature imputation using machine learning |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |