Excel table automatic merging method and device, computer equipment and medium

Abstract

The invention relates to the technical field of computers, and discloses an Excel table automatic merging method, device and equipment and a medium, the method comprises the steps that all Excel file lists in a folder to be processed are automatically read, and the Excel file lists comprise at least two different types of tables; circularly opening all Excel files in the folder to be processed; correspondingly matching preset different types of table merging rules according to the file names of the opened different types of Excel files; and merging the Excel files of the same type into one table according to the correspondingly matched table merging rule. According to the scheme, the type of the table is automatically identified through the file name, and the table is merged by adapting to the preset corresponding table merging rule, so that the requirement of manual operation is greatly reduced, and meanwhile, the possibility of errors in the data processing process is reduced.

Images