使用C++ .NET和MFC自动化创建及格式化Excel工作簿

How To Automate Excel to Create And Format a New Workbook Using C++ .NET and MFC
 

Article ID: 308292 - View products that this article applies to.
This article was previously published under Q308292
For a Microsoft Visual Basic .NET version of this article, see 301982
For a Microsoft Visual C# .NET version of this article, see 302084


Note Microsoft Visual C++ .NET (2002) supports both the managed code model that is provided by the Microsoft .NET Framework and the unmanaged native Microsoft Windows code model. The information in this article applies only to unmanaged Visual C++ code.
Back to the top | Give Feedback

SUMMARY

This article demonstrates how to create an Automation client for Excel by using Microsoft Foundation Classes (MFC) and Visual C++ .NET. 
Back to the top | Give Feedback

MORE INFORMATION

 Automation is a process that allows applications that are written in languages such as MFC to programmatically control other applications. Automation to Excel allows you to perform actions such as creating a new workbook, adding data to the workbook, or creating charts. With Excel and other Microsoft Office applications, virtually all of the actions that you can perform manually through the user interface can also be performed programmatically by using Automation.

 Excel exposes this programmatic functionality through an object model. The object model is a collection of classes and methods that serve as counterparts to the logical components of Excel. For example, there is an Application object, a Workbook object, and a Worksheet object, each of which contain the functionality of those pieces of Excel. To access the object model from MFC and Visual C++ .NET, you can create an MFC wrapper class from Excel's type library.

 This article demonstrates how to use the wrapper classes that are generated by MFC to create and format a new workbook by using Visual C++ .NET. 
Create an Automation Client for Microsoft Excel
1.Follow the steps in the "Create an Automation Client" section of the following Microsoft Knowledge Base article to create a basic Automation client: 
307473

 How To Use a Type Library for Office Automation from Visual C++ .NET In step 4d of the article, select the following interfaces:

?_Application
?Workbooks
?_Workbook
?Worksheets
?_Worksheet
?Range
?Font
?Interior
?Borders
?Border

 In step 6 of the article (where you add #include statements for each of the classes for which you generated wrappers), note that the file for the Font class is CFont0.h and the file for the Interior class is Cnterior.h.
2.In the IDD_AUTOPROJECT_DIALOG dialog box, right-click Run and select Add event handler. In the Event Handler Wizard, select the BN_CLICKED message type and then click Add and Edit. Add the following code in the handler for automating Excel:

void CAutoProjectDlg::OnBnClickedRun()
{
   // Commonly used OLE variants.
   COleVariant
      covTrue((short)TRUE),
      covFalse((short)FALSE),
      covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR);

   CApplication app;
   CWorkbooks books;
   CWorkbook book;
   CWorksheets sheets;
   CWorksheet sheet;
   CRange range;