I need to summarize all the EXCEL table data in the given folder, into a given EXCEL table, write Python requirements as follows: 1. In the sub-table, the columns are candidate number, candidate name, ...
The application automatically creates student_data.csv with sample records the first time it runs. Add your own records from the Add Student page. Keep the CSV file in the same folder as main.py.