CN115392206B - Method, device and equipment for quickly querying data based on WPS/EXCEL and storage medium - Google Patents

Method, device and equipment for quickly querying data based on WPS/EXCEL and storage medium Download PDF

Info

Publication number
CN115392206B
CN115392206B CN202211315200.7A CN202211315200A CN115392206B CN 115392206 B CN115392206 B CN 115392206B CN 202211315200 A CN202211315200 A CN 202211315200A CN 115392206 B CN115392206 B CN 115392206B
Authority
CN
China
Prior art keywords
data
function
user
excel
wps
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
Application number
CN202211315200.7A
Other languages
Chinese (zh)
Other versions
CN115392206A (en
Inventor
杨阳
陈鹏晖
钱锋
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shenzhen Xunce Technology Co ltd
Original Assignee
Shenzhen Xunce Technology Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Shenzhen Xunce Technology Co ltd filed Critical Shenzhen Xunce Technology Co ltd
Priority to CN202211315200.7A priority Critical patent/CN115392206B/en
Publication of CN115392206A publication Critical patent/CN115392206A/en
Application granted granted Critical
Publication of CN115392206B publication Critical patent/CN115392206B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

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/177—Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • 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/2228—Indexing structures
    • G06F16/2272—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/24—Querying
    • G06F16/245—Query processing
    • G06F16/2455—Query execution
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/30—Authentication, i.e. establishing the identity or authorisation of security principals
    • G06F21/31—User authentication
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/60—Protecting data
    • G06F21/604—Tools and structures for managing or administering access control systems
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/60—Protecting data
    • G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
    • G06F21/629—Protecting access to data via a platform, e.g. using keys or access control rules to features or functions of an application
    • 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/174—Form filling; Merging
    • 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/186—Templates
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F2221/00—Indexing scheme relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F2221/21—Indexing scheme relating to G06F21/00 and subgroups addressing additional information or applications relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F2221/2113—Multi-level security, e.g. mandatory access control
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F2221/00—Indexing scheme relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F2221/21—Indexing scheme relating to G06F21/00 and subgroups addressing additional information or applications relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F2221/2141—Access rights, e.g. capability lists, access control lists, access tables, access matrices

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Health & Medical Sciences (AREA)
  • General Health & Medical Sciences (AREA)
  • Software Systems (AREA)
  • Computational Linguistics (AREA)
  • Computer Security & Cryptography (AREA)
  • Computer Hardware Design (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Artificial Intelligence (AREA)
  • Data Mining & Analysis (AREA)
  • Bioethics (AREA)
  • Databases & Information Systems (AREA)
  • Automation & Control Theory (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention relates to an artificial intelligence technology, and discloses a method for quickly inquiring data based on WPS/EXCEL, which comprises the following steps: acquiring user authority; selecting a data function according to user authority, performing function search in the data function according to user requirements to obtain a demand data function, and extracting a function parameter value in the demand data function; quickly generating date parameter values and code parameter values by using an insertion date button and an insertion code button in a data center plug-in; inserting the function, the date and the code parameter value into the cell to obtain cell data; saving the cell data by using a save snapshot button to obtain a data snapshot, and saving the required data function by using a save template button in the data center plug-in to obtain a data function template; and rapidly inquiring the data in the WPS/EXCEL according to the data snapshot and the data function template. The invention also provides a device, equipment and a storage medium for rapidly inquiring data based on the WPS/EXCEL. The invention can improve the data query accuracy.

Description

Method, device and equipment for quickly querying data based on WPS/EXCEL and storage medium
Technical Field
The invention relates to the technical field of artificial intelligence, in particular to a method and a device for quickly querying data based on WPS/EXCEL, computer equipment and a computer readable storage medium.
Background
With the continuous increase of data, data processing, statistical analysis and decision-making assistance operations in WPS/EXCEL office software are needed, but in order to meet the data requirements of non-professional research and development users and facilitate the data analysis of individual requirements of the users in WPS/EXCEL, a tool for quickly querying data needs to be established in WPS/EXCEL to query the data.
The existing office software processes data by manually generating data for calculation, and a special database connection tool is required to be used for inquiring the data in the database. In practical application, errors are easily caused when data is generated manually, and the data is not controlled by authority, so that the data may have a safety problem, and the accuracy of data query is low.
Disclosure of Invention
The invention provides a method and a device for quickly querying data based on WPS/EXCEL and a computer readable storage medium, and mainly aims to solve the problem of low accuracy in data query.
In order to achieve the above object, the method for quickly querying data based on WPS/EXCEL provided by the present invention includes:
acquiring a user name and a password of a preset user, logging in a data center plug-in according to the user name and the password, and acquiring user authority preset by the user in the logged-in data center plug-in;
selecting a data function according to the user authority, performing function matching in the data function according to preset user requirements to obtain a required data function, and extracting a function parameter value in the required data function;
extracting date parameter values in a preset date insertion module and code parameter values in a preset code insertion module;
inserting the function parameter value, the date parameter value and the code parameter value into a preset cell to obtain cell data;
saving the cell data by using a preset snapshot saving module to obtain a data snapshot, and saving the required data function by using a preset saving function template to obtain a data function template;
and outputting a query result aiming at the data in the WPS/EXCEL according to user operation based on the data snapshot and the data function template.
Optionally, the obtaining, in the logged-in data center plug-in, the user authority preset by the user includes:
acquiring a historical data function used by the user;
calculating the rating value of the user on the historical data function by using the following rating algorithm formula:
Figure 477261DEST_PATH_IMAGE001
wherein,
Figure 905968DEST_PATH_IMAGE002
is the value of said score to be said,
Figure 760791DEST_PATH_IMAGE003
in the form of an exponential function of the signal,
Figure 9370DEST_PATH_IMAGE004
to an item
Figure 670159DEST_PATH_IMAGE005
The number of times the function is used,
Figure 937061DEST_PATH_IMAGE006
for item
Figure 228365DEST_PATH_IMAGE007
The number of times the function is used,
Figure 760977DEST_PATH_IMAGE008
to an item
Figure 163140DEST_PATH_IMAGE005
The variance of the number of uses of the function,
Figure 97598DEST_PATH_IMAGE009
for item
Figure 294224DEST_PATH_IMAGE007
Variance of the number of uses of the function;
determining the authority role of the user according to the score value;
and acquiring the user authority preset by the user according to the authority role by using the logged-in data center plug-in.
Optionally, the selecting a data function according to the user right includes:
acquiring a function authority label value of a data function in the user authority;
acquiring a function tag value of a data function in a preset function library;
calculating a difference value between the function permission label value and the function label value;
and selecting a function from the function library as the data function according to the difference value.
Optionally, the performing function matching in the data function according to the user requirement to obtain a requirement data function includes:
extracting a first function keyword in the user requirement;
extracting a second function keyword in the data function;
calculating the similarity of the first function keyword and the second function keyword by using the following similarity formula:
Figure 314133DEST_PATH_IMAGE010
wherein,
Figure 539227DEST_PATH_IMAGE012
in order to be the degree of similarity, the similarity is calculated,
Figure 265875DEST_PATH_IMAGE014
represents the first function key word
Figure 695719DEST_PATH_IMAGE016
The weight of each of the feature items is,
Figure 406186DEST_PATH_IMAGE018
represents the firstIn the two-function key word
Figure 150151DEST_PATH_IMAGE020
The weight of each of the feature items is,
Figure 793622DEST_PATH_IMAGE022
expressing the average value of the feature item weight in the function key words,
Figure 846898DEST_PATH_IMAGE024
represents the number of the function key words,
Figure 575819DEST_PATH_IMAGE026
represents the first function key word
Figure 123475DEST_PATH_IMAGE016
The weighted average of the individual feature terms,
Figure 621453DEST_PATH_IMAGE028
representing the first of the second function keywords
Figure 861941DEST_PATH_IMAGE020
A weighted average of the individual feature terms;
and selecting a function with the maximum similarity as the demand data function.
Optionally, the inserting the function parameter value, the date parameter value, and the code parameter value into a preset cell to obtain cell data includes:
acquiring a first position to be inserted of the function parameter value in the cell, acquiring a second position to be inserted of the date parameter value in the cell, and acquiring a third position to be inserted of the code parameter value in the cell;
inserting the function parameter value into the cell according to the first position to be inserted to obtain first position data, inserting the date parameter value into the cell according to the second position to be inserted to obtain second position data, and inserting the code parameter value into the cell according to the third position to be inserted to obtain third position data;
and collecting the first position data, the second position data and the third position data to obtain the cell data.
Optionally, the outputting a query result for data in WPS/EXCEL according to a user operation based on the data snapshot and the data function template includes:
acquiring data to be queried according to user operation, and extracting a first data attribute of the data to be queried;
extracting a second data attribute in the data snapshot, and constructing a data attribute index table according to the second data attribute and a function formula in the data function template;
calculating a first weight of the first data attribute, calculating a second weight of the second data attribute using a weighting algorithm as follows:
Figure 15842DEST_PATH_IMAGE029
wherein,
Figure 163927DEST_PATH_IMAGE030
is as follows
Figure 470405DEST_PATH_IMAGE031
The weight of the individual data attributes is,
Figure 678533DEST_PATH_IMAGE032
in the form of a function of a logarithm,
Figure 319730DEST_PATH_IMAGE033
as to the number of attributes of the data,
Figure 271505DEST_PATH_IMAGE034
is as follows
Figure 681758DEST_PATH_IMAGE031
Individual data genusEntropy of sex;
and when the first weight and the second weight are equal, outputting a query result aiming at the data to be queried in the WPS/EXCEL in the data attribute index table.
Optionally, when the first weight and the second weight are equal, outputting a query result for data to be queried in WPS/EXCEL in the data attribute index table, including:
acquiring index data in the data attribute index table;
determining a matching value of the index data and the data to be queried;
and selecting the data with the maximum matching value as a query result aiming at the data to be queried in the WPS/EXCEL.
In order to solve the above problem, the present invention further provides an apparatus for fast querying data based on WPS/EXCEL, the apparatus comprising:
the system comprises a user authority acquisition module, a data center plug-in module and a data center plug-in module, wherein the user authority acquisition module is used for acquiring a user name and a password of a preset user, logging in the data center plug-in module according to the user name and the password, and acquiring user authority preset by the user in the logged-in data center plug-in module;
the first parameter value extraction module is used for selecting a data function according to the user permission, performing function matching in the data function according to preset user requirements to obtain a demand data function, obtaining a demand data function, and extracting function parameter values in the demand data function;
the second parameter value extraction module is used for extracting date parameter values in a preset date insertion module and extracting code parameter values in a preset code insertion module;
the data insertion module is used for inserting the function parameter value, the date parameter value and the code parameter value into a preset cell to obtain cell data;
the data storage module is used for storing the cell data by using a preset snapshot storage module to obtain a data snapshot and storing the required data function by using a preset storage function template to obtain a data function template;
and the data query module is used for outputting a query result aiming at the data in the WPS/EXCEL according to the user operation based on the data snapshot and the data function template.
In order to solve the above problem, the present invention also provides a computer apparatus, comprising:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein,
the memory stores a computer program executable by the at least one processor, the computer program being executable by the at least one processor to enable the at least one processor to perform the WPS/EXCEL-based fast query data method described above.
In order to solve the above problem, the present invention also provides a computer-readable storage medium, in which at least one computer program is stored, the at least one computer program being executed by a processor in a computer device to implement the WPS/EXCEL-based fast query data method described above.
According to the embodiment of the invention, the use permission of the user for the data function is obtained, and the data function which can be used by the user is further selected according to the use permission, so that the data security is improved; searching a data function used by a user in a function library according to the user requirement, extracting function parameter values of the data function, generating date parameter values and code parameter values by using shortcuts, inserting the function parameter values, the date parameter values and the code parameter values into cells, storing templates of the data and data function formulas by using the stored shortcuts, facilitating forwarding and checking of data in a table, facilitating next-time opening of the templates to check new data contents, and performing secondary processing on the data to quickly query the data, thereby improving the working efficiency of the user and the accuracy of the data. Therefore, the WPS/EXCEL-based method, the device, the computer equipment and the computer-readable storage medium for quickly querying data can solve the problem of low accuracy in data query.
Drawings
FIG. 1 is a schematic flow chart of a WPS/EXCEL-based method for quickly querying data according to an embodiment of the present invention;
fig. 2 is a schematic flowchart of a process for obtaining user rights according to an embodiment of the present invention;
FIG. 3 is a flow chart illustrating selecting a data function according to an embodiment of the present invention;
FIG. 4 is a functional block diagram of a WPS/EXCEL-based device for fast querying data according to an embodiment of the present invention;
fig. 5 is a schematic structural diagram of a computer device for implementing the WPS/EXCEL-based method for quickly querying data according to an embodiment of the present invention.
The implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
The embodiment of the application provides a method for quickly querying data based on WPS/EXCEL. The WPS/EXCEL-based method for quickly querying data includes, but is not limited to, at least one of a server, a terminal and other computer devices that can be configured to execute the method provided by the embodiments of the present application. In other words, the WPS/EXCEL-based rapid query data method may be performed by software or hardware installed in a terminal device or a server device, and the software may be a block chain platform. The server includes but is not limited to: a single server, a server cluster, a cloud server or a cloud server cluster, and the like. The server may be an independent server, or may be a cloud server that provides basic cloud computing services such as cloud service, a cloud database, cloud computing, cloud functions, cloud storage, web service, cloud communication, middleware service, domain name service, security service, content Delivery Network (CDN), and a big data and artificial intelligence platform.
Fig. 1 is a schematic flowchart of a method for quickly querying data based on WPS/EXCEL according to an embodiment of the present invention. In this embodiment, the method for quickly querying data based on WPS/EXCEL includes:
s1, obtaining a user name and a password of a preset user, logging in a data center plug-in according to the user name and the password, and obtaining user authority preset by the user in the logged-in data center plug-in;
in the embodiment of the invention, the user name and the password of the user are key parameters for logging in any software, and the user name and the password can be ensured to be successfully entered into the software only by using the correct user name and password, wherein the user name and the password of the user can be acquired through a database (such as MySQL).
In one practical application scenario of the invention, a user logs in the software by single click, the data center plug-in can be logged in by filling a user name and a password in a pop-up box, and the password can be remembered by checking and remembering the password, so that the next login is facilitated; opening a new sheet page without re-logging when not closing WPS or EXCEL. And the WPS or EXCEL is closed or logging out is required to be logged in again, the log-in can be kept for 3 days, and the log-in is required to be logged in again after 3 days, wherein the number of days for keeping the log-in can be configured by parameters. The background map of the login box needs to be replaceable with the background map provided by the customer.
In the embodiment of the present invention, referring to fig. 2, the obtaining of the user right preset by the user from the logged-in data center plug-in includes:
s21, acquiring a historical data function used by the user;
s22, calculating the score value of the user on the historical data function by using the following scoring algorithm formula:
Figure 60787DEST_PATH_IMAGE001
wherein,
Figure 189280DEST_PATH_IMAGE002
for the value of said score, it is,
Figure 679167DEST_PATH_IMAGE003
in order to be an exponential function of the,
Figure 724352DEST_PATH_IMAGE004
to an item
Figure 946386DEST_PATH_IMAGE005
The number of times the function is used,
Figure 624492DEST_PATH_IMAGE006
for item
Figure 855753DEST_PATH_IMAGE007
The number of times the function is used,
Figure 302915DEST_PATH_IMAGE008
to an item
Figure 961429DEST_PATH_IMAGE005
The variance of the number of uses of the function,
Figure 861252DEST_PATH_IMAGE009
for item
Figure 644007DEST_PATH_IMAGE007
Variance of the number of uses of the function;
s23, determining the authority role of the user according to the score value;
and S24, acquiring the corresponding preset authority of the user according to the authority role by using the logged-in data center plug-in.
In detail, the item
Figure 148938DEST_PATH_IMAGE005
Indicating the use of functions, items in WPS
Figure 40671DEST_PATH_IMAGE007
Indicating that the function is used in the EXCEL, determining the authority role of the user according to the scoring value, and indicating the authority role of the user when the scoring value used for the function is higherThe larger will be; when the value of credit used for the function is lower, the role authority of the user is smaller, wherein the role authority comprises a super administrator, an administrator and a common user.
Specifically, when the authority role of the user is a super administrator, the user has the highest authority and can use all data functions in the function library; when the authority role of the user is an administrator, the user has a middle-level authority and can use most data functions in the function library; when the authority role of the user is a common user, the user has low-level authority and can use a small part of data functions in the function library.
Further, in the number of times algorithm
Figure 365473DEST_PATH_IMAGE006
For the number of uses of the data function in EXCEL,
Figure 204116DEST_PATH_IMAGE004
the use frequency of the data function in the WPS can be judged, the more the use frequency is, the higher the score value of the function used by the user is, different scores are carried out on different data functions, the role of the user can be determined according to the score value of the data function obtained through calculation, the user permission is ensured to be more accurate, and the user can work more quickly.
S2, selecting a data function according to the user permission, performing function matching in the data function according to user requirements to obtain a required data function, and extracting a function parameter value in the required data function;
in the embodiment of the present invention, the data function refers to a function for processing data, such as a data function for processing a daily report and a data function for processing a monthly report, which are similar to SUM functions in EXCEL, and can be directly used in an EXCEL table.
In the embodiment of the present invention, referring to fig. 3, the selecting a data function according to the user right includes:
s31, acquiring a function authority tag value of a data function in the user authority;
s32, acquiring a function tag value of a data function in a preset function library;
s33, calculating a difference value between the function permission label value and the function label value;
and S34, selecting a function from the function library as the data function according to the difference value.
In detail, when the function permission tag value of the data function in the user permission is 1, 3, 5, and the function tag value included in the function library is 1, 2, 3, 4, 5, 6, the function tag value in the function library is matched with the function permission tag value corresponding to the user permission, and only when the function tag value is equal to the function permission tag value, that is, the absolute difference between the function tag value and the function permission tag value is zero, the corresponding data function is selected in the function library.
In the embodiment of the invention, in the EXCEL, for example, when a user needs to add all data, the SUM function in the EXCEL can be directly used; when a user needs to calculate the length of text data, the LEN function in the EXCEL can be directly used; when the user needs to sum the values of the cells meeting the conditions, the SUMIF function in the EXCEL can be directly used, so that the function can be searched in the function library according to the requirement of the user, and the function meeting the requirement is selected.
In the embodiment of the present invention, the performing function matching in the data function according to the user requirement to obtain a requirement data function includes:
extracting a first function keyword in the user requirement;
extracting a second function keyword in the data function;
calculating the similarity of the first function keyword and the second keyword by using the following similarity formula:
Figure 625870DEST_PATH_IMAGE010
wherein,
Figure 875454DEST_PATH_IMAGE035
in order to be the degree of similarity, the similarity is calculated,
Figure 953132DEST_PATH_IMAGE036
represents the first function key word
Figure 329886DEST_PATH_IMAGE031
The weight of each of the feature items is,
Figure 606147DEST_PATH_IMAGE037
representing the first of the second function keywords
Figure 777365DEST_PATH_IMAGE038
The weight of each feature item is calculated by the weight,
Figure 139077DEST_PATH_IMAGE039
expressing the average value of the feature item weight in the function key words,
Figure 70255DEST_PATH_IMAGE040
representing the number of the function keywords;
and selecting a function with the maximum similarity as the demand data function.
In detail, the first function keyword refers to a keyword related to a function in a user requirement, and the second function keyword refers to a keyword capable of representing a data function, for example, keywords related to functions in the user requirement are added, and a data function to be searched by a user is a summation function, wherein a keyword extraction tool kit (e.g., textRank algorithm tool) can be used for extracting the first function keyword in the user requirement and extracting the second function keyword of the function in the function library.
Specifically, vectorizing the first function keyword and the second function keyword to obtain a vector of each feature item in the keywords, calculating the weight of the vector, and determining the similarity of the first function keyword and the second function keyword according to the weight, wherein the feature items comprise keyword length, keyword number, keyword part of speech and the like.
Further, a statement (e.g., JAVA statement, python statement) with a parameter extraction function may be used to extract the function parameter value in the demand data function.
S3, extracting date parameter values in a preset date insertion module, and extracting code parameter values in a preset code insertion module;
in the embodiment of the invention, the data center plug-in comprises an insertion date button and an insertion code button, the date parameter filling popup box pops up by clicking the insertion date button, the date parameter to be inserted is a calendar type, a start date, an end date, a date format, a date sorting mode (ascending or descending), and a filling direction (longitudinal filling or transverse filling) of the date in a cell, the popup box fills a date range to be inserted, the date data meeting the conditions can be inserted into the cell for use, and the insertion value is a character type. And clicking the code inserting button to pop up a selection box of the code type, and selecting the code type and the corresponding detailed code data, namely quickly inserting the code type and the corresponding detailed code data into the cell for use. The date parameter value may be extracted in the insert date module and the code parameter value may be extracted in the insert code module.
S4, inserting the function parameter value, the date parameter value and the code parameter value into a preset cell to obtain cell data;
in the embodiment of the invention, the function parameter values, the date parameter values and the code parameter values are inserted into the cells, the inserted data can be clearly seen in the cells, the data functions can be conveniently operated, the cells can store the function formula, and the function formula can be rapidly dragged and assigned to a plurality of rows of data values like common functions such as SUM.
In an embodiment of the present invention, the inserting the function parameter value, the date parameter value, and the code parameter value into a preset cell to obtain cell data includes:
acquiring a first position to be inserted of the function parameter value in the cell, acquiring a second position to be inserted of the date parameter value in the cell, and acquiring a third position to be inserted of the code parameter value in the cell;
inserting the function parameter value into the cell according to the first position to be inserted to obtain first position data, inserting the date parameter value into the cell according to the second position to be inserted to obtain second position data, and inserting the code parameter value into the cell according to the third position to be inserted to obtain third position data;
and collecting the first position data, the second position data and the third position data to obtain the cell data.
In detail, a function library of a data center plug-in can be used for acquiring the positions of function parameter names, date parameter names and code erasing parameter names in the cells, wherein the function parameter names are insertion indexes, the date parameter names are insertion dates and the code parameter names are insertion codes, the cells corresponding to the function parameter names, the date parameter names and the code parameter names are inquired in the cells, and corresponding parameter values can be inserted into the cells in the next row with different names.
Illustratively, a daily purchase-sale-stock report is processed in EXCEL, the profit is calculated in the daily purchase-sale-stock report, and the function parameter values comprise the purchase quantity, the purchase price, the retail price, the stock and the like; the date parameter values comprise the date of shipment, and the like; the code parameter value comprises a code type and corresponding detailed code data, wherein the code type is a product code 234232, and the product name is profit number 1.
S5, saving the cell data by using a preset snapshot saving module to obtain a data snapshot, and saving the required data function by using a preset saving function template to obtain a data function template;
in the embodiment of the invention, the data center plug-in comprises a snapshot storage module and a function storage template module; the snapshot storage module can store the final calculation results of all data functions or page display data in the sheet page according to the page of the stored file and the name of the stored file (the name specification is judged by an operating system), so that the data of the report can be conveniently forwarded and checked. Clicking a determining button for saving the snapshot page, closing a popup frame, saving the result data snapshots of all sheet pages, wherein the generated files comprise xls and xlsx; and clicking a cancel button of the snapshot storage page, closing the pop-up box, and not storing the snapshot.
In the embodiment of the invention, the function saving template can save the function formulas of all data functions in the sheet page according to the page of the function saving template and the saved file name (the name specification is judged by the operating system), so that the template can be opened for looking up new data content conveniently next time. And if the template is opened, the fact that the user does not log in the template and needs to log in the template is found, wherein the data center plug-in also comprises a refreshing button, and the data returned by the function formula in the sheet page can be refreshed by clicking the refreshing button.
And S6, outputting a query result aiming at the data in the WPS/EXCEL according to user operation based on the data snapshot and the data function template.
In the embodiment of the invention, the data snapshot is formed by storing the final calculation data results of all data functions in the sheet page or the data displayed by the page in a folder; the data function template is used for storing the function formulas of all data functions in the sheet page into the template, so that the template can be opened for viewing new data contents conveniently next time.
In this embodiment of the present invention, the outputting a query result for data in WPS/EXCEL according to a user operation based on the data snapshot and the data function template includes:
acquiring data to be queried according to user operation, and extracting a first data attribute of the data to be queried;
extracting a second data attribute in the data snapshot, and constructing a data attribute index table according to the second data attribute and a function formula in the data function template;
calculating a first weight of the first data attribute, calculating a second weight of the second data attribute using a weighting algorithm as follows:
Figure 138705DEST_PATH_IMAGE029
wherein,
Figure 215245DEST_PATH_IMAGE030
is as follows
Figure 64252DEST_PATH_IMAGE031
The weight of the individual data attributes is,
Figure 297657DEST_PATH_IMAGE032
in the form of a function of a logarithm,
Figure 220613DEST_PATH_IMAGE033
as to the number of attributes of the data,
Figure 795951DEST_PATH_IMAGE034
is as follows
Figure 335517DEST_PATH_IMAGE031
Entropy values of the data attributes;
and when the first weight and the second weight are equal, outputting a query result aiming at the data to be queried in the WPS/EXCEL in the data attribute index table.
In detail, the first data attribute represents an attribute of the data to be queried, and if the data to be queried is 2022, 1 month and 1 day, the first data attribute represents a date; the data snapshot has a plurality of data, including a plurality of data attributes, for example, the data snapshot includes second data attributes such as date, code, function calculation result, etc., and a data attribute index is constructed according to the second data attributes and the function formula in the function template, that is, data corresponding to date attributes and date form an index table; the detailed code data corresponding to the code attribute and the code constitute another index table.
In particular, in the weighting algorithm
Figure 592186DEST_PATH_IMAGE034
Is as follows
Figure 697545DEST_PATH_IMAGE031
The entropy value of each data attribute is the weight of the data attribute calculated according to the reliability of the data attribute, the data in which the data to be inquired belongs to the data attribute index table can be judged according to the weight value, and the data to be inquired is obtained from the data attribute index table, so that the inquiry of the data to be inquired can be realized, and the inquiry of a user on the data is more efficient.
Exemplarily, when the first data attribute, for example, the weight of the date is 0.2, the second data attribute in the data snapshot includes the date, the code, and the function calculation result, the weight corresponding to the date is 0.2, the weight corresponding to the code is 0.3, and the weight corresponding to the function calculation result is 0.4, and then the data to be queried is selected to be queried in the data attribute with the same weight.
In this embodiment of the present invention, when the first weight and the second weight are equal, outputting a query result for data to be queried in WPS/EXCEL in the data attribute index table includes:
acquiring index data in the data attribute index table;
determining a matching value of the index data and the data to be queried;
and selecting the data with the maximum matching value as a query result aiming at the data to be queried in the WPS/EXCEL.
Exemplarily, when the data attribute index is an index table corresponding to a date attribute, index data in the date index table are 2022/1/1, 2022/1/2, 2022/1/3, 2022/1/4, and data to be queried is 2022/1/1, matching values of the data to be queried and the index data in the index table are respectively calculated, and data with the largest matching value is selected as the data to be queried, that is, the data to be queried is 2022/1/1 in the index data with the largest matching value, and then the data to be queried is selected as 2022/1/1.
According to the embodiment of the invention, the use permission of the user for the data function is obtained, and the data function which can be used by the user is further selected according to the use permission, so that the data security is improved; searching a data function used by a user in a function library according to the user requirement, extracting function parameter values of the data function, generating date parameter values and code parameter values by using shortcuts, inserting the function parameter values, the date parameter values and the code parameter values into cells, storing templates of the data and data function formulas by using the stored shortcuts, facilitating forwarding and checking of data in a table, facilitating next-time opening of the templates to check new data contents, and performing secondary processing on the data to quickly query the data, thereby improving the working efficiency of the user and the accuracy of the data. Therefore, the WPS/EXCEL-based method, the device, the computer equipment and the computer-readable storage medium for quickly querying data can solve the problem of low accuracy in data query.
Fig. 4 is a functional block diagram of an apparatus for quickly querying data based on WPS/EXCEL according to an embodiment of the present invention.
The WPS/EXCEL-based rapid query data device 100 according to the present invention may be installed in a computer device. According to the implemented functions, the WPS/EXCEL-based rapid query data device 100 may include a user right obtaining module 101, a first parameter value extracting module 102, a parameter value generating module 103, a data inserting module 104, a data saving module 105, and a data query module 106. The module of the present invention, which may also be referred to as a unit, refers to a series of computer program segments that can be executed by a processor of a computer device and that can perform a fixed function, and that are stored in a memory of the computer device.
In the present embodiment, the functions regarding the respective modules/units are as follows:
the user permission obtaining module 101 is configured to obtain a user name and a password of a preset user, log in a data center plug-in according to the user name and the password, and obtain a user permission preset by the user in the logged-in data center plug-in;
the first parameter value extraction module 102 is configured to select a data function according to the user permission, perform function matching in the data function according to a preset user requirement to obtain a required data function, and extract a function parameter value in the required data function;
the second parameter value extraction module 103 is configured to extract a date parameter value in a preset date insertion module and extract a code parameter value in a preset code insertion module;
the data insertion module 104 is configured to insert the function parameter value, the date parameter value, and the code parameter value into a preset cell to obtain cell data;
the data saving module 105 is configured to save the cell data by using a preset snapshot saving module to obtain a data snapshot, and save the required data function by using a preset save function template to obtain a data function template;
and the data query module 106 is configured to output a query result for data in the WPS/EXCEL according to a user operation based on the data snapshot and the data function template.
In detail, when the modules in the WPS/EXCEL-based fast query data apparatus 100 according to the embodiment of the present invention are used, the same technical means as the WPS/EXCEL-based fast query data method described in fig. 1 to fig. 3 are adopted, and the same technical effects can be produced, which is not described herein again.
Fig. 5 is a schematic structural diagram of a computer device implementing a WPS/EXCEL-based method for quickly querying data according to an embodiment of the present invention.
The computer device 1 may comprise a processor 10, a memory 11, a communication bus 12 and a communication interface 13, and may further comprise a computer program, such as a WPS/EXCEL based fast query data program, stored in the memory 11 and executable on the processor 10.
In some embodiments, the processor 10 may be composed of an integrated circuit, for example, a single packaged integrated circuit, or may be composed of a plurality of integrated circuits packaged with the same function or different functions, and includes one or more Central Processing Units (CPUs), a microprocessor, a digital Processing chip, a graphics processor, a combination of various control chips, and the like. The processor 10 is a Control Unit (Control Unit) of the computer device, connects various components of the entire computer device by using various interfaces and lines, and executes various functions of the computer device and processes data by running or executing programs or modules (for example, executing WPS/EXCEL-based quick query data programs, etc.) stored in the memory 11 and calling data stored in the memory 11.
The memory 11 includes at least one type of readable storage medium including flash memory, removable hard disks, multimedia cards, card-type memory (e.g., SD or DX memory, etc.), magnetic memory, magnetic disks, optical disks, and the like. The memory 11 may in some embodiments be an internal storage unit of the computer device, for example a removable hard disk of the computer device. The memory 11 may also be an external storage device of the computer device in other embodiments, such as a plug-in mobile hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), and the like provided on the computer device. Further, the memory 11 may also include both an internal storage unit and an external storage device of the computer device. The memory 11 may be used not only to store application software installed in a computer device and various types of data, such as code of a WPS/EXCEL-based quick query data program, etc., but also to temporarily store data that has been output or is to be output.
The communication bus 12 may be a Peripheral Component Interconnect (PCI) bus or an Extended Industry Standard Architecture (EISA) bus. The bus may be divided into an address bus, a data bus, a control bus, etc. The bus is arranged to enable connection communication between the memory 11 and at least one processor 10 or the like.
The communication interface 13 is used for communication between the computer device and other devices, and includes a network interface and a user interface. Optionally, the network interface may include a wired interface and/or a wireless interface (e.g., WI-FI interface, bluetooth interface, etc.), typically used to establish a communication connection between the computer device and other computer devices. The user interface may be a Display (Display), an input unit such as a Keyboard (Keyboard), and optionally a standard wired interface, a wireless interface. Alternatively, in some embodiments, the display may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, an OLED (Organic Light-Emitting Diode) touch device, or the like. The display, which may also be referred to as a display screen or display unit, is suitable for displaying information processed in the computer device and for displaying a visualized user interface.
Only a computer device having components is shown, it will be understood by those skilled in the art that the structures shown in the figures do not constitute limitations on the computer device, and may include fewer or more components than shown, or some components in combination, or a different arrangement of components.
For example, although not shown, the computer device may further include a power supply (such as a battery) for supplying power to each component, and preferably, the power supply may be logically connected to the at least one processor 10 through a power management device, so that functions of charge management, discharge management, power consumption management and the like are realized through the power management device. The power supply may also include any component of one or more dc or ac power sources, recharging devices, power failure detection circuitry, power converters or inverters, power status indicators, and the like. The computer device may further include various sensors, a bluetooth module, a Wi-Fi module, and the like, which are not described herein again.
It is to be understood that the described embodiments are for purposes of illustration only and that the scope of the appended claims is not limited to such structures.
The WPS/EXCEL-based fast query data program stored in the memory 11 of the computer device 1 is a combination of instructions that, when executed in the processor 10, can implement:
acquiring a user name and a password of a preset user, logging in a data center plug-in according to the user name and the password, and acquiring user authority preset by the user in the logged-in data center plug-in;
selecting a data function according to the user permission, performing function matching in the data function according to preset user requirements to obtain a required data function, and extracting a function parameter value in the required data function;
extracting date parameter values in a preset date insertion module and code parameter values in a preset code insertion module;
inserting the function parameter value, the date parameter value and the code parameter value into a preset cell to obtain cell data;
saving the cell data by using a preset snapshot saving module to obtain a data snapshot, and saving the required data function by using a preset saving function template to obtain a data function template;
and outputting a query result aiming at the data in the WPS/EXCEL according to the user operation based on the data snapshot and the data function template.
Specifically, the specific implementation method of the instruction by the processor 10 may refer to the description of the relevant steps in the embodiment corresponding to the drawings, which is not described herein again.
Further, the modules/units integrated with the computer device 1 may be stored in a computer-readable storage medium if they are implemented in the form of software functional units and sold or used as separate products. The computer readable storage medium may be volatile or non-volatile. For example, the computer-readable medium may include: any entity or device capable of carrying said computer program code, recording medium, U-disk, removable hard disk, magnetic disk, optical disk, computer Memory, read-Only Memory (ROM).
The present invention also provides a computer-readable storage medium, storing a computer program which, when executed by a processor of a computer device, may implement:
acquiring a user name and a password of a preset user, logging in a data center plug-in according to the user name and the password, and acquiring user authority preset by the user in the logged-in data center plug-in;
selecting a data function according to the user permission, performing function matching in the data function according to preset user requirements to obtain a required data function, and extracting a function parameter value in the required data function;
extracting date parameter values in a preset date insertion module and code parameter values in a preset code insertion module;
inserting the function parameter value, the date parameter value and the code parameter value into a preset cell to obtain cell data;
saving the cell data by using a preset snapshot saving module to obtain a data snapshot, and saving the required data function by using a preset saving function template to obtain a data function template;
and outputting a query result aiming at the data in the WPS/EXCEL according to the user operation based on the data snapshot and the data function template.
In the several embodiments provided in the present invention, it should be understood that the disclosed apparatus, device and method may be implemented in other manners. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the modules is only one logical functional division, and other divisions may be realized in practice.
The modules described as separate parts may or may not be physically separate, and parts displayed as modules may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment.
In addition, functional modules in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, or in a form of hardware plus a software functional module.
It will be evident to those skilled in the art that the invention is not limited to the details of the foregoing illustrative embodiments, and that the present invention may be embodied in other specific forms without departing from the spirit or essential attributes thereof.
The present embodiments are therefore to be considered in all respects as illustrative and not restrictive, the scope of the invention being indicated by the appended claims rather than by the foregoing description, and all changes which come within the meaning and range of equivalency of the claims are therefore intended to be embraced therein. Any reference signs in the claims shall not be construed as limiting the claim concerned.
The embodiment of the application can acquire and process related data based on an artificial intelligence technology. Among them, artificial Intelligence (AI) is a theory, method, technique and application system that simulates, extends and expands human Intelligence using a digital computer or a machine controlled by a digital computer, senses the environment, acquires knowledge and uses the knowledge to obtain the best result.
Furthermore, it will be obvious that the term "comprising" does not exclude other elements or steps, and the singular does not exclude the plural. A plurality of units or means recited in the system claims may also be implemented by one unit or means in software or hardware. The terms first, second, etc. are used to denote names, but not any particular order.
Finally, it should be noted that the above embodiments are only for illustrating the technical solutions of the present invention and not for limiting, and although the present invention is described in detail with reference to the preferred embodiments, it should be understood by those skilled in the art that modifications or equivalent substitutions may be made on the technical solutions of the present invention without departing from the spirit and scope of the technical solutions of the present invention.

Claims (9)

1. A WPS/EXCEL-based method for quickly querying data, which is characterized by comprising the following steps:
acquiring a user name and a password of a preset user, logging in a data center plug-in according to the user name and the password, acquiring a historical data function used by the user, and calculating the score value of the user on the historical data function by using the following scoring algorithm formula:
Figure DEST_PATH_IMAGE001
wherein,
Figure 934724DEST_PATH_IMAGE002
for the value of said score, it is,
Figure DEST_PATH_IMAGE003
in order to be an exponential function of the,
Figure 757318DEST_PATH_IMAGE004
to an item
Figure DEST_PATH_IMAGE005
The number of times the function is used,
Figure 463105DEST_PATH_IMAGE006
for item
Figure DEST_PATH_IMAGE007
The number of times the function is used,
Figure 844277DEST_PATH_IMAGE008
to an item
Figure 838778DEST_PATH_IMAGE005
The variance of the number of uses of the function,
Figure DEST_PATH_IMAGE009
for item
Figure 714330DEST_PATH_IMAGE007
Determining the authority role of the user according to the score value by using the variance of the use times of the function, and acquiring the user authority preset by the user according to the authority role by using a logged-in data center plug-in;
selecting a data function according to the user permission, performing function matching in the data function according to preset user requirements to obtain a required data function, and extracting a function parameter value in the required data function;
extracting date parameter values in a preset date insertion module and code parameter values in a preset code insertion module;
inserting the function parameter value, the date parameter value and the code parameter value into a preset cell to obtain cell data;
saving the cell data by using a preset snapshot saving module to obtain a data snapshot, and saving the required data function by using a preset saving function template to obtain a data function template;
and outputting a query result aiming at the data in the WPS/EXCEL according to user operation based on the data snapshot and the data function template.
2. The WPS/EXCEL-based rapid query data method of claim 1, wherein the selecting a data function according to the user authority comprises:
acquiring a function authority label value of a data function in the user authority;
acquiring a function tag value of a data function in a preset function library;
calculating a difference value between the function permission label value and the function label value;
and selecting a function from the function library as the data function according to the difference value.
3. The WPS/EXCEL-based rapid data query method according to claim 1, wherein the function matching in the data function according to the user requirement to obtain a requirement data function comprises:
extracting a first function keyword in the user requirement;
extracting a second function keyword in the data function;
calculating the similarity of the first function keyword and the second function keyword by using the following similarity formula:
Figure 743466DEST_PATH_IMAGE010
wherein,
Figure DEST_PATH_IMAGE011
in order to be the degree of similarity, the similarity is calculated,
Figure 62583DEST_PATH_IMAGE012
represents the first function key word
Figure DEST_PATH_IMAGE013
The weight of each of the feature items is,
Figure 809959DEST_PATH_IMAGE014
representing the first of the second function keywords
Figure 223623DEST_PATH_IMAGE016
The weight of each feature item is calculated by the weight,
Figure DEST_PATH_IMAGE017
representing an average of the total feature term weights of the first and second function keywords,
Figure 642620DEST_PATH_IMAGE018
representing a total number of said first function key and said second function key,
Figure DEST_PATH_IMAGE019
representing a weighted average of feature terms in the first function keyword,
Figure 381906DEST_PATH_IMAGE020
representing a weighted average of feature items in the second function keyword;
and selecting the function with the maximum similarity as the demand data function.
4. The WPS/EXCEL-based rapid data query method according to claim 1, wherein said inserting the function parameter value, the date parameter value and the code parameter value into a preset cell to obtain cell data comprises:
acquiring a first position to be inserted of the function parameter value in the cell, acquiring a second position to be inserted of the date parameter value in the cell, and acquiring a third position to be inserted of the code parameter value in the cell;
inserting the function parameter value into the cell according to the first position to be inserted to obtain first position data, inserting the date parameter value into the cell according to the second position to be inserted to obtain second position data, and inserting the code parameter value into the cell according to the third position to be inserted to obtain third position data;
and collecting the first position data, the second position data and the third position data to obtain the cell data.
5. The WPS/EXCEL-based rapid query data method of any one of claims 1 to 4, wherein the outputting of the query result for data in WPS/EXCEL according to a user operation based on the data snapshot and the data function template comprises:
acquiring data to be queried according to user operation, and extracting a first data attribute of the data to be queried;
extracting a second data attribute in the data snapshot, and constructing a data attribute index table according to the second data attribute and a function formula in the data function template;
calculating a first weight of the first data attribute, calculating a second weight of the second data attribute using a weighting algorithm as follows:
Figure DEST_PATH_IMAGE021
wherein,
Figure 350999DEST_PATH_IMAGE022
is a first
Figure 53507DEST_PATH_IMAGE013
The weight of the individual data attributes is,
Figure DEST_PATH_IMAGE023
in the form of a function of a logarithm,
Figure 322814DEST_PATH_IMAGE024
as to the number of attributes of the data,
Figure DEST_PATH_IMAGE025
is as follows
Figure 233001DEST_PATH_IMAGE013
Entropy values of the data attributes;
and when the first weight and the second weight are equal, outputting a query result aiming at the data to be queried in the WPS/EXCEL in the data attribute index table.
6. The WPS/EXCEL-based fast query data method of claim 5, wherein the outputting the query result for the data to be queried in WPS/EXCEL in the data attribute index table when the first weight and the second weight are equal comprises:
acquiring index data in the data attribute index table;
determining a matching value of the index data and the data to be queried;
and selecting the data with the maximum matching value as a query result aiming at the data to be queried in the WPS/EXCEL.
7. An apparatus for fast querying data based on WPS/EXCEL, the apparatus comprising:
the user permission obtaining module is used for obtaining a user name and a password of a preset user, logging in a data center plug-in according to the user name and the password, obtaining a historical data function used by the user, and calculating the score value of the user on the historical data function by using the following scoring algorithm formula:
Figure 938658DEST_PATH_IMAGE026
wherein,
Figure 428545DEST_PATH_IMAGE002
for the value of said score, it is,
Figure 21200DEST_PATH_IMAGE003
in order to be an exponential function of the,
Figure 571130DEST_PATH_IMAGE004
to an item
Figure 514816DEST_PATH_IMAGE005
The number of times the function is used,
Figure 808394DEST_PATH_IMAGE006
for item
Figure 271867DEST_PATH_IMAGE007
Function(s)The number of times of use of (a) is,
Figure 727119DEST_PATH_IMAGE008
to an item
Figure 158101DEST_PATH_IMAGE005
The variance of the number of uses of the function,
Figure 989790DEST_PATH_IMAGE009
for item
Figure 822617DEST_PATH_IMAGE007
Determining the authority role of the user according to the score value by using the variance of the use times of the function, and acquiring the user authority preset by the user according to the authority role by using a logged-in data center plug-in;
the first parameter value extraction module is used for selecting a data function according to the user permission, performing function matching in the data function according to a preset user requirement to obtain a requirement data function, and extracting a function parameter value in the requirement data function;
the second parameter value extraction module is used for extracting date parameter values in a preset date insertion module and extracting code parameter values in a preset code insertion module;
the data insertion module is used for inserting the function parameter value, the date parameter value and the code parameter value into a preset cell to obtain cell data;
the data storage module is used for storing the cell data by using a preset snapshot storage module to obtain a data snapshot and storing the required data function by using a preset storage function template to obtain a data function template;
and the data query module is used for outputting a query result aiming at the data in the WPS/EXCEL according to the user operation based on the data snapshot and the data function template.
8. A computer device, characterized in that the computer device comprises:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein,
the memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the WPS/EXCEL-based rapid query data method of any one of claims 1 to 6.
9. A computer-readable storage medium storing a computer program, wherein the computer program, when executed by a processor, implements the WPS/EXCEL-based rapid query data method according to any one of claims 1 to 6.
CN202211315200.7A 2022-10-26 2022-10-26 Method, device and equipment for quickly querying data based on WPS/EXCEL and storage medium Active CN115392206B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202211315200.7A CN115392206B (en) 2022-10-26 2022-10-26 Method, device and equipment for quickly querying data based on WPS/EXCEL and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202211315200.7A CN115392206B (en) 2022-10-26 2022-10-26 Method, device and equipment for quickly querying data based on WPS/EXCEL and storage medium

Publications (2)

Publication Number Publication Date
CN115392206A CN115392206A (en) 2022-11-25
CN115392206B true CN115392206B (en) 2023-01-13

Family

ID=84127968

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202211315200.7A Active CN115392206B (en) 2022-10-26 2022-10-26 Method, device and equipment for quickly querying data based on WPS/EXCEL and storage medium

Country Status (1)

Country Link
CN (1) CN115392206B (en)

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2021189829A1 (en) * 2020-09-02 2021-09-30 平安科技（深圳）有限公司 Data query method and apparatus, electronic device, and storage medium
CN114611096A (en) * 2022-01-24 2022-06-10 北京掌上乐游科技有限公司 Method for realizing data warehouse function security engine

Family Cites Families (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103617045A (en) * 2013-12-12 2014-03-05 用友软件股份有限公司 Plug-in development system and method based on user-defined Excel function
US10013412B2 (en) * 2014-08-25 2018-07-03 Purple Robot Software, Inc. Peer to peer spreadsheet processing
CN105868196A (en) * 2015-01-21 2016-08-17 张家口沪东电子科技有限公司 Method for generating industrial data report in server
CN108536761B (en) * 2018-03-21 2022-03-04 平安科技（深圳）有限公司 Report data query method and server
CN111767578B (en) * 2020-08-31 2021-06-04 支付宝(杭州)信息技术有限公司 Data inspection method, device and equipment
CN112784037B (en) * 2021-01-20 2023-05-05 山东师范大学 Binary function visual demonstration system and binary function visual demonstration method based on VBA
CN115017185A (en) * 2021-03-04 2022-09-06 腾讯科技（深圳）有限公司 Data processing method, device and storage medium
CN113434901A (en) * 2021-06-30 2021-09-24 平安普惠企业管理有限公司 Intelligent data query method and device, electronic equipment and storage medium
CN114239532A (en) * 2021-12-21 2022-03-25 中国建设银行股份有限公司 Report generation method and device

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2021189829A1 (en) * 2020-09-02 2021-09-30 平安科技（深圳）有限公司 Data query method and apparatus, electronic device, and storage medium
CN114611096A (en) * 2022-01-24 2022-06-10 北京掌上乐游科技有限公司 Method for realizing data warehouse function security engine

Also Published As

Publication number Publication date
CN115392206A (en) 2022-11-25

Similar Documents

Publication Publication Date Title
CN115002200B (en) Message pushing method, device, equipment and storage medium based on user portrait
CN113449187A (en) Product recommendation method, device and equipment based on double portraits and storage medium
CN114979120B (en) Data uploading method, device, equipment and storage medium
CN114186132B (en) Information recommendation method and device, electronic equipment and storage medium
CN115081025A (en) Sensitive data management method and device based on digital middlebox and electronic equipment
CN114612194A (en) Product recommendation method and device, electronic equipment and storage medium
CN111310032A (en) Resource recommendation method and device, computer equipment and readable storage medium
CN113886708A (en) Product recommendation method, device, equipment and storage medium based on user information
CN113837631A (en) Employee evaluation method and device, electronic device and readable storage medium
CN114398560B (en) Marketing interface setting method, device, equipment and medium based on WEB platform
CN115018588A (en) Product recommendation method and device, electronic equipment and readable storage medium
CN114756669A (en) Intelligent analysis method and device for problem intention, electronic equipment and storage medium
CN114862140A (en) Behavior analysis-based potential evaluation method, device, equipment and storage medium
CN113505117A (en) Data quality evaluation method, device, equipment and medium based on data indexes
CN113505273A (en) Data sorting method, device, equipment and medium based on repeated data screening
CN112948705A (en) Intelligent matching method, device and medium based on policy big data
CN111402068A (en) Premium data analysis method and device based on big data and storage medium
CN114708073B (en) Intelligent detection method and device for surrounding mark and serial mark, electronic equipment and storage medium
CN115392206B (en) Method, device and equipment for quickly querying data based on WPS/EXCEL and storage medium
CN115221323A (en) Cold start processing method, device, equipment and medium based on intention recognition model
CN115099680A (en) Risk management method, device, equipment and storage medium
CN114722789A (en) Data report integration method and device, electronic equipment and storage medium
CN111652281B (en) Information data classification method, device and readable storage medium
CN113344674A (en) Product recommendation method, device, equipment and storage medium based on user purchasing power
CN113139129A (en) Virtual reading track map generation method and device, electronic equipment and storage medium

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
CP03 Change of name, title or address

Address after: 518000, C6 Floor, Building 1, Shenzhen Software Industry Base, No. 81, 83, and 85 Gaoxin South Tenth Road, Binhai Community, Yuehai Street, Nanshan District, Shenzhen, Guangdong Province

Patentee after: Shenzhen Xunce Technology Co.,Ltd.

Country or region after: China

Address before: 118A, Industry University Research Building, Hong Kong University of Science and Technology, No. 9, Yuexing 1st Road, Gaoxin Park, Yuehai Street, Nanshan District, Shenzhen, Guangdong 518000

Patentee before: SHENZHEN XUNCE TECHNOLOGY Co.,Ltd.

Country or region before: China

CP03 Change of name, title or address