C语言 Win32 API GetIDsOfNames 获取Excel表格 Rows行数

要使用Win32 API GetIDsOfNames获取Excel表格的行数，你需要使用COM（Component Object Model）接口来访问Excel应用程序。以下是一个简单的示例代码：

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

int main()
{
    // 初始化COM库
    CoInitialize(NULL);

    // 创建Excel应用程序对象
    CLSID clsid;
    HRESULT hr = CLSIDFromProgID(L"Excel.Application", &clsid);
    IDispatch* pExcelApp = NULL;
    hr = CoCreateInstance(clsid, NULL, CLSCTX_LOCAL_SERVER, IID_IDispatch, (void**)&pExcelApp);

    // 获取Workbooks集合
    VARIANT result;
    VariantInit(&result);
    DISPID dispidNamed = DISPID_PROPERTYPUT;
    DISPPARAMS params = { NULL, NULL, 0, 0 };
    OLECHAR* szMember = L"Workbooks";
    hr = pExcelApp->GetIDsOfNames(IID_NULL, &szMember, 1, LOCALE_USER_DEFAULT, &dispidNamed);
    hr = pExcelApp->Invoke(dispidNamed, IID_NULL, LOCALE_SYSTEM_DEFAULT, DISPATCH_PROPERTYGET, &params, &result, NULL, NULL);

    // 获取ActiveWorkbook对象
    IDispatch* pWorkbook = NULL;
    szMember = L"ActiveWorkbook";
    hr = result.pdispVal->GetIDsOfNames(IID_NULL, &szMember, 1, LOCALE_USER_DEFAULT, &dispidNamed);
    hr = result.pdispVal->Invoke(dispidNamed, IID_NULL, LOCALE_SYSTEM_DEFAULT, DISPATCH_PROPERTYGET, &params, &result, NULL, NULL);
    pWorkbook = result.pdispVal;

    // 获取ActiveSheet对象
    IDispatch* pActiveSheet = NULL;
    szMember = L"ActiveSheet";
    hr = pWorkbook->GetIDsOfNames(IID_NULL, &szMember, 1, LOCALE_USER_DEFAULT, &dispidNamed);
    hr = pWorkbook->Invoke(dispidNamed, IID_NULL, LOCALE_SYSTEM_DEFAULT, DISPATCH_PROPERTYGET, &params, &result, NULL, NULL);
    pActiveSheet = result.pdispVal;

    // 获取Rows属性
    szMember = L"Rows";
    hr = pActiveSheet->GetIDsOfNames(IID_NULL, &szMember, 1, LOCALE_USER_DEFAULT, &dispidNamed);
    hr = pActiveSheet->Invoke(dispidNamed, IID_NULL, LOCALE_SYSTEM_DEFAULT, DISPATCH_PROPERTYGET, &params, &result, NULL, NULL);

    // 获取Count属性
    IDispatch* pRows = result.pdispVal;
    szMember = L"Count";
    hr = pRows->GetIDsOfNames(IID_NULL, &szMember, 1, LOCALE_USER_DEFAULT, &dispidNamed);
    hr = pRows->Invoke(dispidNamed, IID_NULL, LOCALE_SYSTEM_DEFAULT, DISPATCH_PROPERTYGET, &params, &result, NULL, NULL);

    // 输出行数
    printf("Rows: %d\n", result.lVal);

    // 释放COM对象
    pRows->Release();
    pActiveSheet->Release();
    pWorkbook->Release();
    pExcelApp->Release();
    CoUninitialize();

    return 0;
}

注意，你需要在链接器设置中添加`ole32.lib`和`oleaut32.lib`库文件。此外，你需要先打开一个Excel文档，并确保有一个活动的工作表。