Skip to content

Instantly share code, notes, and snippets.

@ninjs
Created April 14, 2015 19:43
Show Gist options
  • Save ninjs/a21d27cec857d5b060d9 to your computer and use it in GitHub Desktop.
Save ninjs/a21d27cec857d5b060d9 to your computer and use it in GitHub Desktop.
book = RubyXL::Parser.parse('ub04.xlsx')
newbook = RubyXL::Workbook.new
newsheet1 = newbook[0]
sheet1 = book[0]
sheet1.each_with_index() { |row, index |
break if row[0] == nil
next if index == 0
# Column 3
col_3 = row[104]
# this just prints a bunch of <RubyXL::Cell:0x007fcb4ea12900>
print col_3
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment