EXCEL data export method and export device in multi-concurrence large data volume environment

Abstract

The invention discloses an EXCEL data export method in a multi-concurrence large data volume environment. The EXCEL data export method in the multi-concurrence large data volume environment comprises the following steps that (a) configuration information in a configuration file is set, the configuration information comprises data export format information, data table structure information, and the information about the data volume output every time, and the data export format is an xml format; (b) the configuration information is analyzed; (c) user inquiry conditions are obtained; (d) an executable statement of a database is generated, the executable statement of the database is generated according to the user inquiry conditions and the information about the data volume output every time; (e) data conversion and data output are carried out, the data needing exporting are converted and output in batches, and the memory is released every time output is finished. According to the EXCEL data export method and export device in the multi-concurrence large data volume environment, the output data format is defined as the xml format, the EXCEL files with a large data volume are exported in batches, the memory is released every time exportation is finished, and therefore occupation of the memory in the data downloading process can be largely reduced.

Description

technical field [0001] The invention relates to a data export method, in particular to an EXCEL data export method and an export device thereof in a multi-concurrent and large-data-volume environment. Background technique [0002] With the development of information technology, many intelligent platforms currently need to use databases to store various huge process and result data, and many materials and reports are saved, queried, summarized, and exported in the form of EXCEL files, so the query of EXCEL data , Export is very important. [0003] At present, the export of EXCEL data generally uses POI or JXL, two open source tools for editing Excel files, to export data from the server to EXCEL format, and then download. This method is the most direct and convenient, but when the amount of data to be exported is very large, since all data must be stored in the memory first and then exported, and the server memory is limited, the server may be paralyzed. For example, when ex...

AI Technical Summary

Problems solved by technology

This method is the most direct and convenient, but when the amount of data to be exported is very large, since all data must be stored in the memory first and then exported, and the server memory is limited, the server may be paralyzed. For example, when exporting 20 When there are 10,000 pieces of data, the memory occupied by these data may reach 20M. When 100 people use this function at the same time, it will consume 2G of memory. collapse

[0004] At present, there are also some solutions that generate temporary files in the server and then download them. This method will generate disk files and affect service performance.

Images