System and method for achieving Excel data import and export based on similar SQL

Abstract

The invention discloses a system and method for achieving Excel data import and export based on a similar SQL, the system comprises a display layer, a general import and export system and a service system, the general import and export system comprises a task manager, a template analyzer, an actuator and an output device, and the general import and export system achieves the execution function of the whole task. The problems of long waiting time of synchronous import and export and synchronous response failure of import and export in the prior art are avoided, repeated historical data can be inquired directly through history without increasing the load of the system again, the use friendliness to clients is greatly improved, and the use threshold is reduced. The business development process is greatly accelerated, the development task of 2-3 days in the past is shortened to be within one day, most of logic which is prone to generating errors is avoided, and fast and stable support of the business is guaranteed. After the import and export logic is collected and edited, for later system upgrading and function adding, more universal expansibility is achieved.

Description

technical field [0001] The invention belongs to the technical field of data processing, and in particular relates to a system and method for implementing Excel data import and export based on SQL-like. Background technique [0002] As a management background for merchants and operations, there are usually more management requirements for configuration data and sales data, such as batch online / offline products, order reconciliation, etc., so the system needs to provide more through files. For data upload and download functions, the existing Excel data import and export has the following problems: importing and exporting large files takes a long time, and synchronization fails; the development cycle of a single function is long and error-prone, and the code redundancy cannot be shared. Contents of the invention [0003] The technical problem to be solved by the present invention is to provide a system and method for implementing Excel data import and export based on SQL-like...

AI Technical Summary

Problems solved by technology

[0002] As a management background for merchants and operations, there are usually more management requirements for configuration data and sales data, such as batch online / offline products, order reconciliation, etc., so the system needs to provide more through files. The function of data upload and download, the existing Excel data import and export have the following problems: import and export large files, if it takes a long time, the synchronization fails; the development cycle of a single function is long and error-prone, and the code redundancy cannot be shared

Images