Class: DataSpork::Importer::GoogleSpreadsheet::Reader

Inherits:
BaseReader
  • Object
show all
Defined in:
lib/data_spork/google_spreadsheet.rb

Instance Attribute Summary

Attributes inherited from BaseReader

#owner

Instance Method Summary collapse

Methods inherited from BaseReader

#initialize

Constructor Details

This class inherits a constructor from DataSpork::BaseReader

Instance Method Details

#each(&block) ⇒ Object 



52
53
54
55
56
57
58
59
60
61
62
 
# File 'lib/data_spork/google_spreadsheet.rb', line 52

def each(&block)
  google = GoogleDrive.(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