Table splitting method, device, electronic device and storage medium

Abstract

The present invention discloses a table splitting method, device, electronic device and storage medium, the method comprising: obtaining a first master table file, a second master table file and a user account, wherein the second master table file comprises a field name set, the field name set is obtained by extracting the content of the first master table file, and the user account is obtained when logging into the file acquisition system; according to the extraction parameters of the first master table file, the content of the first master table file is cleared to obtain a sub-table template; according to the user account, the field name to be extracted is obtained, and the target object is determined from the field name set of the second master table file based on the field name to be extracted; the target object is stored in the sub-table template to obtain the target sub-table file. The solution provided by the embodiment of the present invention automatically extracts the target sub-table file from the first master table file, which has the beneficial effects of saving work costs, improving work efficiency and accuracy.

Description

Technical Field

[0001] Embodiments of the present invention relate to the field of computer technology, and in particular to a table splitting method, device, electronic device, and storage medium. Background Art

[0002] In the process of advancing the evaluation work, it is necessary to inform the provincial departments and localities of the contents that need to be rectified. Generally, the contents are counted in the form of a table to form a task list to help local departments to effectively rectify the problems raised. At the same time, to ensure data security, local departments can only view the task contents related to their own institutions and their subordinate institutions. Therefore, the evaluation special working group needs to split the local task list (a large table file containing data from departments at all levels) into multiple sub-tables according to the related department or city information, and distribute the sub-tables to the contacts of the corresponding departments or cities by email.

[0003] When splitting the general table into multiple sub-tables according to the associated department or city information, it is generally done manually. In the process of manually splitting the table, the splitting work involves a large number of departments and cities. Taking Guangdong Province as an example, it involves 55 provincial departments and 21 cities, that is, each task list general table requires 76 manual operations to split, and there will be multiple task list general tables in one evaluation work. Therefore, the use of manual operation has problems such as large workload, low efficiency and low accuracy. Summary of the invention

[0004] Embodiments of the present invention provide a table splitting method, device, electronic device and storage medium to improve table splitting efficiency and accuracy and reduce table splitting workload.

[0005] According to one aspect of an embodiment of the present invention, a table splitting method is provided, comprising:

[0006] Acquire a first summary table file, a second summary table file, and a user account, wherein the second summary table file includes a field name set, the field name set is obtained by extracting the content of the first summary table file, and the user account is obtained when logging into the file acquisition system;

[0007] According to the extraction parameters of the first master table file, the content of the first master table file is cleared to obtain a sub-table template;

[0008] Acquire the name of the field to be extracted according to the user account, and determine the target object from the field name set in the second master table file based on the name of the field to be extracted;

[0009] The target object is stored in the sub-table template to obtain a target sub-table file.

[0010] According to another aspect of an embodiment of the present invention, a table splitting device is provided, comprising:

[0011] an acquisition module, used to acquire a first master table file, a second master table file and a user account, wherein the second master table file includes a field name set, the field name set is obtained by extracting the content of the first master table file, and the user account is obtained when logging into the file acquisition system;

[0012] A clearing module, used for clearing the content of the first master table file according to the extraction parameters of the first master table file to obtain a sub-table template;

[0013] A determination module, configured to obtain a name of a field to be extracted according to the user account, and determine a target object from a field name set in the second master table file based on the name of the field to be extracted;

[0014] The storage module is used to store the target object in the sub-table template to obtain a target sub-table file.

[0015] According to another aspect of an embodiment of the present invention, an electronic device is provided, the electronic device comprising:

[0016] at least one processor; and

[0017] a memory communicatively connected to the at least one processor; wherein,

[0018] The memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the table splitting method described in any embodiment of the present invention.

[0019] According to another aspect of an embodiment of the present invention, a computer-readable storage medium is provided, wherein the computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a processor to implement the table splitting method described in any embodiment of the present invention when executed.

[0020] The table splitting scheme of the embodiment of the present invention first obtains the first general table file, the second general table file and the user account, wherein the second general table file includes a field name set, the field name set is obtained by extracting the content of the first general table file, and the user account is obtained when logging into the file acquisition system; then, according to the extraction parameters of the first general table file, the content of the first general table file is cleared to obtain a sub-table template; then, the field names to be extracted are obtained according to the user account, and the target object is determined from the field name set of the second general table file based on the field names to be extracted; finally, the target object is stored in the sub-table template to obtain the target sub-table file. Through the above technical scheme, when the user logs into the file acquisition system through the user account, the field names to be extracted can be obtained according to the user account, and the target object can be automatically determined from the field name set of the second general table file based on the field names to be extracted to form a target sub-table file, which solves the problem that the existing scheme requires manual table splitting. The scheme provided by the embodiment of the present invention automatically extracts the target sub-table file from the first general table file, which has the beneficial effects of saving work costs and improving work efficiency and accuracy.

[0021] It should be understood that the contents described in this section are not intended to identify the key or important features of the embodiments of the present invention, nor are they intended to limit the scope of the present invention. Other features of the embodiments of the present invention will become easily understood through the following description. BRIEF DESCRIPTION OF THE DRAWINGS

[0022] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.

[0023] Figure 1 is a flowchart of a table splitting method provided according to Embodiment 1 of the present invention;

[0024] Figure 2 is a flowchart of a table splitting method provided according to Embodiment 2 of the present invention;

[0025] Figure 3 is a structural schematic diagram of a table splitting device provided according to Embodiment 3 of the present invention;

[0026] Figure 4 It is a structural schematic diagram of an electronic device for implementing the table splitting method of the fourth embodiment of the present invention. DETAILED DESCRIPTION

[0027] In order to enable those skilled in the art to better understand the scheme of the present invention, the technical scheme in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present invention.

[0028] It should be noted that the terms "first", "second", etc. in the specification and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of the present invention described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units that are clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0029] Embodiment 1

[0030] Figure 1 A flowchart of a table splitting method is provided for the first embodiment of the present invention. This embodiment can be applied to obtain a target sub-table file from a master table and automatically split the table. The method can be executed by a table splitting device. The table splitting device can be implemented in the form of hardware and / or software. The table splitting device can be configured in a server such as a computer. Figure 1 As shown, the method includes:

[0031] S110, obtaining a first summary table file, a second summary table file, and a user account.

[0032] The first master list file may be a master list file corresponding to a certain task, and the master list file contains a detailed list of tasks for departments at all levels.

[0033] Taking the evaluation work as an example, the first general table file can be a list of "immediate processing degree" to be optimized. The current list contains the content that needs to be optimized about the "immediate processing degree" of various government departments in provinces, cities, or counties. Among them, the "immediate processing degree" means that when citizens go to the relevant government departments to handle a certain business, they can get it done with only one trip, so as to improve the efficiency of serving citizens. The "immediate processing degree" to be optimized list can record the number of times citizens have run to the relevant government departments to handle the corresponding business, so as to strive to achieve the purpose of "immediate processing" for each business by optimizing the relevant business. Among them, the first general table file is stored in the form of a table, and the current table can be in xlsx format.

[0034] Generally, after the evaluation work is completed, in order to enable each department in each province, city or county to make targeted improvements to the proposed content to be optimized, and to ensure the confidentiality of the data, the corresponding content recorded in the "immediate degree" to be optimized list needs to be split according to the level of each region and the different departments, so that each department in each region can obtain the split sub-table files that need to be improved by their own department. And in the same department, high-level departments have the authority to obtain relevant data content of low-level departments. For example, the Provincial Department of Education can obtain the table of content that needs to be optimized for the entire province (including all counties in all urban areas in the current province); the Municipal Department of Education can obtain the table of content that needs to be optimized for the entire city (including all counties in the current city); the County Department of Education can only obtain the table of content that needs to be optimized for the current County Department of Education. If the table is split manually, there are shortcomings such as large workload and low efficiency.

[0035] In view of this, the table splitting solution provided by the embodiment of the present invention requires obtaining a second general table file based on obtaining the first general table file, wherein the second general table file includes a field name set, and the field name set is obtained by extracting the content of the first general table file.

[0036] It can be understood that the second master table file is a master table file in which the content of the first master table file is extracted as a set of field names. The content of the first master table file can represent the content of each cell, that is, the content of each cell in the first master table file is extracted, and a field name is obtained for each extracted cell. After all cells in the first master table file are extracted, a set of field names is obtained, and the obtained set of field names is still stored in the form of a table to obtain the second master table file.

[0037] After the second general table file is formed, the sub-table file messages corresponding to each administrative department can be pushed through the government public account to notify each administrative department that they can download the form about the task list to be optimized, and upload the first general table file and the second general table file to the file download system commonly used by each administrative department. The current file download system stores the corresponding files required by each administrative department, and users are required to log in according to their user account to obtain the target file.

[0038] When a user logs in to the file download system according to a user account, the corresponding permissions of the current user can be obtained according to the user account level, so as to facilitate the subsequent steps to determine the target object based on the user account.

[0039] It should be noted that the table splitting solution provided in the embodiment of the present invention is not limited to the administrative department scenarios such as provinces, cities or counties used in government affairs systems as shown in the example, but can also be used between various departments within an enterprise. The specific application scenarios are not limited here.

[0040] S120 , clearing the content of the first master table file according to the extraction parameters of the first master table file to obtain a sub-table template.

[0041] The above extraction parameters may represent parameters capable of extracting corresponding content from the first master table file, and may include, for example, a start row parameter, a start column parameter, an end row parameter, an end column parameter, and the like.

[0042] Generally, due to the different table structures of each file, it is necessary to locate the area in the first master table file where the content needs to be cleared through the start row parameters, start column parameters, end row parameters and end column parameters in the first master table file, and after clearing the content in the area defined by the extraction parameters, obtain the sub-table template.

[0043] Optionally, when setting the extraction parameters of the first general table file, only the starting row parameters and the ending column parameters can be set. The purpose of doing this is that since the table contents in the first general table file need to be cleared, only the header structure of the first general table file needs to be retained. When the computer implements automatic clearing according to the code program, when the content in the current row or the current column is empty, there is no need to clear the process. Therefore, the starting and ending row parameters and the starting column parameters do not need to be defined.

[0044] Exemplarily, the header structure of the first summary table file includes: summary table name, precautions and header attribute fields, and the content contained in the first summary table file is eight rows and ten columns. For example, the starting row parameter of the first summary table file should be 4, and the first three rows are all headers. The ending row parameter should be 11, and the starting column parameter is 1, which means that the positioning starts from the first column. The ending column parameter is 10, and the extraction parameters of the first summary table file can be set according to the current parameters; optionally, only the starting row parameter can be set to 4 and the ending column parameter can be set to 10. The specific extraction parameters of the first summary table file are not limited here.

[0045] The header attribute field in the first general table file generally indicates the attributes corresponding to the current column, and may include, for example: serial number, department name, main item name, sub-item name, and content to be optimized, etc., wherein the header attribute field is generally different for different general table file types, and the content contained in the specific header attribute field is not limited here.

[0046] In an embodiment of the present invention, subsequent steps need to obtain the permissions corresponding to the current user based on the user account level of the login file download system, so as to facilitate the subsequent steps to determine the target object based on the user account, wherein the permissions corresponding to the user can indicate the user's department name. Therefore, in an embodiment of the present invention, the header attribute field of the first general table file must include a field that can represent the user identity, such as a department name field, a user name field, etc.

[0047] S130: Obtain the name of the field to be extracted according to the user account, and determine the target object from the field name set in the second general table file based on the name of the field to be extracted.

[0048] After the second master list file is obtained according to step S110, when the user account is used to log in to the file download system, the system can parse the user authority according to the user account, thereby obtaining the fields to be extracted according to the user account.

[0049] The method of parsing user permissions based on user accounts is to pre-store user accounts with system permissions to log in to file downloads in a database, and when logging in to the system based on the current account, compare them one by one with the account set pre-stored in the database. If the comparison passes, it indicates that the current user has login permissions.

[0050] Furthermore, when storing user accounts with the permission to log in to the file download system in the database, the institution or department to which each user account belongs is pre-marked, and the specific institution name or department name is called the field name. For example, the field name can be the Education Department of xx Province, the Finance Department of xx City, or the Public Security Bureau of xx County, etc.

[0051] Since high-level departments have the authority to obtain relevant data content of low-level departments, the management authority corresponding to the current organization or department should also be pre-defined. For example, when it is determined that the current user has the high-level authority of the current department, he or she also has the low-level authority of the sub-department corresponding to the current department.

[0052] Then, according to the field name and field name subset corresponding to the current account, the field with the same field name is searched from the field name set of the second general table file, and the field name that is consistent with the field name and field name subset is used as the field name to be extracted. Among them, the field name subset is the corresponding low-level field name obtained according to the current field name. If the current account is the lowest level, it does not contain the field name subset.

[0053] For example, taking the example of judging that the user's institution is the Finance Department of xx City based on the current user account, the Finance Department of xx City is used as the field name, and its field name subset is all the Finance Departments of xx counties below the municipal institutions contained in xx City. Then, the target object is determined in the field name set of the second general table file based on the field name and the field name subset composed of the field name to be extracted.

[0054] When the name of the field to be extracted is obtained in the field name set of the second general table file, the row where the current field name to be extracted is located can be marked in the second general table file. Generally, the number of fields to be extracted is at least two or more. Therefore, the field name set can be traversed. Each time a field to be extracted is obtained, the row where the current extracted field is located is marked. When the traversal is completed, the marked content in the second general table file is used as the target object, and the content contained in the current target object is the content corresponding to the organization or department to which the user account belongs.

[0055] S140: Store the target object in the sub-table template to obtain a target sub-table file.

[0056] The target object determined in step S130 is stored in the sub-table template obtained in step S120 to form a target sub-table file. The content contained in the current target sub-table file is the content that can be viewed by the organization corresponding to the current user account.

[0057] After obtaining the target sub-table file, rename the target sub-table file and save it to facilitate subsequent reference by the user.

[0058] The table splitting method of the embodiment of the present invention first obtains the first general table file, the second general table file and the user account, wherein the second general table file includes a field name set, the field name set is obtained by extracting the content of the first general table file, and the user account is obtained when logging into the file acquisition system; then, according to the extraction parameters of the first general table file, the content of the first general table file is cleared to obtain a sub-table template; then, the field name to be extracted is obtained according to the user account, and the target object is determined from the field name set of the second general table file based on the field name to be extracted; finally, the target object is stored in the sub-table template to obtain the target sub-table file. Through the above technical solution, when the user logs into the file acquisition system through the user account, the target object can be automatically determined from the field name set of the second general table file based on the field name to be extracted according to the field name to be extracted obtained by the user account, and the target sub-table file is formed, which solves the problem that the existing solution needs to manually split the table. The solution provided by the embodiment of the present invention automatically extracts the target sub-table file from the first general table file, which has the beneficial effects of saving work costs and improving work efficiency and accuracy.

[0059] Embodiment 2

[0060] Figure 2 This is a flow chart of a table splitting method provided by the second embodiment of the present invention. The relationship between this embodiment and the above embodiment is a further refinement of the corresponding features of the above embodiment. Figure 2 As shown, the method includes:

[0061] S210: Obtain a first summary table file.

[0062] S211. Determine the data extraction row number and the data extraction column number according to the header structure of the first general table file.

[0063] The header structure generally indicates the attributes and file name of the current table, and the header structures of different tables are generally the same. Therefore, when extracting data from the first general table file, it is generally necessary to retain the original header structure. After determining the number of rows occupied by the header structure, data extraction is performed from the next row of the header structure.

[0064] Since the table splitting method provided by the embodiment of the present invention needs to realize the extraction of the content in each cell in the first master table file, it is necessary to locate each cell through the data extraction row number and the data extraction column number.

[0065] For example, taking the table header structure occupying three rows as an example, the data extraction row number can start from the fourth row, and in general, the first column of the table is the serial number, so the data extraction column number can start from the second column. The specific data starting row number and data starting column number are not limited here, and shall be based on the first general table file actually provided.

[0066] S212. Extract the content of each cell in the first summary table file as a field name according to the data extraction row number and the data extraction column number, obtain a field name set, and form a second summary table file.

[0067] When each cell is located according to the data extraction row number and the data extraction column number, the content in the current cell is extracted, and the content of the current cell is named as the field name, so that the number of corresponding field names can be formed according to the number of cells whose contents need to be extracted contained in the first master table file, and the file formed by the field name set is called the second master table file.

[0068] An optional method is to extract the content of each cell in the first master table file as a field name according to the data extraction row number and the data extraction column number, and obtain a set of field names. The formation of the second master table file can be achieved by the following method:

[0069] a) Get the current extraction row number and the current extraction column number.

[0070] When extracting the content of each cell in the first master table file, it is necessary to extract row by row and column by column. During the extraction process, the following steps need to be performed to finally obtain the second master table file.

[0071] b) Determine whether the content corresponding to the current extracted line number is empty.

[0072] The purpose of judging whether the current extraction line number is empty is that when the content corresponding to the current line is empty, it indicates that the last line has been extracted and no corresponding extraction operation is required. Then, when the content corresponding to the current extraction line number is not empty, execute step c), if it is empty, execute step f).

[0073] c) Get the content corresponding to the current extracted column number.

[0074] d) Determine whether the content corresponding to the currently extracted column number is empty.

[0075] If the content corresponding to the current extracted column number is empty, it means that the column used by the current row has been extracted to the last row, then the current extracted row number is incremented by one unit, the content corresponding to the next extracted row number is extracted, and the above step b) is repeated.

[0076] If the content corresponding to the currently extracted column number is not empty, execute step e).

[0077] e) Extract the contents of the cells corresponding to the current extraction row number and the current extraction column number, obtain the corresponding field name, and increment the current extraction column number by one unit, extract the contents corresponding to the next extraction column number and the current extraction row number, and repeat the above step d).

[0078] f) Finish extracting the content of each cell in the first master list file and obtain the second master list file.

[0079] S213: Obtain user account.

[0080] S220, obtaining a region range formed by the data start row number, data end row number, data start column number, and data end column number of the first master table file.

[0081] The data starting row number, data ending row number, data starting column number and data ending column number are generally set according to the actual table structure of the first master table file, so as to obtain the area range in the first master table file according to the data starting row number, data ending row number, data starting column number and data ending column number while retaining the header structure of the first master table file. The advantage of this is that it is convenient to clear the sub-table file template based on the first master table file in the subsequent steps, without clearing each cell in the first master table file one by one, thereby improving work efficiency.

[0082] S221. Clear the content contained in the area range, retain the header structure and table format of the first general table file, and obtain a sub-table template.

[0083] The purpose of obtaining a sub-table template based on the first general table file is to store the target object obtained in the subsequent steps in the sub-table template on the basis of the first general table header and table format, so that the target sub-table file format obtained in the subsequent steps is consistent with the first general table format, thereby facilitating the extraction of the target object in the subsequent steps.

[0084] S230. Determine the field names to be extracted and the number of field names to be extracted in the second general table file according to the user account.

[0085] Based on the user account, the organization or department to which the current account belongs, and the corresponding subordinate organization or department can be known, thereby knowing the field name corresponding to the user account (wherein the current field name may include the field name corresponding to the current organization or department and the field name corresponding to the subordinate organization or department). When obtaining the field names to be extracted from the second master table file based on the field names corresponding to the user account, the corresponding number of field names to be extracted in the second master table file can be obtained, so that the corresponding number of field names to be extracted can be extracted in the second master table file.

[0086] S231. Extract the field names to be extracted from the second general table file, and obtain the number of field names currently extracted.

[0087] When the name of the field to be extracted is obtained in the second general table file, the row where the current field name to be extracted is located can be marked in the second general table file. Generally, the number of fields to be extracted is at least two or more. Therefore, the second general table file can be traversed. Each time a field to be extracted is obtained, the row where the current extracted field is located is marked, thereby indicating that the field to be extracted is extracted.

[0088] Optionally, when a marked extraction is performed on the field name segment to be extracted, the field name to be extracted that is marked and extracted is called the extracted field name, and the number of extracted field names is obtained. The purpose of this is to determine whether the current extraction work is completed based on the number of extracted field names.

[0089] Optionally, the operation of extracting the field names to be extracted in the second general table file in the embodiment of the present invention is not limited to the above-mentioned method of marking the row where the field names to be extracted are located. It can also be that after obtaining a field name to be extracted, the row where the current field name to be extracted is located can be directly extracted into the sub-table template, and the specific method of extracting the field names to be extracted is not limited here.

[0090] S232: Determine whether the number of extracted field names is equal to the number of field names to be extracted.

[0091] If they are equal, execute step S233; if they are not equal, repeat step S231 and continue to extract the target objects corresponding to the remaining field names to be extracted until the number of extracted field names is equal to the number of field names to be extracted.

[0092] S233. Extract the target object corresponding to the extracted field name from the field name set of the second general table file.

[0093] In step S231, when extracting field names, if the method of marking the field name segments to be extracted is adopted, then when it is determined that the number of extracted field names is equal to the number of field names to be extracted, the marked extracted field names are used as target objects; if the method of directly extracting the row where the current field names to be extracted are located into the sub-table template is adopted, then the row where the current field names to be extracted are located is used as the target object.

[0094] S240: Store the target object in the sub-table template to obtain a target sub-table file.

[0095] The currently obtained target sub-table file does not contain a serial number. Furthermore, in order to make the file content contained in the target sub-table file more complete, the table splitting method provided in an embodiment of the present invention, after obtaining the name of the field to be extracted according to the user account and determining the target object from the field name set of the second general table file based on the name of the field to be extracted, also includes: obtaining the serial number column number of the second general table file; using the serial number column number to reset the serial number of the target object to obtain the target serial number.

[0096] Generally, the serial number column is located in the first column of the table, and the serial number column number of the current second general table file can be 1. Since there is confusion in the serial number corresponding to the row where the target object is located when the target object is extracted, after determining the target object from the field name set of the second general table file, the serial number of the current target object is reset using the serial number column number to obtain the target serial number, so as to arrange the target object in order by the target serial number.

[0097] Accordingly, the target sequence number and the target object are stored in the sub-table template to obtain the target sub-table file.

[0098] The content contained in the target sub-table file is the content that can be viewed by the organization or department corresponding to the current user account, and the target sub-table file contains several data corresponding to several target serial numbers, thereby achieving the integrity of the target sub-table file.

[0099] Optionally, after the target object is stored in the subtable template and the target subtable file is obtained, the table splitting method provided by the embodiment of the present invention further includes: naming the target subtable file according to the name of the field to be extracted obtained from the user account; locking the content of the subtable file, and encrypting the target subtable file using ciphertext data to obtain an encrypted target subtable file. The system locks the data content of the target subtable file, prohibiting users from performing secondary editing after downloading, which can ensure the security of the data, and after the target subtable file is encrypted, only users with current file permissions can view the target subtable file.

[0100] Furthermore, the file password can be pushed to the corresponding user with file download permission through the government WeChat or file download public account; after complete locking and encryption processing, the system starts the target sub-table file download and downloads the target sub-table file to the user's local computer. Administrative division or administrative department users can view the file encryption information through the government WeChat, decrypt the file and view the specific sub-table file content.

[0101] The table splitting method provided by the embodiment of the present invention combines the unique institutional information in the field of government services, namely, departmental institutions and administrative division information, and performs data screening and writing based on the institutional information to achieve table splitting; and the first general table file is pre-stored as a second general table file in the form of fields, which is convenient for subsequent screening of target object information based on user accounts to form a general table file related to the institution or department to which the user account belongs. At the same time, based on the institutional information, the government WeChat is used to implement message push and encrypted information push, timely reminding users to download files and improve data security, and the process of splitting the general table file to obtain the sub-table file is realized through system automation, which replaces a large amount of manpower investment, saves costs, and improves efficiency.

[0102] Embodiment 3

[0103] Figure 3 This is a schematic diagram of the structure of a table splitting device provided in Embodiment 3 of the present invention. Figure 3 As shown, the device includes: an acquisition module 31, a clearing module 32, a determination module 33 and a storage module 34, wherein:

[0104] The acquisition module 31 is used to acquire a first master table file, a second master table file and a user account, wherein the second master table file includes a field name set, the field name set is obtained by extracting the content of the first master table file, and the user account is obtained when logging into the file acquisition system;

[0105] A clearing module 32, configured to clear the content of the first master table file according to the extraction parameters of the first master table file to obtain a sub-table template;

[0106] A determination module 33, configured to obtain a name of a field to be extracted according to the user account, and determine a target object from a field name set in the second general table file based on the name of the field to be extracted;

[0107] The storage module 34 is used to store the target object in the sub-table template to obtain a target sub-table file.

[0108] The table splitting device of the embodiment of the present invention first obtains the first general table file, the second general table file and the user account, wherein the second general table file includes a field name set, the field name set is obtained by extracting the content of the first general table file, and the user account is obtained when logging into the file acquisition system; then, according to the extraction parameters of the first general table file, the content of the first general table file is cleared to obtain a sub-table template; then, the field name to be extracted is obtained according to the user account, and the target object is determined from the field name set of the second general table file based on the field name to be extracted; finally, the target object is stored in the sub-table template to obtain the target sub-table file. Through the above technical scheme, when the user logs into the file acquisition system through the user account, the target object can be automatically determined from the field name set of the second general table file based on the field name to be extracted according to the field name to be extracted obtained by the user account, and the target sub-table file is formed, which solves the problem that the existing scheme needs to manually split the table. The scheme provided by the embodiment of the present invention automatically extracts the target sub-table file from the first general table file, which has the beneficial effects of saving work costs and improving work efficiency and accuracy.

[0109] Optionally, the acquisition module 31 includes: a determination unit and an acquisition unit, wherein:

[0110] A determination unit, used to determine a data extraction row number and a data extraction column number according to a header structure of the first general table file;

[0111] An obtaining unit is used to extract the content of each cell in the first general table file as a field name according to the data extraction row number and the data extraction column number, obtain the field name set, and form the second general table file.

[0112] Optionally, the obtaining unit includes: an obtaining subunit, a judging subunit and an obtaining subunit, wherein:

[0113] Get subunit, used to get the current extraction row number and the current extraction column number;

[0114] A judging subunit, used to judge whether the content corresponding to the currently extracted line number is empty;

[0115] The acquisition subunit, specifically, if the content corresponding to the currently extracted row number is not empty, then the content corresponding to the currently extracted column number is acquired;

[0116] An acquisition subunit is used to terminate the extraction of the content of each cell in the first master table file and obtain the second master table file if the content corresponding to the currently extracted row number is empty.

[0117] Optionally, the obtaining unit further comprises: an extracting subunit, wherein:

[0118] A judgment subunit, specifically used to judge whether the content corresponding to the current extraction column number is empty;

[0119] An extraction subunit, for, if the content corresponding to the current extraction column number is empty, increasing the current extraction row number by one unit, and extracting the content corresponding to the next extraction row number;

[0120] The extraction subunit is also used to extract the contents of the cells corresponding to the current extraction row number and the current extraction column number if the content corresponding to the current extraction column number is not empty, obtain the corresponding field name, and increment the current extraction column number by one unit to extract the contents corresponding to the next extraction column number and the current extraction row number.

[0121] Optionally, the extraction parameters of the first summary table file include: a data starting row number, a data ending row number, a data starting column number, and a data ending column number;

[0122] The clearing module 32 includes: a first acquiring unit and a clearing unit, wherein:

[0123] A first acquisition unit is used to acquire a region range formed by the data start row number, the data end row number, the data start column number and the data end column number in the first general table file;

[0124] A clearing unit is used to clear the content contained in the area range, retain the header structure and table format of the first general table file, and obtain the sub-table template.

[0125] Optionally, the determination module includes: a determination unit, a second acquisition unit, a judgment unit and an extraction unit, wherein:

[0126] A determining unit, configured to determine the name of the field to be extracted and the number of the field names to be extracted in the second general table file according to the user account;

[0127] A second acquisition unit is used to extract the fields to be extracted from the second general table file and obtain the number of field names currently extracted;

[0128] A judging unit, used to judge whether the number of the extracted field names is equal to the number of the field names to be extracted;

[0129] If they are equal, the extraction unit is used to extract the target object corresponding to the extracted field name from the field name set of the second general table file;

[0130] If not equal, the extraction unit is further used to continue to perform extraction operations on the target objects corresponding to the remaining field names to be extracted.

[0131] Optionally, the acquisition module 31 is specifically configured to acquire a sequence number column number of the second master table file; and use the sequence number column number to reset the sequence number of the target object to obtain a target sequence number;

[0132] The storage module 34 is specifically used to store the target sequence number and the target object in the sub-table template to obtain the target sub-table file.

[0133] The table splitting device provided in the embodiment of the present invention can execute the table splitting method provided in any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the execution method.

[0134] Embodiment 4

[0135] Figure 4 A schematic diagram of the structure of an electronic device 10 that can be used to implement an embodiment of the present invention is shown. The electronic device is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workstations, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device can also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices (such as helmets, glasses, watches, etc.) and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely examples and are not intended to limit the implementation of the present invention described and / or required herein.

[0136] like Figure 4 As shown, the electronic device 10 includes at least one processor 11, and a memory connected to the at least one processor 11, such as a read-only memory (ROM) 12, a random access memory (RAM) 13, etc., wherein the memory stores a computer program that can be executed by at least one processor, and the processor 11 can perform various appropriate actions and processes according to the computer program stored in the read-only memory (ROM) 12 or the computer program loaded from the storage unit 18 to the random access memory (RAM) 13. In the RAM 13, various programs and data required for the operation of the electronic device 10 can also be stored. The processor 11, the ROM 12, and the RAM 13 are connected to each other through a bus 14. An input / output (I / O) interface 15 is also connected to the bus 14.

[0137] A number of components in the electronic device 10 are connected to the I / O interface 15, including: an input unit 16, such as a keyboard, a mouse, etc.; an output unit 17, such as various types of displays, speakers, etc.; a storage unit 18, such as a disk, an optical disk, etc.; and a communication unit 19, such as a network card, a modem, a wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information / data with other devices through a computer network such as the Internet and / or various telecommunication networks.

[0138] The processor 11 may be a variety of general and / or special processing components with processing and computing capabilities. Some examples of the processor 11 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various dedicated artificial intelligence (AI) computing chips, various processors running machine learning model algorithms, digital signal processors (DSPs), and any appropriate processors, controllers, microcontrollers, etc. The processor 11 performs the various methods and processes described above, such as method table splitting.

[0139] In some embodiments, the method table splitting can be implemented as a computer program, which is tangibly contained in a computer-readable storage medium, such as a storage unit 18. In some embodiments, part or all of the computer program can be loaded and / or installed on the electronic device 10 via the ROM 12 and / or the communication unit 19. When the computer program is loaded into the RAM 13 and executed by the processor 11, one or more steps of the method table splitting described above can be performed. Alternatively, in other embodiments, the processor 11 can be configured to perform the method table splitting in any other suitable manner (for example, by means of firmware).

[0140] Various implementations of the systems and techniques described above herein can be implemented in digital electronic circuit systems, integrated circuit systems, field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various implementations can include: being implemented in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, which can be a special purpose or general purpose programmable processor that can receive data and instructions from a storage system, at least one input device, and at least one output device, and transmit data and instructions to the storage system, the at least one input device, and the at least one output device.

[0141] Computer programs for implementing the methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing device, so that when the computer program is executed by the processor, the functions / operations specified in the flow chart and / or block diagram are implemented. The computer program may be executed entirely on the machine, partially on the machine, partially on the machine and partially on a remote machine as a stand-alone software package, or entirely on a remote machine or server.

[0142] In the context of the present invention, a computer-readable storage medium may be a tangible medium that may contain or store a computer program for use by or in combination with an instruction execution system, device or equipment. A computer-readable storage medium may include, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, devices or equipment, or any suitable combination of the foregoing. Alternatively, a computer-readable storage medium may be a machine-readable signal medium. A more specific example of a machine-readable storage medium may include an electrical connection based on one or more lines, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0143] To provide interaction with a user, the systems and techniques described herein may be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and a pointing device (e.g., a mouse or trackball) through which the user can provide input to the electronic device. Other types of devices may also be used to provide interaction with the user; for example, the feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form (including acoustic input, voice input, or tactile input).

[0144] The systems and techniques described herein may be implemented in a computing system that includes backend components (e.g., as a data server), or a computing system that includes middleware components (e.g., an application server), or a computing system that includes frontend components (e.g., a user computer with a graphical user interface or a web browser through which a user can interact with implementations of the systems and techniques described herein), or a computing system that includes any combination of such backend components, middleware components, or frontend components. The components of the system may be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: a local area network (LAN), a wide area network (WAN), a blockchain network, and the Internet.

[0145] A computing system may include a client and a server. The client and the server are generally remote from each other and usually interact through a communication network. The client and server relationship is generated by computer programs running on the corresponding computers and having a client-server relationship with each other. The server may be a cloud server, also known as a cloud computing server or cloud host, which is a host product in the cloud computing service system to solve the defects of difficult management and weak business scalability in traditional physical hosts and VPS services.

[0146] It should be understood that the various forms of processes shown above can be used to reorder, add or delete steps. For example, the steps described in the present invention can be executed in parallel, sequentially or in different orders, as long as the desired results of the technical solution of the present invention can be achieved, and this document does not limit this.

[0147] The above specific implementations do not constitute a limitation on the protection scope of the present invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions can be made according to design requirements and other factors. Any modification, equivalent substitution and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims

1. A table splitting method, characterized in that: include: Acquire a first summary table file, a second summary table file, and a user account, wherein the second summary table file includes a field name set, the field name set is obtained by extracting the content of the first summary table file, and the user account is obtained when logging into the file acquisition system; Clear the content of the first master table file according to the extraction parameters of the first master table file to obtain a sub-table template; Acquire the name of the field to be extracted according to the user account, and determine the target object from the field name set in the second master table file based on the name of the field to be extracted; The target object is stored in the sub-table template to obtain a target sub-table file; Wherein, obtaining the second master table file includes: determining a data extraction row number and a data extraction column number according to a header structure of the first master table file; extracting the content of each cell in the first master table file as a field name according to the data extraction row number and the data extraction column number, obtaining a field name set, and forming the second master table file; The extraction parameters of the first master table file include: a starting row number of data, an ending row number of data, a starting column number of data, and an ending column number of data; the content of the first master table file is cleared according to the extraction parameters of the first master table file to obtain a sub-table template, including: obtaining an area range formed by the first master table file according to the starting row number of data, the ending row number of data, the starting column number of data, and the ending column number of data; clearing the content contained in the area range, retaining the header structure and table format of the first master table file, and obtaining the sub-table template.

2. The method according to claim 1, characterized in that According to the data extraction row number and the data extraction column number, the content of each cell in the first general table file is extracted as a field name, and a field name set is obtained to form the second general table file, including: Get the current extraction row number and the current extraction column number; Determine whether the content corresponding to the currently extracted line number is empty; If the content corresponding to the currently extracted row number is not empty, then obtaining the content corresponding to the currently extracted column number; If the content corresponding to the currently extracted row number is empty, the extraction of the content of each cell in the first general table file is terminated to obtain the second general table file.

3. The method according to claim 2, characterized in that Obtain the content corresponding to the currently extracted column number, including: Determine whether the content corresponding to the currently extracted column number is empty; If the content corresponding to the current extraction column number is empty, the current extraction row number is incremented by one unit, and the content corresponding to the next extraction row number is extracted; If the content corresponding to the current extraction column number is not empty, extract the content of the cell corresponding to the current extraction row number and the current extraction column number, obtain the corresponding field name, and increment the current extraction column number by one unit, and extract the content corresponding to the next extraction column number and the current extraction row number.

4. The method according to claim 1, characterized in that: Acquiring the name of the field to be extracted according to the user account, and determining the target object from the field name set of the second master table file based on the name of the field to be extracted, including: Determine the name of the field to be extracted and the number of the field names to be extracted in the second general table file according to the user account; Extract the fields to be extracted from the second master list file, and obtain the number of field names currently extracted; Determine whether the number of the extracted field names is equal to the number of the field names to be extracted; If they are equal, extracting the target object corresponding to the extracted field name from the field name set of the second general table file; If not equal, continue to extract the target objects corresponding to the remaining field names to be extracted.

5. The method according to claim 1, characterized in that After obtaining the name of the field to be extracted according to the user account and determining the target object from the field name set of the second master table file based on the name of the field to be extracted, the method further includes: Get the serial number of the second master list file; Reset the sequence number of the target object using the sequence number column number to obtain the target sequence number; Accordingly, the target object is stored in the sub-table template to obtain the target sub-table file, including: The target sequence number and the target object are stored in the sub-table template to obtain the target sub-table file.

6. A table splitting device, characterized in that: include: an acquisition module, used to acquire a first master table file, a second master table file and a user account, wherein the second master table file includes a field name set, the field name set is obtained by extracting the content of the first master table file, and the user account is obtained when logging into the file acquisition system; A clearing module, used for clearing the content of the first master table file according to the extraction parameters of the first master table file to obtain a sub-table template; A determination module, configured to obtain a name of a field to be extracted according to the user account, and determine a target object from a field name set in the second master table file based on the name of the field to be extracted; A storage module, used for storing the target object in the sub-table template to obtain a target sub-table file; The acquisition module is specifically used to: determine the data extraction row number and the data extraction column number according to the header structure of the first master table file; extract the content of each cell in the first master table file as a field name according to the data extraction row number and the data extraction column number, obtain a field name set, and form the second master table file; The extraction parameters of the first general table file include: data starting row number, data ending row number, data starting column number and data ending column number; the clearing module is specifically used to: obtain the area range formed by the first general table file according to the data starting row number, the data ending row number, the data starting column number and the data ending column number; clear the content contained in the area range, retain the header structure and table format of the first general table file, and obtain the sub-table template.

7. An electronic device, characterized in that: The electronic device comprises: at least one processor; and a memory communicatively connected to the at least one processor; wherein, The memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the table splitting method according to any one of claims 1 to 5.

8. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a processor to implement the table splitting method according to any one of claims 1 to 5 when executed.

Images