# Bumblebee writing "10" to two excel cells not 1 **URL:** \ **Category:** Uncategorized\ **Created:** [March 25, 2020, 6:01pm UTC](https://forum.dynamobim.com/t/bumblebee-writing-10-to-two-excel-cells-not-1/48484 "2020-03-25T18:01:08Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Alien](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/alien/32/40701_2.png) [@Alien](https://forum.dynamobim.com/u/Alien)\ **Post date:** [March 25, 2020, 6:01pm UTC](https://forum.dynamobim.com/t/bumblebee-writing-10-to-two-excel-cells-not-1/48484/1 "2020-03-25T18:01:08Z")
![AAA](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/f/b/fbc82b3ab6839c0827917abc05c993ce6478fec9.jpeg) 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. ---
**Author:** ![Nick\_Boyts](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nick_boyts/32/76313_2.png) [@Nick\_Boyts](https://forum.dynamobim.com/u/Nick_Boyts)\ **Post date:** [March 25, 2020, 8:02pm UTC](https://forum.dynamobim.com/t/bumblebee-writing-10-to-two-excel-cells-not-1/48484/2 "2020-03-25T20:02:55Z")
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. ---
**Author:** ![Alien](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/alien/32/40701_2.png) [@Alien](https://forum.dynamobim.com/u/Alien)\ **Post date:** [March 25, 2020, 8:35pm UTC](https://forum.dynamobim.com/t/bumblebee-writing-10-to-two-excel-cells-not-1/48484/3 "2020-03-25T20:35:08Z")
Could you elaborate a little please? The input to SheetName is in the same format and that seems to work OK. ---
**Author:** ![markshaworth](https://avatars.discourse-cdn.com/v4/letter/m/779978/32.png) [@markshaworth](https://forum.dynamobim.com/u/markshaworth)\ **Post date:** [March 25, 2020, 8:53pm UTC](https://forum.dynamobim.com/t/bumblebee-writing-10-to-two-excel-cells-not-1/48484/4 "2020-03-25T20:53:22Z")
use List.chop to cut the list length down. ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/2/12d1aad9aa13d2237d37c54417da3b6a85509b03.png) ---
**Author:** ![Alien](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/alien/32/40701_2.png) [@Alien](https://forum.dynamobim.com/u/Alien)\ **Post date:** [March 25, 2020, 9:02pm UTC](https://forum.dynamobim.com/t/bumblebee-writing-10-to-two-excel-cells-not-1/48484/5 "2020-03-25T21:02:36Z")
Thanks Marks! Works perfectly! ---
**Author:** ![Nick\_Boyts](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nick_boyts/32/76313_2.png) [@Nick\_Boyts](https://forum.dynamobim.com/u/Nick_Boyts)\ **Post date:** [March 25, 2020, 9:06pm UTC](https://forum.dynamobim.com/t/bumblebee-writing-10-to-two-excel-cells-not-1/48484/6 "2020-03-25T21:06:28Z")
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. ---
**Author:** ![Konrad\_K\_Sobon](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/konrad_k_sobon/32/8838_2.png) [@Konrad\_K\_Sobon](https://forum.dynamobim.com/u/Konrad_K_Sobon)\ **Post date:** [March 28, 2020, 2:58am UTC](https://forum.dynamobim.com/t/bumblebee-writing-10-to-two-excel-cells-not-1/48484/7 "2020-03-28T02:58:31Z")
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”.