WO2019062191A1 - Electronic device, method and system for extracting data in data table, and storage medium - Google Patents

Abstract

The present application relates to an electronic device, a method and system for extracting data in a data table, and a storage medium. The method comprises: predefining service types corresponding to various Excel data tables, with regard to each service type, configuring a field to be extracted associated with the service type, and storing an association relationship between the service type and the corresponding field to be extracted; when an Excel data table is imported into a financial assistance system, identifying, based on a file name of the Excel data table, a service type corresponding to the Excel data table, and determining a field to be extracted associated with the service type corresponding to the Excel data table according to the stored association relationship between the service type and the field to be extracted; based on the determined field to be extracted, extracting a data object in the Excel data table; and displaying the determined field to be extracted and the extracted data object for a user to confirm. The present application can automatically analyze and extract data of an Excel data table which is imported into a financial assistance system, thereby saving on time and labor, and facilitating later maintenance.

Description

Electronic device, method, system and storage medium for extracting data of data table

Priority claim

This application is based on the priority of the Chinese Patent Application entitled "Electronic Device, Method of Extracting Data Table and Storage Medium", filed on September 30, 2017, with the application number of CN 201710914884.5, which is filed on September 30, 2017. The entire content is incorporated herein by reference.

Technical field

The present application relates to the field of database technologies, and in particular, to an electronic device, a method, a system, and a storage medium for extracting data of a data table.

Background technique

Currently, there are a lot of data import operations in the Financial Assistant System (FAS), which include importing Excel data tables. Each Excel data table contains different contents. In view of the complexity of business data, developers currently need to write code to analyze and extract the data for each Excel data table import, and then package it into corresponding objects. After that, follow-up warehousing operations are performed. On the one hand, this method is time consuming and laborious. On the other hand, due to the difference in the code written, the latter maintenance is more troublesome.

Summary of the invention

The purpose of the present application is to provide an electronic device, a method, a system and a storage medium for extracting data of a data table, which are intended to automatically parse and extract data of an Excel data table imported into a financial auxiliary system, saving time and effort, and facilitating the later stage. maintain.

To achieve the above object, the present application provides an electronic device including a memory and a processor coupled to the memory, the memory storing a processing system operable on the processor, the processing The system implements the following steps when executed by the processor:

S1, pre-defining a service type corresponding to each Excel data table, and configuring, for each service type, a field to be extracted associated with the service type, and storing an association relationship between the service type and the corresponding field to be extracted;

S2, when the Excel data table is imported into the financial auxiliary system, the service type corresponding to the Excel data table is identified based on the file name of the Excel data table, and the Excel data table is determined according to the relationship between the stored service type and the field to be extracted. The field to be extracted associated with the corresponding service type;

S3. Extract a data object in the Excel data table based on the determined to-be-extracted field.

S4: Display the determined to-be-extracted field and the extracted data object for user confirmation.

To achieve the above objective, the present application further provides a method for extracting data of a data table, where the method for extracting data of the data table includes:

S1, pre-defining a service type corresponding to each Excel data table, and configuring, for each service type, a field to be extracted associated with the service type, and storing an association relationship between the service type and the corresponding field to be extracted;

S2, when the Excel data table is imported into the financial auxiliary system, the service type corresponding to the Excel data table is identified based on the file name of the Excel data table, and the Excel data table is determined according to the relationship between the stored service type and the field to be extracted. The field to be extracted associated with the corresponding service type;

S3. Extract a data object in the Excel data table based on the determined to-be-extracted field.

S4: Display the determined to-be-extracted field and the extracted data object for user confirmation.

To achieve the above object, the present application further provides a system for extracting data of a data table, the system for extracting data of the data table includes:

a configuration module, configured to pre-define a service type corresponding to each Excel data table, and for each service type, configure a to-be-extracted field associated with the service type, and store an association relationship between the service type and the corresponding to-be-extracted field;

a determining module, configured to identify a service type corresponding to the Excel data table based on a file name of the Excel data table when the Excel data table is imported into the financial assistance system, and determine the relationship according to the stored service type and the relationship to be extracted The field to be extracted associated with the service type corresponding to the Excel data table;

An extracting module, configured to extract a data object in the Excel data table based on the determined field to be extracted;

The display module is configured to display the determined to-be-extracted field and the extracted data object for confirmation by the user.

The present application also provides a computer readable storage medium having stored thereon a processing system that, when executed by a processor, implements the steps of the method of extracting data of a data table as described above.

The utility model has the beneficial effects that the present application can identify the service type of the Excel data table when the Excel data table is imported into the financial assistance system, determine the field to be extracted associated with the service type corresponding to the Excel data table, and extract the to-be-extracted field. The corresponding data object under the field displays the determined to-be-extracted field and the extracted data object. Based on the foregoing components, the present application can automatically parse and extract the data of the Excel data table imported into the financial auxiliary system, saving time and effort. There is no need to write various code to analyze and extract data, to avoid differences, and to facilitate later maintenance.

DRAWINGS

1 is a schematic diagram of an optional application environment of each embodiment of the present application;

2 is a schematic flowchart of a method for extracting data of a data table according to an embodiment of the present application;

FIG. 3 is a schematic diagram of the refinement process of step S3 shown in FIG. 2.

Detailed ways

In order to make the objects, technical solutions, and advantages of the present application more comprehensible, the present application will be further described in detail below with reference to the accompanying drawings and embodiments. It is understood that the specific embodiments described herein are merely illustrative of the application and are not intended to be limiting. All other embodiments obtained by a person of ordinary skill in the art based on the embodiments of the present application without departing from the inventive scope are the scope of the present application.

It should be noted that the descriptions of "first", "second" and the like in the present application are for the purpose of description only, and are not to be construed as indicating or implying their relative importance or implicitly indicating the number of technical features indicated. . Thus, features defining "first" and "second" may include at least one of the features, either explicitly or implicitly. In addition, the technical solutions between the various embodiments may be combined with each other, but must be based on the realization of those skilled in the art, and when the combination of the technical solutions is contradictory or impossible to implement, it should be considered that the combination of the technical solutions does not exist. Nor is it within the scope of protection required by this application.

Referring to FIG. 1 , it is a schematic diagram of an application environment of a preferred embodiment of a method for extracting data of a data table. The application environment diagram includes an electronic device 1 and a terminal device 2. The electronic device 1 can perform data interaction with the terminal device 2 through a suitable technology such as a network or a near field communication technology.

The terminal device 2 includes, but is not limited to, any electronic product that can interact 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, or a smart phone. , Personal Digital Assistant (PDA), game consoles, Internet Protocol Television (IPTV), smart wearable devices, navigation devices, etc., or mobile devices such as digital TVs, desktop computers, Fixed terminal for notebooks, servers, etc. The terminal device 2 is configured to receive an instruction of the user (for example, an instruction to configure a field to be extracted associated with various service types) and send it to the electronic device 1, and display information fed back by the electronic device 1 and the like.

In other embodiments, the software and/or hardware components of the terminal device 2 for receiving the user's instructions and transmitting them to the electronic device 1 and displaying the information fed back by the electronic device 1 may be integrated into the electronic device 1 without A special terminal device 2 is required.

The electronic device 1 is an apparatus capable of automatically performing numerical calculation and/or information processing in accordance with an instruction set or stored in advance. The electronic device 1 may be a computer, a single network server, a server group composed of multiple network servers, or a cloud-based cloud composed of a large number of hosts or network servers, where cloud computing is a type of distributed computing. A super virtual computer consisting of a group of loosely coupled computers.

In the present embodiment, the electronic device 1 may include, but is not limited to, a memory 11 communicably connected to each other through a system bus, a processor 12, and a network interface 13, and the memory 11 stores a processing system operable on the processor 12. It should be noted that FIG. 1 only shows the electronic device 1 having the components 11-13, but it should be understood that not all illustrated components may be implemented, and more or fewer components may be implemented instead.

The memory 11 includes a memory and at least one type of readable storage medium. The memory provides a cache for the operation of the electronic device 1; the readable storage medium may be, for example, a flash memory, a hard disk, a multimedia card, a card type memory (eg, SD or DX memory, etc.), a random access memory (RAM), a static random access memory (SRAM). A non-volatile storage medium such as a read only memory (ROM), an electrically erasable programmable read only memory (EEPROM), a programmable read only memory (PROM), a magnetic memory, a magnetic disk, an optical disk, or the like. In some embodiments, the readable storage medium may be an internal storage unit of the electronic device 1, such as a hard disk of the electronic device 1; in other embodiments, the non-volatile storage medium may also be external to the electronic device 1. A storage device, such as a plug-in hard disk equipped with an electronic device 1, a smart memory card (SMC), a Secure Digital (SD) card, a flash card, or the like. In this embodiment, the readable storage medium of the memory 11 is generally used to store an operating system installed in the electronic device 1 and various types of application software, such as program codes of the processing system in an embodiment of the present application. Further, the memory 11 can also be used to temporarily store various types of data that have been output or are to be output.

The processor 12 may be a Central Processing Unit (CPU), controller, microcontroller, microprocessor, or other data processing chip in some embodiments. The processor 12 is typically used to control the overall operation of the electronic device 1, such as performing control and processing related to data interaction or communication with the terminal device 2. In this embodiment, the processor 12 is configured to run program code or process data stored in the memory 11, such as running a processing system or the like.

The network interface 13 may comprise a wireless network interface or a wired network interface, which is typically used to establish a communication connection between the electronic device 1 and other electronic devices. In this embodiment, the network interface 13 is mainly used to connect the electronic device 1 with one or more terminal devices 2, and establish a data transmission channel and a communication connection between the electronic device 1 and one or more terminal devices 2.

The processing system is stored in the memory 11 and includes at least one computer readable instruction stored in the memory 11, the at least one computer readable instruction being executable by the processor 12 to implement the methods of various embodiments of the present application; The at least one computer readable instruction can be classified into different logic modules depending on the functions implemented by its various parts.

In an embodiment, when the processing system is executed by the processor 12, the following steps are implemented:

Step S1, pre-defining the service type corresponding to each Excel data table, and configuring, for each service type, a field to be extracted associated with the service type, and storing an association relationship between the service type and the corresponding field to be extracted;

In this embodiment, using the import function of the current financial auxiliary system as a sample, an automatic parsing and extracting component of the Excel data table content is developed. In this component, the business type corresponding to each Excel data table can be defined in advance, for example, for an Excel data table. The “travel expense reimbursement template”, the corresponding business type is the reimbursement type. For the Excel data table “entry line upload template”, the corresponding business type is the financial system accounting line record type. Of course, there are other types of Excel data tables that can be imported into the financial assistance system, which are not listed here.

For each type of service, configure the field to be extracted associated with the service type. For example, for the type of reimbursement, the field to be extracted associated with the configuration includes “employee name or employee ID, department, reimbursement, reimbursement amount and Reimbursement time" and so on. For the financial system accounting line record type, the fields to be extracted associated with the configuration include “ticket type, reimbursement category, output tax rate, accounting processing type, detail type, description and flexfield information”.

After the fields to be extracted associated with the service types of the various Excel data tables in the financial assistance system are configured, the relationship between the service types of the various Excel data tables and the corresponding fields to be extracted is stored, for example, in the form of an association mapping table. storage.

Step S2, when the Excel data table is imported into the financial auxiliary system, the service type corresponding to the Excel data table is identified based on the file name of the Excel data table, and the Excel data is determined according to the relationship between the stored service type and the field to be extracted. The field to be extracted associated with the service type corresponding to the table;

In this embodiment, in the financial assistance system, one or more Excel data tables containing different contents may be imported at one time. When the Excel data table is imported into the financial assistance system, the service type corresponding to the Excel data table is identified based on the file name of the Excel data table. As described above, if the file name of the Excel data table is “travel expense reimbursement template”, then The business type of the Excel data table is identified as a reimbursement order type. If the file name of the Excel data table is “entry line upload template”, the business type of the Excel data table is identified as a financial system accounting line record type.

After identifying the service type corresponding to the Excel data table according to the file name of the Excel data table, matching the stored service type to find the stored same service type, and obtaining the association relationship between the service type and the field to be extracted, according to The association relationship between the service type and the field to be extracted determines the field to be extracted associated with the service type corresponding to the Excel data table.

Step S3, extracting a data object in the Excel data table based on the determined field to be extracted;

In step S4, the determined field to be extracted and the extracted data object are displayed for confirmation by the user.

In this embodiment, if the Excel data table is a "travel expense reimbursement template", the data therein is as shown in Table 1 below:

Table 1

The fields to be extracted are the employee name or employee ID, the department, the reimbursement reason, the reimbursement time and the reimbursement amount. The corresponding data objects under the fields to be extracted are “Zhang San, Sales Department, Beijing Business Travel, 2017.07.20, The train ticket fee is 500 yuan, the air ticket fee is 1,500 yuan, and the accommodation fee is 500 yuan."

After extracting the corresponding data object under the field to be extracted determined in the Excel data table, the field to be extracted and the extracted data object are displayed for the user to confirm and confirm. If the user confirms that the displayed content has no errors, it is put into the library for subsequent execution of corresponding data operations, such as data encapsulation, warehousing, and the like.

Compared with the prior art, when the Excel data table is imported into the financial auxiliary system, the embodiment identifies the service type of the Excel data table, determines the to-be-extracted field associated with the service type corresponding to the Excel data table, and extracts the to-be-extracted field. The corresponding data object under the field, the determined to-be-extracted field and the extracted data object are displayed. In this embodiment, based on the foregoing components, the data of the Excel data table imported into the financial auxiliary system can be automatically parsed and extracted, saving time. Labor-saving, no need to write a variety of code to analyze and extract data, to avoid differences, and to facilitate later maintenance.

In a preferred embodiment, based on the above embodiment of FIG. 1, the step S3 includes:

S31, comparing the determined to-be-extracted field with each fixed field in the Excel data table;

S32. If the determined to-be-extracted field is in one-to-one correspondence with each fixed field, analyze whether there is a corresponding data object under each fixed field.

S33: If there are corresponding data objects, extract the data objects corresponding to the fixed fields in the Excel data table.

First, the first determined field to be extracted is compared with each fixed field in the Excel data table. If the fixed field in the Excel data table is the same as the first determined field to be extracted, The second determined field to be extracted is continuously compared with each fixed field in the Excel data table until all the determined fields to be extracted are compared.

If the determined to-be-extracted field is in one-to-one correspondence with each fixed field, it is analyzed whether there is a corresponding data object under each fixed field. If each fixed field has a corresponding data object, the fixed field may be directly extracted. The corresponding data object.

Taking the above Table 1 as an Excel data table as an example, the fields to be extracted include: employee name or employee ID, department, reimbursement reason, reimbursement time and reimbursement amount details, and the fixed fields in Table 1 are: employee name, The department, reimbursement reason, reimbursement time and reimbursement amount details, if the two are corresponding and identical, you can analyze whether there are corresponding data objects in each fixed field in Table 1, if any, you can extract.

In other optional embodiments, the foregoing step S3 further includes: if the determined to-be-extracted field does not correspond to each fixed field, or if there is no corresponding data object in the fixed field, the generating includes the determined to be extracted. A prompt message for the field to prompt the user to manually check the Excel data table.

There may be two abnormal situations that require manual checking: one may have one or several determined fields to be extracted that do not correspond to fixed fields in the Excel data table; the other is the determined field to be extracted and Each fixed field corresponds to one and the same, but some fixed fields are not filled with corresponding data objects. In these two cases, the user needs to manually check and process the Excel data table. In addition, the user can re-process the Excel data table. Extract data objects. Therefore, the embodiment can improve the accuracy of extracting data objects in the Excel data table by combining the manual inspection.

In a preferred embodiment, on the basis of the above-described embodiment of FIG. 1, when the processing system is executed by the processor, the following steps are further implemented: according to a predetermined conversion rule before displaying the extracted data object. Convert the extracted data object to the corresponding data format.

In this embodiment, the user may set a plurality of conversion rules in advance, and set one or more of the conversion rules to be the predetermined conversion rule, or the user corresponding to the Excel data table after setting a plurality of conversion rules in advance. The type automatically selects the corresponding conversion rule.

Before displaying the extracted data object, converting the extracted data object into a corresponding data format according to a predetermined conversion rule, for example, for the amount of money, uniformly converting it into data in units of yuan and two decimal places, for Time is unified into the form of "****-**-**", and so on. In this embodiment, the data object is converted into a corresponding data format, which is convenient for the user to confirm, and facilitates subsequent execution of corresponding data operations, such as data encapsulation, storage, and the like.

As shown in FIG. 2, FIG. 2 is a schematic flowchart of a method for extracting data of a data table according to an embodiment of the present application. The method for extracting data of a data table includes the following steps:

Step S1, pre-defining the service type corresponding to each Excel data table, and configuring, for each service type, a field to be extracted associated with the service type, and storing an association relationship between the service type and the corresponding field to be extracted;

In this embodiment, using the import function of the current financial auxiliary system as a sample, an automatic parsing and extracting component of the Excel data table content is developed. In this component, the business type corresponding to each Excel data table can be defined in advance, for example, for an Excel data table. The “travel expense reimbursement template”, the corresponding business type is the reimbursement type. For the Excel data table “entry line upload template”, the corresponding business type is the financial system accounting line record type. Of course, there are other types of Excel data tables that can be imported into the financial assistance system, which are not listed here.

For each type of service, configure the field to be extracted associated with the service type. For example, for the type of reimbursement, the field to be extracted associated with the configuration includes “employee name or employee ID, department, reimbursement, reimbursement amount and Reimbursement time" and so on. For the financial system accounting line record type, the fields to be extracted associated with the configuration include “ticket type, reimbursement category, output tax rate, accounting processing type, detail type, description and flexfield information”.

After the fields to be extracted associated with the service types of the various Excel data tables in the financial assistance system are configured, the relationship between the service types of the various Excel data tables and the corresponding fields to be extracted is stored, for example, in the form of an association mapping table. storage.

Step S2, when the Excel data table is imported into the financial auxiliary system, the service type corresponding to the Excel data table is identified based on the file name of the Excel data table, and the Excel data is determined according to the relationship between the stored service type and the field to be extracted. The field to be extracted associated with the service type corresponding to the table;

In this embodiment, in the financial assistance system, one or more Excel data tables containing different contents may be imported at one time. When the Excel data table is imported into the financial assistance system, the service type corresponding to the Excel data table is identified based on the file name of the Excel data table. As described above, if the file name of the Excel data table is “travel expense reimbursement template”, then The business type of the Excel data table is identified as a reimbursement order type. If the file name of the Excel data table is “entry line upload template”, the business type of the Excel data table is identified as a financial system accounting line record type.

After identifying the service type corresponding to the Excel data table according to the file name of the Excel data table, matching the stored service type to find the stored same service type, and obtaining the association relationship between the service type and the field to be extracted, according to The association relationship between the service type and the field to be extracted determines the field to be extracted associated with the service type corresponding to the Excel data table.

Step S3, extracting a data object in the Excel data table based on the determined field to be extracted;

In step S4, the determined field to be extracted and the extracted data object are displayed for confirmation by the user.

In this embodiment, if the Excel data table is a "travel expense reimbursement template", the data therein is as shown in Table 1 above. The fields to be extracted are the employee name or employee ID, the department, the reimbursement reason, the reimbursement time and the reimbursement amount. The corresponding data objects under the fields to be extracted are “Zhang San, Sales Department, Beijing Business Travel, 2017.07.20, The train ticket fee is 500 yuan, the air ticket fee is 1,500 yuan, and the accommodation fee is 500 yuan."

After extracting the corresponding data object under the field to be extracted determined in the Excel data table, the field to be extracted and the extracted data object are displayed for the user to confirm and confirm. If the user confirms that the displayed content has no errors, it is put into the library for subsequent execution of corresponding data operations, such as data encapsulation, warehousing, and the like.

Compared with the prior art, when the Excel data table is imported into the financial auxiliary system, the embodiment identifies the service type of the Excel data table, determines the to-be-extracted field associated with the service type corresponding to the Excel data table, and extracts the to-be-extracted field. The corresponding data object under the field, the determined to-be-extracted field and the extracted data object are displayed. In this embodiment, based on the foregoing components, the data of the Excel data table imported into the financial auxiliary system can be automatically parsed and extracted, saving time. Labor-saving, no need to write a variety of code to analyze and extract data, to avoid differences, and to facilitate later maintenance.

In a preferred embodiment, as shown in FIG. 3, based on the foregoing embodiment of FIG. 2, the step S3 includes:

S31, comparing the determined to-be-extracted field with each fixed field in the Excel data table;

S32. If the determined to-be-extracted field is in one-to-one correspondence with each fixed field, analyze whether there is a corresponding data object under each fixed field.

S33: If there is a corresponding data object, extract the corresponding data object in each fixed field in the Excel data table.

First, the first determined field to be extracted is compared with each fixed field in the Excel data table. If the fixed field in the Excel data table is the same as the first determined field to be extracted, The second determined field to be extracted is continuously compared with each fixed field in the Excel data table until all the determined fields to be extracted are compared.

If the determined to-be-extracted field is in one-to-one correspondence with each fixed field, it is analyzed whether there is a corresponding data object under each fixed field. If each fixed field has a corresponding data object, the fixed field may be directly extracted. The corresponding data object.

Taking the above Table 1 as an Excel data table as an example, the fields to be extracted include: employee name or employee ID, department, reimbursement reason, reimbursement time and reimbursement amount details, and the fixed fields in Table 1 are: employee name, The department, reimbursement reason, reimbursement time and reimbursement amount details, if the two are corresponding and identical, you can analyze whether there are corresponding data objects in each fixed field in Table 1, if any, you can extract.

In other optional embodiments, the foregoing step S3 further includes: if the determined to-be-extracted field does not correspond to each fixed field, or if there is no corresponding data object in the fixed field, the generating includes the determined to be extracted. A prompt message for the field to prompt the user to manually check the Excel data table.

There may be two abnormal situations that require manual checking: one may have one or several determined fields to be extracted that do not correspond to fixed fields in the Excel data table; the other is the determined field to be extracted and Each fixed field corresponds to one and the same, but some fixed fields are not filled with corresponding data objects. In these two cases, the user needs to manually check and process the Excel data table. In addition, the user can re-process the Excel data table. Extract data objects. Therefore, the embodiment can improve the accuracy of extracting data objects in the Excel data table by combining the manual inspection.

In a preferred embodiment, based on the above embodiment of FIG. 1, the method further comprises: converting the extracted data object into a corresponding data format according to a predetermined conversion rule before displaying the extracted data object.

In this embodiment, the user may set a plurality of conversion rules in advance, and set one or more of the conversion rules to be the predetermined conversion rule, or the user corresponding to the Excel data table after setting a plurality of conversion rules in advance. The type automatically selects the corresponding conversion rule.

Before displaying the extracted data object, converting the extracted data object into a corresponding data format according to a predetermined conversion rule, for example, for the amount of money, uniformly converting it into data in units of yuan and two decimal places, for Time is unified into the form of "****-**-**", and so on. In this embodiment, the data object is converted into a corresponding data format, which is convenient for the user to confirm, and facilitates subsequent execution of corresponding data operations, such as data encapsulation, storage, and the like.

The present application also provides a computer readable storage medium having stored thereon a processing system that, when executed by a processor, implements the steps of the method of extracting data of a data table as described above.

The serial numbers of the embodiments of the present application are merely for the description, and do not represent the advantages and disadvantages of the embodiments.

Through the description of the above embodiments, those skilled in the art can clearly understand that the foregoing embodiment method can be implemented by means of software plus a necessary general hardware platform, and of course, can also be through hardware, but in many cases, the former is better. Implementation. Based on such understanding, the technical solution of the present application, which is essential or contributes to the prior art, may be embodied in the form of a software product stored in a storage medium (such as ROM/RAM, disk, The optical disc includes a number of instructions for causing a terminal device (which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to perform the methods described in various embodiments of the present application.

The above is only a preferred embodiment of the present application, and is not intended to limit the scope of the patent application, and the equivalent structure or equivalent process transformations made by the specification and the drawings of the present application, or directly or indirectly applied to other related technical fields. The same is included in the scope of patent protection of this application.

Claims (20)

An electronic device, comprising: a memory and a processor coupled to the memory, wherein the memory stores a processing system operable on the processor, the processing system being The processor implements the following steps when it executes: S1, pre-defining a service type corresponding to each Excel data table, and configuring, for each service type, a field to be extracted associated with the service type, and storing an association relationship between the service type and the corresponding field to be extracted; S2, when the Excel data table is imported into the financial auxiliary system, the service type corresponding to the Excel data table is identified based on the file name of the Excel data table, and the Excel data table is determined according to the relationship between the stored service type and the field to be extracted. The field to be extracted associated with the corresponding service type; S3. Extract a data object in the Excel data table based on the determined to-be-extracted field. S4: Display the determined to-be-extracted field and the extracted data object for user confirmation. The electronic device according to claim 1, wherein the step S3 comprises: S31, comparing the determined to-be-extracted field with each fixed field in the Excel data table; S32. If the determined to-be-extracted field is in one-to-one correspondence with each fixed field, analyze whether there is a corresponding data object under each fixed field. S33: If there is a corresponding data object, extract the corresponding data object in each fixed field in the Excel data table. The electronic device according to claim 2, wherein the step S3 further comprises: If the determined field to be extracted does not correspond to each fixed field, or there is no corresponding data object in the fixed field, a prompt message including the determined field to be extracted is generated to prompt the user to manually check the Excel data table. The electronic device according to any one of claims 1 to 3, wherein when the processing system is executed by the processor, the following steps are further implemented: The extracted data objects are converted to a corresponding data format according to a predetermined conversion rule before the extracted data objects are presented. The electronic device according to claim 1, wherein when the processing system is executed by the processor, the step of: performing the storage processing of the extracted data object after receiving the confirmation instruction of the user is further implemented. . A method for extracting data of a data table, wherein the method for extracting data of a data table comprises: S1, pre-defining a service type corresponding to each Excel data table, and configuring, for each service type, a field to be extracted associated with the service type, and storing an association relationship between the service type and the corresponding field to be extracted; S2, when the Excel data table is imported into the financial auxiliary system, the service type corresponding to the Excel data table is identified based on the file name of the Excel data table, and the Excel data table is determined according to the relationship between the stored service type and the field to be extracted. The field to be extracted associated with the corresponding service type; S3. Extract a data object in the Excel data table based on the determined to-be-extracted field. S4: Display the determined to-be-extracted field and the extracted data object for user confirmation. The method of extracting data of a data table according to claim 6, wherein the step S3 comprises: S31, comparing the determined to-be-extracted field with each fixed field in the Excel data table; S32. If the determined to-be-extracted field is in one-to-one correspondence with each fixed field, analyze whether there is a corresponding data object under each fixed field. S33: If there is a corresponding data object, extract the corresponding data object in each fixed field in the Excel data table. The method of extracting data of a data table according to claim 7, wherein the step S3 further comprises: If the determined field to be extracted does not correspond to each fixed field, or there is no corresponding data object in the fixed field, a prompt message including the determined field to be extracted is generated to prompt the user to manually check the Excel data table. The method for extracting data of a data table according to any one of claims 6 to 8, further comprising: The extracted data objects are converted to a corresponding data format according to a predetermined conversion rule before the extracted data objects are presented. The method for extracting data of a data table according to claim 6, wherein the step S4 further comprises: after receiving the confirmation instruction of the user, performing the warehousing process on the extracted data object. A system for extracting data of a data table, wherein the system for extracting data of a data table comprises: a configuration module, configured to pre-define a service type corresponding to each Excel data table, and for each service type, configure a to-be-extracted field associated with the service type, and store an association relationship between the service type and the corresponding to-be-extracted field; a determining module, configured to identify a service type corresponding to the Excel data table based on a file name of the Excel data table when the Excel data table is imported into the financial assistance system, and determine the relationship according to the stored service type and the relationship to be extracted The field to be extracted associated with the service type corresponding to the Excel data table; An extracting module, configured to extract a data object in the Excel data table based on the determined field to be extracted; The display module is configured to display the determined to-be-extracted field and the extracted data object for confirmation by the user. The system for extracting data of a data table according to claim 11, wherein the extracting module is specifically configured to compare the determined field to be extracted with each fixed field in the Excel data table; If the determined field to be extracted is in one-to-one correspondence with each fixed field, the corresponding data object is analyzed under each fixed field; if there is a corresponding data object, the corresponding corresponding field in the Excel data table is extracted. Data object. The system for extracting data of a data table according to claim 12, wherein the extracting module is further configured to: if the determined field to be extracted does not correspond to each fixed field, or if there is a corresponding field, there is no corresponding The data object generates a prompt message containing the determined field to be extracted to prompt the user to manually check the Excel data table. The system for extracting data of a data table according to any one of claims 11 to 13, further comprising: And a conversion module, configured to convert the extracted data object into a corresponding data format according to a predetermined conversion rule before displaying the extracted data object. The system for extracting data of a data table according to claim 11, further comprising: a warehousing module, configured to perform the warehousing process on the extracted data object after receiving the confirmation instruction of the user. A computer readable storage medium, wherein the computer readable storage medium stores a processing system, and when the processing system is executed by the processor, the steps are: S1, pre-defining a service type corresponding to each Excel data table, and configuring, for each service type, a field to be extracted associated with the service type, and storing an association relationship between the service type and the corresponding field to be extracted; S2, when the Excel data table is imported into the financial auxiliary system, the service type corresponding to the Excel data table is identified based on the file name of the Excel data table, and the Excel data table is determined according to the relationship between the stored service type and the field to be extracted. The field to be extracted associated with the corresponding service type; S3. Extract a data object in the Excel data table based on the determined to-be-extracted field. S4: Display the determined to-be-extracted field and the extracted data object for user confirmation. The computer readable storage medium of claim 16, wherein the step S3 comprises: S31, comparing the determined to-be-extracted field with each fixed field in the Excel data table; S32. If the determined to-be-extracted field is in one-to-one correspondence with each fixed field, analyze whether there is a corresponding data object under each fixed field. S33: If there is a corresponding data object, extract the corresponding data object in each fixed field in the Excel data table. The computer readable storage medium according to claim 17, wherein the step S3 further comprises: If the determined field to be extracted does not correspond to each fixed field, or there is no corresponding data object in the fixed field, a prompt message including the determined field to be extracted is generated to prompt the user to manually check the Excel data table. The computer readable storage medium according to any one of claims 16 to 18, wherein when the processing system is executed by the processor, the following steps are further implemented: The extracted data objects are converted to a corresponding data format according to a predetermined conversion rule before the extracted data objects are presented. The computer readable storage medium according to claim 16, wherein when the processing system is executed by the processor, the method further comprises the steps of: after receiving the confirmation instruction of the user, performing the extracted data object Inbound processing.

Images