How to export health declaration forms for teachers and students

Open the excel file, select Tools in the menu bar-Macros, and close excel (no setting is required next time). Double-click the print template, and then click Enable Macro.

Export the reported software data, and copy the corresponding data to the corresponding label in excel according to the grade. If you print the registration card for grade one, you need to copy and paste the exported data of grade one, grade two and grade three.

The nationality code of the data exported by Senior One is converted into Chinese characters, and the physical education teacher, head teacher and class number are inserted after the total score.

Copy and paste the student number to the corresponding position on the printed list label, and the name and seat number are not needed.

Click the print button on the template to print the student's registration card. If you want to print more than one student, you can right-click Print-Specify Macro-Select Print, Select Edit, and put DimKAsLong.