Form information extraction method based on Excel

The invention relates to the field of informatization, in particular to a form information extraction method based on an Excel, which comprises the following steps of: establishing two database tablesin a database, compiling an Excel table to form a form template, and identifying cells in the form template to form a cell identification Excel template; the server analyzes the cell identification Excel template to form a form information extraction rule; and the user fills in the form and submits the form to the server, and the server extracts form header information and quality inspection iteminformation data in the form according to the form information extraction rule and stores the form header information and the quality inspection item information data in the corresponding database form. The method is applied to development, operation and maintenance of an enterprise information system; software coding knowledge is not needed in the customized development process of the form. According to the method, the d