3,245
社区成员
发帖
与我相关
我的任务
分享
CString str;
COleVariant vResult;
CRange range;
range.AttachDispatch(m_sheet.get_Cells());
range.AttachDispatch(range.get_Item(COleVariant(m_rowstart+row), COleVariant(m_colstart+col)).pdispVal);
vResult = range.get_Value2();
if (vResult.vt == VT_BSTR)
{
str = vResult.bstrVal;
}
else if (vResult.vt == VT_R8)
{
str.Format("%.0f", vResult.dblVal);
}
else if (vResult.vt == VT_DATE)
{
COleDateTime date(vResult.date);
//str = date.Format(VAR_VALIDDATE);
str = date.Format("%Y-%m-%d %H:%M:%S");
}