GoogleCells
A wrapper for Google's Spreadsheet and Drive APIs.
Installation
Add this line to your application's Gemfile:
gem 'google_cells'
Configuration
Sign up for the Drive API in the Google developer console.
Oauth 2 Web Flow
For a web application using the oauth 2 web flow, configure GoogleCells with your client id and secret.
GoogleCells.configure do |config|
config.client_id = 'my-client-id'
config.client_secret = 'my-client-secret'
endOauth 2 Service Account
For background processing using a service account, configure GoogleCells with your account email, path to your key file, and key secret.
GoogleCells.configure do |config|
config.service_account_email = 'my_service_account@email.here'
config.key_file = File.dirname(__FILE__) +
'/path/to/private-key.file/from/Google'
config.key_secret = 'notasecret'
endSee "examples" directory for implementations of both the web flow and service account in sinatra. To use the examples, add config files with your auth info. to /tmp.
Usage
# list all spreadsheets in account
files = GoogleCells::Spreadsheet.list
files.each do |s|
p s.title
end
# get spreadsheet by google key
s = GoogleCells::Spreadsheet.get('my-spreadsheet-key-here')
# spread the love
s.share(value:'mybestfriend@email.here', type:'user', role:'writer')
# create a copy of file
c = s.copy
# put spreadsheet in a folder
s.enfold('my-folder-key-here')
# read cell content
w = s.worksheets[0]
w.rows.each do |row|
row.cells.each do |c|
p c.value
p c.input_value
p c.numeric_value
end
end
# and write it!
w.rows.from(1).to(2).each do |row|
row.cells.each do |c|
c.input_value = "#{cell.row + cell.col}"
end
end
w.save!Contributing
- Fork it ( http://github.com//google_cells/fork )
- Create your feature branch (
git checkout -b my-new-feature) - Commit your changes (
git commit -am 'Add some feature') - Push to the branch (
git push origin my-new-feature) - Create new Pull Request