Looping through Excel Columns through iLogic

ABoaro — Tue, 30 Jun 2020 22:46:49 GMT

I am still working on learning the ins and outs of basic iLogic. I can loop through rows just fine within iLogic itself because they are numbers. However, I am trying to figure out a way with columns instead.

I have the idea of making an ArrayList holding strings of capitalized variables and looping through the ArrayList.

Something like this

For Each oCharStr in ColumnArrayList

'Do something

I am fearful that it may just deal with the numerical values correlated to the letters rather than the Letter itself. Anyone have any tips on how to do something like this? If there is an easier way then I am all ears.

Re: Looping through Excel Columns through iLogic

ckeveryga — Thu, 02 Jul 2020 13:11:02 GMT

Are you reading off of an actual excel sheet (more of the code might be helpful)? If so, the logic should be the same as reading an excel sheet using VB.NET. You can loop through rows and columns like so,

For i = 1 To intFinalRow For j = 1 To intFinalCol strCell = xlWs.Cells(i,j).Value Next Next

Where i represents the row and j represents the column.

topic Looping through Excel Columns through iLogic in Inventor Programming Forum

Looping through Excel Columns through iLogic

Re: Looping through Excel Columns through iLogic