mfc在excel中画图

可以使用MFC中的COleDispatchDriver类来调用Excel的COM组件来画图。以下是一个简单的示例代码：

1. 首先需要在头文件中包含Excel的类型库：

#import "C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE" \
    rename("DialogBox", "ExcelDialogBox") \
    rename("RGB", "ExcelRGB")

这里的路径是根据你的安装目录来定的，需要根据实际情况进行修改。

2. 在需要画图的位置，创建Excel的应用程序对象和工作簿对象：

// 创建Excel应用程序对象
CExcelApp excel;
if (!excel.CreateDispatch(_T("Excel.Application")))
{
    AfxMessageBox(_T("Failed to create Excel application object."));
    return;
}

// 创建工作簿对象
COleVariant covTrue((short)TRUE), covFalse((short)FALSE), covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR);
COleVariant covWorkbook;
covWorkbook.vt = VT_DISPATCH;
covWorkbook.pdispVal = excel.GetWorkbooks()->Add(covOptional);

3. 在工作簿中添加一个工作表，并获取该工作表的范围：

// 添加一个工作表
COleVariant covWorksheetName((LPCTSTR)_T("My Worksheet"));
COleVariant covWorksheet;
covWorksheet.vt = VT_DISPATCH;
covWorksheet.pdispVal = covWorkbook.pdispVal->GetIDispatch(FALSE);
covWorksheet = excel.GetSheets()->Add(covOptional, covWorksheet, covOptional, covOptional);
covWorksheet.pdispVal->PutName(covOptional, covWorksheetName);

// 获取工作表的范围
COleVariant covRange;
covRange.vt = VT_DISPATCH;
covRange.pdispVal = covWorksheet.pdispVal->InvokeHelper(dispidGetRange, DISPATCH_PROPERTYGET, covOptional, covOptional).pdispVal;

4. 在工作表中设置数据并使用ChartWizard创建图表：

// 设置数据
COleSafeArray saData;
saData.CreateOneDim(VT_R8, 10);
for (long i = 0; i < 10; i++)
{
    double value = i * i;
    saData.PutElement(&i, &value);
}
covRange.put_Value(saData);

// 使用ChartWizard创建图表
COleVariant covChart;
covChart.vt = VT_DISPATCH;
covChart.pdispVal = covWorksheet.pdispVal->InvokeHelper(dispidChartWizard, DISPATCH_METHOD, covOptional,
    COleVariant((long)chChartTypeColumnClustered), COleVariant((long)2), COleVariant((long)1),
    COleVariant(_T("My Series")), COleVariant(_T("X Axis")), COleVariant(_T("Y Axis")), covOptional, covOptional, covOptional,
    covOptional, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional).pdispVal;

5. 释放资源：

// 释放资源
if (covWorkbook.pdispVal != NULL)
{
    covWorkbook.pdispVal->Release();
}
excel.Quit();

通过以上代码，就可以在MFC应用程序中使用Excel的COM组件来画图了。需要注意的是，需要在链接器的附加依赖项中添加"oleaut32.lib"和"ole32.lib"。