Thread: 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/