colevariant(_colevariant_colevariant用法(2)

this->MessageBox(CString(rValue.bstrVal));

2)

//读取第一个单元格的值

range.AttachDispatch(sheet.GetCells());

range.AttachDispatch(range.GetItem (COleVariant((long)1),COleVariant((long)1)).pdispVal );

vResult =range.GetValue();

CString str;

if(vResult.vt == VT_BSTR) //字符串

{

str=vResult.bstrVal;

}

else if (vResult.vt==VT_R8) //8字节的数字

{

str.Format(L"%f",vResult.dblVal);

}

else if(vResult.vt==VT_DATE) //时间格式

{

SYSTEMTIME st;

VariantTimeToSystemTime((long)&vResult.date, &st);

}

else if(vResult.vt==VT_EMPTY) //单元格空的

{

str="";

本文来自电脑杂谈，转载请注明本文网址：
http://www.pc-fly.com/a/jisuanjixue/article-27729-2.html