MFC 操作Excel（国外英文资料）.doc

MFC 操作Excel（国外英文资料） The MFC operation excel (2011-09-07 10:47:33) is reprinted Label: miscellaneous: vc VC operation Excel Excel hierarchy: Application Workbooks Workbook ... Worksheets Worksheet ... The Range The Font Borders ... ... Insert the type library (1) press Ctrl + W to bring up the ClassWizard dialog box in an existing MFC project. (2), Add Class... From a type Library... In Office directory, find what you want to use the Excel type library (Offce2000, this directory in C: \ Program Files \ Microsoft Office \ Office \ EXCEL9 OLB; Offce2003, this directory in C: \ Program Files \ Microsoft Office \ OFFICE11 \ Excel. EXE), Offce2007, this directory in C: \ Program Files \ Microsoft Office \ OFFICE12 \ Excel EXE). Choose excel9.olb or EXCEL. (3) select the classes to be added in the pop-up dialog box, depending on the actual situation. Of course you can do the whole thing 3, the basic operation When you want to use Excel to generate reports, the structure of the table may have a fixed part, which is a template that reduces the burden of coding. The code to load the Excel template is as follows: / / (1) define variables: the following types are the c + + classes automatically defined by the addition of the EXCEL type library, which you can freely use. (_Application, Workbook... etc.) _Application ExcelApp; / / define an Excel application Workbooks wbsBooks; _Workbook wbBook; Worksheets wssSheets; _Worksheet wsSheet; The Range rngXls; FontXls font; / / font BordersXls border; / / frame / / (2) initializers, which are typically placed in the initialization functions of the application class, and are used at the end of the application: CoUninitialize (); Release the COM library. If (: : CoInitialize (NULL) = = E_INVALIDARG) { AfxMessageBox (_T ( initialization Com failed! )) } / / (3) create the Excel2000 server (start Excel) If (! Excelapp.createdispatch (_T ( Excel. Application )) { AfxMessageBox (_T ( create Excel2000 service failure! )) : : CoUninitialize ()