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!

Attachments:

Untitled-1.jpg, 100 KB

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