The invention discloses an online editing method and
system for importing an Excel file and a storage medium, and the method comprises the following steps: importing the Excel file, recording a user import
record, and verifying the consistency of a header and a template file; asynchronously reading data, updating an import state to be that analysis is started, filtering null rows, and carrying out user-defined
annotation analysis on a target column; verifying the data line by line and column by column according to a preset rule, identifying the content of the image data, extracting keywords and verifying the keywords, recording line and column information and results, and marking the results to be abnormal; after the user submits, the updating state is completed, and if the exception is not handled, the table without the exception value is returned; the front end verifies the task state, if the task state is not completed, timed
polling is carried out, data is displayed after a result is obtained, abnormity is marked, a modification entry is provided, and the result is returned. The problems that switching and editing are tedious,
error checking is difficult, picture checking is low in efficiency and rule adaptability is poor are solved, and online
exception handling, accurate error positioning, large-model-assisted picture compliance checking and multi-business scene
adaptation are achieved.