C++ win32com操作excel

使用C++操作Excel需要使用Win32 API和COM接口。以下是一个简单的示例代码，可以打开Excel应用程序并创建一个工作簿：

#include <windows.h>
#include <ole2.h>
#include <olectl.h>
#include <ocidl.h>

void main()
{
    HRESULT hr;
    CoInitialize(NULL);

    // 创建Excel应用程序
    IDispatch* pExcelApp = NULL;
    hr = CoCreateInstance(CLSID_Application, NULL, CLSCTX_LOCAL_SERVER, IID_IDispatch, (LPVOID*)&pExcelApp);
    if (FAILED(hr))
    {
        CoUninitialize();
        return;
    }

    // 设置Visible属性为TRUE
    VARIANT vtVisible;
    vtVisible.vt = VT_BOOL;
    vtVisible.boolVal = TRUE;
    DISPID dispid;
    hr = pExcelApp->GetIDsOfNames(IID_NULL, L"Visible", 1, LOCALE_SYSTEM_DEFAULT, &dispid);
    if (FAILED(hr))
    {
        pExcelApp->Release();
        CoUninitialize();
        return;
    }
    DISPPARAMS params = { NULL, NULL, 0, 0 };
    hr = pExcelApp->Invoke(dispid, IID_NULL, LOCALE_SYSTEM_DEFAULT, DISPATCH_PROPERTYPUT, &params, &vtVisible, NULL, NULL);
    if (FAILED(hr))
    {
        pExcelApp->Release();
        CoUninitialize();
        return;
    }

    // 创建一个工作簿
    IDispatch* pWorkbooks = NULL;
    DISPID workbooksID;
    hr = pExcelApp->GetIDsOfNames(IID_NULL, L"Workbooks", 1, LOCALE_SYSTEM_DEFAULT, &workbooksID);
    if (FAILED(hr))
    {
        pExcelApp->Release();
        CoUninitialize();
        return;
    }
    hr = pExcelApp->Invoke(workbooksID, IID_NULL, LOCALE_SYSTEM_DEFAULT, DISPATCH_PROPERTYGET, &params, &pWorkbooks, NULL, NULL);
    if (FAILED(hr))
    {
        pExcelApp->Release();
        CoUninitialize();
        return;
    }
    IDispatch* pWorkbook = NULL;
    VARIANT vtIndex;
    vtIndex.vt = VT_I4;
    vtIndex.lVal = 1;
    hr = pWorkbooks->Invoke(dispid, IID_NULL, LOCALE_SYSTEM_DEFAULT, DISPATCH_PROPERTYGET, &params, &pWorkbook, NULL, NULL);
    if (FAILED(hr))
    {
        pWorkbooks->Release();
        pExcelApp->Release();
        CoUninitialize();
        return;
    }

    // 关闭Excel
    VARIANT vtSaveChanges;
    vtSaveChanges.vt = VT_BOOL;
    vtSaveChanges.boolVal = FALSE;
    hr = pWorkbook->Invoke(dispid, IID_NULL, LOCALE_SYSTEM_DEFAULT, DISPATCH_METHOD, &params, NULL, NULL, NULL);
    if (FAILED(hr))
    {
        pWorkbook->Release();
        pWorkbooks->Release();
        pExcelApp->Release();
        CoUninitialize();
        return;
    }
    pWorkbook->Release();
    pWorkbooks->Release();

    pExcelApp->Release();
    CoUninitialize();
}

这只是一个简单的示例，你需要根据自己的需求进一步完善代码。同时，你需要在代码中添加错误处理逻辑以避免程序崩溃。