The invention relates to an Excel annotation-based report generation method. The method comprises the following steps: defining a script format, and generating a data dictionary and an analytic program; generating an Excel report file; judging whether cells of the Excel report file needs automatically filling in or not, if yes, adding Excel cell annotation according to the data dictionary, and binding database content; if not, directly adding the Excel cell annotation, and describing basic information of a report; calling the report file by utilizing the analytic program to form a result report. Compared with the prior art, the Excel annotation-based report generation method has the advantages of being wide in applicability, simple to manufacture, convenient to change, simple in software maintenance, low in professional requirement and the like.