Methods of appling Excel in VFP

In the development of management software, it is often necessary to put the query data in Excel for output or secondary exploitation. Both VFP and Excel can be used for the processing of database tables, and it would greatly facilitate our work with a skillful combination of the advantages of both. This paper, based on the development experience of Telecommunications Engineering Business Management System, mainly introduces how to operate Excel files to complete the above functions by directly calling Windows API functions and COM components.