CN113268967B - Method and equipment for processing data information - Google Patents

Method and equipment for processing data information Download PDF

Info

Publication number
CN113268967B
CN113268967B CN202011090629.1A CN202011090629A CN113268967B CN 113268967 B CN113268967 B CN 113268967B CN 202011090629 A CN202011090629 A CN 202011090629A CN 113268967 B CN113268967 B CN 113268967B
Authority
CN
China
Prior art keywords
data
template
information
data information
format
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202011090629.1A
Other languages
Chinese (zh)
Other versions
CN113268967A (en
Inventor
郑思林
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shanghai Youyun Information Technology Co ltd
Original Assignee
Shanghai Youyun Information Technology Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Shanghai Youyun Information Technology Co ltd filed Critical Shanghai Youyun Information Technology Co ltd
Priority to CN202011090629.1A priority Critical patent/CN113268967B/en
Publication of CN113268967A publication Critical patent/CN113268967A/en
Application granted granted Critical
Publication of CN113268967B publication Critical patent/CN113268967B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/186—Templates
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00—Arrangements for program control, e.g. control units
    • G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44—Arrangements for executing specific programs
    • G06F9/451—Execution arrangements for user interfaces

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Human Computer Interaction (AREA)
  • Information Transfer Between Computers (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The application aims to provide a method and equipment for processing data information, wherein 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 data information in the second data information to generate third data information; 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; analyzing the candidate Excel templates according to the parameter information corresponding to the preset format templates, and exporting the analyzed candidate Excel templates to generate a target Excel file. The method and the device can be used for quickly and effectively sorting the data, and are favorable for users to review.

Description

Method and equipment for processing data information
Technical Field
The present application relates to the field of communications, and in particular, to a technique for processing data information.
Background
Humans have been required to process data since ancient times, the higher the civilization, the more and more complex the data need to be processed, and the higher the processing requirements, the faster the speed must be. Thus, we are continually improving the tools that are being used to accomplish the data processing needs. When the information age comes, we frequently cross data, excel has also developed. Today, excel is one of the most commonly used software in daily offices, especially when viewing data reports, for which most users mostly have a need for Excel to view data.
Disclosure of Invention
An object of the present application is to provide a method and apparatus for processing data information.
According to one 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 data information in the second data information to generate third data information, wherein the second operation comprises a data formatting operation;
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 comprises data assembly on each piece of data information according to the preset format template;
analyzing the candidate Excel templates according to the parameter information corresponding to the preset format templates, and exporting the analyzed candidate Excel templates to generate a target Excel file.
According to one 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 performing first operation on the first data information to generate second data information;
A second module for 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;
the third module is used for 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 the four modules are used for analyzing the candidate Excel templates according to the parameter information corresponding to the preset format templates, and exporting the analyzed candidate Excel templates to generate a target Excel file.
According to one 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 present 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, after the template related to the data information is assembled in the third operation, 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 the simple data information export, but the normalized and structured data information, so that the user can conveniently and subsequently review, the use experience of the user is improved, and the method and the device are reasonably layered and abstract, have extremely strong expansibility, can rapidly expand the newly defined data types or expand new characteristics of the adaptation Excel, effectively cope with various complex data information, and store and display the data information in the form of Excel.
Drawings
Other features, objects and advantages of the present application will become more apparent upon reading of the detailed description of non-limiting embodiments, made with reference to the following drawings, in which:
FIG. 1 illustrates a system topology according to the present application;
FIG. 2 illustrates a flow chart 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 illustrates a flow chart of a method for processing data information according to yet another embodiment of the present application;
FIG. 5 shows a device schematic diagram of a network device for processing data information according to one embodiment of the present application;
FIG. 6 illustrates an exemplary system that may be used to implement various embodiments described in the present invention.
The same or similar reference numbers in the drawings refer to the same or similar parts.
Detailed Description
The present application is described in further detail below with reference to the accompanying drawings.
In one typical configuration of the present application, the terminal, the device of the service network, and the trusted party each include one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include volatile memory in a computer-readable medium, random Access Memory (RAM) and/or nonvolatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of computer-readable media.
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 storage media for a computer 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 disk storage or other magnetic storage devices, or any other non-transmission medium, which can be used to store information that can be accessed by a computing device.
The device referred to in the present 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 which can perform man-machine interaction with a user (such as man-machine interaction through a touch pad), for example, a smart phone, a tablet computer and the like, and the mobile electronic product can adopt any operating system, for example, an android operating system, an iOS operating system and the like. The network device comprises an electronic device capable of automatically performing numerical calculation and information processing according to a preset or stored instruction, and the hardware of the electronic device comprises, 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 servers; here, the Cloud is composed of a large number of computers or network servers based on Cloud Computing (Cloud Computing), which is a kind of distributed Computing, a virtual supercomputer composed of a group of loosely coupled computer sets. Including but not limited to the internet, wide area networks, metropolitan area networks, local area networks, VPN networks, wireless Ad Hoc networks (Ad Hoc networks), and the like. Preferably, the device may 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 above-described devices are merely examples, and that other devices now known or hereafter may be present as appropriate for the application, are intended to be within the scope of the present application and are incorporated herein by reference.
In the description of the present application, the meaning of "a plurality" is two or more, unless explicitly defined otherwise.
Fig. 1 shows a typical scenario of the present application, where a user holds a user device, where the user device has a communication module, and the user device establishes a communication connection with a corresponding network device through 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, where the candidate infringement information includes, but is not limited to, image information captured 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 obtained by the user according to the data information, and takes the candidate infringement clue as first data information (for example, the network device analyzes infringement phenomena existing in the candidate infringement information and generates a candidate infringement clue based on the infringement phenomena), for example, a candidate infringement clue A, wherein the candidate infringement clue A corresponds to an infringement body 1 and registration information 1; the candidate infringement thread a may also correspond to the infringement subject 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 by using JSON format:
Further, the network device performs a second operation again, for example, formats the registered amount in the registered information to a presentation format of a unified amount, formats the address in the registered information to a unified format (for example, XX area XX of XX province, XX area XX number), and parses the data information in JSON format into a corresponding array form, for example, var hint a= [ "infringement body 1", "registered information 1" ], var hint a= [ "infringement body 2", "registered information 2" ]; further, the network device performs the third operation again, the network device assembles the data information subjected to the second operation according to the preset format template, for example, one thread (candidate infringement thread a) is taken as a row, the row is abstracted into SRD (SingleRowData, line data template), the thread corresponds to two infringement bodies (infringement body 1, infringement body 2), the two infringement bodies are respectively assembled into MRSD (multi rowsingledata, multi-row data template format), the thread corresponds to a plurality of intellectual property IP (intellectual property ) images (for example, cucurbit baby IP, black cat police IP), the network device respectively assembles the two IPs into MCSDs (multi colsingledata, multi-column data template format), and further, the network device assembles the thread, the two infringement bodies, and names corresponding to the plurality of intellectual property IP images into HRD (heatrowdata, header template); finally, the network device analyzes each assembled template sequentially, each assembled data is sequential data, each data is analyzed one by one 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 occupy one column and exist in the MCSD template, and then generates a target Excel for storing data information, wherein the target Excel can be sent to a user for display, 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 exported, and performs a first operation on the first data information to generate second data information. For example, the application may be applicable to multiple 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 Excel form, the technical solution of the application may be applied.
In some embodiments, the first data information is determined from data generated at least at any one of the following stages:
1) A thread collection stage;
2) Evidence notarization stage;
3) A lawyer inviting stage;
4) A litigation stage;
5) And settling a case. In some embodiments, the presence-related platform processes one or more infringement cases, and correspondingly, the corresponding user requirements are present at the same time: the data generated at each stage of processing the one or more infringement cases is output in a structured manner, for example, an Excel file is derived so that subsequent relevant persons (e.g., lawyers, rights persons) can review the data at any time. In processing one or more infringement cases, there are multiple stages of generating data. For example, in a wire collection phase, the first data information that the network device may obtain includes information of the wire (e.g., evidence that may be used to determine that one or more infringement principals exist in the infringement facts, etc.), information of one or more infringement principals (including address, name, registered capital, etc.), image information of the wire, etc.; in the evidence notarization stage, the first data information which can be acquired by the network equipment comprises one or more notarization, notarization materials, notarization time, notarization cost and the like; in the lawyer invitation stage, the first data information which can be acquired by the network equipment comprises lawyer division information, lawyer information, law place information and the like; in the litigation stage, the first data information which can be acquired by the network equipment comprises prosecution information, case setting information, payment information, court case setting information and the like; in the case settlement stage, the first data information which can be acquired by the network equipment comprises case settlement information, division information and the like. The network equipment processes the data information of each stage to be exported into an Excel file which is easy to review, and the data information is presented in a standardized and structured manner. In some embodiments, all data is surrounding case information or information generated during case progress, and the stage is simply to split the data, and in fact, the data belongs to the whole case. The stages here simply categorize the data according to the case development process. The first data of the different phases can be considered as uniform level. In some embodiments, the acquiring the first data information to be derived includes at least any one of:
1) Inquiring from a database to obtain first data information to be exported;
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, which is uploaded by a user; for example, the first data information may be obtained by multiple selection manners, 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 exported (for example, an infringement case processing platform exists, and the data information of each stage is stored in the database corresponding to the platform), 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 searching, by sending a data acquisition request to a specific or non-specific target website, acquiring and receiving search result information returned by the target website based on the data search request through a crawler technology, and taking the search result as first data information, where the first data information includes one or more web page links associated with keywords 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 completely and automatically by the network device or can be uploaded manually and actively, the first data information obtained by the network device is stored in the network device according to a predetermined arrangement rule for subsequent processing (for example, each data is orderly arranged according to a form before obtaining), and a basis is provided for presenting the first data information in the form of an Excel file on the basis of obtaining the first data information in multiple channels. In some embodiments, the performing a first operation on the first data information to generate second data information includes: and if at least two data with corresponding relations exist in the first data information, executing a first operation on the at least two data with corresponding relations to generate second data information, wherein the first operation comprises the step of associating the at least two data with corresponding relations in a first preset format. In some scenarios (e.g., database queries), only simple string concatenation can be performed, so it is not convenient to parse the data into data formats in high-level languages in the first operation (where formats refer to arrays, objects, specific objects may take many forms, such as time objects, picture objects, etc.). Therefore, the most original splicing, namely character string splicing, is carried out in the first step, and the character strings are spliced into JSON character strings, so that a foundation is provided for subsequent data analysis. The first preset format includes JSON, XML, YAML and other formats, and the three formats can be mutually converted, and here, the most commonly used JSON is taken as an example, for example, the first data information includes complex data, and multiple forms of data (for example, numbers, character strings, JSON format data, binary streams and the like) exist in the complex data. For example, the first data information is determined by the data generated in the thread collection phase, the first data information includes one thread information for judging whether there is infringement fact, the thread may involve a plurality of infringement subjects, wherein the infringement subjects only include two attributes of name and registered capital, and the corresponding relationship between registered capital and name can be guaranteed using JSON, for example, thread a has two infringement subjects, namely (infringement subject 1, registered capital 1) and (infringement subject 2, registered capital 2), and the corresponding JSON data format is as follows:
Those skilled in the art will appreciate that the above JSON data format is by way of example only, and that other data formats that may be present in the present application or in the future are intended to be encompassed within the scope of the present application and are incorporated herein 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 comprises step S105 (not shown), in step S105, the network device determining first data type information for each piece of the second data information; in step S102, the network device determines a second operation corresponding to each piece of corresponding data information according to the first data type information; and executing a corresponding second operation on each piece of data information to generate third data information, wherein the second operation comprises a data formatting operation corresponding to the first data type information in different assignment. In some embodiments, the data formatting operation includes at least any one of:
1) Formatting the amount information to add thousandth bits;
2) Formatting the time information into a unified time format;
3) Formatting address information;
4) Asynchronous batch loading of network resource information;
5) Formatting data information represented in a first preset format; wherein the data formatting operation is used for processing each piece of data information in the second data information into data of a preset type, and for example, the first data type information comprises an amount (for example, 30), a date (for example, 2014.06.06), JSON format data, an address (B region of B city of B province), a picture, a file and the like. Corresponding to the different first data type information, the network device performs a 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 thousandth bits 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); the time data is subjected to unified format (for example, the original time information is 6:00pm, the time after unified format is 24 hours system, 18:00); for address data, address is subjected to unified format (for example, original address data B, B district, B, and further refined to house number, for example, B house number B in B district, B, and B district, B, and B); for example, the pictures or files exist in the form of network resources such as picture links and file links, the network equipment acquires the picture information in an asynchronous batch loading mode, the loading time of the pictures is shortened as much as possible, the data information existing in the picture data format is acquired, and the acquisition efficiency of the pictures is improved; and corresponding to the different first data type information, the network equipment adopts different data formatting operations, and takes the second data information after the formatting operation 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 a 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 a parsing 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 parsing operation. The first preset format includes JSON, XML, YAML and other formats, and the three formats may be mutually converted, where, for example, the first data type information is a variable, and different corresponding data processing modes are assigned, if the first data type information includes JSON, the network device determines the data information corresponding to JSON, and performs batch analysis on the data information by using an array to ensure a data corresponding relationship as far as possible, and after acquiring the analyzed array, 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 data assembling each piece of data information according to the preset format template. Wherein, the preset format template comprises a template used by the network device by default or a template designated by a user (the designation refers to that the preset format template can be multiple, and the user can select from the preset format template). In some embodiments, in step S103, the network device determines a pre-formatted template according to the derived demand information; and performing a 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 the step of 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 demand information includes formats of data presentation in subsequent Excel desired by the user, including but not limited to cell hyperlinks, cell insert pictures, cell merging, row column width, cell coloring, and the like. The network equipment determines a template from a template database according to the preset derived demand information of the user or generates a template with a preset format determined according to the demand information, so that the Excel file generated later meets the demand of the user.
In some embodiments, the preset format template is used for storing the corresponding relation between the data and the cells and the attribute information of the cells. For example, the preset format template is used for assembling data information for the purpose of generating an Excel file later, and the format of the Excel file can be defined in the preset format template by a user, so that the Excel file output later is presented in a format required by the user. For example, the preset format template includes DC (DataCell, cell bit template), where DC is the smallest cell, and may be considered as information of an Excel cell, where DC includes font, font size, displayed data content, and hyperlinks; the preset format template includes SD (single data), which is an abstract concept and includes one or more DCs, in other words, SD is composed of the smallest unit DC. In some embodiments, the multi-row data template format or multi-column data template format includes a plurality of cell bit templates; the single data multiple cell template format includes one 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 be an abstract representation DC, MRSD, SDD as well as MCSD at the same time. SD takes MRSD (Multi-line data template Format), MCSD (Multi-column data template Format) and SSD (SimpleSingleData, single data multiple cell template Format) as specific template formats, wherein SSD contains one DC, MRSD and MCSD contain multiple DCs, i.e. SSD contains one data, MRSD and MCSD contain multiple data; the preset format template includes SR (single row template), where SR is an abstract concept for abstracting and representing a row of data, and takes HRD (header row template) and SRD (row data template) as concrete template formats, where HRD and SRD respectively include multiple SDs. On the basis of determining a template with a preset format, a basis is provided for the template assembly of the follow-up data. In some embodiments, determining second data type information for each piece of data information in the third data information; if the second data type information comprises an array type, performing a third operation on the 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 data assembling 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 multiple cell template format, wherein the third operation comprises data assembling the data information by using the single data multiple cell template; and generating candidate Excel templates by 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. In some embodiments, the SD includes an array or a single data (more complex data may be disassembled or combined into unit data after performing the first operation), where one data is contained and the MRSD and MCSD contain multiple data (e.g., arrays). For example, taking infringement case information as an example, one case is a row (one row is abstracted into SRD, because partial data may have row-column merging conditions, corresponding to Excel rows), the data can be assembled by using SSD for one case name, one case corresponds to multiple infringement subjects (infringement subject 1, infringement subject 2, infringement subject 3), the infringement subject name can be assembled by MRSD, one case corresponds to multiple IPs (IP image 1, IP image 2, IP image 3), and MCSD can be used for data assembly. In some embodiments, the generating the candidate Excel templates with the data information assembled into the multi-line data template format or the multi-column data template format and the data information assembled into the single data multi-cell template format includes:
Grouping data information assembled into a multi-line data template format or a multi-line data template format and data information assembled into a single data multi-cell template format according to lines to generate a header line template and a data template, wherein the header line template comprises at least one data information assembled into the single data multi-cell template format, and the data template comprises at least one data information assembled into the multi-line data template format, the multi-line data template format and data information assembled into the single data multi-cell template format; and assembling the header line template and the line data template, and generating a candidate Excel template according to the data information obtained by assembling. Wherein, since there may be a case of row-column merging of partial data, the grouping by row includes grouping by one row or by a plurality of 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 plurality of name information includes one data, an SSD may represent one data, i.e., one DC, where the header row template includes at least one SSD; one or more data of each type may be stored in a line data template, one data may exist in the line data template, an SSD may represent one data, i.e., one DC, or data occupying multiple lines or columns may exist, and may be represented by MRSD and MCSD, where both MRSD and MCSD include multiple data, i.e., multiple DCs. In some embodiments, if there is an MRSD or MCSD type in the preformatted 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 templates are sequentially assembled from DC-SD-SR), so that each data can be assembled hierarchically and without omission, and the subsequent Excel generation is facilitated to be sequentially analyzed.
In step S104, the network device parses the candidate Excel template according to the parameter information corresponding to the preset format template, and exports the parsed candidate Excel template to generate a target Excel file. For example, when the third data information is assembled, the third data information is assembled according to the assembling template of the DC-SD-SR from small to large in sequence, when the target Excel is generated by analysis, the target Excel is gradually analyzed according to the sequence of the SR-SD-DC from large to small in sequence, and when the target Excel is analyzed, the assembled data is a group of sequential data, and the assembled data can be mapped to the Excel line by line after the sequential data are analyzed one by one, so that the Excel is generated. Wherein 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 parses 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 parsed candidate Excel template to generate the target Excel file. In some embodiments, the Excel is assembled through SRs, each SR corresponds to one cell line (the cell line may be formed by multiple lines) in the Excel, when the candidate Excel template is analyzed, the analysis of the SR is performed first, because the specific template format of the SR includes HRD and SRD, the network device analyzes according to the parameter information of the HRD and the parameter information of the SRD, and on the basis of analyzing each cell line preferentially, a basis is provided for continuing to analyze the data assembled by each template in the cell line subsequently. In some embodiments, the parsing the candidate Excel template according to the parameter information of the header line template and the parameter information of the line data template, exporting the parsed candidate Excel template to generate a target Excel file, including: 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 the 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 the data templates of the candidate Excel file, if so, carrying out cell row combination according to the unit row width of the multi-row data template format, and if so, carrying out cell column combination according to the unit column width of the multi-column data template format; and exporting the candidate Excel templates subjected to the merging process to generate a target Excel file. For example, the parameter information assembled into the multi-column data template format includes the most MCSDs in unit columns, when the network device analyzes the HRD to generate the target Excel, determining whether the MCSDs exist in the current column in advance, if so, merging the cells in advance when the HRD is analyzed, wherein the number of the merged cell columns is determined by the most MCSDs in the current unit columns, for example, when the HRD is analyzed, the MCSDs with 3 columns are obtained, wherein the width of the unit column is 3, and when the HRD corresponding to the MCSDs is analyzed, the header cell column merging is performed, and the merging number is 3; for example, when the SRD is parsed to generate the target Excel, it is predetermined whether there are MRSD and MCSD in the current column or row, if there are MRSD and MCSD, it is necessary to merge cells in advance when the SRD is parsed, where the number of merged cell columns is determined by the most MCSD in the current unit column, and the number of merged cell rows is determined by the most MRSD in the current unit column, for example, there is one case number, but there are three infringement subject names (MRSD), then cell merging is required for other unit data (for example, case number) occupying one row, so that the same unit row where the case number and the three infringement subjects are located can be obtained. On the premise of analyzing the SR (comprising the HRD and the SRD), the MCSD and the MRSD are further analyzed, so that the analysis speed and the normalization can be maintained. In some embodiments, the deriving the candidate Excel templates after the merging process to generate the target Excel file includes: determining attribute information of each cell site template in the candidate Excel templates subjected to the cell column merging and/or the cell row merging; and executing corresponding target operation on each cell bit template according to the attribute information of each cell bit template, and exporting to generate the target Excel file. For example, the attribute information of each cell bit template includes a style (e.g., font, color, center) and a dataform (e.g., picture, hyperlink, text), and in some embodiments, the target operation includes at least any one of:
Setting a hyperlink;
inserting a picture;
setting a cell pattern;
setting cell texts; for example, different target operations exist corresponding to different attribute information, so that each parsed DC accords with the display requirement set by a user in Excel. The format of each cell bit template (DC) is inconsistent, and when each DC is parsed, the network device performs a corresponding operation according to different attribute information, for example, the attribute information of a DC includes: font Song Ti, red in color, is centered, setting cell text for this DC to meet font Song Ti, red in color, is centered. And finally, on the premise of analyzing each DC, the generation of the target Excel file is completed.
For example, as shown in fig. 3, the network device obtains first data information to be exported from the database, where the first data information includes a clue number, infringement information (e.g., infringement picture, etc.), related information of an infringer, and associates the associated information in the first data in JSON format, and generates second data information, for example, in the JSON format as follows:
then, the network device performs a second operation again, formats each data in the second data information to generate third data, and obtains infringement pictures from network resources through asynchronous batch loading; and thirdly, assembling each data in the third data by using SRDs corresponding to '6909', assembling 'cue numbers', 'cue remarks', 'case states', 'infringement bodies', 'infringement behaviors', 'organization forms', and the like by using HRDs, respectively assembling '6909', 'cue remarks', 'case states', data under the cue numbers and the like by using SSDs, assembling infringement pictures by using MCSDs, assembling 'infringement bodies', 'infringement behaviors', 'organization forms', and the like, finally analyzing the assembled third data information by using network equipment, and outputting Excel, for example, determining that cell column merging is needed when analyzing the HRD, and combining cell rows and columns when analyzing the SRD. Those skilled in the art will appreciate that the above JSON is by way of example only, and that other second data information that may be present in the present application, as applicable, is also within the scope of the present application and is incorporated herein by reference.
FIG. 4 is a flowchart of a method for processing data information according to another embodiment of the present application, and is mainly divided into four abstract layers, namely a data acquisition layer, a data formatting layer, a template assembly layer and an Excel generation layer, wherein each layer can dynamically expand export requirements for processing data with different formats and Excel with different formats. The invention mainly comprises the following steps: 1. acquiring data from a data storage system and performing preliminary assembly; 2. formatting the original data; 3. performing export template assembly on the data according to the format of the Excel needing to be exported; 4. and analyzing the derived template, and generating an Excel file according to various parameters given by the template.
Fig. 5 shows a network device for processing data information according to one embodiment of the present application, the network device comprising 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, a module 101 is configured to obtain first data information to be exported, and perform a first operation on the first data information to generate second data information. For example, the application may be applicable to multiple 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 Excel form, the technical solution of the application may be applied.
In some embodiments, the first data information is determined from data generated at least at any one of the following stages:
1) A thread collection stage;
2) Evidence notarization stage;
3) A lawyer inviting stage;
4) A litigation stage;
5) And settling a case.
The operation of the related first data information is the same as or similar to that of the embodiment shown in fig. 2, and thus, will not be described in detail herein, and is incorporated by reference.
In some embodiments, the acquiring the first data information to be derived includes at least any one of:
1) Inquiring from a database to obtain first data information to be exported;
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, which is uploaded by a user;
the operation of obtaining the first data information to be derived is the same as or similar to that of the embodiment shown in fig. 2, and thus is not described in detail herein, and is incorporated by reference.
In some embodiments, the performing a first operation on the first data information to generate second data information includes: and if at least two data with corresponding relations exist in the first data information, executing a first operation on the at least two data with corresponding relations to generate second data information, wherein the first operation comprises the step of 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 thus will not be described in detail herein, and is incorporated by reference.
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 five module 105 (not shown), the five module 105 configured to determine first data type information of each piece of the second data information; a second module 102, configured to determine a second operation corresponding to each piece of data information according to the first data type information; and executing a corresponding second operation on each piece of data information to generate third data information, wherein the second operation comprises a data formatting operation corresponding to the first data type information in different assignment. The specific implementation manner of the five modules 105 is the same as or similar to that of the embodiment of the step S105, so that the detailed description is omitted herein and incorporated by reference. In some embodiments, the data formatting operation includes at least any one of:
formatting the amount information to add thousandth bits;
formatting the time information into a unified time format;
formatting address information;
Asynchronous batch loading of network resource information;
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 thus is not described in detail herein and incorporated by reference. In some embodiments, the second module 102 is configured to perform a second operation on the data information associated with the first preset format in the second data information if the assignment of the first data type information is in the first preset format, where the second operation includes performing a parsing 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 parsing operation. The operation of the first data type information including the first predetermined format type is the same as or similar to that of the embodiment shown in fig. 2, and thus will not be described in detail herein, and is incorporated by reference.
And 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. Wherein, the preset format template comprises a template used by the network device by default or a template designated by a user (the designation refers to that the preset format template can be multiple, and the user can select from the preset format template). In some embodiments, a three module 103 determines a pre-formatted template based on the derived demand information; and performing a 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 the step of 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 derived demand information is the same as or similar to that of the embodiment shown in fig. 2, and thus is not described in detail herein and incorporated by reference.
In some embodiments, the preset format template is used for storing the corresponding relation between the data and the 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 thus is not described in detail herein and incorporated by reference. In some embodiments, the multi-row data template format or multi-column data template format includes a plurality of cell bit templates; the single data multiple cell template format includes one cell bit template. The related multi-row data template format or multi-column data template format comprises a plurality of cell bit templates; the operation of the single data multiple cell template format including one cell bit template is the same as or similar to the embodiment shown in fig. 2, and thus is not described in detail herein and incorporated 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 a third operation on the 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 data assembling 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 multiple cell template format, wherein the third operation comprises data assembling the data information by using the single data multiple cell template; and generating candidate Excel templates by 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. The operation of generating the candidate Excel file after the derivation is the same as or similar to the embodiment shown in fig. 2, so that details are not repeated and incorporated herein by reference. In some embodiments, the generating the candidate Excel templates with the data information assembled into the multi-line data template format or the multi-column data template format and the data information assembled into the single data multi-cell template format includes: grouping data information assembled into a multi-line data template format or a multi-line data template format and data information assembled into a single data multi-cell template format according to lines to generate a header line template and a data template, wherein the header line template comprises at least one data information assembled into the single data multi-cell template format, and the data template comprises at least one data information assembled into the multi-line data template format, the multi-line data template format and data information assembled into the single data multi-cell template format; and assembling the header line template and the line data template, and generating a candidate Excel template according to the data information obtained by assembling. The operation of generating candidate Excel files after deriving data information assembled into a multi-line data template format or a multi-line data template format and data information assembled into a single data and a plurality of cell template formats is the same as or similar to the embodiment shown in fig. 2, and therefore will not be described in detail, and is enclosed by reference
And a four-module 104, configured to parse the candidate Excel template according to the parameter information corresponding to the preset format template, and export the parsed candidate Excel template to generate a target Excel file. For example, when the third data information is assembled, the third data information is assembled according to the assembling template of the DC-SD-SR from small to large in sequence, when the target Excel is generated by analysis, the target Excel is gradually analyzed according to the sequence of the SR-SD-DC from large to small in sequence, and when the target Excel is analyzed, the assembled data is a group of sequential data, and the assembled data can be mapped to the Excel line by line after the sequential data are analyzed one by one, so that the Excel is generated. Wherein the parameter information mainly includes a unit row height and a unit column height. In some embodiments, a four-module 104 is configured to parse the candidate Excel template according to the parameter information of the header line template and the parameter information of the line data template if the preset format template includes the header line template and the line data template, and export the parsed candidate Excel template to generate the target Excel file. If the default format template includes the header row template and the operation of the row data template are the same as or similar to those of the embodiment shown in fig. 2, the description is omitted herein for brevity. In some embodiments, the parsing the candidate Excel template according to the parameter information of the header line template and the parameter information of the line data template, exporting the parsed candidate Excel template to generate a target Excel file, including:
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 the 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 the data templates of the candidate Excel file, if so, carrying out cell row combination according to the unit row width of the multi-row data template format, and if so, carrying out cell column combination according to the unit column width of the multi-column data template format; and exporting the candidate Excel templates subjected to the merging process to generate a target Excel file. The operation of generating the target Excel file according to the parameter information of the header line template and the parameter information of the line data template to parse the candidate Excel file is the same as or similar to the embodiment shown in fig. 2, so that details are not repeated and are incorporated herein by reference. In some embodiments, the deriving the candidate Excel templates after the merging process to generate the target Excel file includes: determining attribute information of each cell site template in the candidate Excel templates subjected to the cell column merging and/or the cell row merging; and executing corresponding target operation on each cell bit template according to the attribute information of each cell bit 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 the embodiment shown in fig. 2, and thus will not be described in detail herein, and is incorporated by reference.
Here, the specific implementation examples of the one-to-one module 101, the two-to-one module 102, the three-to-three module 103 and the four-to-four module 104 are the same as or similar to those of the embodiment of the step S101, the step S102, the step S103 and the step S104 in fig. 3, and thus are not described in detail, and are herein incorporated by reference. In addition to the methods and apparatus described in the above embodiments, the present application also provides a computer-readable storage medium storing computer code which, when executed, performs a method as described in any one of the preceding claims.
The present application also provides a computer readable storage medium storing computer code which, when executed, performs a method as claimed in any preceding claim.
The present application also provides a computer program product which, when executed by a computer device, performs a method as claimed in any preceding claim.
The present application also 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 may be used to implement various embodiments described herein;
in some embodiments, as shown in fig. 6, the system 300 can function as any of the devices of the various described embodiments. In some embodiments, system 300 can 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 the modules to perform the actions described herein.
For one embodiment, the system control module 310 may include any suitable interface controller to provide any suitable interface to at least one of the processor(s) 305 and/or any suitable device or component in communication with the 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.
The system memory 315 may be used, for example, to load and store data and/or instructions for the system 300. For one embodiment, system memory 315 may include any suitable volatile memory, such as, for example, a suitable DRAM. In some embodiments, the system memory 315 may comprise a double data rate type four synchronous dynamic random access memory (DDR 4 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 nonvolatile memory (e.g., flash memory) and/or may include any suitable nonvolatile 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 which may be accessed by the device without being part of the device. For example, NVM/storage 320 may be accessed 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. The system 300 may wirelessly communicate with one or more components of a wireless network in accordance with 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 of one or more controllers (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 of one or more controllers 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 as logic of one or more controllers 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 of one or more controllers of the system control module 310 to form a system on chip (SoC).
In various embodiments, the system 300 may be, but is not limited to being: a server, workstation, desktop computing device, or mobile computing device (e.g., laptop computing device, handheld computing device, tablet, 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, keyboards, liquid Crystal Display (LCD) screens (including touch screen displays), non-volatile memory ports, multiple antennas, graphics chips, application Specific Integrated Circuits (ASICs), 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, using Application Specific Integrated Circuits (ASIC), a general purpose computer or any other similar hardware device. In one embodiment, the software programs of the present application may be executed by a processor to implement the steps or functions as described above. Likewise, the software programs of the present application (including associated data structures) may be stored on a computer readable recording medium, such as RAM memory, magnetic or optical drive or diskette and the like. In addition, some 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.
Furthermore, portions 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 by way of operation of the computer. Those skilled in the art will appreciate that the form of computer program instructions present in a computer readable medium includes, but is not limited to, source files, executable files, installation package files, etc., and accordingly, 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. Herein, a computer-readable medium may be any available computer-readable storage medium or communication medium that can be accessed by a computer.
Communication media includes media whereby a communication signal containing, for example, computer readable instructions, data structures, program modules, or other data, is transferred from one system to another. Communication media may include conductive transmission media such as electrical cables and wires (e.g., optical fibers, coaxial, etc.) and wireless (non-conductive transmission) media capable of transmitting energy waves, such as acoustic, electromagnetic, RF, microwave, and infrared. Computer readable instructions, data structures, program modules, or other data may be embodied as a modulated data signal, for example, in a wireless medium, such as a carrier wave or similar mechanism, such as that embodied as part of spread spectrum technology. 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 nonvolatile memory such as flash memory, various read only memory (ROM, PROM, EPROM, EEPROM), magnetic and ferromagnetic/ferroelectric memory (MRAM, feRAM); and magnetic and optical storage devices (hard disk, tape, CD, DVD); or other now known media or later developed computer-readable information/data that can be stored 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 operate a method and/or a solution according to the embodiments of the present application as described above.
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 characteristics 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 evident that the word "comprising" does not exclude other elements or steps, and that the singular does not exclude a plurality. A plurality of units or means recited in the apparatus claims can also be implemented by means of one unit or means in software or hardware. The terms first, second, etc. are used to denote a name, but not any particular order.

Claims (14)

1. A method for processing data information, applied to a network device, wherein the method comprises:
acquiring first data information to be exported, and performing a first operation on the first data information to generate second data information, wherein the performing the first operation on the first data information to generate the second data information includes: if at least two data with a corresponding relation exist in the first data information, performing a first operation on the at least two data with the corresponding relation to generate second data information, wherein the first operation comprises associating the at least two data with the corresponding relation in a first preset format;
performing a second operation on each piece of data information in the second data information to generate third data information, wherein the second operation comprises a data formatting operation; the method further comprises the steps of: determining first data type information of each piece of data information in the second data information; the 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; performing a corresponding second operation on each piece of data information to generate third data information, wherein the second operation comprises a data formatting operation corresponding to the first data type information in different assignment;
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 comprises data assembly on each piece of data information according to the preset format template;
analyzing the candidate Excel templates according to the parameter information corresponding to the preset format templates, and exporting the analyzed candidate Excel templates to generate a target Excel file;
wherein, the performing a 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 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 a third operation on the 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 data assembling 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 multiple cell template format, wherein the third operation comprises data assembling the data information by using the single data multiple cell template; and generating candidate Excel templates by 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.
2. The method of claim 1, wherein the acquiring the first data information to be derived comprises at least any one of:
inquiring from a database to obtain first data information to be exported;
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 the first data information to be exported, which is uploaded by the user.
3. The method of claim 1 or 2, wherein the first data information is determined from data generated at least at any one of the following stages:
a thread collection stage;
evidence notarization stage;
a lawyer inviting stage;
a litigation stage;
and settling a case.
4. The method of claim 1, wherein the data formatting operation comprises at least any one of:
formatting the amount information to add thousandth bits;
formatting the time information into a unified time format;
formatting address information;
asynchronous batch loading of network resource information;
data information represented in a first predetermined format is formatted.
5. The method of claim 4, 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, executing a second operation on the data information related to the first preset format in the second data information, wherein the second operation comprises executing a parsing operation on the data information related to the first preset format and executing a formatting operation on the data information represented by the first preset format after the parsing operation.
6. The method of claim 1, wherein 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, wherein the third operation includes performing data assembly on each piece of the data information according to the preset format template, and includes:
determining a preset format template according to the derived demand information;
and performing a 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 the step of 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.
7. The method of claim 6, wherein the pre-formatted template is used to store a correspondence of data and cells, and attribute information of the cells.
8. The method of claim 1, wherein the multi-row data template format or multi-column data template format comprises a plurality of cell bit templates; the single data multiple cell template format includes one cell bit template.
9. The method of claim 1, wherein the generating candidate Excel templates from the data information assembled into a multi-line 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-line data template format or a multi-line data template format and data information assembled into a single data multi-cell template format according to lines to generate a header line template and a data template, wherein the header line template comprises at least one data information assembled into the single data multi-cell template format, and the data template comprises at least one data information assembled into the multi-line data template format, the multi-line data template format and data information assembled into the single data multi-cell template format;
And assembling the header line template and the line data template, and generating a candidate Excel template according to the data information obtained by assembling.
10. The method of claim 9, wherein the parsing the candidate Excel templates according to the parameter information corresponding to the preset format template, exporting the parsed candidate Excel templates to generate a target Excel file, and comprises:
if the preset format template comprises the header line template and the line data template, analyzing the candidate Excel template according to the parameter information of the header line template and the parameter information of the line data template, and exporting the analyzed candidate Excel template to generate a target Excel file.
11. The method of claim 10, wherein the parsing the candidate Excel templates according to the parameter information of the header line template and the parameter information of the line data template, exporting the parsed candidate Excel templates to generate a target Excel file, and 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 the 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 the data templates of the candidate Excel file, if so, carrying out cell row combination according to the unit row width of the multi-row data template format, and if so, carrying out cell column combination according to the unit column width of the multi-column data template format;
and exporting the candidate Excel templates subjected to the merging process to generate a target Excel file.
12. The method of claim 11, wherein the deriving the candidate Excel templates after the above merging process to generate the target Excel file comprises:
determining attribute information of each cell site template in the candidate Excel templates subjected to the cell column merging and/or the cell row merging;
and executing corresponding target operation on each cell bit template according to the attribute information of each cell bit template, and exporting to generate the target Excel file.
13. An apparatus for processing data information, wherein the apparatus comprises:
A processor; and
a memory arranged to store computer executable instructions which, when executed, cause the processor to perform the operations of the method of any one of claims 1 to 12.
14. A computer readable medium comprising instructions that when executed cause a system to perform the operations of the method of any one of claims 1 to 12.
CN202011090629.1A 2020-10-13 2020-10-13 Method and equipment for processing data information Active CN113268967B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202011090629.1A CN113268967B (en) 2020-10-13 2020-10-13 Method and equipment for processing data information

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011090629.1A CN113268967B (en) 2020-10-13 2020-10-13 Method and equipment for processing data information

Publications (2)

Publication Number Publication Date
CN113268967A CN113268967A (en) 2021-08-17
CN113268967B true CN113268967B (en) 2024-04-09

Family

ID=77227739

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011090629.1A Active CN113268967B (en) 2020-10-13 2020-10-13 Method and equipment for processing data information

Country Status (1)

Country Link
CN (1) CN113268967B (en)

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110399420A (en) * 2019-07-30 2019-11-01 广州吉信网络科技开发有限公司 A kind of deriving method, electronic equipment and the medium of configurableization Excel format
CN111080457A (en) * 2019-12-17 2020-04-28 深圳前海环融联易信息科技服务有限公司 Financial system compatible with browser
CN111125220A (en) * 2019-12-18 2020-05-08 任子行网络技术股份有限公司 Information user-defined export method and device
CN111177243A (en) * 2019-12-24 2020-05-19 浙江大搜车软件技术有限公司 Data export method and device, storage medium and electronic device

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7818661B2 (en) * 2006-10-04 2010-10-19 Dilip Patel Method and system for automatically generating template based spreadsheet pivot tables

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110399420A (en) * 2019-07-30 2019-11-01 广州吉信网络科技开发有限公司 A kind of deriving method, electronic equipment and the medium of configurableization Excel format
CN111080457A (en) * 2019-12-17 2020-04-28 深圳前海环融联易信息科技服务有限公司 Financial system compatible with browser
CN111125220A (en) * 2019-12-18 2020-05-08 任子行网络技术股份有限公司 Information user-defined export method and device
CN111177243A (en) * 2019-12-24 2020-05-19 浙江大搜车软件技术有限公司 Data export method and device, storage medium and electronic device

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
"气象月报表文件数据导出工具的设计与实现";魏宝广;《电脑编程技巧与维护》;全文 *

Also Published As

Publication number Publication date
CN113268967A (en) 2021-08-17

Similar Documents

Publication Publication Date Title
US9495347B2 (en) Systems and methods for extracting table information from documents
US9507480B1 (en) Interface optimization application
CN111061739B (en) Method and device for warehousing massive medical data, electronic equipment and storage medium
US8139872B2 (en) Splitting file types within partitioned images
CN107491334B (en) Method for organizing and loading preloaded files
CN109558128A (en) Json data analysis method, device and computer readable storage medium
CN110020358B (en) Method and device for generating dynamic page
WO2023124217A1 (en) Method and device for acquiring comprehensively sorted data of multi-column data
CN114816377A (en) Script obtaining method and device
CN113282591B (en) Authority filtering method, authority filtering device, computer equipment and storage medium
CN113268967B (en) Method and equipment for processing data information
CN117493309A (en) Standard model generation method, device, equipment and storage medium
CA3203549A1 (en) Unified verification method, device, equipment and storage medium
CN111916164B (en) Method and device for realizing center-started investigation system in clinical research
CN115759029A (en) Document template processing method and device, electronic equipment and storage medium
CN111078654B (en) Method and device for sharing information
CN114968917A (en) Method and device for rapidly importing file data
CN112256991B (en) Method and equipment for native rendering of information flow fusing multiple link addresses
CN112784527A (en) Document merging method and device and electronic equipment
CN112256992A (en) Native rendering method and device for information stream fusing multi-link addresses
CN117076515B (en) Metadata tracing method and device in medical management system, server and storage medium
CN111125565A (en) Method and equipment for inputting information in application
CN111079038B (en) Method and equipment for inputting information in application
CN111367976B (en) Method and device for exporting EXCEL file data based on JAVA reflection mechanism
CN113468460B (en) Method, device and equipment for rendering Web page based on YAML (Yaml language)

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant