Leafcutter: Google Sheets for Grasshopper

29 members

Description

Leafcutter is an open source project to connect Grasshopper to Google Sheets, with proper OAuth 2.0 Authentication.

Leafcutter exposes the following components:

  • Google Authenticator. Creates a session token for connecting to your Google account.
  • Spreadsheet List.  Fetches a list of spreadsheets in your account.
  • Read From Spreadsheet.  Read specified cells from the specified sheet and worksheet.
  • Write To Spreadsheet.  Write to specified cells and worksheet.
  • Create Spreadsheet.  Self-explanatory.
  • Find Cell Address.  Query the spreadsheet for an existing value and return the cell address.

Demo video:

https://vimeo.com/fluxio/leafcutter

Leafcutter can be downloaded here:

http://www.food4rhino.com/project/leafcutter

This project is open source and released under the MIT License.  Visit the Github repo here:

https://github.com/fluxio/leafcutter.git

Comments Discussions Members

Find Multiple Cells with Same Content

by lv2311

Jul 25, 2014

Hey guys,

I'm finding some issues with the "find cell" component though.

Is it possible to retrieve all the cell addresses that have the same content?

Inline image 1

Inline image 1

as you can see from the screenshots I'd like to have also the rest cell addresses that contain the item "a" and not just the first  one.

Any thoughts?!

thank