# Googlespreadsheets + ruby = Roo

**URL:** <https://www.ruby-forum.com/t/googlespreadsheets-ruby-roo/152954>\
**Category:** IT\
**Created:** [November 10, 2008, 12:22pm UTC](https://www.ruby-forum.com/t/googlespreadsheets-ruby-roo/152954 "2008-11-10T12:22:44Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![chiaroscuro](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/c5a1d2/32.png) [@chiaroscuro](https://www.ruby-forum.com/u/chiaroscuro)\
**Post date:** [November 10, 2008, 12:22pm UTC](https://www.ruby-forum.com/t/googlespreadsheets-ruby-roo/152954/1 "2008-11-10T12:22:44Z")

</div>

e’ molto lento ma funziona. scaricatevi roo e potete usare i dati nei  
vostri  
google spreadsheet per fare qualcosa di utile da ruby.

segue piccolo esempio.  
si assume nell’esempio che la prima riga dello spreadsheet sono i nomi  
delle  
colonne

require ‘rubygems’  
require ‘roo’

crm\_wbk = “la key che trovi nella url dello spreadsheet”

$s = Google.new(crm\_wbk,‘removed\_email\_address@domain.invalid’,‘latuapassword’)

$s.default\_sheet = $s.sheets.first  
$fields = %w{Name Lastname tags Company Title Phone Email FB Url}

def value(c,r)  
$s.cell(r,$fields.index(c)+1)  
end

for r in 2…1000  
puts “#{value(‘Name’,r)} ; #{value(‘Company’,r)}”

STDOUT.flush  
end

–  
– Kia

[therubymine.com](http://therubymine.com) | be a miner

---

<div class="post-metadata">

**Author:** ![chiaroscuro](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/c5a1d2/32.png) [@chiaroscuro](https://www.ruby-forum.com/u/chiaroscuro)\
**Post date:** [November 10, 2008, 7:06pm UTC](https://www.ruby-forum.com/t/googlespreadsheets-ruby-roo/152954/2 "2008-11-10T19:06:48Z")

</div>

Una figata! Non vedo l’ora di provarlo!!!  
Paolo

2008/11/10 chiaro scuro [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<div class="post-metadata">

**Author:** ![chiaroscuro](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/c5a1d2/32.png) [@chiaroscuro](https://www.ruby-forum.com/u/chiaroscuro)\
**Post date:** [November 10, 2008, 8:49pm UTC](https://www.ruby-forum.com/t/googlespreadsheets-ruby-roo/152954/3 "2008-11-10T20:49:48Z")

</div>

On 11/10/08, Paolo Donà [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Una figata! Non vedo l’ora di provarlo!!!  
> Paolo

sapevo che c’era un piccolo contabile nel cassetto.  
🙂

---

<div class="post-metadata">

**Author:** ![chiaroscuro](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/c5a1d2/32.png) [@chiaroscuro](https://www.ruby-forum.com/u/chiaroscuro)\
**Post date:** [November 11, 2008, 10:31am UTC](https://www.ruby-forum.com/t/googlespreadsheets-ruby-roo/152954/4 "2008-11-11T10:31:24Z")

</div>

Molto carino! TNX

Il 10 novembre 2008 12.22, chiaro scuro [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) ha  
scritto: