Based on Excel table of the campus one-stop service system, this paper mainly introduces the interactive examples of batch data import and export of Excel table with PHPExcel class, and summarizes some methods, techniques and notes of PHPExcel class. For the actual project, the batch data operation of Excel table has signed and guiding significance.