Merging the cells of excel from vc++

Hi guys,

I'm using the COM programming to output an excel file from vc++. I would like to merge the cells using vc++. is it possible?
My excel format:
Some lengthy description that stretch thru 6 cells.
Header1 | Header2 | Header3 | Header4 | Header5 | Header6

I would like to merge the cells of the lengthy description.

Thanks.

I found the following solution while googling.
So I reproduce the method to share with others who may have similar problem. Cheers.

Code:

---

//Merge cells for a range of cells:
BOOL MyClass::MergeCells(long nColumnStart, long nRowStart, long nColumnEnd, long nRowEnd)
{
        VARIANTARG vargSelection;
        if(!GetCellRange(&vargSelection, nColumnStart, nRowStart, nColumnEnd, nRowEnd))
                return FALSE;

        ClearAllArgs();
        AddArgumentBool(NULL, 0, TRUE);
        if (!ExlInvoke(vargSelection.pdispVal, L"MergeCells", NULL, DISPATCH_PROPERTYPUT, 0))
                return FALSE;
       
        return TRUE;
}

---

For full coding, plz refer to:
http://www.codeguru.com/cpp/data/mfc...le.php/c11745/