win32 获取Worksheets对象 实例

在Win32中可以使用Excel COM对象来获取Worksheets对象实例，具体代码如下：

#include <windows.h>
#include <ole2.h>
#include <comutil.h>
#include <stdio.h>

int main()
{
    HRESULT hr;

    // 初始化COM库
    hr = CoInitialize(NULL);
    if (FAILED(hr))
    {
        printf("Failed to initialize COM library\n");
        return 1;
    }

    // 创建Excel对象
    IDispatch *pExcel = NULL;
    hr = CoCreateInstance(CLSID_Application, NULL, CLSCTX_LOCAL_SERVER, IID_IDispatch, (void **)&pExcel);
    if (FAILED(hr))
    {
        printf("Failed to create Excel object\n");
        CoUninitialize();
        return 1;
    }

    // 获取Workbooks对象
    VARIANT var_workbooks;
    VariantInit(&var_workbooks);
    hr = pExcel->Invoke(0x0000002f, IID_NULL, LOCALE_SYSTEM_DEFAULT, DISPATCH_PROPERTYGET, &var_workbooks, NULL, NULL, NULL);
    if (FAILED(hr))
    {
        printf("Failed to get Workbooks object\n");
        pExcel->Release();
        CoUninitialize();
        return 1;
    }

    // 打开一个Excel文件
    VARIANT var_filename;
    VariantInit(&var_filename);
    var_filename.vt = VT_BSTR;
    var_filename.bstrVal = SysAllocString(L"C:\\test.xlsx");
    VARIANT var_update_links;
    VariantInit(&var_update_links);
    var_update_links.vt = VT_BOOL;
    var_update_links.boolVal = VARIANT_FALSE;
    VARIANT var_read_only;
    VariantInit(&var_read_only);
    var_read_only.vt = VT_BOOL;
    var_read_only.boolVal = VARIANT_TRUE;
    VARIANT var_format;
    VariantInit(&var_format);
    var_format.vt = VT_BOOL;
    var_format.boolVal = VARIANT_FALSE;
    VARIANT var_password;
    VariantInit(&var_password);
    var_password.vt = VT_BSTR;
    var_password.bstrVal = NULL;
    VARIANT var_write_res_password;
    VariantInit(&var_write_res_password);
    var_write_res_password.vt = VT_BSTR;
    var_write_res_password.bstrVal = NULL;
    VARIANT var_ignore_read_only_recommend;
    VariantInit(&var_ignore_read_only_recommend);
    var_ignore_read_only_recommend.vt = VT_BOOL;
    var_ignore_read_only_recommend.boolVal = VARIANT_TRUE;
    VARIANT var_origin;
    VariantInit(&var_origin);
    var_origin.vt = VT_DISPATCH;
    var_origin.pdispVal = NULL;
    IDispatch *pWorkbook = NULL;
    hr = var_workbooks.pdispVal->Invoke(0x0000002e, IID_NULL, LOCALE_SYSTEM_DEFAULT, DISPATCH_METHOD, NULL, &var_filename, &var_update_links, &var_read_only, &var_format, &var_password, &var_write_res_password, &var_ignore_read_only_recommend, &var_origin, (void **)&pWorkbook);
    if (FAILED(hr))
    {
        printf("Failed to open Excel file\n");
        var_workbooks.pdispVal->Release();
        pExcel->Release();
        CoUninitialize();
        return 1;
    }

    // 获取Worksheets对象
    VARIANT var_sheets;
    VariantInit(&var_sheets);
    hr = pWorkbook->Invoke(0x0000011e, IID_NULL, LOCALE_SYSTEM_DEFAULT, DISPATCH_PROPERTYGET, &var_sheets, NULL, NULL, NULL);
    if (FAILED(hr))
    {
        printf("Failed to get Worksheets object\n");
        pWorkbook->Release();
        var_workbooks.pdispVal->Release();
        pExcel->Release();
        CoUninitialize();
        return 1;
    }

    // 释放资源
    var_sheets.pdispVal->Release();
    pWorkbook->Release();
    var_workbooks.pdispVal->Release();
    pExcel->Release();
    CoUninitialize();

    return 0;
}

在代码中，我们使用了Excel COM对象的Invoke方法来调用Excel的各种方法和属性，通过传入不同的参数实现了获取Workbooks对象、打开Excel文件、获取Worksheets对象等操作。注意，在使用完COM对象后，要记得释放资源。