From: Rochit Sen <lists@...>
Date: 2013-07-30T03:23:35+09:00
Subject: Losing values upon converting object to Array

Hi All,

Not sure if i am doing this correctly. I am reading a xlsx file and then
extracting few columns and want to save them in a csv. So below is what
i am doing:

workbook = Roo::Excelx.new("#{@file}")
workbook.default_sheet="#{@sheet}"
7.upto(workbook.last_row) do |line|
  @col1 = Array(devstatus = workbook.cell(line, 'H'))
  @col2 = Array(availabletesting = workbook.cell(line,'Y'))
  @col3 = Array(firstroundstatus = workbook.cell(line,'AB'))
  @col4 = Array(secondroundstatus = workbook.cell(line,'AH'))
  @col5 = Array(thirdroundstatus = workbook.cell(line,'AL'))
end

CSV.open("test.csv",'w') do |writer|
  writer << [@col1,@col2,@col3,@col4,@col5]
end

When i run the above, the csv file generated but its empty. But when i
print the following:

puts @col1.class == Array #Outputs true, so i suppose my conversion to
array is done correctly
puts @col1.length #Shows me that array length as 0

But when i do: puts @col1 - I get to see all the elements in the array.

Any idea whats wrong?

Thanks

-- 
Posted via http://www.ruby-forum.com/.