The principle of importing and exporting excel in php

In php, we need to frequently import and export excel files to facilitate backend management. So what is the principle of php importing and exporting excel? Excel is divided into two major versions: excel2007 (suffix . The process of php generating excel is also the process of php generating xml and putting it together. excel2003: essentially a binary file. (Open a binary file and write binary information into it)