Comments by Member 12483338 (Top 3 by date)

Please help me with c++ code. like column mention below.
Need to add below or above row number.
{
VARIANT result, var1;
wstring rangeStr;
IDispatch *pRange;

// Specify a range that selects a single column
VariantInit(&result);
rangeStr = L"C:C";
var1.bstrVal = SysAllocString(rangeStr.c_str());
var1.vt = VT_BSTR;
AutoWrap(DISPATCH_PROPERTYGET, &result, pXlSheet, L"Range", 1, var1);
pRange = result.pdispVal;

// select this range
AutoWrap(DISPATCH_METHOD, NULL, pRange, L"Select", 0);

// insert a new column
AutoWrap(DISPATCH_METHOD, NULL, pRange, L"Insert", 0);

// done with the range. let excel know
pRange->Release();
}

How to add row like column