Skip to content

Instantly share code, notes, and snippets.

@ninjs
Created April 13, 2015 22:15
Show Gist options
  • Save ninjs/df673a8c2efcf3addbf7 to your computer and use it in GitHub Desktop.
Save ninjs/df673a8c2efcf3addbf7 to your computer and use it in GitHub Desktop.
book = Spreadsheet.open( ARGV.join(' '))
newbook = Spreadsheet::Workbook.new
newsheet1 = newbook.create_worksheet
sheet1 = book.worksheet 0
sheet1.each 1 do |row|
break if row[0] == nil
x = row[0].to_s
y = row[5].to_s
z = row[6].to_s
zz = row[7].to_s
newsheet1.row[WHAT_HERE][WHAT_HERE] = x
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment