CN113822030A

CN113822030A - Data export method, device and storage medium

Info

Publication number: CN113822030A
Application number: CN202011117519.XA
Authority: CN
Inventors: 付会超
Original assignee: Beijing Jingdong Century Trading Co Ltd; Beijing Wodong Tianjun Information Technology Co Ltd
Current assignee: Beijing Jingdong Century Trading Co Ltd; Beijing Wodong Tianjun Information Technology Co Ltd
Priority date: 2020-10-19
Filing date: 2020-10-19
Publication date: 2021-12-21

Abstract

The application discloses a data exporting method, a data exporting device and a storage medium, and particularly comprises the steps of firstly obtaining data to be exported and a pre-stored form template, secondly analyzing cell contents and cell ranges of the form template based on cell commands and annotation commands marked in the form template, finally traversing the data to be exported, adding the data to be exported to the form template according to the cell contents and the cell ranges, and returning the traversed form template serving as an exported form to an interface for a user to call. According to the embodiment of the application, the form template for marking the cell command and the annotation command is set, the data to be exported are traversed and added to the form template, and convenience and efficiency of exporting the data are improved.

Description

Data export method, device and storage medium

Technical Field

The present application relates to the field of computer technologies, and in particular, to a method, an apparatus, and a storage medium for data export.

Background

With the development of the internet, the user requirements of various systems are more and more complicated and diversified, and the simple retrieval of data from the systems can not meet the requirements of users gradually. When the user needs to check account, data in a certain time period can be exported to an Excel file, and then the user can easily realize the account checking operation through screening or an Excel formula. Furthermore, in the conventional data export, objects such as a Workbook, a Sheet, a Row, a Cell and the like are generally created manually in a code, data are written into cells in a traversing manner, then an Excel generation directory is designated, and finally an Excel file is created for a user to download and store to the local. With more complex scenarios, the user's requirements for derived data are high, such as the need for a specified font and font size, a specified line height and column width, a fixed header, a specified background color, and so on. And the method of manually setting the formats of line height, column width, font size, color and the like of the Excel file in which the export data is located has no universality and causes the export efficiency to be low.

Disclosure of Invention

The embodiment of the application provides a data exporting method, and the problems that a template does not have universality and exporting efficiency is low when data is exported are solved.

The method comprises the following steps:

acquiring data to be exported and a pre-stored table template;

analyzing the cell content and the cell range of the table template based on the cell command and the annotation command marked in the table template;

and traversing the data to be exported, adding the data to be exported to the form template according to the cell content and the cell range, and returning the form template after traversing to an interface as an exported form for a user to call.

Optionally, the form template is created and stored, wherein the creating the form template includes:

determining the cell command of the table template as first syntax information, wherein the first syntax information is used for acquiring an attribute value of at least one variable;

determining the annotation command of the form template as second syntax information, wherein the second syntax information is used for traversing the data to be derived and determining a valid range of traversal.

Optionally, personalized information of the form template is set, wherein the personalized information includes row height information, column width information, text information and background color information of the cells.

Optionally, traversing the data to be derived based on the annotation command, determining the cell range based on the data to be derived, and naming at least one variable in the data to be derived;

based on the cell command, acquiring the attribute value of at least one variable and adding the attribute value to the corresponding cell;

and storing the annotation command, the cell command and the current cell style after the personalized information is set, and traversing the data to be exported based on the current cell style so as to add the data to be exported to the form template.

In another embodiment of the present invention, there is provided an apparatus for data export, the apparatus including:

the acquisition module is used for acquiring data to be exported and a pre-stored table template;

the analysis module is used for analyzing the cell content and the cell range of the table template based on the cell command and the annotation command marked in the table template;

and the generating module is used for traversing the data to be exported, adding the data to be exported to the form template according to the cell content and the cell range, and returning the form template after traversing to an interface as an exported form for a user to call.

Optionally, the apparatus further comprises a creating module configured to:

Optionally, the creating module is further configured to:

and setting personalized information of the table template, wherein the personalized information comprises row height information, column width information, character information and background color information of the cells.

Optionally, the generating module is further configured to:

traversing the data to be derived based on the annotation command, determining the cell range based on the data to be derived, and naming at least one variable in the data to be derived;

In another embodiment of the invention, a non-transitory computer readable storage medium is provided, storing instructions that, when executed by a processor, cause the processor to perform the steps of one of the above-described data derivation methods.

In another embodiment of the present invention, a terminal device is provided, which includes a processor configured to perform the steps of a data export method as described above.

Based on the embodiment, firstly, the data to be exported and the pre-stored form template are obtained, secondly, the cell content and the cell range of the form template are analyzed based on the cell command and the annotation command marked in the form template, finally, the data to be exported are traversed, the data to be exported are added to the form template according to the cell content and the cell range, and the traversed form template is used as an exported form and returned to an interface for a user to call. According to the embodiment of the application, the form template for marking the cell command and the annotation command is set, the data to be exported are traversed and added to the form template, and convenience and efficiency of exporting the data are improved.

Drawings

In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are required to be used in the embodiments will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present application and therefore should not be considered as limiting the scope, and for those skilled in the art, other related drawings can be obtained from the drawings without inventive effort.

Fig. 1 shows a schematic flow chart of a method for data export provided by an embodiment 100 of the present application;

fig. 2 is a schematic diagram illustrating a specific flow of a method for data export according to an embodiment 200 of the present application;

fig. 3 shows a schematic diagram of an apparatus for data export according to an embodiment 300 of the present application;

fig. 4 shows a schematic diagram of a terminal device provided in embodiment 400 of the present application.

Detailed Description

The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.

The terms "first," "second," "third," "fourth," and the like in the description and in the claims, as well as in the drawings, if any, are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are, for example, capable of operation in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprising" and "having," as well as any variations thereof, are intended to cover non-exclusive inclusions. For example, a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements explicitly listed, but may include other steps or elements not explicitly listed or inherent to such process, method, article, or apparatus.

Based on the problems in the prior art, the embodiment of the application provides a data export method, which is mainly applicable to the technical field of computers. By directly filling variable placeholders in the cells, carrying out grammatical description on the annotation function of the table template according to grammatical convention, taking the table template as an export template, reading a table template file by a code, analyzing grammatical commands in annotations, and automatically multiplexing the style of each cell, the complex export operation is simplified, and the data export method is realized. Several of the following embodiments may be combined with each other, and details of the same or similar concepts or processes may not be repeated in some embodiments. Fig. 1 is a schematic flowchart of a method for data export according to an embodiment 100 of the present application. The scene of the embodiment of the application is mainly an indoor scene capable of carrying out voice control on the intelligent device. The detailed steps are as follows:

step S11, data to be exported and a table template stored in advance are acquired.

In this step, the data to be exported is a plurality of data that the user needs to visually view or operate, such as order data of the user on an e-commerce website. The pre-stored form template is marked with a cell command and an annotation command and is set in a personalized mode. The form template is stored in the configuration center, and the configuration center provides a download path for downloading.

And step S12, analyzing the cell content and the cell range of the form template based on the cell command and the annotation command marked in the form template.

In the step, a cell command and an annotation command are marked in advance in a form template acquired through a download path, the cell content of each cell in the form template is analyzed based on the acquired data to be exported and the cell command, and the cell range where the data to be exported is located related in the form template is analyzed based on the annotation command.

And step S13, traversing the data to be exported, adding the data to be exported to the form template according to the cell content and the cell range, and returning the form template after traversing to an interface as an exported form for a user to call.

In this step, the data to be exported is traversed through the cell content and the cell range of the parsed form template, and the specific numerical value of the content of the data to be exported is acquired to be in the cell range conforming to the exported data, so as to generate the exported form. Further, the generated exported table is uploaded to a server or cloud storage, and a download address of the file is returned to the interface as an exit parameter, so that the interface caller calls the exported table.

As described above, based on the above embodiment, the data to be exported and the table template stored in advance are first obtained, then, the cell content and the cell range of the table template are analyzed based on the cell command and the annotation command marked in the table template, finally, the data to be exported is traversed, the data to be exported is added to the table template according to the cell content and the cell range, and the traversed table template is returned to the interface as the exported table for the user to call. According to the embodiment of the application, the form template for marking the cell command and the annotation command is set, the data to be exported are traversed and added to the form template, and convenience and efficiency of exporting the data are improved.

Fig. 2 is a schematic diagram illustrating a specific flow of a data exporting method according to an embodiment 200 of the present application. Wherein, the detailed process of the specific flow is as follows:

s201, determining the grammar information of the cell command and the annotation command of the form template.

Here, the cell command of the form template is determined as first syntax information, wherein the first syntax information is used for acquiring an attribute value of at least one variable; and determining the annotation command of the form template as second syntax information, wherein the second syntax information is used for traversing the data to be derived and determining the effective range of the traversal. Specifically, the first syntax information of the cell command carried by the form template is determined to be $ { variable. And determining second syntax information of the annotation command carried by the form template as ex: for (variable in collection), last: A2, meaning to traverse each item of data in the collection of the data to be derived, naming a variable in each item of data as variable, and traversing the included cells as the range from the current cell to the A2 cell.

And S202, creating a form template based on the determined cell command and the annotation command.

Here, a blank form template is created, and based on the cell command and the data to be exported, a cell command indicating that at least one attribute value of the data to be exported is obtained is filled in a first cell in the blank cells. If the data to be exported includes two attribute values, an order number and an order amount, a cell command $ { item. Furthermore, an annotation command is added to the first cell, and ex: for (item in list) and last: A2 are marked in the form template according to the agreed second syntax information.

S203, setting the personalized information of the form template.

In this step, personalized information of the form template is set, wherein the personalized information includes row height information, column width information, character information and background color information of the cells.

And S204, saving the form template and generating a file download address of the form template.

Here, the set form template is saved, and the file is uploaded to a server or cloud storage, so as to generate a download address of the file corresponding to the form template. Further, the download address of the form template is configured to the configuration center.

And S205, acquiring data to be exported.

Here, the data to be exported selected by the user is acquired, and the attribute value of the data to be exported is inquired. If the data to be exported selected by the user is 300 order records, querying to obtain that each order record contains two attribute values: order number orderId and order amount price. Further, the acquired data to be exported are integrated and placed into a set listA.

S206, acquiring a pre-stored template table.

Here, the download address of the template table is acquired from the configuration center, the template table is downloaded through the download address, and the cells are sequentially analyzed. And if the cell content is empty, stopping the analysis.

And S207, analyzing the cell content and the cell range of the form template based on the cell command and the annotation command marked in the form template, and adding the data to be exported to the form template according to the cell command and the annotation command.

In the step, traversing the data to be exported based on the annotation command, determining a cell range based on the data to be exported, and naming at least one variable in the data to be exported; acquiring an attribute value of at least one variable based on the cell command and adding the attribute value to the corresponding cell; and storing the annotation labeling command, the cell command and the current cell style after the personalized information is set, and traversing the data to be exported based on the current cell style so as to add the data to be exported to the form template.

Specifically, the annotation command that is resolved to the first cell is ex: for (item in list), last: A2, that is, data to be exported, that is, the order set listA, is traversed as an item to be traversed, and each order record object is named item. Then, cell commands from the current cell to the A2 cell are analyzed, the obtained variables are $ { item.orderId }, and $ { item.price }, and then the value is obtained through a get method of orderId and price attribute in the data to be exported through a JAVA reflection mechanism. And further, automatically generating cells, automatically generating new cells in the same style as the style of the current cells according to the for traversal command, inserting the new cells below the current line as the new line, and so on until the set traversal is finished.

And S208, returning the form template after traversing the data to be exported to the interface as the exported form for the user to call.

And uploading the generated file to a cloud storage through an interface of the cloud storage, and returning a download address of the file to an interface caller as an export reference until the export task is finished.

According to the data export method disclosed by the embodiment of the application, the set table template is stored in advance, the variable name is defined, the table template is uploaded to the cloud storage, the exported core logic is encapsulated into an interface, only two entries are received externally, one entry is a set object needing to be traversed, and the other entry is an acquisition path of the table template on the cloud storage. And the data can be analyzed into the form template through interface calling, and the download path of the new form template is returned to the calling party as a reference, so that the logic of data export is greatly simplified, the capability of data export of a line of codes is realized, and a large amount of export logic codes are prevented from being accumulated. Meanwhile, the form template can be generalized and can be packaged into a jar packet for other application systems. In addition, the style of the form template is intuitive, and each time the style is adjusted, the form template is directly operated, so that the form template adjusts the style, and the finally exported data file is the style. When exporting, the Excel exporting can be realized by directly calling a line of codes without manually setting styles such as fonts, colors, column widths, line heights and the like through the codes. And directly dragging the row width on the table template to realize the style configuration. Furthermore, the downloading address of the form template is placed in the configuration center, only the file on the cloud storage needs to be replaced after the form template is modified every time, the latest template file is downloaded by acquiring the downloading address through the configuration center during exporting, and development cost is saved.

Based on the same inventive concept, the embodiment 300 of the present application further provides an apparatus for data export, where, as shown in fig. 3, the apparatus includes:

an obtaining module 31, configured to obtain data to be exported and a table template stored in advance;

the analysis module 32 is used for analyzing the cell content and the cell range of the table template based on the cell command and the annotation command marked in the table template;

the generating module 33 is configured to traverse the data to be exported, add the data to be exported to the form template according to the cell content and the cell range, and return the form template after the traversal is completed as an exported form to the interface, so that the user can call the form template.

In this embodiment, the specific functions and interaction manners of the obtaining module 31, the analyzing module 32 and the generating module 33 can be referred to the record of the embodiment corresponding to fig. 1, and are not described herein again.

Optionally, the apparatus further comprises a creating module 34, the creating module 34 is configured to:

determining a cell command of the form template as first syntax information, wherein the first syntax information is used for acquiring an attribute value of at least one variable;

and determining the annotation command of the form template as second syntax information, wherein the second syntax information is used for traversing the data to be derived and determining the effective range of the traversal.

Optionally, the creating module 34 is further configured to:

Optionally, the generating module 33 is further configured to:

traversing data to be derived based on the annotation command, determining the range of the cell based on the data to be derived, and naming at least one variable in the data to be derived;

based on a cell command, acquiring the attribute value of at least one variable and adding the attribute value to the corresponding cell;

and storing the annotation labeling command, the cell command and the current cell style after the personalized information is set, and traversing the data to be exported based on the current cell style so as to add the data to be exported to the form template.

As shown in fig. 4, another embodiment 400 of the present application further provides a terminal device, which includes a processor 401, wherein the processor 401 is configured to execute the steps of the above-mentioned data exporting method. As can also be seen from fig. 4, the terminal device provided by the above embodiment further comprises a non-transitory computer readable storage medium 402, the non-transitory computer readable storage medium 402 having stored thereon a computer program, which when executed by the processor 401, performs the steps of the above-described data exporting method. In practice, the terminal device may be one or more computers, as long as the computer-readable medium and the processor are included.

In particular, the storage medium can be a general-purpose storage medium, such as a removable disk, a hard disk, a FLASH disk, etc., and when the computer program on the storage medium is executed, the steps of the data exporting method can be executed. In practical applications, the computer readable medium may be included in the apparatus/device/system described in the above embodiments, or may exist alone without being assembled into the apparatus/device/system. The computer readable storage medium carries one or more programs which, when executed, are capable of performing the steps of a method of data derivation as described above.

According to embodiments disclosed herein, the computer-readable storage medium may be a non-volatile computer-readable storage medium, which may include, for example and without limitation: a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing, without limiting the scope of the present disclosure. In the embodiments disclosed herein, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.

The flowchart and block diagrams in the figures of the present application illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments disclosed herein. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.

Those skilled in the art will appreciate that various combinations and/or combinations of features recited in the various embodiments and/or claims of the present disclosure can be made, even if such combinations or combinations are not explicitly recited in the present application. In particular, the features recited in the various embodiments and/or claims of the present application may be combined and/or coupled in various ways, all of which fall within the scope of the present disclosure, without departing from the spirit and teachings of the present application.

Finally, it should be noted that: the above-mentioned embodiments are only specific embodiments of the present application, and are used for illustrating the technical solutions of the present application, but not limiting the same, and the scope of the present application is not limited thereto, and although the present application is described in detail with reference to the foregoing embodiments, those skilled in the art should understand that: any person skilled in the art can still change or easily conceive of the technical solutions described in the foregoing embodiments or equivalent replacement of some technical features thereof within the technical scope disclosed in the present application; such changes, variations and substitutions do not depart from the spirit and scope of the exemplary embodiments of the present application and are intended to be covered by the appended claims. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.

Claims

1. A method of data derivation, comprising:

acquiring data to be exported and a pre-stored table template;

2. The method of claim 1, wherein prior to the step of obtaining the data to be exported and a pre-stored form template, the method further comprises creating and storing the form template, wherein the step of creating the form template comprises:

3. The method of claim 2, wherein the step of creating the form template further comprises:

4. The method of claim 3, wherein the step of adding the data to be exported to the table template according to the cell content and the cell range comprises:

5. An apparatus for data derivation, comprising:

6. The apparatus of claim 5, further comprising a creation module configured to:

7. The apparatus of claim 6, wherein the creation module is further configured to:

8. The apparatus of claim 7, wherein the generating module is further configured to:

9. A non-transitory computer readable storage medium storing instructions that, when executed by a processor, cause the processor to perform the steps of a method of data derivation as claimed in any one of claims 1 to 4.

10. A terminal device comprising a processor configured to perform the steps of a method of data derivation according to any one of claims 1 to 4.