CN101561756B - Method for acquiring network function result for analysis by office software and device thereof - Google Patents
Method for acquiring network function result for analysis by office software and device thereof Download PDFInfo
- Publication number
- CN101561756B CN101561756B CN 200910039781 CN200910039781A CN101561756B CN 101561756 B CN101561756 B CN 101561756B CN 200910039781 CN200910039781 CN 200910039781 CN 200910039781 A CN200910039781 A CN 200910039781A CN 101561756 B CN101561756 B CN 101561756B
- Authority
- CN
- China
- Prior art keywords
- network function
- function
- result
- server
- user
- 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
Images
Landscapes
- Computer And Data Communications (AREA)
Abstract
The invention provides a method for acquiring network function result for analysis by office software, comprising the steps: network function information is acquired from user command; the network function information is then transmitted into a server; after operation is carried out on network function by the server, the operation result is sent to a client; and the client analyzes according to the operation result. The invention also provides a device used for analyzing the network function result, comprising a user interaction module used for acquiring network function information from the user command, a communication module used for transmitting the contained network function information into the server and receiving the operation result obtained by the operation carried out on the network function by the server, and an analysis module used for analyzing according to the operation result. With the invention adopted, the concrete command is not needed to be compiled by the user, theoffice software is not needed to be upgraded by the user, the application is simple, and the time can be saved.
Description
Technical field
The present invention relates to a kind of method and device that the network function result is analyzed that obtain, refer in particular to by office software and obtain method and the device that the network function result is analyzed.
Background technology
The operations such as data operation that existing office software uses function completing user that carry, that can directly use to need to operations such as data analysis the time usually, for example, the summation Sum that uses in the application software such as WPS form or excel, get the function such as long-pending Product.These functions are stored in local function library usually in advance, just can obtain result by fixing algorithm, perhaps can get some data and obtain result such as date, time etc. from local computer.But office software needs to obtain the result of the function of network function result such as on-fixed algorithm or function that result is dynamic data etc. sometimes to operations such as data analysis the time, the function of above-mentioned on-fixed algorithm can be as " asking for the province in a city " function, the above results is that the function of dynamic data refers to use the result of obtaining according to the instruction of user's input to change, as stock price: input a functional query stock price, this function, in different different results arranged, so that result can be regarded as is dynamic.Usually can't preserve in local function library in advance for this class network function, in the prior art, usually obtain in the following manner the network function result:
A kind of mode is some dialog boxes that the user uses appointment in office software, office software is connected with a certain network data base, the network function that the while user also needs will to calculate is written as concrete instruction, as SQL statement, be similar to " select*from table1 where condition=' abc ' " such statement, these concrete instructions are submitted to network data base as screening conditions, network data base finds result according to these screening conditions of user in database, return to the user.For this mode, network data base provides many data result selective, but can not computing function, can only according to the screening conditions that provide voluntarily seek the result that meet these conditions in its network data base; And need the user to write voluntarily concrete instruction (as SQL statement), inquire about the data of the screening conditions that obtain meeting in database appointment, therefore very high to user's requirement, the relevant knowledge that the user needs proficient with MS Office to be connected and to search with network data base, very numerous and diverse during processing, the threshold that uses is very high, is not suitable for general office software user.
To also have in addition dual mode be respectively to the office software upgrading or introduce third party's assembly, and upgrading by office software refers to upgrade function in local function library, increases new function; And by third party's assembly, refer in client, third party's assembly is installed, this third party's assembly is that calculation mechanism with network function etc. all is concentrated to wherein, the user can directly calculate the result of network function by using this third party's assembly.But for the front a kind of mode in this dual mode, usually be all to store in the mode of binary file owing to being stored in local function library, and this may be wherein that a lot of functions realizations are in same file, implementation according to binary file, if one of them function changes, must all upgrade whole file, therefore need constantly function library to be upgraded when running into different network functions, the method for therefore upgrading by office software will have been brought great inconvenience to the user; For rear a kind of mode, because the functional operation mechanism of concentrating in described third party's assembly is not comprehensive, during the function that therefore do not have when running into third party's assembly in, need again again to introduce new third party's assembly, a kind of like this mode has also been brought many troubles to user's use.
Summary of the invention
The invention provides and a kind ofly obtain by office software method and the device that the network function result is analyzed, do not need the user to write concrete instruction and upgrading office software, use simply, save time.
A kind ofly obtain by office software the method that the network function result is analyzed, comprise step:
Receive user instruction, user instruction is compiled, then user instruction is compared with the type function of presetting successively, wherein, described default type function comprises built-in function, self-defining function, network function;
If comparative result is network function, obtain the information of described network function;
Described network function information is issued server; Wherein, the parameter of described network function is converted to character string, after the recording parameters type, described network function and parameter type is issued server;
Described server is issued client with operation result after determining in the database of server end that according to this parameter type corresponding described network function carries out computing;
Client is analyzed according to described operation result.
The present invention also provides a kind of and obtains by office software the device that the network function result is analyzed, and comprising:
User interactive module is used for receiving user instruction, user instruction is compiled, then user instruction is compared with the type function of presetting successively, and wherein, described default type function comprises built-in function, self-defining function, network function; If comparative result is network function, obtain the information of described network function;
Communication module is used for described network function information is issued server; Wherein, the parameter of described network function is converted to character string, after the recording parameters type, described network function and parameter type is issued server; And receive described server determine operation result after corresponding described network function carries out computing according to this parameter type in the database of server end;
Analysis module is used for analyzing according to described operation result.
Do not need the user to write voluntarily concrete instruction in the present invention, go to seek in network data base result as screening conditions, only need the calculative network function of input, just can transfer to office software and server is processed, obtain the operation result of described network function.Therefore the present invention obtains by office software method and the device that the network function result analyzes and has more applicability, uses simply, is fit to general office software person and uses.And the present invention comes the computational grid function result by server, if server end has carried out the function library renewal, perhaps after the modification of function calculation algorithm, the user only needs the function name realized on quote server, just can obtain the result of function, and need not constantly office software be upgraded in order to obtain new function again, third party's assembly perhaps constantly is installed, has been saved user's time, also easier in operation.
Description of drawings
Accompanying drawing 1 obtains the process flow diagram of the method that the network function result analyzes by office software for the present invention;
Accompanying drawing 2 is the logic diagram of the analytical equipment of network function result of the present invention.
Embodiment
Existing user normally needs the user to write out voluntarily the concrete instruction corresponding with network function by the method that office software obtains the network function result, this concrete instruction is sought the result that meets this condition as screening conditions in network data base, therefore caused user's requirement very high.Application people of the present invention is for addressing the above problem, by careful thinking, found by office software and obtained the fresh approach that the network function result is analyzed, the method is the instruction that the user inputs, office software will be transferred to and server is processed, server carries out after computing, operation result being returned to client to network function, and the client analyzes according to operation result again.Clearly, in this method, the user only need to input network function, just can be processed instruction by office software and server, and do not need the user to write voluntarily concrete instruction as screening conditions, saved user's time, also very simple in operation, simultaneously owing to being by the server computing function, what the user used is the function library of server end, therefore do not need for upgrade local function library to office software upgrading also third party's assembly need not be installed constantly.
Please refer to Fig. 1, provided by the inventionly obtain by office software the method that the network function result is analyzed, comprising: obtain network function information (step 1) from user instruction; Described network function information is issued server (step 2); Described server is issued client (step 3) with the operation result data after described network function is carried out computing; Client is analyzed (step 4) according to described operation result, need to prove that described analysis comprises the operations such as statistics, arrangement in the present invention.。
When execution in step 1, obtain network function information from user instruction, preferably can realize by following scheme.Set type function in client in advance, to the understanding of function, type function can be divided into the types such as built-in function, self-defining function, network function according to the algorithm of function and user.Network function described herein can be comprise the on-fixed algorithm or result be the function of dynamic data, such as stock price, monetary exchange rate etc., built-in function and self-defining function can be to be stored in function that existing function in local data base or user write voluntarily etc.After pre-set type function, client is according to the user instruction that receives, to compile user instruction, compiling is in order to know which kind of function user instruction need to call, for example summing function or the function etc. of averaging, again user instruction is compared with built-in function, self-defining function, network function successively afterwards, first with wherein one type of comparison, if do not belong to this class function, jump into the function of next type of comparison, compare so successively, until determine the affiliated type of this function.In addition, except the type function of determining that user instruction is affiliated, also will arrange the calculation step of user instruction, namely determine functional operation problem successively, A1=rand () for example, B1=A1+1 is when the needs computing, can indication first calculate the value (because B1 depends on it) of A1, then calculate B1.Can proceed following operation according to the CWinInetConnection type afterwards, if user instruction belongs to front two kinds of type function, can be according to the disposal route of traditional office software, the function that function in the use local data base or user write voluntarily carries out computing to user instruction, obtains result and returns to client; If user instruction belongs to network function, execution in step 2.Also need to prove simultaneously, user instruction might be do not belong to these three kinds of functions any, and be this user instruction to be classified as the type of network function this moment under default situations.
When execution in step 2, preferably we can carry out according to the following steps, certainly also do not get rid of and realize in other way the present invention, but all belong to the category of scheme disclosed in this invention.Receive network function, the parameter of described network function is converted to character string, become the discernible machine language of server, and the recording parameters type, more described network function and parameter type are issued server by network afterwards.The recording parameters type is mainly for the ease of the computing of server to this function, can determine corresponding function and result of calculation according to this parameter type by the convenient service device in the database of server end.
When execution in step 2, described network function is to pass to server by network, and described network is not limited to the internet, has also comprised the latticed forms such as LAN (Local Area Network), VPN, WAPI, WIFI; The network medium of its dependence also is not limited only to copper cable, optical fiber, also comprises the network mediums such as wireless network, infrared ray, bluetooth, radio.Therefore method of the present invention has more applicability and popularity.
When execution in step 3, after described server receives the described network function of coming by Internet Transmission, will carry out computing to described network function, and operation result will be issued client.when described server is transferred to client with described operation result, also will transmit simultaneously the data type of this operation result to client, described data type is mainly exponential quantity, the types such as currency, the result of returning as server is data " 123 ", if data type is not provided, client possibly can't determine that these data are numerals 123, or three text characters, therefore client does not know how these data are processed, on the contrary, if determine this data type, client can be processed into the discernible result of user to these data according to this data type and show the user, text-string in this way, client is when receiving as a result, can find out the text corresponding with result according to data type and show the user.The above-mentioned data type that result is provided is also by due to the characteristic of network function, because each network function can be by realizing different functions with different parameters.For example, the function of economic classification, calculation content are the exchange rate, and the parameter of using is for representing two character strings of two kinds " currency ", and the function of economic classification can also calculate share price, and the parameter of its use means a character string of stock number; Suppose that the operation result that the user needs is to analyze the stock tendency, the user is with the function that the uses function for economic classification, after this function is submitted to server operation, receive that server returns as a result the time, an if simple knowledge of result, client may this result of bad judgement be share price or the exchange rate on earth, can data type know, and result is showed the user this moment.Also have a kind of situation, operation result might be the error message prompting that server provides.This is when due to server, network function being carried out computing, the situation that may occur has: find that this network function does not exist in the function library of server end, perhaps this network function self has problems, for example during user input instruction, with function name clerical error and so on, when running into similar this situation, server will provide error message, and error message is returned to client.
When execution in step 4, client if not error message can be analyzed according to operation result, is for example analyzed the fluctuating situation of the exchange rate etc. after described operation result; If the result that receives is error message, can check voluntarily whether the user instruction of input exists mistake by the user.
In order to make the present invention reach more excellent effect, accelerate arithmetic speed, also increase a step after therefore at described server, described operation result data being issued the step of client: described client is stored described operation result.By storing the nearest function that calculated and result, in order to the user during to the Same Function double counting, can find corresponding result from the nearest function that calculated preserved and result, return to client, improve arithmetic speed.
Preferably, the method that described operation result is stored can be carried out with following mode: server is after just operation result is issued client, and client just can be stored into this function and result in the middle of the nearest function that calculated, and sets the term of validity of this result.The term of validity of setting result herein is mainly the memory source that takies client in order to reduce, also dynamic due to their result of some network functions itself simultaneously, the speed that changes is very fast, therefore these results is set a shorter term of validity, and after the term of validity, these results can be dropped.When client receives identical user instruction next time, at first client will seek whether the existence function parameter is identical in the nearest function that calculated of storing and result, and operation result function before the deadline, if exist, the operation result of preserving before can directly using, be back to client, client can be analyzed according to described operation result; If there is no, then with described network function issue server.Owing to having stored the nearest function that calculated and result, when therefore the client reruned, the result of preserving before can directly using can obtain result of calculation faster, and minimizing and server is mutual to greatest extent, can avoid because the mass data double counting produces sluggish problem.But due to this step having been arranged, under default situations, the user inputs identical user instruction, at first will search whether there is effective result in the function that calculated recently, if the latest result that the user still wants to obtain this function is analyzed, can execute the term of validity of the function calculation result before ignoring by the method for manually reruning, again obtain from network operation result.
Describedly obtain by office software the method that the network function result is analyzed, be mainly by network function being issued server, come this function of computing by server, and return to this operation result to client by server.In this process, the user only need to input calculative network function, other work can transfer to office software and server is carried out, by client, network function is compiled and arranges the operation of calculation step etc., do not comprise the realization to specific algorithm and the code of network function, then by server, network function is carried out the required result of computing acquisition and analyze.The user does not need to write voluntarily concrete instruction as screening conditions, only needs the function name realized on server by reference, just can obtain nearest operation result from server by network.Therefore, if carried out the function library renewal on server, perhaps after the modification of function calculation algorithm, the office software of need not upgrading is just can use immediately up-to-date function and algorithm.Therefore the present invention obtains by office software method that network function analyzes according to result and uses simplyr, the user also needn't be time-consuming writes concrete instruction, more is fit to general office software user.
Simultaneously for the ease of better understanding the technical scheme in the present invention, the present invention also provides and the above-mentioned analytical equipment that obtains the corresponding network function result of method that the network function result analyzes by office software, please refer to accompanying drawing 2, this device comprises user interactive module, communication module and analysis module etc. functional module.Preferably, the function of the analytical equipment of described network function result can be following part, and certainly, these modules also can comprise other function.
Carrying out the step of obtaining network function information in said method from user instruction can be by described user interactive module.Concrete, described user interactive module provides two place's function input areas, is respectively that cell zone and formula bar are regional, and a parameter information suggestion device is provided.When described parameter information suggestion device mainly refers to user input instruction, the parameter information that ejects prompting bar, as the function of input SUM, can eject SUM (numerical value 1, [numerical value 2], [numerical value 3] ...) the parameter information prompting.The user can be at cell zone and formula bar zone input user instruction, and this two places function input area receives the formula grammer same with traditional office software, therefore users do not need to change use habit and just can use method in the present invention, and are more convenient to use; Described user interactive module also can be used for showing the functional operation result; Described user interactive module also can be used for user instruction and the type function of presetting are compared, and determines the type function that described user instruction is affiliated, and described default type function can comprise the types such as built-in function, self-defining function, network function; Described user interactive module also can be used for user instruction is compiled, and arranges calculation step, and its manner of execution all can realize according to the method in above-mentioned steps 1, will no longer narrate at this.
In said method, described network function information is issued server, and receive described server the step that described network function carries out the operation result after computing can be carried out by described communication module.Need to prove that described communication module can directly realize in office software; Certainly, also can be formed in office software by plug set, therefore can make the office software of legacy version also can carry out the function of function information being issued server, not need the office software upgrading with legacy version, just can realize the function in the present invention.Give client's bringing great convenience property of use, and solved the Cost Problems that brings because needing the upgrading office software.When described communication module sent network function information to server, described communication module can be converted to character string with the parameter of described network function, the recording parameters type.Simultaneously described communication module can also reception server result and data type after with described network function computing, and described result and data type are transmitted back to user interactive module.Its concrete steps can realize according to the method in above-mentioned step 2, not repeat them here.
Described analysis module can be carried out the above-mentioned step of analyzing according to described operation result.Described analysis module is mainly the demand according to the client, is to the data analysis of which kind of type, to analyze what kind of result and to determine how it analyzes.Described analysis module begins to analyze after receiving operation result.Same, if the result that receives in user interactive module is error message, but the analysis module undo.
Accordingly, preferred in order to get faster result, also increased storage unit in this device, for storing described server, described network function is carried out operation result after computing, described storage unit can be located at local client.If in described storage unit, data owner operates by communication module.When described communication module receives the operation result that server returns, described communication module will be back to user interactive module to described operation result, show the user, simultaneously, described communication module also can be saved to operation result in storage unit, described storage unit is mainly the function that calculated recently for preserving, and each network function result will be set a term of validity.Its concrete operations can realize according to above-mentioned storing step, therefore no longer narration.Also it should be noted that, the user can force to ignore the nearest function that calculated and the result of preserving in storage unit by the method for manually reruning, at this moment, office software can be by offering button of user, perhaps menu item, the perhaps operation that allows the user complete manually to rerun such as shortcut.
The analytical equipment of described network function result is connected with server by network, the network of its dependence is not limited to the internet, also comprise the latticed forms such as LAN (Local Area Network), VPN, WAPI, WIFI, and the network medium of its dependence is not limited to copper cable, optical fiber, also comprises wireless network, infrared ray, bluetooth and radio.
Above-described embodiment of the present invention does not consist of the restriction to protection domain of the present invention.Any modification of doing within the spirit and principles in the present invention, be equal to and replace and improvement etc., within all should being included in claim protection domain of the present invention.
Claims (6)
1. one kind is obtained by office software the method that the network function result is analyzed, and it is characterized in that, comprises step:
Receive user instruction, user instruction is compiled, then user instruction is compared with the type function of presetting successively, wherein, described default type function comprises built-in function, self-defining function, network function;
If comparative result is network function, obtain the information of described network function;
Described network function information is issued server; Wherein, the parameter of described network function is converted to character string, after the recording parameters type, described network function and parameter type is issued server;
Described server is issued client with operation result after determining in the database of server end that according to this parameter type corresponding described network function carries out computing;
Client is analyzed according to described operation result.
2. as claimed in claim 1ly a kind ofly obtain by office software the method that the network function result is analyzed, it is characterized in that, described server also comprises after described operation result data being issued the step of client:
Described client is stored described operation result.
3. one kind is obtained by office software the device that the network function result is analyzed, it is characterized in that: user interactive module, be used for receiving user instruction, user instruction is compiled, again user instruction is compared with the type function of presetting successively, wherein, described default type function comprises built-in function, self-defining function, network function; If comparative result is network function, obtain the information of described network function;
Communication module is used for described network function information is issued server, wherein, the parameter of described network function is converted to character string, after the recording parameters type, described network function and parameter type is issued server; And receive described server determine operation result after corresponding described network function carries out computing according to this parameter type in the database of server end;
Analysis module is used for analyzing according to described operation result.
4. as claimed in claim 3ly obtain by office software the device that the network function result is analyzed, it is characterized in that, the analytical equipment of described network function result also comprises: storage unit is used for storing described server described network function is carried out operation result after computing.
5. as claimed in claim 3ly obtain by office software the device that the network function result is analyzed, it is characterized in that, the network that the analytical equipment of described network function result relies on comprises internet, LAN (Local Area Network), VPN, WAPI, WIFI.
6. as claimed in claim 3ly obtain by office software the device that the network function result is analyzed, it is characterized in that, the network medium that the analytical equipment of described network function result relies on comprises copper cable, optical fiber, wireless network, infrared ray, bluetooth, radio.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200910039781 CN101561756B (en) | 2009-05-26 | 2009-05-26 | Method for acquiring network function result for analysis by office software and device thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200910039781 CN101561756B (en) | 2009-05-26 | 2009-05-26 | Method for acquiring network function result for analysis by office software and device thereof |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101561756A CN101561756A (en) | 2009-10-21 |
| CN101561756B true CN101561756B (en) | 2013-06-19 |
Family
ID=41220569
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 200910039781 Active CN101561756B (en) | 2009-05-26 | 2009-05-26 | Method for acquiring network function result for analysis by office software and device thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101561756B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8645554B2 (en) | 2010-05-27 | 2014-02-04 | Nokia Corporation | Method and apparatus for identifying network functions based on user data |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1728127A (en) * | 2004-07-30 | 2006-02-01 | 微软公司 | Method, system, and apparatus for providing access to workbook models through remote function calls |
| CN1734448A (en) * | 2004-08-13 | 2006-02-15 | 微软公司 | Support for user-specified spreadsheet functions |
-
2009
- 2009-05-26 CN CN 200910039781 patent/CN101561756B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1728127A (en) * | 2004-07-30 | 2006-02-01 | 微软公司 | Method, system, and apparatus for providing access to workbook models through remote function calls |
| CN1734448A (en) * | 2004-08-13 | 2006-02-15 | 微软公司 | Support for user-specified spreadsheet functions |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101561756A (en) | 2009-10-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9888088B2 (en) | Method and apparatus for accessing an enterprise resource planning system via a mobile device | |
| CN102253936B (en) | Method for recording access of user to merchandise information, search method and server | |
| US20110289407A1 (en) | Font recommendation engine | |
| CN101471847A (en) | Technique for previously providing estimate of time required for processing | |
| WO2014063127A1 (en) | Method and system for creating tax configuration templates | |
| KR102565455B1 (en) | Domain-specific language interpreter and interactive visual interface for rapid screening | |
| CN105210063A (en) | Recommending context based actions for data visualizations | |
| CN101258496A (en) | Autocompleting with queries to a database | |
| CN108345543A (en) | A kind of data processing method, device, equipment and storage medium | |
| US20120110546A1 (en) | Apparatus and method for generating applications automatically | |
| US20120143677A1 (en) | Discoverability Using Behavioral Data | |
| KR100700689B1 (en) | Method and system for transmitting short message service using messenger, and computer readable recording medium recording program for implementing the method | |
| US20230351409A1 (en) | Intelligent merchant onboarding | |
| CN109284450B (en) | Method and device for determining order forming paths, storage medium and electronic equipment | |
| US11816479B2 (en) | System and method for implementing a code audit tool | |
| US12008604B2 (en) | Ad simulator browser extension | |
| KR20220050079A (en) | Method, Apparatus and System for Generating Shopping Mall Based on AI | |
| CN104270443B (en) | A kind of cloud computing system and method for being capable of dynamic analysis Web applications | |
| CN102142025B (en) | Composing views with automatic creation of links | |
| CN111586177A (en) | Cluster session loss prevention method and system | |
| US20130111343A1 (en) | Load balancing of user interface script execution | |
| CN101561756B (en) | Method for acquiring network function result for analysis by office software and device thereof | |
| CN103838632A (en) | Data querying method and device | |
| CN102612683A (en) | Maintaining data integrity across execution environments | |
| CN110555763A (en) | financial data processing method and device based on block chain |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20171120 Address after: Kingsoft No. 33 building, 100085 Beijing city Haidian District Xiaoying Road Patentee after: Beijing Kingsoft office software Limited by Share Ltd Address before: Jinshan computer Building No. 8 Jingshan Hill Road, Lane 519015 Lianshan Jida Zhuhai city in Guangdong Province Patentee before: Zhuhai Kingsoft Software Co., Ltd. |
|
| TR01 | Transfer of patent right |