Loading

COMException Unhandled

richard smith

I am running this code:
string[] lStats= new string[] { "Overboard" };
dynamic totalStats = oXL.ActiveWorkbook.Sheets[1].Cells.Find(lStats, XLFindLookIn.xlValues, XlLookAt.xlWhole).Offset[0,4].Value;

And it throws a COMException was unhandled. Type Mismatch(Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
Accepted answer
I think that the problem here is that you're not passing anything for the second parameter (After) and the run time can't therefore bind the arguments you are passing to the correct parameters.

To deal with this I'd try using 'named' parameters for the second and third arguments:

dynamic totalStats = ws1.Cells.Find(lStats, LookIn : XlFindLookIn.xlValues, LookAt : XlLookAt.xlWhole).Offset[0,4].Value;