Creating an array in ruby from excel spreadsheet (2 columns)

Question

pretty simple issue but can't seem to figure it out. Checked for answers before coming here, nothing too informative yet.

Anyways, I have roughly 4000 rows in excel. Column A, and Column B.

What would be the best way to make an array and be able to store that?

spreadsheet.rubyforge.org

mu is too short
– mu is too short

2012-02-02 07:52:36 +00:00
Commented Feb 2, 2012 at 7:52 — mu is too short
– mu is too short, Commented Feb 2, 2012 at 7:52

Shamith c · Accepted Answer · 2012-02-02 08:17:55Z

2

Please check the following code,

require 'spreadsheet'
a=Array.new
b=Array.new
Spreadsheet.open('abc.xls') do |book|
  book.worksheet('Sheet1').each do |row|        
    a.push(row[0])
    b.push(row[1])
  end
end

This Will return two array a, b. Please check it

answered Feb 2, 2012 at 8:17

Shamith c

3,7593 gold badges28 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Nubtacular Over a year ago

Thanks Shamith c. Well, it didn't fail or return an error, but when I run the ruby file in terminal, it doesn't 'do' anything, just starts a new $ line in the terminal. Is that what is suppose to happen? I mean using irb/rails c isn't going to accomplish anything here is it? B/c whatever you do in there is just...there? Unless you save it. Sorry for my noobness.

Nubtacular Over a year ago

Alright I added book.write '/Users/davidpardy/caweek4/rubytests/newarrayfile2.txt' after the push and it is making the file in the rubytests folder (just did a .txt file for now) and there is all these symbols. For example !"#$%&'()*+,-./0123456789:;<=>?@AC˝ˇˇˇ I also added Spreadsheet.client_encoding = 'UTF-8'

Shamith c Over a year ago

If you want to see array. Just add two line at end of the code puts a puts b

Nubtacular Over a year ago

Hm, after adding push a and push b the array is showing up in terminal when I run it, but there are some duplications. For example, the first number in Column A, row 1 is -81.200399. This number shows up numerous times when the array is run in terminal. Also, the pattern through my excel sheet is a -81.xxxx for column A, and a 28.xxxx for column B. In terminal, there are many areas where there will be a bunch of 28.xxxx numbers in a row, and sometimes lots of -81.xxxx numbers in a row. Why would this be?

Collectives™ on Stack Overflow

Creating an array in ruby from excel spreadsheet (2 columns)

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related