The invention provides a variable column Excel file
analysis method and
system, and the method comprises the steps: carrying out the header
verification of a to-be-analyzed Excel file and a basic template file, determining the type of product detection data, recording the mapping relation between a file path and the type, and transmitting the mapping relation to message-oriented
middleware MQ; after monitoring the message, enabling the message-oriented
middleware MQ consumption terminal to acquire a mapping relationship, use the type of the message-oriented
middleware MQ consumption terminal for loading a pre-established analysis object
java model, and load an Excel file corresponding to the file path into a memory; reading each row of data of the Excel file in the memory, and storing thedata in the corresponding
parsing object
java model; and serializing the analysis object
java model with the stored data into a
JSON string, and sending the
JSON string to Kafka for
library falling. The variable column Excel file
analysis method is adopted, the problem that factory product detection data enter a
database is solved, and
digitization of the factory product detection data is facilitated.