A method and device for implementing Excel import and export

Abstract

The invention discloses an implementation method and device for Excel import and export, and relates to the technical field of data processing. A terminal is used as a service entrance for Excel import and export operations. When the Excel import and export operations are performed, a new Excel export and import record is added, and a corresponding message is sent to a message queue. The message queue receives the message and starts to call the export and import operations of Excel data. After the export and import operations are completed, the Excel file is uploaded, and the record status of the Excel export and import is updated. The Excel file upload page is accessed through the terminal to download the Excel file to a specified location.

Description

Technical Field

[0001] The invention discloses an implementation method and a device, and relates to the technical field of data processing, in particular to an implementation method and a device for Excel import and export. Background Art

[0002] In the current information construction process, various business systems often need to use Excel import and export services in the process of business handling, so that users can effectively manage data, verify and report data offline, and upload data through the system. However, the existing POI direct export method will occupy a large amount of application server memory when exporting and importing large quantities of data, which can easily cause system freezes or even serious problems such as memory overflow of the application server. Summary of the invention

[0003] In view of the problems of the prior art, the present invention provides an implementation method and device for Excel import and export, which solves the problem that a large amount of memory is occupied by an application server during import and export, and based on the asynchronous message mode of the message queue, it will not affect the user's handling of business during import and export, greatly improves the efficiency of user business handling, and at the same time improves the security of the system.

[0004] The specific scheme proposed by the present invention is:

[0005] A method for implementing Excel import and export: using a terminal as a service entry for Excel import and export operations, adding Excel import and export records when performing Excel import and export operations, and sending corresponding messages to a message queue at the same time.

[0006] The message queue receives the message and starts to call the export and import operation of the Excel data. After the export and import operation is completed, the Excel file is uploaded and the record status of the Excel export and import is updated.

[0007] Access the Excel file upload page through the terminal and download the Excel file to the specified location.

[0008] In the Excel import and export implementation method, the Excel import and export records include user information, export data screening conditions and export status.

[0009] In the implementation method of the Excel import and export, after the corresponding message is successfully sent to the message queue, the front page is released through the terminal, and the waiting time is skipped to handle other business.

[0010] In the implementation method of Excel import and export, the Excel files to be exported and imported are stored in a non-relational database.

[0011] A system for implementing Excel import and export, including a user terminal module, a data storage module and a message queue module.

[0012] The user terminal module uses the terminal as the service entry for Excel import and export operations. When performing Excel import and export operations, the user terminal module will add Excel export and import records to the data storage module and send corresponding messages to the message queue module.

[0013] The message queue module receives the message and starts to call the export and import operation of the Excel data. After the export and import operation is completed, the Excel file is uploaded and the record status of the Excel export and import in the data storage module is updated.

[0014] The user terminal module accesses the Excel file upload page through the terminal and downloads the Excel file to the specified location.

[0015] The records of Excel import and export in the Excel import and export implementation system include user information, screening conditions for export data and export status.

[0016] In the Excel import and export implementation system, after the user terminal module successfully sends the corresponding message to the message queue module, the front page is released through the terminal, and the waiting time is skipped to handle other business.

[0017] A device for implementing Excel import and export is a terminal, comprising at least one memory and at least one processor;

[0018] The at least one memory is used to store a machine-readable program;

[0019] The at least one processor is used to call the machine-readable program to execute the Excel import and export implementation method.

[0020] The benefits of the present invention are:

[0021] The invention provides an implementation method for Excel import and export. When performing Excel import and export operations, a record of Excel import and export is newly added, and a corresponding message is sent to a message queue. After receiving the message, the message queue starts to call the import and export operations of Excel data. After the import and export operations are completed, an Excel file is uploaded, and the record status of the Excel import and export is updated. The Excel file upload page is accessed through a terminal to download the Excel file to a specified location. The method of the invention not only solves the problem that a large amount of memory is occupied by an application server during import and export, but also, because it is an asynchronous method, it will not affect the handling of services by users during export and import, greatly reduces the efficiency of user service handling, and improves the security of the system. At the same time, the import and export status of the Excel file can be monitored, and the user experience and the efficiency of service handling can be improved. BRIEF DESCRIPTION OF THE DRAWINGS

[0022] Figure 1 It is a schematic diagram of the application flow of the system of the present invention. DETAILED DESCRIPTION

[0023] A message queue is a container that holds messages while they are in transit. A message queue acts as a middleman in relaying a message from its source to its destination. The main purpose of a queue is to provide routing and guarantee the delivery of messages; if the recipient is unavailable when a message is sent, the message queue holds the message until it can be successfully delivered.

[0024] Asynchronous messages, as the name implies, are sent asynchronously. The message sender does not need to wait for the message consumer to process the message, or even wait for the message delivery to be completed before continuing to send the message.

[0025] The present invention is further described below in conjunction with the accompanying drawings and specific embodiments so that those skilled in the art can better understand the present invention and implement it, but the embodiments are not intended to limit the present invention.

[0026] The present invention provides an implementation method of Excel import and export: using a terminal as a service entrance for Excel import and export operations, adding Excel import and export records when performing Excel import and export operations, and sending corresponding messages to a message queue at the same time.

[0027] The message queue receives the message and starts to call the export and import operation of the Excel data. After the export and import operation is completed, the Excel file is uploaded and the record status of the Excel export and import is updated.

[0028] Access the Excel file upload page through the terminal and download the Excel file to the specified location.

[0029] The method of the present invention not only solves the problem that a large amount of memory is occupied by the application server during import and export, but also, because it is an asynchronous method, it will not affect the user's handling of business during export and import, greatly reducing the efficiency of user business handling and improving the security of the system.

[0030] In one embodiment of the method of the present invention, the terminal serves as a service entry for users to perform Excel import and export operations. When the user performs Excel export (import) operations, a new export (import) record is added, including user information, export data screening conditions and export status, and a message is sent to the message queue at the same time. When the message is sent successfully, the user terminal module releases the front page, and the user can skip the waiting time to handle other services.

[0031] When the message queue receives the message, it starts to call the data export and import operations. After the export and import are completed, the file is uploaded and the record status is updated.

[0032] When the user accesses the export (import) page from the user terminal, the file has been generated, and the user can download the file to the specified location to complete the entire export (import) process.

[0033] The present invention also provides an Excel import and export implementation system, including a user terminal module, a data storage module and a message queue module.

[0034] The user terminal module uses the terminal as the service entry for Excel import and export operations. When performing Excel import and export operations, the user terminal module will add Excel export and import records to the data storage module and send corresponding messages to the message queue module.

[0035] The message queue module receives the message and starts to call the export and import operation of the Excel data. After the export and import operation is completed, the Excel file is uploaded and the record status of the Excel export and import in the data storage module is updated.

[0036] The user terminal module accesses the Excel file upload page through the terminal and downloads the Excel file to the specified location.

[0037] The system of the present invention not only solves the problem of a large amount of memory being occupied by the application server during import and export, but also, because it is an asynchronous method, it will not affect the user's business handling during export and import, greatly reducing the efficiency of user business handling and improving the security of the system.

[0038] In one embodiment of the system of the present invention, the user terminal module uses the terminal as the service entry for the user to perform Excel import and export operations. When the user performs Excel export (import) operations, the user terminal module will add an export (import) record to the data storage module, including user information, export data screening conditions and export status, and send a message to the message queue module. When the message is sent successfully, the user terminal module releases the front page. At this time, the user can skip the waiting time to handle other business. When the message queue module receives the message, it starts to call the import and export service module to export the data. After the export is completed, the file is uploaded to the file storage module for storage, and the status of the record in the data storage module is updated.

[0039] When the user revisits the export (import) page from the user terminal module, the file has been generated, and the user can download the file from the file storage module to the specified location to complete the entire export (import) process.

[0040] In the above process, the file storage module uses non-relational database storage to achieve high concurrency operations.

[0041] The present invention also provides an implementation device for Excel import and export, which is a terminal including at least one memory and at least one processor;

[0042] The at least one memory is used to store a machine-readable program;

[0043] The at least one processor is used to call the machine-readable program to execute the Excel import and export implementation method.

[0044] In the above process, the terminal can be an existing mobile phone, IPD, smart watch, etc. The information interaction, execution process, etc. between the units in the above terminal are based on the same concept as the embodiment of the method of the present invention. The specific contents can be found in the description of the embodiment of the method of the present invention, and will not be repeated here.

[0045] It should be noted that not all steps and modules in the above-mentioned processes and system structures are necessary, and some steps or modules can be ignored according to actual needs. The execution order of each step is not fixed and can be adjusted as needed. The system structure described in the above-mentioned embodiments can be a physical structure or a logical structure, that is, some modules may be implemented by the same physical entity, or some modules may be implemented by multiple physical entities, or some components in multiple independent devices may be implemented together.

[0046] The above-described embodiments are only preferred embodiments for fully illustrating the present invention, and the protection scope of the present invention is not limited thereto. Equivalent substitutions or changes made by those skilled in the art based on the present invention are within the protection scope of the present invention. The protection scope of the present invention shall be subject to the claims.

Claims

1. A method for implementing Excel import and export, characterized by Use the terminal as the service entry for Excel import and export operations. When performing Excel import and export operations, add Excel import and export records, which include user information, export data screening conditions, and export status. At the same time, send corresponding messages to the message queue. After successfully sending the corresponding message to the message queue, release the front page through the terminal, skip the waiting time to handle other business, The message queue receives the message and starts to call the export and import operation of the Excel data. After the export and import operation is completed, the Excel file is uploaded and the record status of the Excel export and import is updated. Access the Excel file upload page through the terminal, download the Excel file to the specified location, and store the exported and imported Excel files through a non-relational database.

2. A system for implementing Excel import and export, characterized by It includes user terminal module, data storage module and message queue module. The user terminal module uses the terminal as the service entry for Excel import and export operations. When performing Excel import and export operations, the user terminal module will add Excel import and export records to the data storage module, including user information, export data screening conditions and export status, and send corresponding messages to the message queue module at the same time. After the user terminal module successfully sends the corresponding message to the message queue module, the front page is released through the terminal, skipping the waiting time to handle other business. The message queue module receives the message and starts to call the export and import operations of the Excel data. After the export and import operations are completed, the Excel file is uploaded and the record status of the Excel export and import in the data storage module is updated. The user terminal module accesses the Excel file upload page through the terminal, downloads the Excel file to the specified location, and stores the exported and imported Excel files through a non-relational database.

3. A device for implementing Excel import and export, characterized in that A terminal comprising at least one memory and at least one processor; The at least one memory is used to store a machine-readable program; The at least one processor is used to call the machine-readable program to execute the Excel import and export implementation method described in claim 1.

Images