Grasshopper

algorithmic modeling for Rhino

How to create alternating text next to existing text / Leafcutter Parameter A

Hi all, 

I am using Leafcutter's Spreadsheet Writer to write data on an online Google spreadsheet. The parameter A of this function, which is the cell address where data is to be placed, only recognizes data such as 'A14' (that is column A, row 14). 

In my script I want to input data NOT one below the other (eg to start from A14 and then continues to A15, A16, etc), but rather to specific rows that I choose each time (eg. A14, then A39, then A732). The number of row is generated by my script, but the problem is that I cannot merge it with an 'A' each time (and the parameter A doesn't recognize only a number input, it needs the letter as well). 

So I need to create this alternating text every time I run my script. 

So to say I keep 'A' permanently in a text panel and only add the number next to it every time. Any ideas on how to do that?

I am attaching a screen capture of my attempt to merge an 'A' and my numbers, which obviously returns an error. 

Any help much appreciated!

Views: 427

Attachments:

Replies to This Discussion

Permalink Reply by Stephen Maher on September 22, 2015 at 2:16pm

I'm not sure I follow you exactly (and I don't have Leafcutter installed), but from what I gather input parameter 'A' requires a Google Sheet cell name (i.e. "A28"). If that's the case you can use the [Format] component to output either one or a list of cells to populate. The inputs would look something like this:

F = {0}{1}

0 = A

1 = 28

/SPM

Permalink Reply by OlinaT92 on September 23, 2015 at 9:36am

Thank you!! That's exactly what I needed :)

Permalink Reply by OlinaT92 on September 23, 2015 at 10:50am

Hi Stephen, 

It seems that in the problem was not fixed.

The following image contains the result I get with the Format component (2nd panel) and what I want to get for the Leafcutter to work for sure. 

Do the two panels contain the same information? 

Thank you in advance.

Attachments:
Permalink Reply by Stephen Maher on September 23, 2015 at 11:48am

Don't forget to input the desired format (input parameter 'F').

Permalink Reply by Stephen Maher on September 23, 2015 at 6:03pm

Also, if you upload a file I can troubleshoot. I'll install Leafcutter.

/SPM

Permalink Reply by OlinaT92 on September 25, 2015 at 2:25am

Hi Stephen, 

Thank you for your reply. It turns out that I had accidentally typed an space ('Enter') in the 'A' panel, that was why the number was underneath it. 

I had put the text for 'F' as advised, just internalised and was thus not visible. 

Thank you for all the help, my script runs perfectly now!

Best,

Olina

RSS

About

Scott Davidson created this Ning Network.

Translate

Search

Photos

  • Add Photos
  • View All

Videos

  • Add Videos
  • View All

© 2024   Created by Scott Davidson.   Powered by

Badges  |  Report an Issue  |  Terms of Service