class DataSpork::Importer::GoogleSpreadsheet::Reader

Public Instance Methods

each(&block) click to toggle source
# File lib/data_spork/google_spreadsheet.rb, line 52
def each(&block)
  google = GoogleDrive.login(google_user, google_password)
  print_error "GoogleDrive #{google} login for #{google_user} #{google.present? ? 'succeeded' : 'failed'}."
  print_error "GoogleDrive opening spreadsheet: #{spreadsheet_title}, worksheet: #{worksheet_title}."
  spreadsheet = google.spreadsheet_by_title(spreadsheet_title)
  sheet = spreadsheet.worksheet_by_title(worksheet_title)
  print_error "GoogleDrive was opened and sheet name was found: #{sheet.title}"
  sheet.rows.each do |row|
    block.call(row.collect {|value| value })
  end
end