WO2018201697A1

WO2018201697A1 - Method, device and equipment for generating a file and computer readable storage medium

Info

Publication number: WO2018201697A1
Application number: PCT/CN2017/112009
Authority: WO
Inventors: 丁志勇
Original assignee: 平安科技（深圳）有限公司
Priority date: 2017-05-05
Filing date: 2017-11-21
Publication date: 2018-11-08
Also published as: CN107688456B; CN107688456A

Abstract

A method, device and equipment for generating a file and a computer readable storage medium, wherein the method comprises the steps of: when a starting instruction from a service system is detected, acquiring the configuration information for a list downloading frame of a predetermined type, and generating a first line of data having a predetermined structure (S10); creating a preset form according to the configuration information, and writing the first line of data into the preset form (S20); if the first line of data satisfies the criteria of the preset form, then a file corresponding to the preset form will be generated according to the first line of data (S30). The described method achieves the generation of corresponding files by means of the list downloading frame of a preset-type, wherein the files may support xls or xlsx formats, thus being able to support the diversification of generated files.

Description

File generation method, device, device, and computer readable storage medium

The present application claims priority to Chinese Patent Application No. JP-A No. No. No. No. No. No. No. No. No. No. No. No. No. No. No. In the application.

Technical field

The present application relates to the field of data processing technologies, and in particular, to a file generating method, apparatus, device, and computer readable storage medium.

Background technique

The existing manifest download framework is based on the open source library poi, with DOM (Document Object Model, Document Object Model) The model is the core list download framework. In the process of using the list downloading framework, the developer needs to write the template file corresponding to the list downloading framework in the form of code, and generate the corresponding file through the template file, but the downloading frame corresponding to the template file is based on the DOM model. The xls or xlsx format is not supported, so the format of the resulting file cannot be in xls or xlsx format.

Summary of the invention

The main purpose of the present application is to provide a file generation method, apparatus, device, and computer readable storage medium, which are intended to solve the technical problem that a file generated by a manifest download framework with a DOM model as a core does not support the xls or xlsx format.

To achieve the above objective, the present application provides a file generating method, where the file generating method includes the following steps:

When the startup command of the service system is detected, acquiring configuration information of the preset type download framework and generating the first row of data of the preset structure;

Forming a preset table according to the configuration information, and writing the first row of data into the preset table;

And if the first row data satisfies the condition of the preset table, generating a file corresponding to the preset table according to the first row data.

In addition, in order to achieve the above object, the present application further provides a file generating apparatus, where the file generating apparatus includes:

An obtaining module, configured to acquire configuration information of a preset type downloading framework when detecting a startup instruction of the business system;

Generating a module for generating a first line of data of the preset structure;

a creating module, configured to create a preset table according to the configuration information, and write the first row of data into the preset table;

The generating module is further configured to: if the first row of data meets the condition of the preset table, generate a file corresponding to the preset table according to the first row of data.

Preferably, the generating module comprises:

An obtaining unit, configured to obtain second row data from a database;

a determining unit, configured to determine a correspondence between the second row of data and a variable in a template file of the manifest download framework;

And a generating unit, configured to generate first row data of the map structure according to the correspondence relationship based on the second row data.

Preferably, the creating unit is further configured to create an Excel table according to the configuration information, and write the first row data of the map structure into the Excel table in a stream form;

The generating module is further configured to: if the row data satisfies the condition of the Excel table, generate a sheet page header and content corresponding to the Excel file, and determine whether the data according to the size of the first row is Need to change pages to generate an Excel file.

Preferably, the template file corresponding to the manifest download framework includes a header file template, a content header template, and a content body template.

Preferably, the obtaining module comprises:

a loading unit, configured to load a JAR package of the list download framework when detecting a startup instruction of the business system;

And an obtaining unit, configured to acquire configuration information of the manifest download framework in the JAR package if the JAR package is successfully loaded.

Preferably, the file generating apparatus further includes:

a detecting module, configured to detect whether a mandatory parameter field of the first row of data written in the preset table is empty, and detecting whether a number of columns corresponding to the first row of data is greater than a maximum of the configuration information The number of columns.

In addition, in order to achieve the above object, the present application further provides a file generating device, the file generating device including a memory, a processor, and a file generating program stored on the memory and executable on the processor, The steps of the file generation method as described above are implemented when the file generation program is executed by the processor.

In addition, in order to achieve the above object, the present application further provides a computer readable storage medium having a file generation program stored thereon, and the file generation program is executed by a processor to implement file generation as described above. The steps of the method.

The present application obtains the configuration information of the preset type of the download framework of the list when the startup command of the business system is detected, and generates the first line of data of the preset structure; and creates a preset table according to the configuration information, and The first row of data is written into the preset table; if the first row of data satisfies the condition of the preset table, a file corresponding to the preset table is generated according to the first row of data. The corresponding file is generated by the preset type list downloading framework, and the file can support the xls or xlsx format, that is, the file generated by the support is diversified.

DRAWINGS

1 is a schematic structural diagram of a device in a hardware operating environment involved in an embodiment of the present application;

FIG. 2 is a schematic flowchart diagram of a preferred embodiment of a method for generating a file according to the present application.

The implementation, functional features and advantages of the present application will be further described with reference to the accompanying drawings.

detailed description

It is understood that the specific embodiments described herein are merely illustrative of the application and are not intended to be limiting.

The solution of the embodiment of the present application is: when detecting a startup instruction of the service system, acquiring configuration information of a preset type of download framework, and generating first row data of the preset structure; and creating according to the configuration information Presetting a table, and writing the first row of data into the preset table; if the first row of data satisfies a condition of the preset table, generating and pre-determining according to the first row of data Set the file corresponding to the form. The file generated by the download framework based on the DOM model does not support the xls or xlsx format.

As shown in FIG. 1 , FIG. 1 is a schematic structural diagram of a device in a hardware operating environment according to an embodiment of the present application.

The file generating device in the embodiment of the present application may be a PC, or may be a smart phone, a tablet computer, an e-book reader, and an MP3 (Moving). Picture Experts Group Audio Layer III, motion picture expert compresses standard audio layer 3) player, MP4 (Moving Picture Experts Group Audio Layer IV, dynamic video experts compress standard audio layers 3) Players, portable computers and other portable terminal devices with display functions.

As shown in FIG. 1, the file generating device may include a processor 1001, such as a CPU, a user interface 1003, a memory 1005, and a communication bus 1002. Among them, the communication bus 1002 is used to implement connection communication between these components. The user interface 1003 can include a display, an input unit such as a keyboard, and the optional user interface 1003 can also include a standard wired interface, a wireless interface. The memory 1005 may be a high speed RAM memory or a stable memory (non-volatile) Memory), such as disk storage. The memory 1005 can also optionally be a storage device independent of the aforementioned processor 1001.

Optionally, the file generating device may further include a camera, RF (Radio) Frequency, RF) circuits, sensors, audio circuits, WiFi modules, and more.

It will be understood by those skilled in the art that the file generating device structure shown in FIG. 1 does not constitute a limitation to the terminal, and may include more or less components than those illustrated, or combine some components, or different component arrangements.

As shown in FIG. 1, an operating system and a file generation program may be included in the memory 1005 as a computer storage medium. Among them, the operating system is a program that manages and controls the file generation device hardware and software resources, and supports the operation of the file generation program and other software and/or programs.

In the file generating device shown in FIG. 1, the user interface 1003 is mainly used to receive a startup command or the like. The processor 1001 can be used to call a file generation program stored in the memory 1005 and perform the following operations:

Further, the step of generating the first row of data of the preset structure includes:

Get the second row of data from the database;

Determining a correspondence between the second row of data and a variable in a template file of the manifest download framework;

Based on the second row of data, the first row of data of the map structure is generated according to the correspondence.

Further, the step of creating a preset table according to the configuration information, and writing the first row of data into the preset table includes:

Creating an Excel table according to the configuration information, and writing the first row data of the map structure into the Excel table in a stream form;

If the first row of data meets the condition of the preset table, the step of generating a file corresponding to the preset table according to the first row of data includes:

If the row data satisfies the condition of the Excel table, generating a sheet page header and content corresponding to the Excel file, and determining whether a page change is required according to the size of the first row data to generate an Excel file.

Further, before the step of determining the correspondence between the second row data and the variables in the template file of the list download frame, the processor 1001 may further be configured to invoke the file generation program stored in the memory 1005 to perform the following operations. :

The second row of data is stored in a Java virtual machine;

The processor 1001 may further be configured to invoke the memory 1005 after the step of generating the file corresponding to the preset table according to the first row of data, if the first row of data meets the condition of the preset table. The file generator stored in the file, do the following:

Deleting the second row of data stored by the Java virtual machine.

Further, the template file corresponding to the manifest download framework includes a header file template, a content header template, and a content body template.

Further, when the startup command of the service system is detected, the step of acquiring configuration information of the preset type of download framework includes:

Loading a JAR package of the manifest download framework when a startup command of the business system is detected;

If the JAR package is successfully loaded, the configuration information of the manifest download framework is obtained in the JAR package.

Further, the processor 1001 may further be used before the step of generating a file corresponding to the preset table according to the first row data, if the first row data satisfies the condition of the preset table. The file generation program stored in the memory 1005 is called to perform the following operations:

Detecting whether a mandatory parameter field of the first row of data written in the preset table is empty;

And detecting whether the number of columns corresponding to the first row of data is greater than a maximum number of columns in the configuration information.

Based on the hardware configuration described above, various embodiments of the file generation method are proposed.

Referring to FIG. 2, FIG. 2 is a schematic flowchart of a first embodiment of a method for generating a file according to the present application.

In the present embodiment, an embodiment of a file generating method is provided. It should be noted that although the logical order is shown in the flowchart, in some cases, the illustrated may be performed in a different order than here. Or the steps described.

The file generation method includes:

In step S10, when the startup command of the service system is detected, the configuration information of the list download framework of the preset type is acquired, and the first row data of the preset structure is generated.

When the startup command of the business system is detected, the configuration information of the preset type download framework is obtained, and the first row of data of the preset structure is generated. In the embodiment of the present application, the startup instruction may be triggered by the user, or may be set to automatically trigger the service system at a fixed time. If the business system is set to start automatically at 6 o'clock every day to trigger the start command.

In this embodiment, the preset type of download framework is a String Template list download framework. String Template (referred to as ST) is a Java-based template engine library (currently supporting C#, Python, Ruby), which can be used to generate various formatted texts such as source code, web pages, and emails. In other embodiments, the preset type of download framework can be and String The Template List download framework has a list download framework with the same functionality. Configuration information includes, but is not limited to, the number of rows and columns of template files in the manifest download framework.

In the embodiment of the present application, String The Template list download framework includes ElisRbsStartup, XlsClassLoader, DsmsXlsCommonIOHandler, DsmsXlsIOHandler, XlsColumnDef, XlsRowDefDTO, RbsXlsIOHandler, DsmsXlsBaseIOHandler, DsmsXlsMgIOHandler, RbsXlsMgIOHandler, and XlsUtli modules. It should be noted that those skilled in the art can supplement the new module of the list downloading framework, and the names of the modules are custom names, which are only used to assist in understanding various program function modules of the list downloading framework, and are not used to limit the present application. The technical solution, the core of the technical solution of the present application is the function to be achieved by the modules respectively defining the names.

When the business system starts, it calls ElisRbsStartup to initialize the JAR package of the manifest download framework.

When ElisRbsStartup initializes the JAR package of the manifest download framework, ElisRbsStartup is used to call XlsClassLoader to load the JAR package of the manifest download framework and check if the JAR package of the manifest download framework is loaded successfully. JAR (Java Archive, a Java archive file) is a platform-independent file format that allows many files to be combined into one compressed file. The JAR file format is based on the popular ZIP file format, with ZIP The difference between files is that JAR files are not only used for compression and publishing, but also for deploying and packaging libraries, components, and plug-ins, and can be used like compilers and JVMs (Java Virtual Machine, Java virtual machine) such a tool is used directly.

DsmsXlsCommonIOHandler is used to define the common header of the manifest download framework, such as defining the common parameters required for each template file, as well as defining the output file path and callback function, and checking whether the manifest download framework is initialized successfully.

DsmsXlsIOHandler is used to read the configuration information of the manifest download framework, and execute the callback function in the common header. The callback function is mainly used to read the first row of data from the database, and download the template in the framework according to the read row data and the list. The correspondence between the file variables generates row data of the map structure, and the row data of the map structure is the second row of data. DsmsXlsIOHandler is also used for file splitting when the file generated by the first line of data needs to be changed.

XlsColumnDef is used to determine the correspondence between the first row of data and the template file variables in the manifest download framework.

XlsRowDefDTO is a data carrier.

DsmsXlsBaseIOHandler is used to get the public header of the manifest download framework.

RbsXlsIOHandler The DsmsXlsMgIOHandler and the RbsXlsMgIOHandler are used to obtain the row data to be configured from different databases, that is, to obtain the second row of data. For example, RbsXlsIOHandler can be used to obtain the row data to be configured from the database of the business system, and DsmsXlsMgIOHandler and RbsXlsMgIOHandler can be used to obtain the row data to be configured from MongoDB. MongoDB is a product between a relational database and a non-relational database. It is the most versatile of the non-relational database, most like a relational database. It supports a very loose data structure and is similar to JSON (Java). Script Object Notation (JS object tag) BJSON (Binary JSON) format, so you can store more complex data types.

XlsUtl is the core module of the list download framework. It is mainly used to define the basic parameters of the list download framework, set the corresponding default values, and support multiple ways to create preset tables. For example, an Excel spreadsheet can be created in multiple files to support writing multiple rows of data to the created Excel spreadsheet at a time; an Excel spreadsheet can be created in a single file and multiple sheets to support writing multiple rows of data to the created Excel spreadsheet at a time. An Excel spreadsheet can be created in a single file breakpoint to support writing a row of data to the created Excel spreadsheet at a time.

XlsUtl can also be used for parameter detection, such as detecting whether the written row data field is empty, whether the required field corresponding to the written row data is empty, and detecting whether the row data is correctly written into the Excel table; Whether the number of columns corresponding to the entered row data exceeds the maximum number of columns set by the template file; detecting whether the template file exists; generating the sheet page header and sheet page contents, and detecting whether the generated Excel file needs to be changed.

Further, when the startup instruction of the service system is detected, the step of acquiring the configuration information of the preset type download framework includes:

Step a, when the startup command of the business system is detected, loading the JAR package of the list download framework.

Step b: If the JAR package is successfully loaded, obtaining configuration information of the manifest download framework in the JAR package.

Further, when the startup command of the business system is detected, the JAR package of the list download framework is loaded. When the JAR package of the list download framework is successfully loaded, the configuration information of the list download framework is obtained in the JAR package; when the JAR package of the list download framework fails to load, the prompt information may be output, prompting the user that the JAR package fails to load, please reload the list. Download the JAR package of the framework; or when the JAR package of the list download framework fails to load, the business system automatically reloads the JAR package of the list download framework. When the number of failed automatic loading of the JAR package by the business system is greater than the preset number of times, the JAR package is loaded. Workflow. In this embodiment, the preset number of times may be set according to specific needs, such as 2 times, or 3 times.

Step c, obtaining the second row of data from the database.

Step d: determining a correspondence between the second row of data and a variable in a template file of the manifest download framework.

Step e, based on the second row of data, generating first row data of the map structure according to the correspondence relationship.

Further, the second row of data is obtained from the database, and the template file of the manifest download framework is obtained. When the second row of data is obtained from the database, parsing the second row of data, determining a correspondence between the second row of data and variables in the template file, and generating a map structure according to the determined correspondence relationship based on the second row of data The first line of data. It can be understood that the first row of data can be obtained through the second row of data. A map is a data structure stored in the form of a key-value pair. The key value is equivalent to the subscript in the list and the array. The key value can be any type of object, and there can be no duplicate key values in the graph and each The key value must be stored in correspondence with a corresponding value.

In this embodiment, the manifest download framework includes three template files, which are a header file template, a content header template, and a content body template. Among them, the header file template is used to define the style of the entire file, such as field type, color, etc., similar to CSS (Cascading) Style Sheets, Cascading Style Sheets) . The content header template is used to define common parameters in the sheet page, such as list names, public parameters, and column field definitions. The content body template is used to bind dynamic column fields to corresponding variables. In order to distinguish different files, in this embodiment, the format of the template file of the list download frame is a file ending with st. For example, the head file template is represented by head.st, and the content header template is represented by body_head.st, with body_row. St represents the content body template.

Further, the manifest downloading framework may further include an optional template for implementing special requirements of the user, such as when the generated file is required to have a drop-down list, data verification, etc., and may be implemented by an optional template.

Step S20: Create a preset table according to the configuration information, and write the first row of data into the preset table.

When the configuration information of the list download frame is obtained, a preset table is created according to the configuration information, and the first line of data is written into the created preset table. When creating a preset table according to the configuration information, the preset table can be created in various ways, and the writing method of writing the first row of data into the preset table is different according to the manner of creating the table, such as writing more at one time. The first row of data in a row, or the first row of data in a row at a time. In this embodiment, the preset form is an Excel table, and in other embodiments, the form may also be a CSV (Comma-Separated) Values, comma-separated values), a table in TXT format.

Further, the step S20 includes:

Step f: Create an Excel table according to the configuration information, and write the first row data of the map structure into the Excel table in a stream form.

Further, when the configuration information of the list download frame is acquired, an Excel table is created according to the acquired configuration information, and the first row data of the map structure is written into the Excel table in a stream form.

Step S30: If the first row data satisfies the condition of the preset table, generate a file corresponding to the preset table according to the first row data.

After the first row data of the map structure is written to the preset table in a stream form, it is detected whether the first row data written in the preset table satisfies the condition of the preset table. When the first row of data satisfies the condition of the preset table, the file corresponding to the preset table is generated according to the first row of data. When the first row data does not satisfy the condition of the preset table, the file corresponding to the preset table is not generated; or the data in the first row data that does not satisfy the preset table condition is deleted, and then the corresponding table is generated. document.

Specifically, the process of detecting whether the first row of data in the preset table satisfies the condition of the preset table is: detecting whether a mandatory parameter field of the first row of data written in the preset table is empty; and detecting the first Whether the number of columns corresponding to the row data is greater than the maximum number of columns in the configuration information.

When the required parameter field of the first row of data written in the preset table is not empty, and the number of columns corresponding to the first row of data is less than or equal to the maximum number of columns in the configuration information, it is determined that the first row of data satisfies the preset table. The condition is that when the mandatory parameter field of the first row of data written in the preset table is empty, and/or the number of columns corresponding to the first row of data is greater than the maximum number of columns in the configuration information, it is determined that the first row of data is not satisfied. Preset the conditions of the form. It can be understood that the mandatory parameters in the line data differ according to the content of the generated file.

Further, it is also possible to detect whether each field corresponding to the first row data in the write preset table is empty, and whether the template file of the list download frame exists or the like.

Further, the step S30 includes:

Step h, if the first row of data satisfies the condition of the Excel table, generate a sheet page header and content corresponding to the Excel file, and determine whether it needs to be changed according to the size of the first row of data. Page to generate an Excel file.

Further, when the first row data of the map structure is written into the Excel table in a stream form, it is detected whether the first row data written in the Excel table satisfies the condition of the Excel table. If the first line of data satisfies the condition of the Excel table, the sheet page header and the sheet page contents corresponding to the Excel file are generated, and the page size is determined according to the size of the first line of data, that is, according to the first line of data. The number of rows and columns determines if a page break is required. When the number of rows of the first row of data is greater than the maximum number of rows of one sheet page, and/or the number of columns of the first row of data is greater than the maximum number of columns of one sheet page, indicating that a page change is required, a page change operation is performed, generating more The Excel file of the page; when the number of rows of the first row of data is less than or equal to the maximum number of rows of a sheet page, and the number of columns of the first row of data is less than or equal to the maximum number of columns of a sheet page, it indicates that no page change is required. Then generate a single page Excel file. It can be understood that, in this embodiment, the format of the Excel file may be xls or xlsx format.

In this embodiment, since the Excel file can be paged, the risk of memory overflow when the data of the line data is too large is avoided. Using String In the template list download framework process, the developer only needs to modify the contents of the variable part to generate the required files, which reduces the workload of the developer and facilitates the maintenance of the list download framework by the developer.

In this embodiment, when the startup command of the service system is detected, the configuration information of the preset type of the download frame is acquired, and the first row of the preset structure is generated; and the preset table is created according to the configuration information, and The first row of data is written into the preset table; if the first row of data satisfies the condition of the preset table, a file corresponding to the preset table is generated according to the first row of data. The corresponding file is generated by the preset type list downloading framework, and the file can support the xls or xlsx format, that is, the file generated by the support is diversified.

Further, a second embodiment of the present document generating method is proposed.

The difference between the second embodiment of the file generation method and the first embodiment of the file generation method is that the file generation method further includes:

In step i, the second row of data is stored in the Java virtual machine.

Step g, deleting the second row of data stored by the Java virtual machine.

When the second row of data to be configured is acquired, the acquired second row of data is stored in the Java virtual machine. After the file corresponding to the preset table is generated according to the first row of data, the second row of data stored in the Java virtual machine is deleted. In the process of writing the first row of data into the preset table, if the first row of data is written incorrectly, or the first row of data is lost, the write failure occurs, etc., and the corresponding corresponding number can be obtained in the Java virtual machine. The two rows of data are regenerated according to the second row of data to generate the required file. The Java virtual machine has its own complete hardware architecture, such as processors, stacks, registers, etc., and has a corresponding instruction system.

In this embodiment, by storing the original data (the second row of data) acquired from the database in the Java virtual machine, when the data related to the original data has an error during the process of generating the file, the The Java virtual machine obtains the original data without looking up the original data in the business system database, which improves the file generation efficiency. After the file is successfully generated, the data stored in the Java virtual machine is deleted, which saves the storage space of the Java virtual machine to improve the utilization of the Java virtual machine storage space.

In addition, the embodiment of the present application further provides a file generating apparatus, where the file generating apparatus includes:

Further, the generating module includes:

An obtaining unit, configured to obtain second row data from a database;

Further, the creating unit is further configured to create an Excel table according to the configuration information, and write the first row data of the map structure into the Excel table in a stream form;

Further, the obtaining module includes:

Further, the file generating apparatus further includes:

The specific implementation of the file generating apparatus of the present application is substantially the same as the embodiment of the foregoing file generating method, and details are not described herein again.

In addition, the embodiment of the present application further provides a computer readable storage medium, where the file readable storage medium is stored, and when the file generating program is executed by the processor, the following steps are implemented:

Get the second row of data from the database;

Further, before the step of determining the correspondence between the second row data and the variables in the template file of the manifest download frame, the file generating program is executed by the processor to implement the following steps:

The second row of data is stored in a Java virtual machine;

If the first line of data satisfies the condition of the preset table, after the step of generating a file corresponding to the preset table according to the first line of data, when the file generating program is executed by the processor Implement the following steps:

Deleting the second row of data stored by the Java virtual machine.

Further, if the first row of data satisfies the condition of the preset table, the file generating program is processed before the step of generating a file corresponding to the preset table according to the first row of data The following steps are implemented when the device is executed:

The specific embodiment of the computer readable storage medium of the present application is substantially the same as the embodiment of the foregoing file generating method, and details are not described herein again.

It is to be understood that the term "comprises", "comprising", or any other variants thereof, is intended to encompass a non-exclusive inclusion, such that a process, method, article, or device comprising a series of elements includes those elements. It also includes other elements that are not explicitly listed, or elements that are inherent to such a process, method, article, or device. An element that is defined by the phrase "comprising a ..." does not exclude the presence of additional equivalent elements in the process, method, item, or device that comprises the element.

The serial numbers of the embodiments of the present application are merely for the description, and do not represent the advantages and disadvantages of the embodiments.

Through the description of the above embodiments, those skilled in the art can clearly understand that the foregoing embodiment method can be implemented by means of software plus a necessary general hardware platform, and of course, can also be through hardware, but in many cases, the former is better. Implementation. Based on such understanding, the technical solution of the present application, which is essential or contributes to the prior art, may be embodied in the form of a software product stored in a storage medium (such as ROM/RAM, disk, The optical disc includes a number of instructions for causing a terminal device (which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to perform the methods described in various embodiments of the present application.

The above is only a preferred embodiment of the present application, and is not intended to limit the scope of the patent application, and the equivalent structure or equivalent process transformations made by the specification and the drawings of the present application, or directly or indirectly applied to other related technical fields. The same is included in the scope of patent protection of this application.

Claims

A file generating method, characterized in that the file generating method comprises the following steps:

When the startup command of the service system is detected, acquiring configuration information of the preset type download framework and generating the first row of data of the preset structure;

Forming a preset table according to the configuration information, and writing the first row of data into the preset table;

And if the first row data satisfies the condition of the preset table, generating a file corresponding to the preset table according to the first row data.
The file generating method according to claim 1, wherein the step of generating the first row of data of the preset structure comprises:

Get the second row of data from the database;

Determining a correspondence between the second row of data and a variable in a template file of the manifest download framework;

Based on the second row of data, the first row of data of the map structure is generated according to the correspondence.
The file generating method according to claim 2, wherein the step of creating a preset table according to the configuration information and writing the first row of data into the preset table comprises:

Creating an Excel table according to the configuration information, and writing the first row data of the map structure into the Excel table in a stream form;

If the first row of data meets the condition of the preset table, the step of generating a file corresponding to the preset table according to the first row of data includes:

If the row data satisfies the condition of the Excel table, generating a sheet page header and content corresponding to the Excel file, and determining whether a page change is required according to the size of the first row data to generate an Excel file.
The method for generating a file according to claim 2, wherein the step of determining the correspondence between the second row of data and the variable in the template file of the list download frame further comprises:

The second row of data is stored in a Java virtual machine;

After the step of generating the file corresponding to the preset table according to the first row of data, if the first row of data meets the condition of the preset table, the method further includes:

Deleting the second row of data stored by the Java virtual machine.
The file generating method according to claim 2, wherein the template file corresponding to the list downloading frame comprises a header file template, a content header template, and a content body template.
The file generating method according to claim 1, wherein the step of acquiring the configuration information of the preset type of the download frame of the list when the startup command of the service system is detected includes:

Loading a JAR package of the manifest download framework when a startup command of the business system is detected;

If the JAR package is successfully loaded, the configuration information of the manifest download framework is obtained in the JAR package.
The file generating method according to claim 1, wherein if the first row of data satisfies a condition of the preset table, generating, corresponding to the preset table, according to the first row of data Before the steps of the file, it also includes:

Detecting whether a mandatory parameter field of the first row of data written in the preset table is empty;

And detecting whether the number of columns corresponding to the first row of data is greater than a maximum number of columns in the configuration information.
The file generating method according to claim 2, wherein if the first row of data satisfies the condition of the preset table, generating, corresponding to the preset table, according to the first row of data Before the steps of the file, it also includes:

Detecting whether a mandatory parameter field of the first row of data written in the preset table is empty;

And detecting whether the number of columns corresponding to the first row of data is greater than a maximum number of columns in the configuration information.
The file generating method according to claim 3, wherein if the first row of data satisfies the condition of the preset table, generating, corresponding to the preset table, according to the first row of data Before the steps of the file, it also includes:

Detecting whether a mandatory parameter field of the first row of data written in the preset table is empty;

And detecting whether the number of columns corresponding to the first row of data is greater than a maximum number of columns in the configuration information.
The file generating method according to claim 4, wherein if the first row of data satisfies the condition of the preset table, generating, corresponding to the preset table, according to the first row of data Before the steps of the file, it also includes:

Detecting whether a mandatory parameter field of the first row of data written in the preset table is empty;

And detecting whether the number of columns corresponding to the first row of data is greater than a maximum number of columns in the configuration information.
The file generating method according to claim 5, wherein if the first row of data satisfies the condition of the preset table, generating, corresponding to the preset table, according to the first row of data Before the steps of the file, it also includes:

Detecting whether a mandatory parameter field of the first row of data written in the preset table is empty;

And detecting whether the number of columns corresponding to the first row of data is greater than a maximum number of columns in the configuration information.
The file generating method according to claim 6, wherein if the first row of data satisfies the condition of the preset table, generating, corresponding to the preset table, according to the first row of data Before the steps of the file, it also includes:

Detecting whether a mandatory parameter field of the first row of data written in the preset table is empty;

And detecting whether the number of columns corresponding to the first row of data is greater than a maximum number of columns in the configuration information.
A file generating apparatus, wherein the file generating apparatus comprises:

An obtaining module, configured to acquire configuration information of a preset type downloading framework when detecting a startup instruction of the business system;

Generating a module for generating a first line of data of the preset structure;

a creating module, configured to create a preset table according to the configuration information, and write the first row of data into the preset table;

The generating module is further configured to: if the first row of data meets the condition of the preset table, generate a file corresponding to the preset table according to the first row of data.
The file generating apparatus according to claim 13, wherein said generating module comprises:

An obtaining unit, configured to obtain second row data from a database;

a determining unit, configured to determine a correspondence between the second row of data and a variable in a template file of the manifest download framework;

And a generating unit, configured to generate first row data of the map structure according to the correspondence relationship based on the second row data.
The file generating apparatus according to claim 14, wherein the creating unit is further configured to create an Excel table according to the configuration information, and write the first row data of the map structure into the Excel table in a stream form. ;

The generating module is further configured to: if the row data satisfies the condition of the Excel table, generate a sheet page header and content corresponding to the Excel file, and determine whether the data according to the size of the first row is Need to change pages to generate an Excel file.
The file generating apparatus according to claim 14, wherein the template file corresponding to the list downloading frame comprises a header file template, a content header template, and a content body template.
The file generating apparatus according to claim 13, wherein the obtaining module comprises:

a loading unit, configured to load a JAR package of the list download framework when detecting a startup instruction of the business system;

And an obtaining unit, configured to acquire configuration information of the manifest download framework in the JAR package if the JAR package is successfully loaded.
The file generating apparatus according to claim 13, wherein the file generating apparatus further comprises:

a detecting module, configured to detect whether a mandatory parameter field of the first row of data written in the preset table is empty, and detecting whether a number of columns corresponding to the first row of data is greater than a maximum of the configuration information The number of columns.
A file generating device, comprising: a memory, a processor, and a file generating program stored on the memory and executable on the processor, the file generating program being processed The steps of the file generating method of claim 1 are implemented when executed.
A computer readable storage medium, characterized in that the computer readable storage medium stores a file generation program, and the file generation program is executed by a processor to implement the steps of the file generation method according to claim 1.