CN113268967A

CN113268967A - Method and equipment for processing data information

Info

Publication number: CN113268967A
Application number: CN202011090629.1A
Authority: CN
Inventors: 郑思林
Original assignee: Shanghai Youyun Information Technology Co ltd
Current assignee: Shanghai Youyun Information Technology Co ltd
Priority date: 2020-10-13
Filing date: 2020-10-13
Publication date: 2021-08-17
Anticipated expiration: 2040-10-13
Also published as: CN113268967B

Abstract

The application aims to provide a method and equipment for processing data information, and the method comprises the following steps: acquiring first data information to be exported, and performing first operation on the first data information to generate second data information; performing a second operation on each piece of the second data information to generate third data information; performing third operation on each piece of data information in the third data information according to a preset format template to generate a candidate Excel template; and analyzing the candidate Excel template according to the parameter information corresponding to the preset format template, and exporting the analyzed candidate Excel template to generate a target Excel file. The data can be quickly and effectively sorted, and the user can conveniently look up the data.

Description

Method and equipment for processing data information

Technical Field

The present application relates to the field of communications, and more particularly, to a technique for processing data information.

Background

The human beings have the requirement of processing data from old times, the higher the civilization degree is, the more and more complex the data need to be processed, and the higher the requirement on processing, the higher the speed still must be. Therefore, we are constantly improving the tools that are used to fulfill data processing needs. When the information age is coming, we frequently deal with data, and Excel is produced accordingly. Excel is one of the most common software in daily office nowadays, and is especially necessary for viewing data reports, so that most users have a requirement for viewing data by Excel.

Disclosure of Invention

An object of the present application is to provide a method and apparatus for processing data information.

According to an aspect of the present application, there is provided a method for processing data information, the method comprising:

acquiring first data information to be exported, and performing first operation on the first data information to generate second data information;

performing a second operation on each piece of the second data information to generate third data information, wherein the second operation comprises a data formatting operation;

performing third operation on each piece of data information in the third data information according to a preset format template to generate a candidate Excel template, wherein the third operation comprises data assembly on each piece of data information according to the preset format template;

and analyzing the candidate Excel template according to the parameter information corresponding to the preset format template, and exporting the analyzed candidate Excel template to generate a target Excel file.

According to an aspect of the present application, there is provided a network device for processing data information, the device comprising:

the system comprises a one-to-one module, a first data processing module and a second data processing module, wherein the one-to-one module is used for acquiring first data information to be exported and carrying out first operation on the first data information to generate second data information;

a second module, configured to perform a second operation on each piece of the second data information to generate third data information, where the second operation includes a data formatting operation;

a third module, configured to perform a third operation on each piece of data information in the third data information according to a preset format template, so as to generate a candidate Excel template, where the third operation includes performing data assembly on each piece of data information according to the preset format template;

and the four modules are used for analyzing the candidate Excel template according to the parameter information corresponding to the preset format template and exporting the analyzed candidate Excel template to generate a target Excel file.

According to an aspect of the present application, there is provided an apparatus for processing data information, the apparatus comprising:

a processor; and

a memory arranged to store computer executable instructions that, when executed, cause the processor to perform the operations of any of the methods described above.

According to another aspect of the application, there is provided a computer readable medium storing instructions that, when executed, cause a system to perform the operations of any of the methods described above.

Compared with the prior art, after the network equipment acquires the first data information, the first operation, the second operation and the third operation are sequentially carried out on the first data information, the template related to the data information is assembled in the third operation, and then the target Excel file is generated according to the parameters of the corresponding template, wherein the data displayed in the target Excel file is not simply exported but is normalized and structured data information, so that the user can conveniently and subsequently consult the data information, the use experience of the user is improved, and the data is reasonably layered and abstracted, so that the data type can be quickly expanded and newly defined, or the new characteristic of expansion adaptation Excel is improved, therefore, various complex data information can be effectively dealt with, and the data information is stored and displayed in the form of Excel.

Drawings

Other features, objects and advantages of the present application will become more apparent upon reading of the following detailed description of non-limiting embodiments thereof, made with reference to the accompanying drawings in which:

FIG. 1 illustrates a system topology according to the present application;

FIG. 2 illustrates a flow diagram of a method for processing data information according to another embodiment of the present application;

FIG. 3 shows a schematic diagram for processing data information according to another embodiment of the present application;

FIG. 4 shows a flow diagram of a method for processing data information according to yet another embodiment of the present application;

FIG. 5 illustrates an apparatus diagram of a network device for processing data information according to one embodiment of the present application;

FIG. 6 illustrates an exemplary system that can be used to implement the various embodiments described in this disclosure.

The same or similar reference numbers in the drawings identify the same or similar elements.

Detailed Description

The present application is described in further detail below with reference to the attached figures.

In a typical configuration of the present application, the terminal, the device serving the network, and the trusted party each include one or more processors (CPUs), input/output interfaces, network interfaces, and memory.

The memory may include forms of volatile memory in a computer readable medium, Random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of a computer-readable medium.

Computer-readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), Digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device.

The device referred to in this application includes, but is not limited to, a user device, a network device, or a device formed by integrating a user device and a network device through a network. The user equipment includes, but is not limited to, any mobile electronic product, such as a smart phone, a tablet computer, etc., capable of performing human-computer interaction with a user (e.g., human-computer interaction through a touch panel), and the mobile electronic product may employ any operating system, such as an android operating system, an iOS operating system, etc. The network device includes an electronic device capable of automatically performing numerical calculation and information processing according to a preset or stored instruction, and hardware thereof includes, but is not limited to, a microprocessor, an Application Specific Integrated Circuit (ASIC), a Programmable Logic Device (PLD), a Field Programmable Gate Array (FPGA), a Digital Signal Processor (DSP), an embedded device, and the like. The network device includes but is not limited to a computer, a network host, a single network server, a plurality of network server sets or a cloud of a plurality of servers; here, the Cloud is composed of a large number of computers or web servers based on Cloud Computing (Cloud Computing), which is a kind of distributed Computing, one virtual supercomputer consisting of a collection of loosely coupled computers. Including, but not limited to, the internet, a wide area network, a metropolitan area network, a local area network, a VPN network, a wireless Ad Hoc network (Ad Hoc network), etc. Preferably, the device may also be a program running on the user device, the network device, or a device formed by integrating the user device and the network device, the touch terminal, or the network device and the touch terminal through a network.

Of course, those skilled in the art will appreciate that the foregoing is by way of example only, and that other existing or future devices, which may be suitable for use in the present application, are also encompassed within the scope of the present application and are hereby incorporated by reference.

In the description of the present application, "a plurality" means two or more unless specifically limited otherwise.

Fig. 1 shows a typical scenario of the present application, where a user holds a user device, the user device has a communication module therein, the user device establishes a communication connection with a corresponding network device in a wired or wireless manner, and based on the communication connection, the network device receives data information sent by the user device, where the data information includes candidate infringement information acquired by the user, and the candidate infringement information includes, but is not limited to, image information taken by the user, infringement description information filled by the user, and web address information submitted by the user. The network device determines a candidate infringement clue acquired by the user according to the data information, and uses the candidate infringement clue as first data information (for example, the network device analyzes an infringement phenomenon existing in the candidate infringement information and generates a candidate infringement clue based on the infringement phenomenon), for example, a candidate infringement clue A, and the candidate infringement clue A corresponds to an infringing subject 1 and registration information 1; the candidate infringing cue a may also correspond to the infringing entity 2 and the registration information 2. The network device performs a first operation on the first data information, for example, if there are multiple data information of an array or a corresponding relationship in the first data information, the multiple data information are associated using a JSON format:

further, the network device performs the second operation again, for example, formats the registration amount in the registration information to a presentation format of a uniform amount, and formats the address in the registration information to a uniform format (for example, XX in XX district XX number in XX city), and parses the data information in JSON format into a corresponding array form, for example, var thread a [ "infringement subject 1", "registration information 1" ], var thread a [ "infringement subject 2", "registration information 2" ]; further, the network device performs the third operation again, and the network device performs the third operation according to the preset format template, the data information that undergoes the second operation is assembled, e.g., with one thread (candidate infringement thread a) as a row, this line is abstracted to an SRD (single rowdata, row data template), which corresponds to two infringing subjects (infringing subject 1, infringing subject 2), for which the MRSD (multirowsingedata, multi-row data template format) is assembled separately, the clue corresponds to a plurality of intellectual property (intellectual property) images (such as cucurbit dolls IP and black cat chief IP), the network device assembles the two IPs into MCSD (multicell single data, multi-column data template format), and further, the network device assembles the clue, two infringing bodies and the names corresponding to the intellectual property IP images into HRD (header row data, head row template); finally, the network device analyzes each assembled template, each assembled data is sequentially analyzed when the assembled templates are analyzed, each assembled data is sequentially analyzed and can be mapped to Excel row by row, the network device performs cell merging on other data which only occupy one row and exist in the MRSD template, performs cell merging on other data which only occupy one column and exist in the MCSD template, and then generates a target Excel for storing data information, and the target Excel can be sent to a user for displaying, as shown in table 1.

TABLE 1

Fig. 2 shows a method for processing data information according to an embodiment of the present application, the method comprising step S101, step S102, step S103 and step S104.

Specifically, in step S101, the network device acquires first data information to be derived, and performs a first operation on the first data information to generate second data information. For example, the present application can be applied to a plurality of fields, and in the case of generating data information in each field, if unstructured data information needs to be output as structured data presented in an Excel format, the technical solution of the present application can be applied.

In some embodiments, the first data information is determined from data generated by at least any one of the following stages:

1) a thread collection stage;

2) a stage of evidence notarization;

3) a lawyer invitation phase;

4) litigation stage;

5) and settlement stage. In some embodiments, there is a relevant platform to handle one or more infringement cases, and correspondingly, there is a corresponding user requirement: the data generated during each stage of processing the one or more infringing cases is structurally output, for example, exported to form an Excel file so that subsequent related personnel (e.g., attorneys, obliques) can review the Excel file at any time. In the process of handling one or more infringement cases, there are a number of stages in which data is generated. For example, in the cable collection phase, the first data information that is retrievable by the network device includes information of the cable (e.g., evidence that may be used to determine the existence of infringement facts by one or more infringing subjects, etc.), information of one or more infringing subjects (including addresses, names, registered capital, etc.), image information of the cable, etc.; in the notarization stage, the first data information available to the network device includes one or more notarization, notarization materials, notarization time, notarization expenses, and the like; in the attorney invitation phase, the first data information available to the network device comprises attorney classification information, attorney information, law institute information and the like; in the litigation stage, the first data information which can be acquired by the network equipment comprises complaint information, plan information, payment information, court settlement information and the like; the first data information available to the network device during the settlement stage includes settlement information, as well as separation information and the like. The network device conducts data processing on the data information of each stage to export the data information into an Excel file which is easy to review, and the data information can be conveniently presented in a normalized and structured mode. In some embodiments, all data is information surrounding or generated during the case progress, and the stage is just splitting the data, and the data actually belongs to the whole case. The stages here are just data classified into categories according to the case development process. The first data of the different phases can be considered to be of a uniform level. In some embodiments, the obtaining first data information to be derived comprises at least any one of:

1) querying from a database to obtain first data information to be derived;

2) sending a data acquisition request to a target network, and receiving first data information returned by the target website based on the data acquisition request;

3) receiving first data information to be exported uploaded by a user; for example, the obtaining manner of the first data information may have multiple choices, so that the selection of the source information is wider, in some embodiments, the network device may query from the database to obtain the first data information to be derived (for example, there is an infringing case processing platform, and the database corresponding to the platform stores the data information of each stage), for example, the network device may query data from the relational database through SQL, and perform simple processing, such as null data filling and simple data filtering; for example, the network device may perform file search, obtain and receive search result information returned by a target website based on a data search request by sending the data acquisition request to the specific or unspecified target website through a crawler technology, and use the search result as first data information, where the first data information includes one or more web page links associated with a keyword set by the network device and data content corresponding to the one or more web page links; for example, the network device receives data information uploaded by one or more users, and uses the data information as first data information to be exported, for example, the data information is obtained by the network device automatically or manually and actively, and the first data information obtained by the network device is stored in the network device according to a predetermined arrangement rule for subsequent processing by the network device (for example, the data are arranged in order according to a form before obtaining), and on the basis of obtaining the first data information through multiple channels, a basis is provided for subsequently presenting the first data information in the form of an Excel file. In some embodiments, said performing a first operation on said first data information to generate second data information comprises: if at least two data with corresponding relations exist in the first data information, performing a first operation on the at least two data with corresponding relations to generate second data information, wherein the first operation comprises associating the at least two data with corresponding relations in a first preset format. In some scenarios (such as database query), only simple string concatenation can be performed, so it is not convenient to parse data into a data format in a high-level language in the first operation (the format here refers to an array, an object, and a specific object may have many forms, such as a time object, a picture object, and the like). Therefore, only the most original splicing, namely character string splicing, is performed in the first step, and the spliced character string is spliced into a JSON character string, so that a basis is provided for subsequent data analysis. The first preset format includes JSON, XML, YAML and other formats, and the three formats may be mutually converted, where the most common JSON is taken as an example, for example, the first data information includes complex data, data in multiple forms (e.g., numbers, character strings, JSON format data, binary streams and the like) exist in the complex data, and since part of the data may be arrays or there is a correspondence between data, the data with the correspondence may be associated using the JSON format at this time, and it is ensured that the correspondence between the data can be recovered subsequently, thereby ensuring that the data in the JSON format exists in the second data information, and ensuring the association of the data. For example, the first data information is determined by the data generated in the thread collection stage, the first data information includes one thread information for determining whether there is infringement fact, the thread may involve multiple infringing subjects, wherein the infringing subject only contains two attributes of name and registered capital, and JSON can be used to guarantee the correspondence of registered capital and name, for example, thread a has two infringing subjects, which are (infringing subject 1, registered capital 1) and (infringing subject 2, registered capital 2), respectively, and the corresponding JSON data format is as follows:

it will be understood by those skilled in the art that the JSON data format described above is merely exemplary, and that other existing or future data formats may be used, as applicable, and are intended to be encompassed within the scope of the present application and are hereby incorporated by reference.

In step S102, the network device performs a second operation on each piece of the second data information to generate third data information, where the second operation includes a data formatting operation. In some embodiments, the method further includes step S105 (not shown), in step S105, the network device determines first data type information of each piece of the second data information; in step S102, the network device determines, according to the first data type information, a second operation corresponding to each piece of corresponding data information; and executing corresponding second operation on each piece of data information to generate third data information, wherein the second operation comprises data formatting operation corresponding to the first data type information in different assignments. In some embodiments, the data formatting operation comprises at least any one of:

1) formatting the amount information to add a quartile;

2) formatting the time information into a uniform time format;

3) formatting the address information;

4) asynchronously loading network resource information in batch;

5) formatting data information represented in a first preset format; the data formatting operation is configured to process each piece of data information in the second data information into data of a preset type, where for example, the first data type information includes an amount of money (e.g., < 30 >, a date (e.g., 2014.06.06), JSON format data, an address (B-ward, B-city, B-district), a picture, a file, and the like. Corresponding to different first data type information, the network device performs corresponding data formatting operation on the data information corresponding to each first data type information, for example. For the data information of the amount type, adding a decimal place to the amount data (for example, the original amount data is 1890, and the amount data after the data formatting operation is 1,890.00); unifying the format of the time data (for example, the original time information is 6:00pm, the time after the unified format is 24 hours, 18: 00); for address data, the address is subjected to unified format (for example, original address data in a B district, province, city, B and further refined to a house number, for example, a house number B in the B district, province, city, B and city); for example, pictures or files exist in a network resource form such as picture links and file links, and the network equipment acquires picture information in an asynchronous batch loading mode, so that the loading time of the pictures is shortened as much as possible, data information existing in a data format of the pictures is acquired, and the acquisition efficiency of the pictures is improved; and corresponding to different first data type information, the network equipment adopts different data formatting operations, and takes the second data information subjected to the formatting operations as third data information, so that the presentation form is more standardized when the subsequent data is generated into an Excel file. In some embodiments, in step S102, if the assignment of the first data type information is the first preset format, a second operation is performed on the data information associated with the first preset format in the second data information, where the second operation includes performing an analysis operation on the data information associated with the first preset format and performing a formatting operation on the data information represented in the first preset format after the analysis operation. The first preset format includes JSON, XML, YAML, and the like, and the three formats may be converted to each other, where the most common JSON is taken as an example, for example, the first data type information is a variable, and different data processing manners corresponding to different assignments are also different, if the first data type information includes JSON, the network device determines the data information corresponding to the JSON, and performs array batch analysis on the data information, so as to guarantee a data correspondence as much as possible, and after an analyzed array is obtained, performs data formatting on the analyzed data, where the data formatting includes, but is not limited to, a formatting amount, a formatting date, a formatting address, and the like.

In step S103, the network device performs a third operation on each piece of data information in the third data information according to a preset format template to generate a candidate Excel template, where the third operation includes performing data assembly on each piece of data information according to the preset format template. The preset format template includes a template used by the network device by default or a template designated by the user (the designation here means that there may be a plurality of preset format templates from which the user can select). In some embodiments, in step S103, the network device determines a preset format template according to the derivation requirement information; and performing third operation on each piece of data information in the third data information according to the preset format template to generate a candidate Excel template, wherein the third operation comprises assembling the third data information into a multi-row data template format, a multi-column data template format or a single-data multi-cell template format. For example, the derived requirement information includes the format of data representation in subsequent Excel desired by the user, including but not limited to cell hyperlink, cell insert picture, cell merge, row width, cell coloring, and the like. The network equipment determines a template from a template database according to export demand information predetermined by a user or generates a template with a preset format determined according to the demand information, so that the subsequently generated Excel file is more in line with the demand of the user.

In some embodiments, the preset format template is used for storing the corresponding relationship between data and cells and the attribute information of the cells. For example, the preset format template is used for assembling data information for the purpose of subsequently generating an Excel file, and the format of the Excel file can be defined in the preset format template by a user, so that the subsequently output Excel file is presented in a format required by the user. For example, the preset format template includes a DC (data cell, cell site template), where the DC is a minimum cell, and may be considered as information of an Excel cell, and the DC includes a font, a font size, a displayed data content, a hyperlink, and the like; the default format template includes a SD (single data) which is an abstract concept and includes one or more DCs, in other words, the SD is composed of the minimum unit DC. In some embodiments, the multiple-row data template format or the multiple-column data template format includes a plurality of cell bit templates; the single data multiple cell template format includes a cell bit template. The multi-row data template format, the multi-column data template format and the single-data multi-cell template format are specific format forms of unit data. So that SD can simultaneously abstract representatives of DC, MRSD, SDD, and MCSD. The SD takes MRSD (multi-row data template format), MCSD (multi-column data template format) and SSD (SimpleSingleData, single data and multi-cell template format) as specific template formats, wherein the SSD contains one DC, and the MRSD and the MCSD contain a plurality of DCs, namely the SSD contains one data, and the MRSD and the MCSD contain a plurality of data; the preset format template includes SR (single row template), where SR is an abstract concept used for abstract representation of a row of data and takes HRD (head row template) and SRD (row data template) as concrete template formats, and the HRD and SRD respectively include multiple SDs. And on the basis of determining the preset format template, providing a basis for the subsequent template assembly of the data. In some embodiments, determining second data type information for each of the third data information; if the second data type information comprises an array type, performing third operation on data information corresponding to the second data type information to assemble the data information into a multi-row data template format or a multi-column data template format, wherein the third operation comprises performing data assembly on the data information by using the multi-row data template or the multi-column data template; otherwise, performing a third operation on the data information corresponding to the second data type information to assemble the data information into a single-data multi-cell template format, wherein the third operation comprises performing data assembly on the data information by using a single-data multi-cell template; and generating candidate Excel templates by using the data information assembled into a multi-row data template format or a multi-column data template format and the data information assembled into a single-data multi-cell template format. In some embodiments, the SD comprises an array or single data (more complex data may be disassembled or combined into single data after a first operation) wherein one data is included, and the MRSD and MCSD comprise multiple data (e.g., arrays). For example, taking an infringing case information as an example, one case is a row (one row is abstracted to be SRD, and corresponds to multiple Excel rows due to the fact that part of data may have row-column combination), the name of the case only has one data, so that SSD can be used for data assembly, one case corresponds to multiple infringing subjects (infringing subject 1, infringing subject 2, infringing subject 3), the name of the infringing subject can be used for data assembly by MRSD, and one case corresponds to multiple IPs (IP image 1, IP image 2, IP image 3), so that MCSD can be used for data assembly. In some embodiments, the generating a candidate Excel template from the data information assembled into a multi-row data template format or a multi-column data template format and the data information assembled into a single-data multi-cell template format includes:

grouping data information assembled into a multi-row data template format or a multi-column data template format and data information assembled into a single data multi-cell template format in rows to generate a header row template and a row data template, wherein the header row template comprises at least one piece of data information assembled into the single data multi-cell template format, and the row data template comprises at least one piece of data information assembled into the multi-row data template format or the multi-column data template format and data information assembled into the single data multi-cell template format; and assembling the header row template and the row data template, and generating a candidate Excel template by using the data information obtained by assembling. Wherein, because there may be a row-column combination in part of the data, the grouping by row includes grouping by one or more rows, name information (e.g., infringement subject, case number, registered capital, etc.) for representing or summarizing each data is generally stored in a header row template, the name information includes one data, SSD may represent one data, i.e., one DC, where the header row template includes at least one SSD; the row data template may be used to store one or more data of various types, one data may exist in the row data template, the SSD may represent one data, i.e., one DC, or data occupying multiple rows or multiple columns, which may be represented by the MRSD and the MCSD, where both the MRSD and the MCSD include multiple data, i.e., multiple DCs. In some embodiments, if there is an MRSD or MCSD type in the preset format template, the current column maximum width needs to be recorded in the HRD, and the current row maximum height needs to be recorded in the SRD. Here, the data information is assembled from small to large (for example, the assembly template is sequentially assembled from DC-SD-SR), each data can be assembled in a hierarchical and non-exhaustive manner, and the Excel generated subsequently is sequentially analyzed.

In step S104, the network device analyzes the candidate Excel template according to the parameter information corresponding to the preset format template, and exports the analyzed candidate Excel template to generate a target Excel file. For example, when the third data information is assembled, the third data information is assembled from small to large according to an assembly template of DC-SD-SR in sequence, when the target Excel is generated through analysis, the third data information is analyzed from large to small according to the sequence of SR-SD-DC, and the third data information is analyzed according to the sequence, the assembled data is a group of sequential data, and the sequential data can be mapped to the Excel line by line through one-by-one analysis, so that the Excel is generated. The parameter information mainly includes a unit row height and a unit column height. In some embodiments, in step S104, if the preset format template includes the header line template and the line data template, the network device analyzes the candidate Excel template according to the parameter information of the header line template and the parameter information of the line data template, and exports the analyzed candidate Excel template to generate a target Excel file. In some embodiments, Excel is assembled by SR, each SR corresponds to one cell line (the cell line may be composed of multiple lines) in Excel, when the candidate Excel template is analyzed, SR analysis is performed first, since the specific template format form of SR includes HRD and SRD, the network device analyzes according to the parameter information of HRD and the parameter information of SRD, and on the basis of analyzing each cell line preferentially, a basis is provided for subsequently analyzing each template-assembled data in the cell line. In some embodiments, the analyzing the candidate Excel template according to the parameter information of the header row template and the parameter information of the row data template, and exporting the analyzed candidate Excel template to generate a target Excel file includes: detecting whether the parameter information assembled into a multi-column data template format exists in the parameter information of the header row template of the candidate Excel template, and if so, merging cell columns according to the unit column width of the multi-column data template format; detecting whether the data information assembled into a multi-row data template format or the data information assembled into a multi-column data template format exists in a row data template of the candidate Excel file, if so, merging cell rows according to the unit row width of the multi-row data template format, and if so, merging cell columns according to the unit column width of the multi-column data template format; exporting the candidate Excel template subjected to the merging processing to generate a target Excel file. For example, the parameter information assembled into the multi-column data template format includes the largest MCSD in a unit column, when the network device parses the HRD to generate the target Excel, it is predetermined whether the MCSD exists in the current column, and if so, cells need to be merged in advance when parsing the HRD, where the number of merged cell columns is determined by the largest MCSD in the current unit column, for example, a MCSD with 3 columns is obtained when parsing the HRD, where the width of the unit column is 3, and the HRD corresponding to the MCSD performs header cell column merging during parsing, and the merging number is 3; for example, when the SRD is analyzed to generate the target Excel, whether the MRSD and the MCSD exist in the current column or row is determined in advance, if so, the cells need to be merged in advance when the SRD is analyzed, wherein the number of merged cell columns is determined by the maximum MCSD in the current cell column, the number of merged cell rows is determined by the maximum MRSD in the current cell column, for example, there is one case number, but there are three infringement body names (MRSDs), and then other unit data (for example, case numbers) occupying one row need to be merged, so that the same unit row with the case number and the three infringement bodies can be obtained. When the SR (including the HRD and the SRD) is analyzed, the MCSD and the MRSD are further analyzed, and the analysis rate and the normalization can be maintained. In some embodiments, exporting the candidate Excel template subjected to the above merging process to generate a target Excel file includes: determining attribute information of each cell position template in the candidate Excel templates subjected to cell column combination and/or cell row combination; and executing corresponding target operation on each cell site template according to the attribute information of each cell site template, and exporting to generate the target Excel file. For example, the attribute information of each cell site template includes a style (e.g., font, color, center) and a data form (e.g., picture, hyperlink, text), and in some embodiments, the target operation includes at least any one of:

setting a hyperlink;

inserting pictures;

setting a cell style;

setting a cell text; for example, different target operations exist corresponding to different attribute information, so that each analyzed DC meets the display requirement in Excel set by a user. The format of each cell site template (DC) is not consistent, and when parsing each DC, the network device performs corresponding operations according to different attribute information, for example, the attribute information of a DC includes: font song style, color red, center set to this DC set up cell text to satisfy font song style, color red, center set. And on the premise of finally analyzing each DC, completing the generation of the target Excel file.

For example, as shown in fig. 3, the network device acquires first data information to be derived from a database, where the first data information includes a thread number, infringement information (e.g., an infringement picture, etc.), and related information of an infringer, and associates the associated information in the first data in a JSON format to generate second data information, where, for example, the JSON format is as follows:

then, the network device performs the second operation again, formats each data in the second data information to generate third data, for example, acquires an infringement picture from the network resource through asynchronous batch loading; and thirdly, performing data assembly on each piece of data in the third data, for example, an entire line corresponding to '6909' is assembled by using an SRD, data under the thread number of '6909', 'thread remark', 'case state', 'infringement subject', 'infringement behavior' and 'organization form' are assembled by using an HRD, data under the thread number of '6909', 'thread remark', 'case state' and the like are assembled by using an SSD, an infringement picture is assembled by using an MCSD, data users MRSD under the 'infringement subject', 'infringement behavior' and 'organization form' are assembled, and finally, the network device analyzes the assembled third data information and outputs Excel, for example, it is determined that cell column merging is needed when the HRD is analyzed, and cell row and column merging is needed when the SRD is analyzed. It will be understood by those skilled in the art that the above JSON is merely exemplary and that other existing or future secondary data information, as applicable to the present application, is also included within the scope of the present application and is hereby incorporated by reference.

Fig. 4 shows a flowchart of a method for processing data information according to another embodiment of the present application, which is mainly divided into four abstraction layers, namely a data acquisition layer, a data formatting layer, a template assembly layer, and an Excel generation layer, and each layer can dynamically expand export requirements for processing data in different formats and Excel in different formats. The invention mainly comprises the following steps: firstly, acquiring data from a data storage system and carrying out primary assembly; secondly, formatting the original data; thirdly, exporting template assembly is carried out on the data according to the format of the Excel to be exported; and fourthly, analyzing the exported template, and generating an Excel file according to the parameters given by the template.

Fig. 5 shows a network device for processing data information according to an embodiment of the present application, which includes a one-to-one module 101, a two-to-two module 102, a three-to-three module 103, and a four-to-four module 104.

Specifically, the one-to-one module 101 is configured to obtain first data information to be derived, and perform a first operation on the first data information to generate second data information. For example, the present application can be applied to a plurality of fields, and in the case of generating data information in each field, if unstructured data information needs to be output as structured data presented in an Excel format, the technical solution of the present application can be applied.

1) a thread collection stage;

2) a stage of evidence notarization;

3) a lawyer invitation phase;

4) litigation stage;

5) and settlement stage.

The operation of the related first data information is the same as or similar to that of the embodiment shown in fig. 2, and therefore is not described herein again, and is included herein by reference.

In some embodiments, the obtaining first data information to be derived comprises at least any one of:

1) querying from a database to obtain first data information to be derived;

3) receiving first data information to be exported uploaded by a user;

the operation of obtaining the first data information to be derived is the same as or similar to the embodiment shown in fig. 2, and therefore, the description is omitted, and the description is incorporated herein by reference.

In some embodiments, said performing a first operation on said first data information to generate second data information comprises: if at least two data with corresponding relations exist in the first data information, performing a first operation on the at least two data with corresponding relations to generate second data information, wherein the first operation comprises associating the at least two data with corresponding relations in a first preset format. The operation of performing the first operation on the first data information to generate the second data information is the same as or similar to the embodiment shown in fig. 2, and therefore is not repeated herein, and is incorporated by reference herein.

A second module 102, configured to perform a second operation on each piece of the second data information to generate third data information, where the second operation includes a data formatting operation. In some embodiments, the network device further includes a fifth module 105 (not shown), the fifth module 105 configured to determine the first data type information of each piece of the second data information; a second module 102, configured to determine, according to the first data type information, a second operation corresponding to each piece of corresponding data information; and executing corresponding second operation on each piece of data information to generate third data information, wherein the second operation comprises data formatting operation corresponding to the first data type information in different assignments. The specific implementation manner of the fifth module 105 is the same as or similar to the embodiment of the step S105, and therefore, the detailed description is omitted, and the detailed implementation manner is included herein by reference. In some embodiments, the data formatting operation comprises at least any one of:

formatting the amount information to add a quartile;

formatting the time information into a uniform time format;

formatting the address information;

asynchronously loading network resource information in batch;

formatting data information represented in a first preset format; the operation of the related data formatting operation is the same as or similar to that of the embodiment shown in FIG. 2, and therefore is not described herein again, and is incorporated herein by reference. In some embodiments, the secondary module 102 is configured to, if the assignment of the first data type information is in the first preset format, perform a second operation on the data information associated with the first preset format in the second data information, where the second operation includes performing an analysis operation on the data information associated with the first preset format and performing a formatting operation on the data information represented in the first preset format after the analysis operation. The operation of associating the first data type information with the first predetermined format type is the same as or similar to that of the embodiment shown in fig. 2, and therefore, the description thereof is omitted, and the description is incorporated herein by reference.

A third module 103, configured to perform a third operation on each piece of data information in the third data information according to a preset format template, so as to generate a candidate Excel template, where the third operation includes performing data assembly on each piece of data information according to the preset format template. The preset format template includes a template used by the network device by default or a template designated by the user (the designation here means that there may be a plurality of preset format templates from which the user can select). In some embodiments, a third module 103 determines the preset format template according to the derived requirement information; and performing third operation on each piece of data information in the third data information according to the preset format template to generate a candidate Excel template, wherein the third operation comprises assembling the third data information into a multi-row data template format, a multi-column data template format or a single-data multi-cell template format. The operation of determining the preset format template according to the export requirement information is the same as or similar to that of the embodiment shown in fig. 2, and therefore, the detailed description thereof is omitted, and the description is incorporated herein by reference.

In some embodiments, the preset format template is used for storing the corresponding relationship between data and cells and the attribute information of the cells. The operation of the related default format template is the same as or similar to that of the embodiment shown in fig. 2, and therefore, the description thereof is omitted, and the description thereof is incorporated herein by reference. In some embodiments, the multiple-row data template format or the multiple-column data template format includes a plurality of cell bit templates; the single data multiple cell template format includes a cell bit template. The related multi-row data template format or multi-column data template format comprises a plurality of unit cell bit templates; the operation of the single data multiple cell template format including a cell bit template is the same as or similar to that of the embodiment shown in fig. 2, and therefore, the description is omitted, and the description is incorporated herein by reference. In some embodiments, the performing a third operation on each piece of the third data information according to the preset format template to generate a candidate Excel template includes: determining second data type information of each piece of data information in the third data information;

if the second data type information comprises an array type, performing third operation on data information corresponding to the second data type information to assemble the data information into a multi-row data template format or a multi-column data template format, wherein the third operation comprises performing data assembly on the data information by using the multi-row data template or the multi-column data template; otherwise, performing a third operation on the data information corresponding to the second data type information to assemble the data information into a single-data multi-cell template format, wherein the third operation comprises performing data assembly on the data information by using a single-data multi-cell template; and generating candidate Excel templates by using the data information assembled into a multi-row data template format or a multi-column data template format and the data information assembled into a single-data multi-cell template format. The operation of performing the third operation on each piece of data information in the third data information according to the preset format template and generating the candidate Excel file after exporting is the same as or similar to the embodiment shown in fig. 2, so that the description is omitted, and the operation is included herein by reference. In some embodiments, the generating a candidate Excel template from the data information assembled into a multi-row data template format or a multi-column data template format and the data information assembled into a single-data multi-cell template format includes: grouping data information assembled into a multi-row data template format or a multi-column data template format and data information assembled into a single data multi-cell template format in rows to generate a header row template and a row data template, wherein the header row template comprises at least one piece of data information assembled into the single data multi-cell template format, and the row data template comprises at least one piece of data information assembled into the multi-row data template format or the multi-column data template format and data information assembled into the single data multi-cell template format; and assembling the header row template and the row data template, and generating a candidate Excel template by using the data information obtained by assembling. The operation of generating the candidate Excel file after exporting the data information assembled into the multi-row data template format or the multi-column data template format and the data information assembled into the single data multi-cell template format is the same as or similar to the embodiment shown in fig. 2, so that the detailed description is omitted, and the data information is included by reference

A fourth module 104, configured to analyze the candidate Excel template according to the parameter information corresponding to the preset format template, and export the analyzed candidate Excel template to generate a target Excel file. For example, when the third data information is assembled, the third data information is assembled from small to large according to an assembly template of DC-SD-SR in sequence, when the target Excel is generated through analysis, the third data information is analyzed from large to small according to the sequence of SR-SD-DC, and the third data information is analyzed according to the sequence, the assembled data is a group of sequential data, and the sequential data can be mapped to the Excel line by line through one-by-one analysis, so that the Excel is generated. The parameter information mainly includes a unit row height and a unit column height. In some embodiments, a fourth module 104 is configured to, if the preset format template includes the header line template and the line data template, analyze the candidate Excel template according to the parameter information of the header line template and the parameter information of the line data template, and export the analyzed candidate Excel template to generate a target Excel file. If the operations of the preset format template including the header row template and the row template are the same as or similar to those of the embodiment shown in fig. 2, further description is omitted, and the description is incorporated herein by reference. In some embodiments, the analyzing the candidate Excel template according to the parameter information of the header row template and the parameter information of the row data template, and exporting the analyzed candidate Excel template to generate a target Excel file includes:

detecting whether the parameter information assembled into a multi-column data template format exists in the parameter information of the header row template of the candidate Excel template, and if so, merging cell columns according to the unit column width of the multi-column data template format; detecting whether the data information assembled into a multi-row data template format or the data information assembled into a multi-column data template format exists in a row data template of the candidate Excel file, if so, merging cell rows according to the unit row width of the multi-row data template format, and if so, merging cell columns according to the unit column width of the multi-column data template format; exporting the candidate Excel template subjected to the merging processing to generate a target Excel file. The operation of analyzing the candidate Excel file according to the parameter information of the header row template and the parameter information of the row data template to generate the target Excel file is the same as or similar to the embodiment shown in fig. 2, and therefore, the description is omitted, and the description is included herein by reference. In some embodiments, exporting the candidate Excel template subjected to the above merging process to generate a target Excel file includes: determining attribute information of each cell position template in the candidate Excel templates subjected to cell column combination and/or cell row combination; and executing corresponding target operation on each cell site template according to the attribute information of each cell site template, and exporting to generate the target Excel file. The operation of determining the candidate Excel file after the cell column merging and the cell row merging as the target Excel file is the same as or similar to that of the embodiment shown in fig. 2, and therefore, the operation is not repeated, and is included herein by reference.

Here, the specific implementation of the above-mentioned one-to-one module 101, the two-to-one module 102, the one-to-three module 103 and the one-to-four module 104 is the same as or similar to the embodiment of step S101, step S102, step S103 and step S104 in fig. 3, and therefore, the detailed description thereof is omitted, and the detailed description thereof is incorporated herein by reference. In addition to the methods and apparatus described in the embodiments above, the present application also provides a computer readable storage medium storing computer code that, when executed, performs the method as described in any of the preceding claims.

The present application also provides a computer readable storage medium having stored thereon computer code which, when executed, performs a method as in any one of the preceding.

The present application also provides a computer program product, which when executed by a computer device, performs the method of any of the preceding claims.

The present application further provides a computer device, comprising:

one or more processors;

a memory for storing one or more computer programs;

the one or more computer programs, when executed by the one or more processors, cause the one or more processors to implement the method of any preceding claim.

FIG. 6 illustrates an exemplary system that can be used to implement the various embodiments described herein;

in some embodiments, as shown in FIG. 6, the system 300 can be implemented as any of the devices in the various embodiments described. In some embodiments, system 300 may include one or more computer-readable media (e.g., system memory or NVM/storage 320) having instructions and one or more processors (e.g., processor(s) 305) coupled with the one or more computer-readable media and configured to execute the instructions to implement modules to perform the actions described herein.

For one embodiment, system control module 310 may include any suitable interface controllers to provide any suitable interface to at least one of processor(s) 305 and/or any suitable device or component in communication with system control module 310.

The system control module 310 may include a memory controller module 330 to provide an interface to the system memory 315. Memory controller module 330 may be a hardware module, a software module, and/or a firmware module.

System memory 315 may be used, for example, to load and store data and/or instructions for system 300. For one embodiment, system memory 315 may include any suitable volatile memory, such as suitable DRAM. In some embodiments, the system memory 315 may include a double data rate type four synchronous dynamic random access memory (DDR4 SDRAM).

For one embodiment, system control module 310 may include one or more input/output (I/O) controllers to provide an interface to NVM/storage 320 and communication interface(s) 325.

For example, NVM/storage 320 may be used to store data and/or instructions. NVM/storage 320 may include any suitable non-volatile memory (e.g., flash memory) and/or may include any suitable non-volatile storage device(s) (e.g., one or more Hard Disk Drives (HDDs), one or more Compact Disc (CD) drives, and/or one or more Digital Versatile Disc (DVD) drives).

NVM/storage 320 may include storage resources that are physically part of the device on which system 300 is installed or may be accessed by the device and not necessarily part of the device. For example, NVM/storage 320 may be accessible over a network via communication interface(s) 325.

Communication interface(s) 325 may provide an interface for system 300 to communicate over one or more networks and/or with any other suitable device. System 300 may wirelessly communicate with one or more components of a wireless network according to any of one or more wireless network standards and/or protocols.

For one embodiment, at least one of the processor(s) 305 may be packaged together with logic for one or more controller(s) (e.g., memory controller module 330) of the system control module 310. For one embodiment, at least one of the processor(s) 305 may be packaged together with logic for one or more controller(s) of the system control module 310 to form a System In Package (SiP). For one embodiment, at least one of the processor(s) 305 may be integrated on the same die with logic for one or more controller(s) of the system control module 310. For one embodiment, at least one of the processor(s) 305 may be integrated on the same die with logic for one or more controller(s) of the system control module 310 to form a system on a chip (SoC).

In various embodiments, system 300 may be, but is not limited to being: a server, a workstation, a desktop computing device, or a mobile computing device (e.g., a laptop computing device, a handheld computing device, a tablet, a netbook, etc.). In various embodiments, system 300 may have more or fewer components and/or different architectures. For example, in some embodiments, system 300 includes one or more cameras, a keyboard, a Liquid Crystal Display (LCD) screen (including a touch screen display), a non-volatile memory port, multiple antennas, a graphics chip, an Application Specific Integrated Circuit (ASIC), and speakers.

It should be noted that the present application may be implemented in software and/or a combination of software and hardware, for example, implemented using Application Specific Integrated Circuits (ASICs), general purpose computers or any other similar hardware devices. In one embodiment, the software programs of the present application may be executed by a processor to implement the steps or functions described above. Likewise, the software programs (including associated data structures) of the present application may be stored in a computer readable recording medium, such as RAM memory, magnetic or optical drive or diskette and the like. Additionally, some of the steps or functions of the present application may be implemented in hardware, for example, as circuitry that cooperates with the processor to perform various steps or functions.

In addition, some of the present application may be implemented as a computer program product, such as computer program instructions, which when executed by a computer, may invoke or provide methods and/or techniques in accordance with the present application through the operation of the computer. Those skilled in the art will appreciate that the form in which the computer program instructions reside on a computer-readable medium includes, but is not limited to, source files, executable files, installation package files, and the like, and that the manner in which the computer program instructions are executed by a computer includes, but is not limited to: the computer directly executes the instruction, or the computer compiles the instruction and then executes the corresponding compiled program, or the computer reads and executes the instruction, or the computer reads and installs the instruction and then executes the corresponding installed program. Computer-readable media herein can be any available computer-readable storage media or communication media that can be accessed by a computer.

Communication media includes media by which communication signals, including, for example, computer readable instructions, data structures, program modules, or other data, are transmitted from one system to another. Communication media may include conductive transmission media such as cables and wires (e.g., fiber optics, coaxial, etc.) and wireless (non-conductive transmission) media capable of propagating energy waves such as acoustic, electromagnetic, RF, microwave, and infrared. Computer readable instructions, data structures, program modules, or other data may be embodied in a modulated data signal, for example, in a wireless medium such as a carrier wave or similar mechanism such as is embodied as part of spread spectrum techniques. The term "modulated data signal" means a signal that has one or more of its characteristics set or changed in such a manner as to encode information in the signal. The modulation may be analog, digital or hybrid modulation techniques.

By way of example, and not limitation, computer-readable storage media may include volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer-readable instructions, data structures, program modules or other data. For example, computer-readable storage media include, but are not limited to, volatile memory such as random access memory (RAM, DRAM, SRAM); and non-volatile memory such as flash memory, various read-only memories (ROM, PROM, EPROM, EEPROM), magnetic and ferromagnetic/ferroelectric memories (MRAM, FeRAM); and magnetic and optical storage devices (hard disk, tape, CD, DVD); or other now known media or later developed that can store computer-readable information/data for use by a computer system.

An embodiment according to the present application comprises an apparatus comprising a memory for storing computer program instructions and a processor for executing the program instructions, wherein the computer program instructions, when executed by the processor, trigger the apparatus to perform a method and/or a solution according to the aforementioned embodiments of the present application.

It will be evident to those skilled in the art that the present application is not limited to the details of the foregoing illustrative embodiments, and that the present application may be embodied in other specific forms without departing from the spirit or essential attributes thereof. The present embodiments are therefore to be considered in all respects as illustrative and not restrictive, the scope of the application being indicated by the appended claims rather than by the foregoing description, and all changes which come within the meaning and range of equivalency of the claims are therefore intended to be embraced therein. Any reference sign in a claim should not be construed as limiting the claim concerned. Furthermore, it is obvious that the word "comprising" does not exclude other elements or steps, and the singular does not exclude the plural. A plurality of units or means recited in the apparatus claims may also be implemented by one unit or means in software or hardware. The terms first, second, etc. are used to denote names, but not any particular order.

Claims

1. A method for processing data information, applied to a network device, wherein the method comprises:

2. The method of claim 1, wherein the obtaining first data information to be derived comprises at least any one of:

querying from a database to obtain first data information to be derived;

sending a data acquisition request to a target website, and receiving first data information returned by the target website based on the data acquisition request;

and receiving first data information to be exported uploaded by a user.

3. The method of claim 1 or 2, wherein the first data information is determined by data generated by at least any one of the following stages:

a thread collection stage;

a stage of evidence notarization;

a lawyer invitation phase;

litigation stage;

and settlement stage.

4. The method of any of claims 1-3, wherein the performing a first operation on the first data information to generate second data information comprises:

if at least two data with corresponding relations exist in the first data information, performing a first operation on the at least two data with corresponding relations to generate second data information, wherein the first operation comprises associating the at least two data with corresponding relations in a first preset format.

5. The method of claim 1, wherein the method further comprises:

determining first data type information of each piece of data information in the second data information;

performing a second operation on each piece of the second data information to generate third data information, wherein the second operation includes a data formatting operation, including:

determining a second operation corresponding to each piece of corresponding data information according to the first data type information;

and executing corresponding second operation on each piece of data information to generate third data information, wherein the second operation comprises data formatting operation corresponding to the first data type information in different assignments.

6. The method of claim 5, wherein the data formatting operation comprises at least any one of:

formatting the amount information to add a quartile;

formatting the time information into a uniform time format;

formatting the address information;

asynchronously loading network resource information in batch;

data information represented in a first predetermined format is formatted.

7. The method of claim 6, wherein the performing a second operation on each piece of the second data information to generate third data information, wherein the second operation comprises a data formatting operation comprising:

and if the assignment of the first data type information is in a first preset format, performing a second operation on the data information associated with the first preset format in the second data information, wherein the second operation comprises performing an analysis operation on the data information associated with the first preset format and performing a formatting operation on the data information represented by the first preset format after the analysis operation.

8. The method according to claim 1, wherein the performing a third operation on each piece of data information in the third data information according to a preset format template to generate a candidate Excel template, wherein the third operation includes performing data assembly on each piece of data information according to the preset format template, and includes:

determining a preset format template according to the export demand information;

and performing third operation on each piece of data information in the third data information according to the preset format template to generate a candidate Excel template, wherein the third operation comprises assembling the third data information into a multi-row data template format, a multi-column data template format or a single-data multi-cell template format.

9. The method according to claim 8, wherein the preset format template is used for storing the corresponding relationship between data and cells and the attribute information of the cells.

10. The method according to claim 8 or 9, wherein the third operation on each piece of the third data information according to the preset format template to generate a candidate Excel template comprises:

determining second data type information of each piece of data information in the third data information;

if the second data type information comprises an array type, performing third operation on data information corresponding to the second data type information to assemble the data information into a multi-row data template format or a multi-column data template format, wherein the third operation comprises performing data assembly on the data information by using the multi-row data template or the multi-column data template; otherwise, performing a third operation on the data information corresponding to the second data type information to assemble the data information into a single-data multi-cell template format, wherein the third operation comprises performing data assembly on the data information by using a single-data multi-cell template;

and generating candidate Excel templates by using the data information assembled into a multi-row data template format or a multi-column data template format and the data information assembled into a single-data multi-cell template format.

11. The method of claim 10, wherein the multiple-row data template format or the multiple-column data template format comprises a plurality of cell bit templates; the single data multiple cell template format includes a cell bit template.

12. The method of claim 10, wherein generating candidate Excel templates from the data information assembled into a multi-row data template format or a multi-column data template format and the data information assembled into a single data multi-cell template format comprises:

grouping data information assembled into a multi-row data template format or a multi-column data template format and data information assembled into a single data multi-cell template format in rows to generate a header row template and a row data template, wherein the header row template comprises at least one piece of data information assembled into the single data multi-cell template format, and the row data template comprises at least one piece of data information assembled into the multi-row data template format or the multi-column data template format and data information assembled into the single data multi-cell template format;

and assembling the header row template and the row data template, and generating a candidate Excel template by using the data information obtained by assembling.

13. The method according to claim 12, wherein the parsing the candidate Excel template according to the parameter information corresponding to the preset format template, and exporting the parsed candidate Excel template to generate a target Excel file comprises:

if the preset format template comprises the header row template and the line data template, analyzing the candidate Excel template according to the parameter information of the header row template and the parameter information of the line data template, and exporting the analyzed candidate Excel template to generate a target Excel file.

14. The method according to claim 13, wherein the parsing the candidate Excel template according to the parameter information of the header row template and the parameter information of the row data template, and exporting the parsed candidate Excel template to generate a target Excel file comprises:

detecting whether the parameter information assembled into a multi-column data template format exists in the parameter information of the header row template of the candidate Excel template, and if so, merging cell columns according to the unit column width of the multi-column data template format;

detecting whether the data information assembled into a multi-row data template format or the data information assembled into a multi-column data template format exists in a row data template of the candidate Excel file, if so, merging cell rows according to the unit row width of the multi-row data template format, and if so, merging cell columns according to the unit column width of the multi-column data template format;

exporting the candidate Excel template subjected to the merging processing to generate a target Excel file.

15. The method according to claim 14, wherein exporting the candidate Excel templates subjected to the above merging process to generate a target Excel file comprises:

determining attribute information of each cell position template in the candidate Excel templates subjected to cell column combination and/or cell row combination;

and executing corresponding target operation on each cell site template according to the attribute information of each cell site template, and exporting to generate the target Excel file.

16. An apparatus for processing data information, wherein the apparatus comprises:

a processor; and

a memory arranged to store computer executable instructions that, when executed, cause the processor to perform the operations of the method of any of claims 1 to 15.

17. A computer-readable medium comprising instructions that, when executed, cause a system to perform the operations of any of the methods of claims 1-15.