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

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();

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

CWorksheet      m_WorkSheet;
CString bCell;
CString eCell;
bCell = _T("A1");
eCell = _T("A1");
CRange0 Range = m_WorkSheet.get_Range(COleVariant(bCell),COleVariant(eCell));
CRange0 RangeMergeArea = Range.get_MergeArea();
CRange0 RangeColumns= RangeMergeArea.get_Columns();
CRange0 RangeRows= RangeMergeArea.get_Rows();

int  count = RangeMergeArea.get_Count();

int Columns = RangeColumns.get_Count();
int Rows = RangeRows.get_Count();