Skip to main content
Question

Excel Counter/Variable operations

  • Mar 17, 2023 9:33 PM UTC
  • 3 replies
  • 993 views

OK, I know V11 extremely well. I am learning AA2019 360 Community Addition.

2 Silly questions that I can’t seem to wrap my head around:

  1. How the heck do you get the Excel Row Number you are on to use as a counter? I want the row number I am currently on during a loop?
  2. Say i want to increment the counter by +1. In aa V11 there were variable operations to do so, Is there an equivalent in V2019 360? 

3 replies

  • Chris 1066
  • Author
  • Cadet | Tier 2
  • Mar 18, 2023 1:19 PM UTC

All I want to do (which was simple in AAV11) is to log to file ExcelRow[0] and the current row # the loop is on. Here are my commands:

 

  • Chris 1066
  • Author
  • Cadet | Tier 2
  • Mar 18, 2023 1:20 PM UTC

This is the result I get:

 

  • Chris 1066
  • Author
  • Cadet | Tier 2
  • Mar 20, 2023 12:59 PM UTC

Ok, I figured it out. I had to do the steps manually. But this does work as expected.

 

Terms & ConditionsAccessibility statement