Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
GetValue() Does Not Work
I use Visual C++ MFC 4.2.
I need to get the value of some cells like in my code below: LPDISPATCH lpDisp = sheet.GetRange( COleVariant( "A8" ), COleVariant( "A10" ) ); VARIANT varRet = range.GetValue(); CString sVar( varRet.bstrVal ); if( sVar.IsEmpty() ){ } The bug is: even if A8 has already been filled with values, it still detect the whole range as Empty. How to fix this? Thank you very much. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
GetValue - Closed Workbook? | Excel Discussion (Misc queries) | |||
GetValue from closed workbook | Excel Programming | |||
Getvalue from closed workbook | Excel Discussion (Misc queries) | |||
getValue | Excel Programming | |||
GetValue to extract data from closed files | Excel Programming |