Sha256: 68c6b8789303daddd27d40a278d3a8ab691696a05a5edb3ebbb39675311c5ff1
Contents?: true
Size: 1.49 KB
Versions: 1
Compression:
Stored size: 1.49 KB
Contents
# GoogleCells A wrapper for Google's Spreadsheet and Drive APIs. ## Installation Add this line to your application's Gemfile: gem 'google_cells' And then execute: $ bundle Or install it yourself as: $ gem install google_cells ## Usage ```ruby # configure with Google Service account keys 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' end # 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 1. Fork it ( http://github.com/<my-github-username>/google_cells/fork ) 2. Create your feature branch (`git checkout -b my-new-feature`) 3. Commit your changes (`git commit -am 'Add some feature'`) 4. Push to the branch (`git push origin my-new-feature`) 5. Create new Pull Request
Version data entries
1 entries across 1 versions & 1 rubygems
Version | Path |
---|---|
google-cells-0.3.0 | README.md |