High-performance excel exporting method based on asynchronous task

Abstract

The invention discloses a high-performance excel export method based on an asynchronous task, which comprises the following steps of: (1) generating an export task according to an event needing to be processed, and configuring export task file parameters by providing an interface; (2) operating an export task to realize data processing; the data processing process comprises the steps of obtaining business data, realizing business data caching in combination with a redis cache database, obtaining export strategy data, realizing asynchronous data processing in combination with a RabbitMQ queue, and realizing a user-defined export universal mode by using EasyExcel in combination with an export strategy; and (3) uploading and backing up the file in combination with a third-party cloud storage service, and exporting the file. According to the method, data processing is unified, the export number can be configured, a segmented export mode is achieved in the execution process, the user experience degree is improved to the maximum degree, the requirement for system decoupling of services is met, and meanwhile the system throughput is reduced.

Description

technical field [0001] The invention belongs to the technical field of network data processing, in particular to a high-performance excel export method based on asynchronous tasks. Background technique [0002] Due to the rapid development of the Internet, the related businesses of the Internet industry are becoming more and more complex, the amount of business data is also increasing, and the demand for business data display and statistics is also becoming more and more common. Excel is one of the most popular file formats for users today, and users cannot help but put forward higher requirements on the performance, user experience and display diversity of the business data carried in the excel file format exported by the business system they use. [0003] At present, there is a need to update the existing data technology, which requires not only simple system assembly, but also universal and unified files, configurable export quantity, configuration file compression quanti...

AI Technical Summary

Problems solved by technology

Due to the limitations of the technology used, there are generally some experiential requirements for user-defined requirements, such as multi-dimensional display of custom headers, segmented export of custom files, real-time control of custom export tasks, etc. Difficult to achieve

But in fact, in the face of more and more complex businesses, user needs will become more and more diverse. Neglecting user experience or satisfying user experience at the expense of system performance may reduce the system life cycle and improve system maintenance. Costs, reducing business benefits and other issues

Images