Skip to main content
Question

Does Index number start from 0 or 1??


Novice question here, 

 

Got an IF action in my bot which is looking at an excel row, for the index value I want it to always be a certain column (in this instance it's column G)

 

My question is, would the index number be 6 (suggesting that column A and the index starts from 0) or would it be 7 (suggesting that column A and the index starts from 1)?

 

Thanks

Jonny

2 replies

Tamil Arasu10
Most Valuable Pathfinder
Forum|alt.badge.img+16
  • Most Valuable Pathfinder
  • 3276 replies
  • March 2, 2022

Hi @Jonathan Hart​ ,

 

Index Refers to Column Numbers but Index starts from 0 and Name refers to the Header of the Column


  • Author
  • Cadet | Tier 2
  • 1 reply
  • March 2, 2022

Thanks for this, so in my instance where the value I'm looking at is in column G (the 7th column) my source value in the IF string condition source value would be: $CurrentExcelRow[6]$ ?


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings