Data processing method and device, computer device and storage medium

Abstract

The application relates to a data processing method and device, computer equipment, a storage medium and a computer program product. The method comprises the following steps: obtaining data configuration information of target export data, style information of an export file, and format configuration information of a target column in the export file; determining an export specification interface according to the data configuration information and a target database; determining a data entity type to be exported according to the export specification interface; screening export data columns according to the data entity type, the data configuration information and the target database; writing data corresponding to the export data columns into a temporary export file according to the style information of the export file; and converting the data of the target column in the temporary export file according to the format configuration information of the target column in the export file to obtain the export file. The method can abstract the style information and the format information into a configurable process, highly simplifies data processing operations, and improves data processing efficiency.

Description

TECHNICAL FIELD

[0001] The present application relates to the field of data processing, and in particular to a data processing method and device, computer equipment, a storage medium and a computer program product. BACKGROUND

[0002] In report statistics and data aggregation, it is often necessary to customize the Excel document style according to business requirements, so as to obtain an Excel document that meets individual needs. Function integration is required during Excel import. In the process of data import and data export, the code of high-frequency general processing steps is highly redundant and prone to errors, and the open source Excel-API has the problem of high complexity of use, resulting in low efficiency of Excel document export.

[0003] Therefore, the current Excel processing has the problems of high complexity and low efficiency in the export process, and cannot realize efficient processing of data. SUMMARY

[0004] Therefore, it is necessary to provide a data processing method, device, computer equipment, computer readable storage medium and computer program product capable of improving the efficiency of data import and export.

[0005] In a first aspect, the present application provides a data processing method. The method comprises:

[0006] obtaining data configuration information of target export data, style information of an export file, and format configuration information of a target column in the export file;

[0007] determining an export specification interface according to the data configuration information and a target database;

[0008] determining a data entity type to be exported according to the export specification interface;

[0009] filtering export data columns according to the data entity type, the data configuration information and the target database;

[0010] writing data corresponding to the export data columns into a temporary export file according to the style information of the export file;

[0011] converting data of the target column in the temporary export file according to the format configuration information of the target column in the export file to obtain an export file.

[0012] In one embodiment, the method further comprises: if the data configuration information includes a star-level encrypted file, encrypting the export file to obtain an encrypted export file.

[0013] In one of the embodiments, the method further comprises:

[0014] obtaining target import data and format configuration information of target columns in the import file; wherein the format configuration information of the target columns in the import file comprises at least one of title configuration, compliance verification configuration, code table conversion configuration and customized format configuration;

[0015] reading the target import data into the import file;

[0016] verifying the target column data in the import file according to the format configuration information of the target columns in the import file.

[0017] In one of the embodiments, the writing of the data corresponding to the export data columns into the temporary export file according to the style information of the export file comprises:

[0018] writing the data corresponding to the export data columns into the temporary export file;

[0019] setting the style of the title cell of the temporary export file according to the title cell style in the style information;

[0020] setting the cell style of each column of the temporary export file according to the column cell style in the style information;

[0021] merging the target cells of the temporary export file according to the merged cell configuration in the style information to obtain merged cells;

[0022] setting the merged cells according to the merged style in the style information;

[0023] automatically dividing the worksheets of the temporary export file according to the number of worksheets in the style information.

[0024] In one of the embodiments, the format configuration information of the target columns comprises at least one of serial number column configuration, code table conversion configuration and customized format configuration.

[0025] In one of the embodiments, the conversion of the data of the target columns in the temporary export file according to the format configuration information of the target columns in the export file to obtain the export file comprises:

[0026] if the format configuration information comprises serial number column configuration, then automatically filling the data of the serial number column in the target columns of the temporary export file;

[0027] if the format configuration information comprises code table conversion configuration, then converting the business data of the target columns in the temporary export file according to the code table;

[0028] If the format configuration information includes the customized formatting configuration, the formatter is invoked to format the business data of the target column in the temporary export file.

[0029] In a second aspect, the present application provides a data processing apparatus. The apparatus comprises:

[0030] an information obtaining module, configured to obtain data configuration information of target export data, style information of an export file, and format configuration information of a target column in the export file;

[0031] an export specification interface determining module, configured to determine an export specification interface according to the data configuration information and a target database;

[0032] a data entity type determining module, configured to determine a data entity type to be exported according to the export specification interface;

[0033] an export data column screening module, configured to screen export data columns according to the data entity type, the data configuration information, and the target database;

[0034] a temporary export file writing module, configured to write data corresponding to the export data columns into a temporary export file according to the style information of the export file;

[0035] an export file obtaining module, configured to convert data of the target column in the temporary export file according to the format configuration information of the target column in the export file, and obtain an export file.

[0036] In a third aspect, the present application provides a computer device. The computer device comprises a memory and a processor, the memory stores a computer program, and the processor implements the following steps when executing the computer program:

[0037] obtain data configuration information of target export data, style information of an export file, and format configuration information of a target column in the export file;

[0038] determine an export specification interface according to the data configuration information and a target database;

[0039] determine a data entity type to be exported according to the export specification interface;

[0040] screen export data columns according to the data entity type, the data configuration information, and the target database;

[0041] write data corresponding to the export data columns into a temporary export file according to the style information of the export file;

[0042] According to the format configuration information of the target column in the export file, data of the target column in the temporary export file is converted to obtain the export file.

[0043] In a fourth aspect, the present application provides a computer readable storage medium. The computer readable storage medium has a computer program stored thereon, and the computer program, when executed by a processor, implements the following steps:

[0044] obtaining data configuration information of target export data, style information of the export file, and format configuration information of a target column in the export file;

[0045] determining an export specification interface according to the data configuration information and the target database;

[0046] determining a data entity type to be exported according to the export specification interface;

[0047] filtering export data columns according to the data entity type, the data configuration information, and the target database;

[0048] writing data corresponding to the export data columns into a temporary export file according to the style information of the export file;

[0049] converting data of the target column in the temporary export file according to the format configuration information of the target column in the export file to obtain the export file.

[0050] In a fifth aspect, the present application provides a computer program product. The computer program product comprises a computer program, and the computer program, when executed by a processor, implements the following steps:

[0051] obtaining data configuration information of target export data, style information of the export file, and format configuration information of a target column in the export file;

[0052] determining an export specification interface according to the data configuration information and the target database;

[0053] determining a data entity type to be exported according to the export specification interface;

[0054] filtering export data columns according to the data entity type, the data configuration information, and the target database;

[0055] writing data corresponding to the export data columns into a temporary export file according to the style information of the export file;

[0056] converting data of the target column in the temporary export file according to the format configuration information of the target column in the export file to obtain the export file.

[0057] The data processing method, device, computer device, storage medium and computer program product determine an export specification interface according to the data configuration information and the target database, determine data columns exported from the target database according to the export specification interface, process the exported data according to the export file style and the format configuration information of the target column, and obtain an export file conforming to the style information and the format configuration information. The style information and the format information are abstracted into configurable processes, the data processing operation is highly simplified, and the data processing efficiency is improved. BRIEF DESCRIPTION OF DRAWINGS

[0058] Figure 1 A flowchart of a data processing method in an embodiment is shown;

[0059] Figure 2 A flowchart of a data processing method in an embodiment is shown;

[0060] Figure 3 A flowchart of a data processing method in an embodiment is shown;

[0061] Figure 4 A flowchart of a data processing method in an embodiment is shown;

[0062] Figure 5 A flowchart of a data processing method in an embodiment is shown;

[0063] Figure 6 A structural block diagram of a data processing device in an embodiment is shown;

[0064] Figure 7 An internal structure diagram of a computer device in an embodiment is shown. DETAILED DESCRIPTION

[0065] In order to make the purpose, technical scheme and advantages of the present application clearer, the present application is further described in detail below with reference to the drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and do not limit the present application.

[0066] In an embodiment, as shown in Figure 1 , a data processing method is provided, comprising the following steps:

[0067] Step 102, obtaining data configuration information of target export data, style information of an export file, and format configuration information of a target column in the export file.

[0068] The data configuration information is used to configure the data export before exporting the file. The style information of the exported file can include header cell style, cell style of each column, merged cell configuration, merge style, etc. The format configuration information of the target column in the exported file includes serial number column configuration, code table translation configuration, and custom formatting configuration.

[0069] Specifically, based on business requirements, the style information of the exported file and the format configuration information of the target columns in the exported file are determined, thereby obtaining the style information of the exported file and the format configuration information of the target columns in the exported file.

[0070] Step 104: Determine the export specification interface based on the data configuration information and the target database.

[0071] The data configuration information specifies the export settings, with the target database being the database containing the exported data. The export specification interface configuration covers all configuration requirements, including style configuration information and target column format configuration information.

[0072] Specifically, the export specification interface is determined based on the data configuration information and the target database, and the export specification section covers all the configurations related to the exported files.

[0073] Step 106: Determine the data entity type to be exported based on the export specification interface.

[0074] An entity is a single, unique object in the real world that is being controlled. Examples of entities include a single person, a single product, or a single organization. An entity type stores information about the person, organization, object type, or concept that is being controlled. It describes the type of information being controlled. Entity types typically correspond to one or more related tables in a database.

[0075] If the exported specification interface is a generic interface, then the types of data entities to be processed can be restricted based on the genericity of the exported specification interface. Therefore, the types of data entities to be exported can be determined based on the genericity of the exported specification interface.

[0076] Step 108: Filter and export data columns based on data entity type, data configuration information, and target database.

[0077] Specifically, the target exported data is determined from the target database based on the data entity type and data configuration information.

[0078] Step 110: Write the data corresponding to the exported data columns into a temporary export file according to the style information of the exported file.

[0079] The style information includes header cell styles, column cell styles, merged cell configurations, and merge styles. The temporary export file is a file obtained by configuring the styles of the data corresponding to the exported data columns based on the style information of the export file.

[0080] Specifically, the data corresponding to the exported data columns is written to a temporary export file. According to the style information of the export file, the data in the data columns to be exported is set to obtain a temporary export file containing the data corresponding to the exported data columns.

[0081] Step 112: Based on the format configuration information of the target column in the exported file, convert the data of the target column in the temporary exported file to obtain the exported file.

[0082] The format configuration information for the target columns in the exported file includes serial number column configuration, code table translation configuration, and custom formatting configuration.

[0083] Specifically, the target column in the exported file is determined based on the format configuration information, and the data in the target column is configured according to the format configuration information of the target column to obtain an exported file that conforms to the style information and format configuration information of the exported file.

[0084] In this embodiment, an export specification interface is determined based on data configuration information and the target database. Based on the export specification interface, the data columns to be exported from the target database are determined. The exported data is processed according to the export file style and the format configuration information of the target columns to obtain an export file that conforms to the style and format configuration information. By abstracting the style and format information into a configurable process, data processing operations are greatly simplified, and data processing efficiency is improved.

[0085] In one embodiment, the data processing method further includes:

[0086] If the data configuration information includes a star-rating encrypted file, then the exported file will be encrypted to obtain an encrypted exported file.

[0087] Specifically, when the data configuration information for the exported file is set to a star-level encrypted file, an encrypted channel is provided for exporting Excel files. This allows for the configuration of encryption policies and encryption methods for the exported file, and also provides a quick download channel for the encrypted exported file, allowing customers to download it. Specifically, the DSM channel can be invoked to generate the encrypted exported file, which will then be used as the final exported file.

[0088] In this embodiment, when the data configuration information of the exported file is a star-level encrypted file, an encryption channel is provided to encrypt the exported file, and a quick download channel for the exported file is provided so that customers can download the encrypted exported file.

[0089] In one embodiment, such as Figure 2 As shown, the data processing method also includes the following steps:

[0090] Step 202: Obtain the target import data and the format configuration information of the target column in the import file; wherein, the format configuration information of the target column in the import file includes at least one of the following: title configuration, compliance verification configuration, transcoding table configuration, and custom format configuration.

[0091] The title configuration is used to verify whether the titles of the data list conform to regulations. Specifically, for example, if the content of the title row of a column is "name," while the preset title row content is "title," the validator will perform the verification based on the preset content. When the verification fails, the failure information is cached. The compliance verification configuration is used to verify the numerical values, data formats, and text content of the data in the data list. The decoding table configuration is used to convert the numerical values ​​in the file into the corresponding text content. The custom format configuration is used to convert the text content into the corresponding numerical format.

[0092] Specifically, the format configuration information of the target column in the import file is determined according to business requirements, and the target import data and the format configuration information of the target column in the import file are obtained.

[0093] Step 204: Read the target import data into the import file.

[0094] Write the target import data into the import file and upload the import file to the execution engine.

[0095] Step 206: Validate the target column data in the imported file according to the format configuration information of the target column in the imported file.

[0096] The execution engine reads the imported data and verifies and modifies the target column data according to the target column's format configuration information. Specifically, it verifies the compliance of the target data column's title based on the title configuration. For example, if the title row of a column contains "name" while the preset title row contains "title," the validator will verify according to the preset content. When verification fails, the failure information is cached. It also verifies the numerical values, data formats, and text content of the data in the data list according to the compliance verification configuration. Finally, it converts the numerical values ​​in the file to their corresponding text content according to the decoding table configuration, and converts the text content to its corresponding numerical format according to the custom format configuration, with the custom format configuration having higher priority than the decoding table configuration.

[0097] In this embodiment, the target imported data is validated through format configuration information such as title configuration, compliance verification configuration, transcoding table configuration, and customized format configuration, so that the text content of the target imported data is compliant and the data format of the target column is correct.

[0098] In one embodiment, such as Figure 3 As shown, the data corresponding to the exported data columns is written to a temporary export file according to the style information of the exported file, including the following steps:

[0099] Step 302: Save the data corresponding to the exported data columns into a temporary export file.

[0100] Step 304: Set the style of the title cell of the temporary exported file according to the title cell style in the style information.

[0101] If the style information includes a header cell style, then clone the header cell style to the header cell of the temporary exported file.

[0102] Step 306: Set the cell styles of each column in the temporary exported file according to the cell styles in the style information.

[0103] If the style information includes the cell styles for each column, then clone that cell style to all cells in the target column of the temporary export file.

[0104] Step 308: According to the merged cell configuration in the style information, merge the target cells of the temporary exported file to obtain merged cells.

[0105] The on-demand configuration specifies the cells to be merged. Merging cells is achieved using an array configuration. Specifically, the four values ​​inside the array represent: the starting column, the ending column, the starting row, and the ending row. For example: [0,2,0,0] represents merging A1, B1, and C1; [3,3,0,1] represents merging D1 and D2; and [4,4,0,1] represents merging E1 and E2.

[0106] Step 310: Set the merged cells according to the merge style in the style information.

[0107] If the style information includes a merge style, then the style is cloned to the merged cells of the temporary exported file, thus making the style of the merged cells the merge style.

[0108] Step 312: Automatically divide the worksheets of the temporary exported file according to the number of worksheet rows in the style information.

[0109] Based on the upper limit of the data bars in each worksheet, the data is automatically divided into multiple worksheets and exported. If style and format configuration information for multiple worksheets is configured, the export file is generated according to the style and format configuration information corresponding to each worksheet.

[0110] In this embodiment, the data of the exported data columns is written into a temporary exported file according to the title cell style, column cell style, merged cell configuration, merge style, and number of worksheet rows of the exported file, so as to obtain a temporary exported file that conforms to the style information of the exported file.

[0111] In one embodiment, the format configuration information of the target column includes at least one of the following: serial number column configuration, decoding table configuration, and custom format configuration.

[0112] Specifically, the sequence number column configuration is used to automatically populate the data in the sequence number column, with the data incrementing from 1 based on the row. The code table translation configuration is used to translate business data based on a code table. For example, if there exists a code table cljd_codemap: {0: "Pending", 1: "Processing", 2: "Completed"}, and the processing progress configuration uses cljd_codemap for conversion, then when the processing progress value is 0, it will automatically be converted to "Pending" before being written to the file. The custom format configuration is used to call a formatter to format business data. For example, if the value of an accountability item is generated from the current record based on the template: "Responsible Person: ${Responsible Person} received the accountability item of ${Processing Progress} at ${Accountability Time}", then the user needs to implement a personalized configuration, which generates the result according to the template based on the current record. This configuration, within the custom format configuration, is scheduled by the export execution engine.

[0113] In this embodiment, different configurations of the target column are achieved through three different target column format configuration information.

[0114] In one embodiment, such as Figure 4 As shown, based on the format configuration information of the target column in the exported file, the data of the target column in the temporary exported file is converted to obtain the exported file, including the following steps:

[0115] Step 402: If the format configuration information includes a serial number column configuration, then automatically fill the target column in the temporary exported file with the serial number column data.

[0116] The serial number column configuration is used to automatically populate the data in the serial number column, which increments from 1 based on the row.

[0117] Step 404: If the format configuration information includes code table translation configuration, then the business data of the target column in the temporarily exported file is translated according to the code table.

[0118] The code table translation configuration is used to translate business data based on the code table. For example, there is a code table cljd_codemap: {0: "Pending", 1: "Processing", 2: "Completed"}. If the processing progress is configured to use cljd_codemap for translation, then when the processing progress value is 0, it will be automatically converted to pending before being written to the file.

[0119] Step 406: If the format configuration information includes a custom format configuration, then call the formatter to format the business data of the target column in the temporary export file.

[0120] Custom format configurations are used to invoke a formatter to format business data. For example, if the value of an accountability item is generated from the current record based on the template: "Responsible Person: ${Responsible Person} received the accountability item of ${Processing Progress} at ${Accountability Time}", then the user needs to implement a personalized configuration, which generates the result according to the template based on the current record. This configuration is scheduled by the export execution engine within the custom format configuration. Custom format configurations can also convert business data into corresponding numerical forms.

[0121] In this embodiment, the data of the exported file is processed according to three different format configurations: serial number column configuration, code table translation configuration, and customized format configuration. This greatly simplifies the style configuration and format configuration operations and improves the efficiency of data processing.

[0122] This application provides a data processing method that can be implemented on a terminal, such as a computer, PC, mobile phone, or tablet. Figure 5 As shown, the method includes the following steps:

[0123] Step 502: Obtain the target import data and the format configuration information of the target columns in the import file; wherein, the format configuration information of the target columns in the import file includes title configuration, compliance verification configuration, transcoding table configuration and custom format configuration.

[0124] Step 504: Read the target import data into the import file.

[0125] Step 506: Validate the target column data in the imported file according to the format configuration information of the target column in the imported file.

[0126] It is understandable that importing target data and exporting target data are two independent processes with no necessary connection. The data processing method provided in this application includes both import and export processes. Steps 502 to 506 are the data import processing process, and steps 508 to 520 are the data export processing process.

[0127] Step 508: Obtain the data configuration information for the target exported data, the style information for the exported file, and the format configuration information for the target columns in the exported file. The style information includes the header cell style, the style of each column's cells, the configuration for merged cells, the merge style, and the number of worksheet rows. The format configuration information for the target columns includes at least one of the following: serial number column configuration, decoding table configuration, and custom format configuration.

[0128] Step 510: Determine the export specification interface based on the data configuration information and the target database.

[0129] Step 512: Determine the data entity type to be exported based on the export specification interface.

[0130] Step 514: Filter and export data columns based on data entity type, data configuration information, and target database.

[0131] Step 516: Write the data corresponding to the exported data columns into a temporary export file according to the style information of the exported file.

[0132] Step 518: Based on the format configuration information of the target column in the exported file, convert the data of the target column in the temporary exported file to obtain the exported file.

[0133] Step 520: If the data configuration information of the exported file is a star-level encrypted file, then encrypt the exported file to obtain an encrypted exported file.

[0134] In this embodiment, an export specification interface is determined based on data configuration information and the target database. Based on the export specification interface, the data columns to be exported from the target database are determined. The exported data is processed according to the export file style and the format configuration information of the target columns to obtain an export file that conforms to the style and format configuration information. By abstracting the style and format information into a configurable process, data processing operations are greatly simplified, and data processing efficiency is improved.

[0135] It should be understood that although the steps in the flowcharts of the above embodiments are shown sequentially according to the arrows, these steps are not necessarily executed in the order indicated by the arrows. Unless explicitly stated herein, there is no strict order restriction on the execution of these steps, and they can be executed in other orders. Moreover, at least some steps in the flowcharts of the above embodiments may include multiple steps or multiple stages. These steps or stages are not necessarily completed at the same time, but can be executed at different times. The execution order of these steps or stages is not necessarily sequential, but can be performed alternately or in turn with other steps or at least some of the steps or stages of other steps.

[0136] Based on the same inventive concept, this application also provides a data processing apparatus for implementing the data processing method described above. The solution provided by this apparatus is similar to the implementation scheme described in the above method; therefore, the specific limitations in one or more data processing apparatus embodiments provided below can be found in the limitations of the data processing method described above, and will not be repeated here.

[0137] In one embodiment, such as Figure 6 As shown, a data processing apparatus is provided, comprising: an information acquisition module 602, an export specification interface determination module 604, a data entity type determination module 606, an export data column filtering module 608, a temporary export file writing module 610, and an export file obtaining module 612, wherein:

[0138] The information acquisition module 602 is used to acquire the data configuration information of the target exported data, the style information of the exported file, and the format configuration information of the target column in the exported file.

[0139] The Export Specification Interface Determination Module 604 is used to determine the export specification interface based on the data configuration information and the target database.

[0140] The data entity type determination module 606 is used to determine the data entity type to be exported based on the export specification interface.

[0141] The exported data column filtering module 608 is used to filter and export data columns based on data entity type, data configuration information, and target database.

[0142] The temporary export file writing module 610 is used to write the data corresponding to the exported data columns into a temporary export file according to the style information of the export file.

[0143] The export file module 612 is used to convert the data of the target column in the temporary export file according to the format configuration information of the target column in the export file, so as to obtain the export file.

[0144] In one embodiment, the data processing apparatus further includes an export file encryption module, which is used to encrypt the export file if the data configuration information of the export file is a star-level encrypted file, thereby obtaining an encrypted export file.

[0145] In one embodiment, the data processing apparatus further includes an import data acquisition module, used to acquire target import data and format configuration information of target columns in the import file; wherein, the format configuration information of the target columns in the import file includes header configuration, compliance verification configuration, decoding table configuration, and custom format configuration. The target import data import module is used to read the target import data into the import file. The import file verification module is used to verify the target column data in the import file according to the format configuration information of the target columns in the import file.

[0146] In one embodiment, the temporary export file writing module is used to set the style of the title cell of the temporary export file according to the title cell style in the style information; set the cell style of each column of the temporary export file according to the cell style of each column in the style information; merge the target cells according to the merged cell configuration in the style information to obtain merged cells; set the merged cells according to the merged style in the style information; and automatically divide the worksheet according to the number of worksheet rows in the style information.

[0147] In one embodiment, the file export module is used to automatically fill in the data in the serial number column if the format configuration information includes a serial number column configuration; to translate the business data according to the code table if the format configuration information includes a code table translation configuration; and to call the formatter to format the business data if the format configuration information includes a custom formatting configuration.

[0148] Each module in the aforementioned data processing device can be implemented entirely or partially through software, hardware, or a combination thereof. These modules can be embedded in or independent of the processor in a computer device, or stored in the memory of a computer device as software, so that the processor can call and execute the operations corresponding to each module.

[0149] In one embodiment, a computer device is provided, which may be a terminal, and its internal structure diagram may be as follows: Figure 7 As shown, the computer device includes a processor, memory, communication interface, display screen, and input device connected via a system bus. The processor provides computing and control capabilities. The memory includes non-volatile storage media and internal memory. The non-volatile storage media stores the operating system and computer programs. The internal memory provides an environment for the operation of the operating system and computer programs stored in the non-volatile storage media. The communication interface is used for wired or wireless communication with external terminals; wireless communication can be achieved through Wi-Fi, mobile cellular networks, NFC (Near Field Communication), or other technologies. When the computer program is executed by the processor, it implements a data processing method.

[0150] Those skilled in the art will understand that Figure 7 The structure shown is merely a block diagram of a portion of the structure related to the present application and does not constitute a limitation on the computer device to which the present application is applied. Specific computer devices may include more or fewer components than those shown in the figure, or combine certain components, or have different component arrangements.

[0151] In one embodiment, a computer device is provided, including a memory and a processor, wherein the memory stores a computer program, and the processor executes the computer program to perform the following steps:

[0152] Obtain the data configuration information of the target exported data, the style information of the exported file, and the format configuration information of the target columns in the exported file;

[0153] Based on the data configuration information and the target database, determine the export specification interface;

[0154] Determine the type of data entity to be exported based on the export specification interface;

[0155] Filter and export data columns based on data entity type, data configuration information, and target database;

[0156] Write the data corresponding to the exported data columns into a temporary export file according to the style information of the exported file.

[0157] Based on the format configuration information of the target column in the exported file, the data in the target column of the temporary exported file is converted to obtain the exported file.

[0158] In one embodiment, the processor, when executing a computer program, also performs the following steps:

[0159] If the data configuration information includes a star-rating encrypted file, then the exported file will be encrypted to obtain an encrypted exported file.

[0160] In one embodiment, the processor, when executing a computer program, also performs the following steps:

[0161] Obtain the target import data and the format configuration information of the target columns in the import file; wherein, the format configuration information of the target columns in the import file includes at least one of the following: title configuration, compliance verification configuration, transcoding table configuration, and custom format configuration; read the target import data into the import file; and verify the target column data in the import file according to the format configuration information of the target columns in the import file.

[0162] In one embodiment, the processor, when executing a computer program, also performs the following steps:

[0163] The data corresponding to the exported data columns is loaded into a temporary export file; the style of the header cell in the temporary export file is set according to the header cell style in the style information; the cell style of each column in the temporary export file is set according to the cell style of each column in the style information; the target cells in the temporary export file are merged according to the merge cell configuration in the style information to obtain merged cells; the merged cells are set according to the merge style in the style information; and the worksheet of the temporary export file is automatically divided according to the number of worksheet rows in the style information.

[0164] In one embodiment, the processor, when executing a computer program, also performs the following steps:

[0165] The target column's format configuration information includes at least one of the following: serial number column configuration, decoding table configuration, and custom format configuration.

[0166] In one embodiment, the processor, when executing a computer program, also performs the following steps:

[0167] If the format configuration information includes a serial number column configuration, the serial number column data in the target column of the temporary export file will be automatically filled. If the format configuration information includes a code table translation configuration, the business data in the target column of the temporary export file will be translated according to the code table. If the format configuration information includes a custom formatting configuration, the formatter will be called to format the business data in the target column of the temporary export file.

[0168] In one embodiment, a computer-readable storage medium is provided having a computer program stored thereon, the computer program performing the following steps when executed by a processor:

[0169] Obtain the data configuration information of the target exported data, the style information of the exported file, and the format configuration information of the target columns in the exported file;

[0170] Based on the data configuration information and the target database, determine the export specification interface;

[0171] Determine the type of data entity to be exported based on the export specification interface;

[0172] Filter and export data columns based on data entity type, data configuration information, and target database;

[0173] Write the data corresponding to the exported data columns into a temporary export file according to the style information of the exported file.

[0174] Based on the format configuration information of the target column in the exported file, the data in the target column of the temporary exported file is converted to obtain the exported file.

[0175] In one embodiment, when the computer program is executed by a processor, it also performs the following steps:

[0176] If the data configuration information includes a star-rating encrypted file, then the exported file will be encrypted to obtain an encrypted exported file.

[0177] In one embodiment, when the computer program is executed by a processor, it also performs the following steps:

[0178] Obtain the target import data and the format configuration information of the target columns in the import file; wherein, the format configuration information of the target columns in the import file includes at least one of the following: title configuration, compliance verification configuration, transcoding table configuration, and custom format configuration; read the target import data into the import file; and verify the target column data in the import file according to the format configuration information of the target columns in the import file.

[0179] In one embodiment, when the computer program is executed by a processor, it also performs the following steps:

[0180] The data corresponding to the exported data columns is loaded into a temporary export file; the style of the header cell in the temporary export file is set according to the header cell style in the style information; the cell style of each column in the temporary export file is set according to the cell style of each column in the style information; the target cells in the temporary export file are merged according to the merge cell configuration in the style information to obtain merged cells; the merged cells are set according to the merge style in the style information; and the worksheet of the temporary export file is automatically divided according to the number of worksheet rows in the style information.

[0181] In one embodiment, when the computer program is executed by a processor, it also performs the following steps:

[0182] The target column's format configuration information includes at least one of the following: serial number column configuration, decoding table configuration, and custom format configuration.

[0183] In one embodiment, when the computer program is executed by a processor, it also performs the following steps:

[0184] If the format configuration information includes a serial number column configuration, the serial number column data in the target column of the temporary export file will be automatically filled. If the format configuration information includes a code table translation configuration, the business data in the target column of the temporary export file will be translated according to the code table. If the format configuration information includes a custom formatting configuration, the formatter will be called to format the business data in the target column of the temporary export file.

[0185] In one embodiment, a computer program product is provided, including a computer program that, when executed by a processor, performs the following steps:

[0186] Obtain the data configuration information of the target exported data, the style information of the exported file, and the format configuration information of the target columns in the exported file;

[0187] Based on the data configuration information and the target database, determine the export specification interface;

[0188] Determine the type of data entity to be exported based on the export specification interface;

[0189] Filter and export data columns based on data entity type, data configuration information, and target database;

[0190] Write the data corresponding to the exported data columns into a temporary export file according to the style information of the exported file.

[0191] Based on the format configuration information of the target column in the exported file, the data in the target column of the temporary exported file is converted to obtain the exported file.

[0192] In one embodiment, when the computer program is executed by a processor, it also performs the following steps:

[0193] If the data configuration information includes a star-rating encrypted file, then the exported file will be encrypted to obtain an encrypted exported file.

[0194] In one embodiment, when the computer program is executed by a processor, it also performs the following steps:

[0195] Obtain the target import data and the format configuration information of the target columns in the import file; wherein, the format configuration information of the target columns in the import file includes at least one of the following: title configuration, compliance verification configuration, transcoding table configuration, and custom format configuration; read the target import data into the import file; and verify the target column data in the import file according to the format configuration information of the target columns in the import file.

[0196] In one embodiment, when the computer program is executed by a processor, it also performs the following steps:

[0197] The data corresponding to the exported data columns is loaded into a temporary export file; the style of the header cell in the temporary export file is set according to the header cell style in the style information; the cell style of each column in the temporary export file is set according to the cell style of each column in the style information; the target cells in the temporary export file are merged according to the merge cell configuration in the style information to obtain merged cells; the merged cells are set according to the merge style in the style information; and the worksheet of the temporary export file is automatically divided according to the number of worksheet rows in the style information.

[0198] In one embodiment, when the computer program is executed by a processor, it also performs the following steps:

[0199] The target column's format configuration information includes at least one of the following: serial number column configuration, decoding table configuration, and custom format configuration.

[0200] In one embodiment, when the computer program is executed by a processor, it also performs the following steps:

[0201] If the format configuration information includes a serial number column configuration, the serial number column data in the target column of the temporary export file will be automatically filled. If the format configuration information includes a code table translation configuration, the business data in the target column of the temporary export file will be translated according to the code table. If the format configuration information includes a custom formatting configuration, the formatter will be called to format the business data in the target column of the temporary export file.

[0202] Those skilled in the art will understand that all or part of the processes in the methods of the above embodiments can be implemented by a computer program instructing related hardware. The computer program can be stored in a non-volatile computer-readable storage medium, and when executed, it can include the processes of the embodiments of the above methods. Any references to memory, databases, or other media used in the embodiments provided in this application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetic random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM). The databases involved in the embodiments provided in this application may include at least one type of relational database and non-relational database. Non-relational databases may include, but are not limited to, blockchain-based distributed databases. The processors involved in the embodiments provided in this application may be general-purpose processors, central processing units, graphics processing units, digital signal processors, programmable logic devices, quantum computing-based data processing logic devices, etc., and are not limited to these.

[0203] The technical features of the above embodiments can be combined in any way. For the sake of brevity, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0204] The embodiments described above are merely illustrative of several implementation methods of this application, and while the descriptions are specific and detailed, they should not be construed as limiting the scope of this patent application. It should be noted that those skilled in the art can make various modifications and improvements without departing from the concept of this application, and these all fall within the protection scope of this application. Therefore, the protection scope of this application should be determined by the appended claims.

Claims

1. A data processing method, characterized by, The method comprises: obtaining data configuration information of target export data, style information of an export file, and format configuration information of target columns in the export file; determining an export specification interface according to the data configuration information and a target database; determining a data entity type to be exported according to the export specification interface; screening export data columns according to the data entity type, the data configuration information, and the target database; writing data corresponding to the export data columns into a temporary export file according to the style information of the export file; wherein the writing of the data corresponding to the export data columns into the temporary export file according to the style information of the export file comprises: writing the data corresponding to the export data columns into the temporary export file; setting a style of a title cell of the temporary export file according to a title cell style in the style information; setting a cell style of each column of the temporary export file according to each column cell style in the style information; merging target cells of the temporary export file according to a merged cell configuration in the style information to obtain merged cells; setting the merged cells according to a merged style in the style information; automatically dividing worksheets of the temporary export file according to a number of worksheets in the style information; converting data of target columns in the temporary export file according to format configuration information of the target columns in the export file to obtain an export file; wherein the conversion of the data of the target columns in the temporary export file according to the format configuration information of the target columns in the export file to obtain the export file comprises: if the format configuration information includes sequence number column configuration, automatically filling the data of the sequence number column in the target columns of the temporary export file; if the format configuration information includes code table translation configuration, translating business data of the target columns in the temporary export file according to a code table; if the format configuration information includes customized formatting configuration, calling a formatter to format the business data of the target columns in the temporary export file. The method further comprises: obtaining target import data and format configuration information of target columns in an import file; wherein the format configuration information of the target columns in the import file includes at least one of title configuration, compliance verification configuration, translation code table configuration, and customized format configuration; reading the target import data into the import file; verifying target column data in the import file according to the format configuration information of the target columns in the import file.

2. The method of claim 1, wherein, The method further comprises: if the data configuration information includes a star-level encrypted file, encrypting the export file to obtain an encrypted export file.

3. The method of claim 1, wherein, The format configuration information of the target columns includes at least one of sequence number column configuration, translation code table configuration, and customized format configuration.

4. A data processing apparatus, characterized by, The apparatus comprises: an information obtaining module configured to obtain data configuration information of target export data, style information of an export file, and format configuration information of target columns in the export file; The device further comprises: The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. 5.A computer device, comprising a memory and a processor, wherein the memory stores a computer program, and the computer device is configured to perform the method according to any one of claims 1-4 when the computer program is executed by the processor. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3.

6. A computer-readable storage medium having stored thereon a computer program, characterized in that, The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3.

7. A computer program product comprising a computer program, characterized in that, The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 3. The processor executes

Images