CODEWITHSUNDEEP
c#excelinteropvstoadd-in
woodykiddy
woodykiddy

Reputation: 6455

Invalid index (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX)) when calling AddIns.Item[0]

I am receiving Invalid Index COM exception when calling Excel.AddIns.Item[0].

Excel.AddIns.Count works all right, which returns 4. But I just don't understand why Excel.AddIns.Item[0] fails to return the first Excel.AddIn object. The API doesn't seem to say too much about it either.

http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.addins.item

Upvotes: 2

Views: 9301

Answers (1)

Douglas
Douglas

Reputation: 54917

Most Office interop indexers are one-based, not zero-based (like the rest of the .NET Framework).

You need to access your first element using Excel.AddIns.Item[1].

Subsequently, when looping, use a for loop similar to the following:

for (int i = 1; i <= Excel.AddIns.Count; ++i)

Upvotes: 7

Related Questions