excel automation anywhere

shreyaD

New Member
Hello Guys,

How to count number of columns in excel. In loop I don't want to hard code value. It should pick dynamically and loop should run that number of time. Please help
 

debosreeSinha

New Member
1.You can create an array and initialize it by reading the excel file.
2.you can then use system variable $ArrayColumns to get the last column of the array or excel , eg $ArrayColumns($varray$)$.
3. once you know the total count of cols(say n), you can loop through n times.
 
Top