vc操作Excel无法获取合并单元格的行列数

Question

COleVariant rangeVal = range.GetValue();
rangeVal.ChangeType(VT_BSTR);
CString beginval = rangeVal.bstrVal;

        range.AttachDispatch(sheet.GetCells(),TRUE);
        //range.AttachDispatch(sheet.GetUsedRange());//加载已使用的单元格  
        unionRange = sheet.GetRange(_variant_t(nCel),_variant_t(nCel));

        COleVariant vResult;
        vResult = unionRange.GetMergeCells();
        if (vResult.boolVal==-1)
        {
            //EXCEL9::Range rangeHeTemp;
            //获取行数
            range.AttachDispatch(unionRange.GetRows(),TRUE);
            long hang = range.GetCount();

            //获取列数
            range.AttachDispatch(unionRange.GetColumns(),TRUE);
            long lie = range.GetCount();

Answer 1

现在有办法获取行数、列数么？