Excel. cpp and Excel. h

Excel. CPP and excel. H is obtained from the Excel Type Library. The Type Library is similar to the header file in C ++, including the definition of interfaces, methods, and attributes. The Type Library can be found in the Excel installation directory, different Excel versions have different types of databases, as shown below:

Excel 95 and prior: xl5en32. olb

Excel 97: excel8.olb

Excel 2000: excel9.olb

Excel 2002: excel.exe

Excel 2003: excel.exe

The specific method for obtaining data is as follows:

1. Create an MFC-based EXE project using VC ++

2. Click "View" --> "create Class Wizard". The "MFC classwizard" dialog box appears.

3. click "add class" --> "from a type libray" to specify the type libray of Excel, which can be found in the Excel installation directory, for example, "D: \ Microsoft Office \ excel9.olb"

4. In the pop-up dialog box, select the desired class and press "OK". Excel. cpp and Excel. h are generated.