Bumblebee writing "10" to two excel cells not 1

1

AAA
AAA1054×794 174 KB

So I’m trying to write 10 to the 10 series sheet and 20 to the 20 series sheet.

Sheet name works fine, I get two sheets.
However the string that goes into the data appears in TWO cells.

So 10 appears on sheet 10 series but 1 is in cell A5 and 0 is in cell A6.
20 appears on sheet 20 series but 2 is in cell B5 and 0 is in cell B6.

I want 10 to be in A5 only on the 10 series sheet and for 20 to be in B5 only on the 20 series sheet.

2

You need to change the list structure of your data. Each sheet gets a data input in the form of a list. Providing a single list for a series of sheets is causing problems.

3

Could you elaborate a little please?

The input to SheetName is in the same format and that seems to work OK.

4

use List.chop to cut the list length down.

image
image1144×689 147 KB

2 Likes
5

Thanks Marks! Works perfectly!

6

It all has to do with how the node is expecting the input to be formatted. SheetName and Origin both expect single objects. Data expects a list (usually with sublists). A list of 2 SheetNames represents 2 separate inputs. A list of 2 objects in Data is the expected format for a single input. That’s why chopping the list into two separate lists gives the expected result.

2 Likes
7

Just to expand on that answer, the reason it was writing 1, 0 instead of 10 was because like @Nick_Boyts explained it was expecting two lists (matching two sheets). Trick is that strings are actually enumerable ie. similar to lists, so you can iterate over them. This little nuance of programming languages meant that your single list containing “10” and “20” was interpreted as two lists “1” and “0” and second with “2” and “0”.

1 Like