Get index of item in list of element

[filippo.costantin3HZMT]

Hi everyone, 

I need to read a coloumn of Excel file and create a list of element. I need to check if there is a value in this list and get the index of this list. 

For example, I have a For Cycle. In this Cycle is obtain a "Value". 

If this "Value" = "OM_L01_Pannello_Lamiera_Template" I want to get "Index"=1.

How can I do it?

If you have different solution this is good. 

I try to use :

VPanelTemplate = "OM_L01_Pannello_Lamiera_template"

'create list of element of coloumn A in image
Dim PartList As New List(Of String) 
PartList = GoExcel.CellValues(SharedVariable("MapExcelFilePath"), "02_Main Part", "A1", "A10")
	
For Each element In PartList
If element = VPanelTemplate Then
contatore=PartList.IndexOf(element)
Logger.Info("°°Questo è l'indice corretto= " & contatore & "°°")
End If	
Next

It doesn't run correctly. 

How can I solve it?

Thanks

[snappyjazz]

Hello @filippo.costantin3HZMT 

on the line: PartList = GoExcel.CellValues(SharedVariable("MapExcelFilePath"), "02_Main Part", "A1", "A10")

try: PartList.AddRange(GoExcel.CellValues(SharedVariable("MapExcelFilePath"), "02_Main Part", "A1", "A10"))

[filippo.costantin3HZMT]

thanks for your answer, but it doesn't run. 

Have you got other solution?

Thanks

[WCrihfield · Accepted solution]

You need to change the Type of PartList from List(Of String) to ArrayList.  The function specifies that it's resulting object is an "IList", which is a 'non-generic' collection.  A 'non-generic' collection is one that can hold multiple Types of objects, like the ArrayList.  The List(Of String) is a 'generic' collection...it can only hold one Type of object.

If this solved your problem, or answered your question, please click ACCEPT SOLUTION.
Or, if this helped you, please click (LIKE or KUDOS) 👍.

If you have time, please... Vote For My IDEAS 💡or you can Explore My CONTRIBUTIONS

[filippo.costantin3HZMT]

Thanks a lot. It run. 

Where can I find a guide to use the List of object and Array in ilogic?

[WCrihfield]

Since iLogic is an Inventor Add-in, and it uses VB.NET as its basis, then just adds a bunch of custom objects, methods, properties, that are specific to Inventor to make it easier, you can look most of the basics up online through the 'docs.microsoft.com' website, but it's a really huge site, so you will definitely need to utilize its search function.

Here are a couple of links to get you started, from the vb.net side:

.NET API Reference (very general - tons of 'tip of the iceberg stuff')

System.Collections Namespace  (more specific to Types of collections)

If this solved your problem, or answered your question, please click ACCEPT SOLUTION.
Or, if this helped you, please click (LIKE or KUDOS) 👍.