CN110688827A - Data processing method and device, electronic equipment and storage medium - Google Patents
Data processing method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN110688827A CN110688827A CN201910728965.5A CN201910728965A CN110688827A CN 110688827 A CN110688827 A CN 110688827A CN 201910728965 A CN201910728965 A CN 201910728965A CN 110688827 A CN110688827 A CN 110688827A
- Authority
- CN
- China
- Prior art keywords
- data
- target
- parameters
- configuration database
- excel
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Abstract
The invention provides a data processing method, a data processing device, electronic equipment and a storage medium. The data processing method can acquire the login information of the user when detecting that the parameters are input, acquiring a target Excel table corresponding to the user from a configuration database according to the login information, calling target data corresponding to the parameters from the configuration database, determining the position data of the parameters in the target Excel table according to the target data, replacing the current data corresponding to the position data in the target Excel table with the parameters to realize automatic replacement of the data in the Excel table, further analyzing the target Excel table to obtain the corresponding operational logic on the position data, performing corresponding calculation on the parameters according to the operation logic to obtain output data, and displaying the output data, therefore, automatic processing of data in the Excel table is realized, and the trouble brought to a user by manual maintenance of the Excel table is avoided.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a data processing method and apparatus, an electronic device, and a storage medium.
Background
In the prior art, when a client modifies a project requirement, modified data is often resubmitted, and the data submitted by the client is usually in the form of an Excel form.
In view of the fact that each item of data in the Excel form has a certain operational logic, the Excel form needs to be maintained again before a client submits the data every time, and therefore the Excel form is high in labor cost, low in processing efficiency and not timely enough, but cannot be automatically maintained after the data are received at present.
Disclosure of Invention
In view of the above, there is a need to provide a data processing method, device, electronic device and storage medium, which can implement automatic processing of data in an Excel form, avoid the trouble brought to a user by manually maintaining the Excel form, and provide better user experience.
A method of data processing, the method comprising:
when detecting that the parameters are input, acquiring login information of a user;
acquiring a target Excel form corresponding to the user from a configuration database according to the login information;
calling target data corresponding to the parameters from the configuration database;
determining the position data of the parameters in the target Excel table according to the target data;
replacing the current data corresponding to the position data in the target Excel table with the parameters;
analyzing the target Excel table to obtain corresponding operational logic on the position data;
performing corresponding calculation on the parameters according to the operation logic to obtain output data;
and displaying the output data.
According to the preferred embodiment of the present invention, before obtaining the target Excel form corresponding to the user from the configuration database according to the login information, the method further includes:
when any Excel form is received, obtaining client information recorded by the electronic equipment;
identifying the customer information to obtain a target identifier;
generating a table identifier of the arbitrary Excel table according to the target identifier by adopting a configuration algorithm;
and recording any Excel table into the configuration database by taking the table identification as a unique identification.
According to a preferred embodiment of the present invention, the obtaining, according to the login information, a target Excel form corresponding to the user from a configuration database includes:
acquiring a login person from the login information;
determining a first target identification of an enterprise to which the login user belongs;
acquiring a target table identifier corresponding to the first target identifier;
matching the target table identification with all table identifications stored in the configuration database to obtain a matched first table identification;
and calling an Excel table corresponding to the first table identifier from the configuration database to serve as the target Excel table.
According to a preferred embodiment of the present invention, the retrieving, from the configuration database, target data corresponding to the parameter includes:
acquiring a parameter identifier corresponding to the parameter;
matching the parameter identification with the data identifications of all data stored in the configuration database to obtain matched data;
and determining the matched data as the target data.
According to a preferred embodiment of the present invention, the performing, according to the operation logic, the corresponding calculation on the parameter to obtain the output data includes:
and adopting POI technology to perform corresponding calculation on the parameters according to the operation logic to obtain output data.
According to a preferred embodiment of the present invention, after performing corresponding calculation on the parameter according to the operation logic to obtain output data, the method further includes:
acquiring uploaded standard data;
calculating a standard deviation of the output data and the standard data;
and sending out prompt information when the standard deviation exceeds a preset range.
According to a preferred embodiment of the present invention, when the standard deviation is out of a preset range, the method further comprises:
acquiring an execution log;
carrying the execution log and sending the prompt information.
A data processing apparatus, the apparatus comprising:
the acquisition unit is used for acquiring login information of a user when the input of the parameters is detected;
the obtaining unit is further configured to obtain a target Excel table corresponding to the user from a configuration database according to the login information;
the calling unit is used for calling target data corresponding to the parameters from the configuration database;
the determining unit is used for determining the position data of the parameters in the target Excel table according to the target data;
the replacing unit is used for replacing the current data corresponding to the position data in the target Excel table with the parameters;
the analysis unit is used for analyzing the target Excel table to obtain the corresponding operational logic on the position data;
the arithmetic unit is used for executing corresponding calculation on the parameters according to the arithmetic logic to obtain output data;
and the display unit is used for displaying the output data.
According to the preferred embodiment of the present invention, the obtaining unit is further configured to, before obtaining the target Excel form corresponding to the user from the configuration database according to the login information, receive any target Excel form
When the Excel form is adopted, obtaining client information recorded by the electronic equipment;
the device further comprises:
the identification unit is used for identifying the client information to obtain a target identifier;
the generating unit is used for generating the table identifier of the arbitrary Excel table according to the target identifier by adopting a configuration algorithm;
and the recording unit is used for recording the arbitrary Excel table into the configuration database by taking the table identifier as a unique identifier.
According to a preferred embodiment of the present invention, the obtaining, by the obtaining unit, a target Excel form corresponding to the user from a configuration database according to the login information includes:
acquiring a login person from the login information;
determining a first target identification of an enterprise to which the login user belongs;
acquiring a target table identifier corresponding to the first target identifier;
matching the target table identification with all table identifications stored in the configuration database to obtain a matched first table identification;
and calling an Excel table corresponding to the first table identifier from the configuration database to serve as the target Excel table.
According to a preferred embodiment of the present invention, the retrieving unit is specifically configured to:
acquiring a parameter identifier corresponding to the parameter;
matching the parameter identification with the data identifications of all data stored in the configuration database to obtain matched data;
and determining the matched data as the target data.
According to a preferred embodiment of the present invention, the operation unit is specifically configured to:
and adopting POI technology to perform corresponding calculation on the parameters according to the operation logic to obtain output data.
According to a preferred embodiment of the present invention, the obtaining unit is further configured to obtain the uploaded standard data after performing corresponding calculation on the parameter according to the operation logic to obtain output data;
the device further comprises:
a calculation unit configured to calculate a standard deviation of the output data and the standard data;
and the sending unit is used for sending out prompt information when the standard deviation exceeds a preset range.
According to a preferred embodiment of the present invention, the obtaining unit is further configured to obtain an execution log when the standard deviation exceeds a preset range;
the sending unit is further configured to carry the execution log and send the prompt information.
An electronic device, the electronic device comprising:
a memory storing at least one instruction; and
a processor executing instructions stored in the memory to implement the data processing method.
A computer-readable storage medium having stored therein at least one instruction, the at least one instruction being executable by a processor in an electronic device to implement the data processing method.
According to the technical scheme, the method can acquire login information of a user when the input of parameters is detected, acquire a target Excel form corresponding to the user from a configuration database according to the login information, call target data corresponding to the parameters from the configuration database, further determine position data of the parameters in the target Excel form according to the target data, replace current data corresponding to the position data in the target Excel form with the parameters, realize automatic replacement of data in the Excel form without re-submitting a new Excel form, further analyze the target Excel form to obtain operation logic corresponding to the position data, perform corresponding calculation on the parameters according to the operation logic to obtain output data, and simultaneously display the output data, thereby realizing automatic processing of the data in the Excel form, the trouble brought to the user by manually maintaining the Excel table is avoided, and the user experience is better.
Drawings
FIG. 1 is a flow chart of a preferred embodiment of the data processing method of the present invention.
FIG. 2 is a functional block diagram of a preferred embodiment of a data processing apparatus according to the present invention.
FIG. 3 is a schematic structural diagram of an electronic device implementing a data processing method according to a preferred embodiment of the invention.
Description of the main elements
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention will be described in detail with reference to the accompanying drawings and specific embodiments.
FIG. 1 is a flow chart of a data processing method according to a preferred embodiment of the present invention. The order of the steps in the flow chart may be changed and some steps may be omitted according to different needs.
The data processing method is applied to one or more electronic devices, which are devices capable of automatically performing numerical calculation and/or information processing according to preset or stored instructions, and the hardware thereof includes, but is not limited to, a microprocessor, an Application Specific Integrated Circuit (ASIC), a Programmable Gate Array (FPGA), a Digital Signal Processor (DSP), an embedded device, and the like.
The electronic device may be any electronic product capable of performing human-computer interaction with a user, for example, a Personal computer, a tablet computer, a smart phone, a Personal Digital Assistant (PDA), a game machine, an interactive Internet Protocol Television (IPTV), an intelligent wearable device, and the like.
The electronic device may also include a network device and/or a user device. The network device includes, but is not limited to, a single network server, a server group consisting of a plurality of network servers, or a cloud computing (cloud computing) based cloud consisting of a large number of hosts or network servers.
The Network where the electronic device is located includes, but is not limited to, the internet, a wide area Network, a metropolitan area Network, a local area Network, a Virtual Private Network (VPN), and the like.
And S10, when the parameter input is detected, acquiring the login information of the user.
In at least one embodiment of the present invention, the electronic device may provide a display interface for a user, when the user needs to change some project requirement data, the user can directly log in, and can fill in the requirement data in a corresponding field in the display interface after the log-in is successful, that is, input parameters.
Further, when the parameter input is detected, it indicates that there may be a change of the required data, and therefore, the electronic device will start a subsequent process for data processing.
In at least one embodiment of the present invention, the input parameters may include, but are not limited to, a combination of one or more of the following:
turnover, name, property data, real property data, default loss values, and the like.
It is understood that the above parameters are parameters that may change during the service process, and once the values change, other service data may also change.
In at least one embodiment of the present invention, the login information may include, but is not limited to, one or a combination of more of the following:
the user name, login password, login time, login place and the like of the login user.
And S11, acquiring a target Excel form corresponding to the user from a configuration database according to the login information.
In at least one embodiment of the invention, in order to better serve the client, the electronic device often needs to record various business data of the client after establishing a cooperative relationship with the client.
Specifically, the electronic device receives an Excel form uploaded by a client, and stores the uploaded Excel form into the configuration database.
In at least one embodiment of the invention, the configuration database may be any database, and the invention is not limited. And the configuration database is used for storing all service data, and the configuration database can be communicated with the electronic equipment.
In at least one embodiment of the present invention, before obtaining the target Excel form corresponding to the user from the configuration database according to the login information, the method further includes:
when any Excel form is received, obtaining client information recorded by the electronic equipment, further, identifying the client information by the electronic equipment to obtain a target identifier, generating a form identifier of the Excel form according to the target identifier by adopting a configuration algorithm, and recording the Excel form into the configuration database by taking the form identifier as a unique identifier.
In at least one embodiment of the invention, the customer information includes, but is not limited to, a combination of one or more of the following:
customer name, customer's target identification, customer address, customer's contact, etc.
In at least one embodiment of the present invention, a snowfall algorithm may be used to process any bit data in the target identifier, and generate a table identifier of the any Excel table, which is not limited in the present invention.
In at least one embodiment of the invention, because the target identifier of each enterprise is unique, the table identifier generated by the target identifier is also unique, so that an Excel table can be uniquely determined by the table identifier, and the condition of table acquisition errors is effectively avoided.
Through the embodiment, when any Excel form is received, each Excel form corresponds to one enterprise or company, so that the embodiment generates the form identification capable of uniquely determining one Excel form on the basis of the target identification, so that the Excel forms are distinguished according to different enterprises, the records of data in the configuration database are clearer, the data acquisition according to different enterprises is more convenient, and the efficiency and the accuracy of data extraction are improved.
In at least one embodiment of the present invention, the obtaining, by the electronic device, the target Excel form corresponding to the user from the configuration database according to the login information includes:
the electronic equipment acquires a login person from the login information, determines a first target identifier of an enterprise to which the login person belongs, further acquires a target table identifier corresponding to the first target identifier, matches the target table identifier with all table identifiers stored in the configuration database to obtain a matched first table identifier, and calls an Excel table corresponding to the first table identifier from the configuration database to serve as the target Excel table.
For example: after the electronic device determines that the login user is a user A, if the user A belongs to a business B, the target identifier of the business B is 1234, and the form identifier corresponding to the target identifier 1234 is 123456789, the electronic device obtains data from the configuration database by using the form identifier 123456789, and further obtains the target Excel form.
By the embodiment, the target Excel form can be automatically acquired quickly and accurately by taking the target form identification as a matching basis.
And S12, calling the target data corresponding to the parameters from the configuration database.
In at least one embodiment of the present invention, the electronic device further stores the data in each Excel table into the configuration database separately, and records the position data of each data in the corresponding Excel table while storing, that is, the row and column of each data in the corresponding Excel table, and configures the data identifier for each data.
In at least one embodiment of the present invention, each parameter further corresponds to a parameter identifier, and the parameter identifier is compared with the data identifier of each data in the configuration database, so that the target data corresponding to the parameter can be uniquely determined from the configuration database.
Specifically, the electronic device retrieving, from the configuration database, target data corresponding to the parameter includes:
and the electronic equipment acquires the parameter identification corresponding to the parameter, matches the parameter identification with the data identification of all the data stored in the configuration database to obtain matched data, and determines the matched data as the target data.
For example: when the parameter input is detected, determining that the parameter identifier of the parameter is 456, and acquiring 456 corresponding data from the configuration database by the electronic device with the parameter identifier 456 as a matching basis to serve as the target data.
By the embodiment, the parameter identification can be automatically detected after the parameter is received, and the target data can be acquired according to the parameter identification.
S13, according to the target data, determining the position data of the parameters in the target Excel table.
In at least one embodiment of the invention, since the target data is stored and the position data of the target data in the target Excel table is also recorded, the electronic device can directly determine the position data of the parameter in the target Excel table according to the target data.
S14, replacing the current data corresponding to the position data in the target Excel table with the parameters.
In at least one embodiment of the present invention, after determining the position data, the electronic device may directly position the corresponding position in the target Excel table according to the position data, and perform data replacement without uploading a new Excel table again.
It can be understood that, in general, as long as no change of project requirements or the like occurs, data in the Excel table stored in the configuration database is unchanged. And once the data changes, the method is different from the conventional method of uploading the Excel table again for updating, and the scheme only carries out local updating according to the changed data and does not need a user to make the Excel table again, so that the method is more convenient.
And S15, analyzing the target Excel table to obtain the corresponding operation logic on the position data.
In at least one embodiment of the present invention, each cell in the target Excel table may include a certain operation logic, and therefore, the electronic device parses the target Excel table to confirm the operation logic of the corresponding cell on the location data.
Specifically, the electronic device may analyze the target Excel table by using a POI (point annotation, simple fuzzy Implementation) technology, which is not limited in the present invention.
Further, there are 4 main classes in a POI package, including:
(1) workbook: the worksheet is obtained by the create (FileInputStream fis) method of Workbook factory.
(2) Sheet: table, obtained by getsheetat (int num) method of Workbook instance.
(3) Row: line, obtained by the getRow (int num) method of the heet instance.
(4) Cell: and the cells are obtained by a getcell (int num) method of the Row example.
And finally, calling a corresponding method according to the data type through the Cell instance to obtain the value of the Cell, and further realizing the analysis of the target Excel table.
And S16, performing corresponding calculation on the parameters according to the operation logic to obtain output data.
In at least one embodiment of the present invention, the output data refers to a result obtained by operating the parameter with the operation logic, that is, the output data is a result obtained by performing data processing according to an input parameter, and the output data may be in the form of a jar packet, which is not limited by the present invention.
Specifically, the electronic device performs corresponding calculation on the parameter according to the operation logic, and obtaining output data includes:
and the electronic equipment performs corresponding calculation on the parameters according to the operation logic by adopting a POI technology to obtain output data.
Through the POI technology, reading of data in the target Excel table can be achieved, and the invention is not repeated herein.
In at least one embodiment of the present invention, after performing corresponding calculation on the parameter according to the operation logic to obtain output data, the method further includes:
the electronic equipment acquires the uploaded standard data, further calculates the standard deviation of the output data and the standard data, and sends prompt information when the standard deviation exceeds a preset range.
Specifically, the standard data refers to data capable of determining accuracy.
Further, the preset range may be configured by self-definition, which is not limited in the present invention.
Furthermore, the electronic device can send the prompt message to a designated developer, so that the developer can adjust and maintain the electronic device technically in time, and response efficiency is improved.
In addition, in order to facilitate prompt urging of the designated developer, the electronic device may also send the prompt information to a relevant person in charge, for example, send the prompt information to a leader of the designated developer, so as to facilitate execution of a service.
With the above embodiment, it can be verified whether or not the present embodiment is effective. Specifically, when the standard deviation exceeds the preset range, the electronic device determines that a large error exists in the embodiment, so that a prompt message is sent, and relevant personnel can correct the error in time technically.
In at least one embodiment of the present invention, when the standard deviation is out of a preset range, the method further comprises:
the electronic equipment acquires an execution log, and further carries the execution log to send the prompt information.
Through the embodiment, the prompt information is transmitted, and the execution log is also transmitted at the same time, so that the developer is assisted to confirm the error point, and the operation and maintenance efficiency is improved.
And S17, displaying the output data.
In at least one embodiment of the present invention, the electronic device may display the output data on a configuration interface for a user to view.
Through the implementation mode, timely feedback can be carried out according to the parameters input by the user, so that the user can see the data change caused by the change of the parameters, and better experience is brought to the user.
According to the technical scheme, the method can acquire login information of a user when the input of parameters is detected, acquire a target Excel form corresponding to the user from a configuration database according to the login information, call target data corresponding to the parameters from the configuration database, further determine position data of the parameters in the target Excel form according to the target data, replace current data corresponding to the position data in the target Excel form with the parameters, realize automatic replacement of data in the Excel form without re-submitting a new Excel form, further analyze the target Excel form to obtain operation logic corresponding to the position data, perform corresponding calculation on the parameters according to the operation logic to obtain output data, and simultaneously display the output data, thereby realizing automatic processing of the data in the Excel form, the trouble brought to the user by manually maintaining the Excel table is avoided, and the user experience is better.
FIG. 2 is a functional block diagram of a data processing apparatus according to a preferred embodiment of the present invention. The data processing apparatus 11 includes an acquisition unit 110, a retrieval unit 111, a determination unit 112, a replacement unit 113, an analysis unit 114, an operation unit 115, a display unit 116, a recognition unit 117, a generation unit 118, a recording unit 119, a calculation unit 120, a transmission unit 121, and a saving unit 122. The module/unit referred to in the present invention refers to a series of computer program segments that can be executed by the processor 13 and that can perform a fixed function, and that are stored in the memory 12. In the present embodiment, the functions of the modules/units will be described in detail in the following embodiments.
When detecting that the parameter is input, the obtaining unit 110 obtains login information of the user.
In at least one embodiment of the present invention, the obtaining unit 110 may provide a display interface for a user, when the user needs to change some project requirement data, the user can directly log in, and can fill in the requirement data in a corresponding field in the display interface after the user successfully logs in, that is, input parameters.
Further, when the parameter input is detected, it indicates that there may be a change of the required data, and therefore, a subsequent process is started to perform data processing.
In at least one embodiment of the present invention, the input parameters may include, but are not limited to, a combination of one or more of the following:
turnover, name, property data, real property data, default loss values, and the like.
It is understood that the above parameters are parameters that may change during the service process, and once the values change, other service data may also change.
In at least one embodiment of the present invention, the login information may include, but is not limited to, one or a combination of more of the following:
the user name, login password, login time, login place and the like of the login user.
The obtaining unit 110 obtains a target Excel table corresponding to the user from a configuration database according to the login information.
In at least one embodiment of the invention, in order to better serve the client, various business data of the client is required to be recorded after establishing a cooperative relationship with the client.
Specifically, the obtaining unit 110 receives an Excel form uploaded by a client, and stores the uploaded Excel form in the configuration database.
In at least one embodiment of the invention, the configuration database may be any database, and the invention is not limited. And the configuration database is used for storing all service data, and the configuration database can be communicated with the electronic equipment.
In at least one embodiment of the present invention, before obtaining the target Excel form corresponding to the user from the configuration database according to the login information, the method further includes:
when any Excel form is received, the obtaining unit 110 obtains the customer information recorded by the electronic device, further, the identifying unit 117 identifies the customer information to obtain a target identifier, the generating unit 118 generates the form identifier of the Excel form according to the target identifier by adopting a configuration algorithm, and the recording unit 119 records the Excel form into the configuration database by taking the form identifier as a unique identifier.
In at least one embodiment of the invention, the customer information includes, but is not limited to, a combination of one or more of the following:
customer name, customer's target identification, customer address, customer's contact, etc.
In at least one embodiment of the present invention, a snowfall algorithm may be used to process any bit data in the target identifier, and generate a table identifier of the any Excel table, which is not limited in the present invention.
In at least one embodiment of the invention, because the target identifier of each enterprise is unique, the table identifier generated by the target identifier is also unique, so that an Excel table can be uniquely determined by the table identifier, and the condition of table acquisition errors is effectively avoided.
Through the embodiment, when any Excel form is received, each Excel form corresponds to one enterprise or company, so that the embodiment generates the form identification capable of uniquely determining one Excel form on the basis of the target identification, so that the Excel forms are distinguished according to different enterprises, the records of data in the configuration database are clearer, the data acquisition according to different enterprises is more convenient, and the efficiency and the accuracy of data extraction are improved.
In at least one embodiment of the present invention, the obtaining, by the obtaining unit 110, a target Excel form corresponding to the user from a configuration database according to the login information includes:
the obtaining unit 110 obtains a login user from the login information, and determines a first target identifier of an enterprise to which the login user belongs, further, the obtaining unit 110 obtains a target table identifier corresponding to the first target identifier, matches the target table identifier with all table identifiers stored in the configuration database to obtain a matched first table identifier, and retrieves an Excel table corresponding to the first table identifier from the configuration database as the target Excel table.
For example: after the obtaining unit 110 determines that the login user is user a, if the user a belongs to enterprise B, the target identifier of the enterprise B is 1234, and the table identifier corresponding to the target identifier 1234 is 123456789, the obtaining unit 110 obtains data from the configuration database by using the table identifier 123456789, and further obtains the target Excel table.
By the embodiment, the target Excel form can be automatically acquired quickly and accurately by taking the target form identification as a matching basis.
The retrieval unit 111 retrieves target data corresponding to the parameter from the configuration database.
In at least one embodiment of the present invention, the saving unit 122 further separately saves the data in each Excel table into the configuration database, and records the position data of each data in the corresponding Excel table while saving, that is, the row and column of each data in the corresponding Excel table, and configures the data identifier for each data.
In at least one embodiment of the present invention, each parameter further corresponds to a parameter identifier, and the parameter identifier is compared with the data identifier of each data in the configuration database, so that the target data corresponding to the parameter can be uniquely determined from the configuration database.
Specifically, the retrieving unit 111 retrieves, from the configuration database, target data corresponding to the parameter, including:
the invoking unit 111 obtains a parameter identifier corresponding to the parameter, matches the parameter identifier with data identifiers of all data stored in the configuration database to obtain matched data, and determines the matched data as the target data.
For example: when the parameter input is detected, it is determined that the parameter identifier of the parameter is 456, and the invoking unit 111 acquires 456 corresponding data from the configuration database by using the parameter identifier 456 as a matching basis, so as to serve as the target data.
By the embodiment, the parameter identification can be automatically detected after the parameter is received, and the target data can be acquired according to the parameter identification.
The determining unit 112 determines the position data of the parameter in the target Excel table according to the target data.
In at least one embodiment of the present invention, since the target data is stored and the position data of the target data in the target Excel table is also recorded, the determining unit 112 can determine the position data of the parameter in the target Excel table directly according to the target data.
The replacing unit 113 replaces the current data corresponding to the position data in the target Excel table with the parameter.
In at least one embodiment of the present invention, after determining the position data, the replacing unit 113 may directly position the corresponding position in the target Excel table according to the position data, and perform data replacement without uploading a new Excel table again.
It can be understood that, in general, as long as no change of project requirements or the like occurs, data in the Excel table stored in the configuration database is unchanged. And once the data changes, the method is different from the conventional method of uploading the Excel table again for updating, and the scheme only carries out local updating according to the changed data and does not need a user to make the Excel table again, so that the method is more convenient.
The analyzing unit 114 analyzes the target Excel table to obtain the corresponding operation logic on the position data.
In at least one embodiment of the present invention, each cell in the target Excel table may include a certain operation logic, and therefore, the parsing unit 114 parses the target Excel table so as to confirm the operation logic of the corresponding cell on the position data.
Specifically, the parsing unit 114 may parse the target Excel table by using a POI (point objective fuzzy implementation) technique, which is not limited in the present invention.
Further, there are 4 main classes in a POI package, including:
(1) workbook: the worksheet is obtained by the create (FileInputStreamfis) method of Workbook factory.
(2) Sheet: table, obtained by getsheetat (int num) method of Workbook instance.
(3) Row: line, obtained by the getRow (int num) method of the heet instance.
(4) Cell: and the cells are obtained by a getcell (int num) method of the Row example.
And finally, calling a corresponding method according to the data type through the Cell instance to obtain the value of the Cell, and further realizing the analysis of the target Excel table.
The arithmetic unit 115 performs corresponding calculation on the parameters according to the arithmetic logic to obtain output data.
In at least one embodiment of the present invention, the output data refers to a result obtained by operating the parameter with the operation logic, that is, the output data is a result obtained by performing data processing according to an input parameter, and the output data may be in the form of a jar packet, which is not limited by the present invention.
Specifically, the calculating unit 115 performs corresponding calculation on the parameter according to the calculating logic, and obtaining output data includes:
the operation unit 115 performs corresponding calculation on the parameters according to the operation logic by using the POI technology, so as to obtain output data.
Through the POI technology, reading of data in the target Excel table can be achieved, and the invention is not repeated herein.
In at least one embodiment of the present invention, after performing corresponding calculation on the parameter according to the operation logic to obtain output data, the method further includes:
the obtaining unit 110 obtains the uploaded standard data, further, the calculating unit 120 calculates a standard deviation between the output data and the standard data, and when the standard deviation exceeds a preset range, the sending unit 121 sends a prompt message.
Specifically, the standard data refers to data capable of determining accuracy.
Further, the preset range may be configured by self-definition, which is not limited in the present invention.
Further, the sending unit 121 may send the prompt information to a specified developer, so that the developer can perform adjustment and maintenance in time from a technical standpoint, and further improve response efficiency.
In addition, in order to facilitate prompt urging of the designated developer, the sending unit 121 may also send the prompt information to the relevant responsible person at the same time, for example, send the prompt information to the leader of the designated developer, so as to facilitate execution of the service.
With the above embodiment, it can be verified whether or not the present embodiment is effective. Specifically, when the standard deviation exceeds the preset range, it is determined that a large error exists in the embodiment, and therefore, a prompt message is sent, so that relevant personnel can correct the error in time technically.
In at least one embodiment of the present invention, when the standard deviation is out of a preset range, the method further comprises:
the obtaining unit 110 obtains an execution log, and further, the sending unit 121 carries the execution log and sends the prompt information.
Through the embodiment, the prompt information is transmitted, and the execution log is also transmitted at the same time, so that the developer is assisted to confirm the error point, and the operation and maintenance efficiency is improved.
The display unit 116 displays the output data.
In at least one embodiment of the present invention, the display unit 116 may display the output data on a configuration interface for the user to view.
Through the implementation mode, timely feedback can be carried out according to the parameters input by the user, so that the user can see the data change caused by the change of the parameters, and better experience is brought to the user.
According to the technical scheme, the method can acquire login information of a user when the input of parameters is detected, acquire a target Excel form corresponding to the user from a configuration database according to the login information, call target data corresponding to the parameters from the configuration database, further determine position data of the parameters in the target Excel form according to the target data, replace current data corresponding to the position data in the target Excel form with the parameters, realize automatic replacement of data in the Excel form without re-submitting a new Excel form, further analyze the target Excel form to obtain operation logic corresponding to the position data, perform corresponding calculation on the parameters according to the operation logic to obtain output data, and simultaneously display the output data, thereby realizing automatic processing of the data in the Excel form, the trouble brought to the user by manually maintaining the Excel table is avoided, and the user experience is better.
Fig. 3 is a schematic structural diagram of an electronic device according to a preferred embodiment of the data processing method of the present invention.
The electronic device 1 is a device capable of automatically performing numerical calculation and/or information processing according to a preset or stored instruction, and its hardware includes, but is not limited to, a microprocessor, an Application Specific Integrated Circuit (ASIC), a Programmable Gate Array (FPGA), a Digital Signal Processor (DSP), an embedded device, and the like.
The electronic device 1 may also be, but not limited to, any electronic product that can perform human-computer interaction with a user through a keyboard, a mouse, a remote controller, a touch panel, or a voice control device, for example, a Personal computer, a tablet computer, a smart phone, a Personal Digital Assistant (PDA), a game machine, an Internet Protocol Television (IPTV), an intelligent wearable device, and the like.
The electronic device 1 may also be a desktop computer, a notebook, a palm computer, a cloud server, or other computing devices.
The Network where the electronic device 1 is located includes, but is not limited to, the internet, a wide area Network, a metropolitan area Network, a local area Network, a Virtual Private Network (VPN), and the like.
In one embodiment of the present invention, the electronic device 1 includes, but is not limited to, a memory 12, a processor 13, and a computer program, such as a data processing program, stored in the memory 12 and executable on the processor 13.
It will be appreciated by a person skilled in the art that the schematic diagram is only an example of the electronic device 1 and does not constitute a limitation of the electronic device 1, and that it may comprise more or less components than shown, or some components may be combined, or different components, e.g. the electronic device 1 may further comprise an input output device, a network access device, a bus, etc.
The Processor 13 may be a Central Processing Unit (CPU), other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), an off-the-shelf Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic device, discrete hardware component, etc. The processor 13 is an operation core and a control center of the electronic device 1, and is connected to each part of the whole electronic device 1 by various interfaces and lines, and executes an operating system of the electronic device 1 and various installed application programs, program codes, and the like.
The processor 13 executes an operating system of the electronic device 1 and various installed application programs. The processor 13 executes the application program to implement the steps in the above-described respective data processing method embodiments, such as steps S10, S11, S12, S13, S14, S15, S16, S17 shown in fig. 1.
Alternatively, the processor 13, when executing the computer program, implements the functions of the modules/units in the above device embodiments, for example: when detecting that the parameters are input, acquiring login information of a user; acquiring a target Excel form corresponding to the user from a configuration database according to the login information; calling target data corresponding to the parameters from the configuration database; determining the position data of the parameters in the target Excel table according to the target data; replacing the current data corresponding to the position data in the target Excel table with the parameters; analyzing the target Excel table to obtain corresponding operational logic on the position data; performing corresponding calculation on the parameters according to the operation logic to obtain output data; and displaying the output data.
Illustratively, the computer program may be divided into one or more modules/units, which are stored in the memory 12 and executed by the processor 13 to accomplish the present invention. The one or more modules/units may be a series of computer program instruction segments capable of performing specific functions, which are used to describe the execution process of the computer program in the electronic device 1. For example, the computer program may be divided into an acquisition unit 110, a calling unit 111, a determination unit 112, a replacement unit 113, an analysis unit 114, an operation unit 115, a display unit 116, a recognition unit 117, a generation unit 118, a recording unit 119, a calculation unit 120, a transmission unit 121, and a saving unit 122.
The memory 12 can be used for storing the computer programs and/or modules, and the processor 13 implements various functions of the electronic device 1 by running or executing the computer programs and/or modules stored in the memory 12 and calling data stored in the memory 12. The memory 12 may mainly include a program storage area and a data storage area, wherein the program storage area may store an operating system, an application program required by at least one function (such as a sound playing function, an image playing function, etc.), and the like; the storage data area may store data (such as audio data, etc.) created according to the use of the electronic device, etc. Further, the memory 12 may include high speed random access memory, and may also include non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), at least one magnetic disk storage device, a Flash memory device, or other volatile solid state storage device.
The memory 12 may be an external memory and/or an internal memory of the electronic device 1. Further, the memory 12 may be a circuit having a memory function without any physical form In the integrated circuit, such as a RAM (Random-access memory), a FIFO (First In First Out), and the like. Alternatively, the memory 12 may be a memory in a physical form, such as a memory stick, a TF Card (Trans-flash Card), or the like.
The integrated modules/units of the electronic 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. Based on such understanding, all or part of the flow of the method according to the embodiments of the present invention may also be implemented by a computer program, which may be stored in a computer-readable storage medium, and when the computer program is executed by a processor, the steps of the method embodiments may be implemented.
Wherein the computer program comprises computer program code, which may be in the form of source code, object code, an executable file or some intermediate form, etc. The computer-readable medium may include: any entity or device capable of carrying the computer program code, recording medium, usb disk, removable hard disk, magnetic disk, optical disk, computer Memory, Read-Only Memory (ROM), Random Access Memory (RAM), electrical carrier wave signals, telecommunications signals, software distribution medium, etc. It should be noted that the computer readable medium may contain content that is subject to appropriate increase or decrease as required by legislation and patent practice in jurisdictions, for example, in some jurisdictions, computer readable media does not include electrical carrier signals and telecommunications signals as is required by legislation and patent practice.
In conjunction with fig. 1, the memory 12 in the electronic device 1 stores a plurality of instructions to implement a data processing method, and the processor 13 can execute the plurality of instructions to implement: when detecting that the parameters are input, acquiring login information of a user; acquiring a target Excel form corresponding to the user from a configuration database according to the login information; calling target data corresponding to the parameters from the configuration database; determining the position data of the parameters in the target Excel table according to the target data; replacing the current data corresponding to the position data in the target Excel table with the parameters; analyzing the target Excel table to obtain corresponding operational logic on the position data; performing corresponding calculation on the parameters according to the operation logic to obtain output data; and displaying the output data.
According to a preferred embodiment of the present invention, the processor 13 further executes a plurality of instructions including:
when any Excel form is received, obtaining client information recorded by the electronic equipment;
identifying the customer information to obtain a target identifier;
generating a table identifier of the arbitrary Excel table according to the target identifier by adopting a configuration algorithm;
and recording any Excel table into the configuration database by taking the table identification as a unique identification.
According to a preferred embodiment of the present invention, the processor 13 further executes a plurality of instructions including:
acquiring a login person from the login information;
determining a first target identification of an enterprise to which the login user belongs;
acquiring a target table identifier corresponding to the first target identifier;
matching the target table identification with all table identifications stored in the configuration database to obtain a matched first table identification;
and calling an Excel table corresponding to the first table identifier from the configuration database to serve as the target Excel table.
According to a preferred embodiment of the present invention, the processor 13 further executes a plurality of instructions including:
acquiring a parameter identifier corresponding to the parameter;
matching the parameter identification with the data identifications of all data stored in the configuration database to obtain matched data;
and determining the matched data as the target data.
According to a preferred embodiment of the present invention, the processor 13 further executes a plurality of instructions including:
and adopting POI technology to perform corresponding calculation on the parameters according to the operation logic to obtain output data.
According to a preferred embodiment of the present invention, the processor 13 further executes a plurality of instructions including:
acquiring uploaded standard data;
calculating a standard deviation of the output data and the standard data;
and sending out prompt information when the standard deviation exceeds a preset range.
According to a preferred embodiment of the present invention, the processor 13 further executes a plurality of instructions including:
acquiring an execution log;
carrying the execution log and sending the prompt information.
Specifically, the processor 13 may refer to the description of the relevant steps in the embodiment corresponding to fig. 1 for a specific implementation method of the instruction, which is not described herein again.
In the embodiments provided in the present invention, it should be understood that the disclosed system, apparatus and method may be implemented in other ways. 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.
Furthermore, it is obvious that the word "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 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 (10)
1. A method of data processing, the method comprising:
when detecting that the parameters are input, acquiring login information of a user;
acquiring a target Excel form corresponding to the user from a configuration database according to the login information;
calling target data corresponding to the parameters from the configuration database;
determining the position data of the parameters in the target Excel table according to the target data;
replacing the current data corresponding to the position data in the target Excel table with the parameters;
analyzing the target Excel table to obtain corresponding operational logic on the position data;
performing corresponding calculation on the parameters according to the operation logic to obtain output data;
and displaying the output data.
2. The data processing method of claim 1, wherein before obtaining the target Excel form corresponding to the user from a configuration database according to the login information, the method further comprises:
when any Excel form is received, obtaining client information recorded by the electronic equipment;
identifying the customer information to obtain a target identifier;
generating a table identifier of the arbitrary Excel table according to the target identifier by adopting a configuration algorithm;
and recording any Excel table into the configuration database by taking the table identification as a unique identification.
3. The data processing method of claim 1, wherein the obtaining a target Excel form corresponding to the user from a configuration database according to the login information comprises:
acquiring a login person from the login information;
determining a first target identification of an enterprise to which the login user belongs;
acquiring a target table identifier corresponding to the first target identifier;
matching the target table identification with all table identifications stored in the configuration database to obtain a matched first table identification;
and calling an Excel table corresponding to the first table identifier from the configuration database to serve as the target Excel table.
4. The data processing method of claim 1, wherein the retrieving the target data corresponding to the parameter from the configuration database comprises:
acquiring a parameter identifier corresponding to the parameter;
matching the parameter identification with the data identifications of all data stored in the configuration database to obtain matched data;
and determining the matched data as the target data.
5. The data processing method of claim 1, wherein said performing respective calculations on said parameters according to said operational logic to obtain output data comprises:
and adopting POI technology to perform corresponding calculation on the parameters according to the operation logic to obtain output data.
6. The data processing method of claim 1, wherein after performing respective calculations on the parameters according to the arithmetic logic to obtain output data, the method further comprises:
acquiring uploaded standard data;
calculating a standard deviation of the output data and the standard data;
and sending out prompt information when the standard deviation exceeds a preset range.
7. The data processing method of claim 6, wherein when the standard deviation is outside a preset range, the method further comprises:
acquiring an execution log;
carrying the execution log and sending the prompt information.
8. A data processing apparatus, characterized in that the apparatus comprises:
the acquisition unit is used for acquiring login information of a user when the input of the parameters is detected;
the obtaining unit is further configured to obtain a target Excel table corresponding to the user from a configuration database according to the login information;
the calling unit is used for calling target data corresponding to the parameters from the configuration database;
the determining unit is used for determining the position data of the parameters in the target Excel table according to the target data;
the replacing unit is used for replacing the current data corresponding to the position data in the target Excel table with the parameters;
the analysis unit is used for analyzing the target Excel table to obtain the corresponding operational logic on the position data;
the arithmetic unit is used for executing corresponding calculation on the parameters according to the arithmetic logic to obtain output data;
and the display unit is used for displaying the output data.
9. An electronic device, characterized in that the electronic device comprises:
a memory storing at least one instruction; and
a processor executing instructions stored in the memory to implement a data processing method as claimed in any one of claims 1 to 7.
10. A computer-readable storage medium characterized by: the computer-readable storage medium has stored therein at least one instruction that is executed by a processor in an electronic device to implement the data processing method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910728965.5A CN110688827A (en) | 2019-08-08 | 2019-08-08 | Data processing method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910728965.5A CN110688827A (en) | 2019-08-08 | 2019-08-08 | Data processing method and device, electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110688827A true CN110688827A (en) | 2020-01-14 |
Family
ID=69108181
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910728965.5A Pending CN110688827A (en) | 2019-08-08 | 2019-08-08 | Data processing method and device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110688827A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111913993A (en) * | 2020-08-12 | 2020-11-10 | 望海康信(北京)科技股份公司 | Table data generation method and device, electronic equipment and computer readable storage medium |
| CN112036130A (en) * | 2020-09-01 | 2020-12-04 | 山东浪潮通软信息科技有限公司 | Method and device for exporting Excel data and electronic equipment |
| CN112149183A (en) * | 2020-10-19 | 2020-12-29 | 关涛 | System for realizing data 'physics' cutting through data cloud function |
| CN112036130B (en) * | 2020-09-01 | 2024-04-30 | 浪潮通用软件有限公司 | Excel data export method and device and electronic equipment |
-
2019
- 2019-08-08 CN CN201910728965.5A patent/CN110688827A/en active Pending
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111913993A (en) * | 2020-08-12 | 2020-11-10 | 望海康信(北京)科技股份公司 | Table data generation method and device, electronic equipment and computer readable storage medium |
| CN111913993B (en) * | 2020-08-12 | 2024-02-23 | 望海康信(北京)科技股份公司 | Table data generation method, apparatus, electronic device and computer readable storage medium |
| CN112036130A (en) * | 2020-09-01 | 2020-12-04 | 山东浪潮通软信息科技有限公司 | Method and device for exporting Excel data and electronic equipment |
| CN112036130B (en) * | 2020-09-01 | 2024-04-30 | 浪潮通用软件有限公司 | Excel data export method and device and electronic equipment |
| CN112149183A (en) * | 2020-10-19 | 2020-12-29 | 关涛 | System for realizing data 'physics' cutting through data cloud function |
| CN112149183B (en) * | 2020-10-19 | 2024-03-29 | 关涛 | System for realizing data physical cutting through data cloud function |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10073823B2 (en) | Generating a form response interface in an online application | |
| EP3413212A1 (en) | Random forest model training method, electronic apparatus and storage medium | |
| CN111444992B (en) | User information checking method and system based on information code | |
| CN108073429B (en) | Payment mode configuration method, device, equipment and storage medium | |
| CN113076104A (en) | Page generation method, device, equipment and storage medium | |
| CN110555072A (en) | Data access method, device, equipment and medium | |
| CN110825731A (en) | Data storage method and device, electronic equipment and storage medium | |
| CN113011473A (en) | Model optimization method, model optimization device and electronic equipment | |
| CN110688827A (en) | Data processing method and device, electronic equipment and storage medium | |
| CN110647827A (en) | Comment information processing method and device, electronic equipment and storage medium | |
| CN111814045A (en) | Data query method and device, electronic equipment and storage medium | |
| CN113761514B (en) | Cloud desktop multi-factor security authentication method and system | |
| CN113821254A (en) | Interface data processing method, device, storage medium and equipment | |
| CN110648105A (en) | Recommendation method and device based on data processing, electronic equipment and storage medium | |
| US20220353351A1 (en) | Platform for multi-stream sampling and visualization | |
| CN113158988B (en) | Financial statement processing method, device and computer readable storage medium | |
| US20140258829A1 (en) | Webform monitoring | |
| US10664501B2 (en) | Deriving and interpreting users collective data asset use across analytic software systems | |
| CN115509637A (en) | Form-based intelligent filling method, system, equipment and medium | |
| WO2021129849A1 (en) | Log processing method, apparatus and device, and storage medium | |
| CN111401889B (en) | Credit data processing method, device, equipment and medium based on block chain | |
| CN113868400A (en) | Method and device for responding to digital human questions, electronic equipment and storage medium | |
| CN114281849B (en) | Data query method and device | |
| CN114880549B (en) | Service platform, device, equipment and medium for assisting in examining media resource information | |
| CN112291329B (en) | Information display method, device and equipment |
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 |