The invention relates to the technical field of excel data, and discloses a million-level excel data quick and stable import
system, which comprises the following steps: step 1, after starting to read data and load an excel file, adopting a line-by-line data reading mode to avoid overflowing of a memory of the
system due to the fact that the data is completely loaded into the memory; quickly and stably importing the million-level excel data into the
system; through using read-write separation, one thread
queue being responsible for reading data;
processing data, then putting into a data
queue pool; meanwhile, the other thread
queue being responsible for obtaining data from the data queue
pool; writing data into a
database by multiple threads simultaneously; no longer executing the two steps synchronously. The data are imported in batches without influencing the importing speed along with the increase of excel content, and meanwhile, the method supports multiple threads to write the data into a
database, so that the importing speed is greatly increased, and the importing speed is always kept within a relatively
constant speed range value.