ninjs

spreadsheet.rb:72:in `each': comparison of NilClass with String failed (ArgumentError)
	from spreadsheet.rb:72:in `min'
	from spreadsheet.rb:72:in `block in hcfa'
	from /Users/logan/.rvm/gems/ruby-2.1.5/gems/spreadsheet-1.0.3/lib/spreadsheet/worksheet.rb:147:in `block in each'
	from /Users/logan/.rvm/gems/ruby-2.1.5/gems/spreadsheet-1.0.3/lib/spreadsheet/worksheet.rb:146:in `upto'
	from /Users/logan/.rvm/gems/ruby-2.1.5/gems/spreadsheet-1.0.3/lib/spreadsheet/worksheet.rb:146:in `each'
	from /Users/logan/.rvm/gems/ruby-2.1.5/gems/spreadsheet-1.0.3/lib/spreadsheet/excel/worksheet.rb:47:in `each'
	from spreadsheet.rb:59:in `each_with_index'
	from spreadsheet.rb:59:in `hcfa'
	from spreadsheet.rb:111:in `<main>'

ninjs

/Users/logan/.rvm/gems/ruby-2.1.5/gems/spreadsheet-1.0.3/lib/spreadsheet/excel/row.rb:31:in `[]': wrong number of arguments (6 for 1..2) (ArgumentError)
	from spreadsheet.rb:78:in `block in <main>'
	from /Users/logan/.rvm/gems/ruby-2.1.5/gems/spreadsheet-1.0.3/lib/spreadsheet/worksheet.rb:147:in `block in each'
	from /Users/logan/.rvm/gems/ruby-2.1.5/gems/spreadsheet-1.0.3/lib/spreadsheet/worksheet.rb:146:in `upto'
	from /Users/logan/.rvm/gems/ruby-2.1.5/gems/spreadsheet-1.0.3/lib/spreadsheet/worksheet.rb:146:in `each'
	from /Users/logan/.rvm/gems/ruby-2.1.5/gems/spreadsheet-1.0.3/lib/spreadsheet/excel/worksheet.rb:47:in `each'
	from spreadsheet.rb:67:in `each_with_index'
	from spreadsheet.rb:67:in `<main>'

ninjs

  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

ninjs

book = Spreadsheet.open( ARGV.join(' '))
  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
  end
  

ninjs

require 'fileutils'

def help
  print "
    Hello there! Welcome to the Ruby File Mover.
    Copy this script and the run.bat file into the working folder, then double click the run.bat file.
    Usage: ruby #{__FILE__}
        "
end

ninjs

if File.extname(file) != '.xlsx'
  next if File.extname(file) != '.npi'
else
  next
end

ninjs

book = Spreadsheet.open( ARGV.join(' '))
sheet1 = book.worksheet 0
sheet1.each do |row|
  x = row[0]
  y = row[6]
  z = row[24]
end