使用C语言和 Microsoft Excel COM对象模型打开Excel表格遍历行和列

首先需要使用COM对象模型来打开Excel表格，以下是C语言代码示例：

#include <windows.h>
#include <ole2.h> // 包含了COM对象模型相关的头文件
#include <stdio.h>

void main()
{
    // 初始化COM对象模型
    CoInitialize(NULL);

    // 创建Excel应用程序对象
    IDispatch* pExcelApp;
    CLSID clsid;
    HRESULT hr = CLSIDFromProgID(L"Excel.Application", &clsid);
    if (SUCCEEDED(hr))
    {
        hr = CoCreateInstance(clsid, NULL, CLSCTX_LOCAL_SERVER, IID_IDispatch, (LPVOID*)&pExcelApp);
        if (SUCCEEDED(hr))
        {
            // 显示Excel程序
            VARIANT vtVisible;
            vtVisible.vt = VT_BOOL;
            vtVisible.boolVal = TRUE;
            IDispatch* pWorkbook = NULL;
            VARIANT vtIndex;
            vtIndex.vt = VT_I4;
            vtIndex.lVal = 1;
            VARIANT vtName;
            vtName.vt = VT_BSTR;
            vtName.bstrVal = SysAllocString(L"test.xlsx");
            hr = pExcelApp->Invoke(0x000001C5, IID_NULL, LOCALE_USER_DEFAULT, DISPATCH_PROPERTYPUT, &vtVisible, NULL, NULL, NULL);
            // 打开工作簿
            hr = pExcelApp->Invoke(0x000002E5, IID_NULL, LOCALE_USER_DEFAULT, DISPATCH_METHOD, &vtName, &vtIndex, NULL, NULL);
            if (SUCCEEDED(hr))
            {
                pWorkbook = vtResult.pdispVal;
                // 获取工作表对象
                VARIANT vtSheetIndex;
                vtSheetIndex.vt = VT_I4;
                vtSheetIndex.lVal = 1;
                VARIANT vtSheet;
                hr = pWorkbook->Invoke(0x00000146, IID_NULL, LOCALE_USER_DEFAULT, DISPATCH_PROPERTYGET, &vtSheetIndex, NULL, NULL, NULL);
                if (SUCCEEDED(hr))
                {
                    IDispatch* pSheet = vtResult.pdispVal;
                    // 获取行数和列数
                    VARIANT vtRowNum;
                    VARIANT vtColNum;
                    hr = pSheet->Invoke(0x0000006A, IID_NULL, LOCALE_USER_DEFAULT, DISPATCH_PROPERTYGET, &vtRowNum, NULL, NULL, NULL);
                    hr = pSheet->Invoke(0x0000006B, IID_NULL, LOCALE_USER_DEFAULT, DISPATCH_PROPERTYGET, &vtColNum, NULL, NULL, NULL);
                    int nRowNum = vtRowNum.lVal;
                    int nColNum = vtColNum.lVal;
                    // 遍历每一行和每一列
                    for (int iRow = 1; iRow <= nRowNum; iRow++)
                    {
                        for (int iCol = 1; iCol <= nColNum; iCol++)
                        {
                            VARIANT vtCellIndex;
                            vtCellIndex.vt = VT_I4;
                            vtCellIndex.lVal = iRow * nColNum + iCol;
                            VARIANT vtCellValue;
                            hr = pSheet->Invoke(0x0000006C, IID_NULL, LOCALE_USER_DEFAULT, DISPATCH_PROPERTYGET, &vtCellIndex, NULL, NULL, NULL);
                            if (SUCCEEDED(hr))
                            {
                                printf("%d ", vtCellValue.lVal);
                            }
                        }
                        printf("\n");
                    }
                    // 释放工作表对象
                    pSheet->Release();
                }
                // 关闭工作簿
                hr = pWorkbook->Invoke(0x0000012E, IID_NULL, LOCALE_USER_DEFAULT, DISPATCH_METHOD, NULL, NULL, NULL, NULL);
            }
            // 关闭Excel程序
            hr = pExcelApp->Invoke(0x00000127, IID_NULL, LOCALE_USER_DEFAULT, DISPATCH_METHOD, NULL, NULL, NULL, NULL);
            pExcelApp->Release();
        }
    }

    // 释放COM对象模型
    CoUninitialize();
}

以上代码可以打开名为“test.xlsx”的Excel表格，并遍历每一个单元格的值。你可以根据需要修改代码实现其他功能。