# Iterate excel columns/rows

**URL:** <https://www.ruby-forum.com/t/iterate-excel-columns-rows/180847>\
**Category:** Ruby\
**Created:** [December 30, 2009, 10:32am UTC](https://www.ruby-forum.com/t/iterate-excel-columns-rows/180847 "2009-12-30T10:32:09Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![venkatraman\_r](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/aeb1de/32.png) [@venkatraman\_r](https://www.ruby-forum.com/u/venkatraman_r)\
**Post date:** [December 30, 2009, 10:32am UTC](https://www.ruby-forum.com/t/iterate-excel-columns-rows/180847/1 "2009-12-30T10:32:09Z")

</div>

Hi, If anybody helps me greatly appreciated… I need to run loops to the  
column data…below is my testdata which is in a single lengthy row…

[http://URL1.com](http://URL1.com) [http://URL2.com](http://URL2.com)[http://URL3.com](http://URL3.com) pageTitle:Login  
user1 pwd1 user2 pwd2 user3 pwd3 DB1 DB2 DB3

I know my script is wrong, which was written as below…i want to use  
xls class…

begin  
xlFile = XLS.new(“Dir.getwd + '/TestData.xls”)  
myData = xlFile.getColumnRecords(“A1:AZ1”, “Sheet1”)  
ensure  
xlFile.close  
end  
myData.each do |r|  
puts r[“user”]  
puts r[“pwd”]  
# end  
end

…i want to iterate URL1, URL2, URL3 then user1:pwd1, user2:pwd2,  
user3:pwd3…and again to iterate db1, db2, db3 like that…

your help is greatly appreciated…

thanks,  
venkat