# Writing to Excel with multiple sheet names **URL:** \ **Category:** Lists-Logic\ **Tags:** bumblebee, excel, dynamo\ **Created:** [May 10, 2017, 11:13pm UTC](https://forum.dynamobim.com/t/writing-to-excel-with-multiple-sheet-names/11671 "2017-05-10T23:13:54Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![babysatch](https://avatars.discourse-cdn.com/v4/letter/b/ecccb3/32.png) [@babysatch](https://forum.dynamobim.com/u/babysatch)\ **Post date:** [May 10, 2017, 11:13pm UTC](https://forum.dynamobim.com/t/writing-to-excel-with-multiple-sheet-names/11671/1 "2017-05-10T23:13:54Z")
Hi everyone, I encounter a massive problem which I cannot manage to solve, although I’m trying it since hours. See the following Dynamo code please: ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/3/0/30e2d89b0b08b79567a8d5dd0b5fdf7afb71085f.png) Having this I would like to have the following results in Excel: ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/8/a/8ab8420d5acd82ac1ebce37e9eb4ccfd2dd72e16.png) ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/7/6/76e35177655e7c1597f09b230f54b7894eda1c66.png) ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/9/d91254cfe9e8237dce7b8d2bbe45f74ffad8dbb2.png) But no matter what I do, I cannot solve the Problem. I have played around with levels etc. 1000 times. It doesn’t want to to work. Can somebody please support me? I would be grateful of any help. Thank you all. ---
**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:** [May 11, 2017, 1:09am UTC](https://forum.dynamobim.com/t/writing-to-excel-with-multiple-sheet-names/11671/2 "2017-05-11T01:09:17Z")
Try a package called Bumblebee. It has ability to easily write data across multiple sheets. Here’s a link to some examples and explanations: [https://konradsobon.gitbooks.io/bumblebee-primer/content/120\_write\_data\_to\_excel.html](https://konradsobon.gitbooks.io/bumblebee-primer/content/120_write_data_to_excel.html) ---
**Author:** ![babysatch](https://avatars.discourse-cdn.com/v4/letter/b/ecccb3/32.png) [@babysatch](https://forum.dynamobim.com/u/babysatch)\ **Post date:** [May 11, 2017, 6:34am UTC](https://forum.dynamobim.com/t/writing-to-excel-with-multiple-sheet-names/11671/3 "2017-05-11T06:34:26Z")
Hi Konrad, thank you for your reply and the amazing package you developed. I wanted to try your example under 1.2.3 Combining BB Data Nodes to Write Multiple Sheets. Unfortunately I get the following output: Traceback (most recent call last): File “”, line 177, in File “”, line 74, in WriteData File “”, line 65, in FillData EnvironmentError: System.Runtime.InteropServices.COMException (0x800A03EC): Ausnahme von HRESULT: 0x800A03EC bei Microsoft.Scripting.ComInterop.ComRuntimeHelpers.CheckThrowException(Int32 hresult, ExcepInfo& excepInfo, UInt32 argErr, String message) bei CallSite.Target(Closure , CallSite , ComObject , Object , Object , Object ) bei System.Dynamic.UpdateDelegates.UpdateAndExecute4[T0,T1,T2,T3,TRet](CallSite site, T0 arg0, T1 arg1, T2 arg2, T3 arg3) bei Microsoft.Scripting.Interpreter.DynamicInstruction`5.Run(InterpretedFrame frame) bei Microsoft.Scripting.Interpreter.Interpreter.Run(InterpretedFrame frame) bei Microsoft.Scripting.Interpreter.LightLambda.Run8[T0,T1,T2,T3,T4,T5,T6,T7,TRet](T0 arg0, T1 arg1, T2 arg2, T3 arg3, T4 arg4, T5 arg5, T6 arg6, T7 arg7) bei IronPython.Compiler.PythonCallTargets.OriginalCallTarget7(PythonFunction function, Object arg0, Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6) bei System.Dynamic.UpdateDelegates.UpdateAndExecute9[T0,T1,T2,T3,T4,T5,T6,T7,T8,TRet](CallSite site, T0 arg0, T1 arg1, T2 arg2, T3 arg3, T4 arg4, T5 arg5, T6 arg6, T7 arg7, T8 arg8) bei Microsoft.Scripting.Interpreter.DynamicInstruction`10.Run(InterpretedFrame frame) bei Microsoft.Scripting.Interpreter.Interpreter.Run(InterpretedFrame frame) bei Microsoft.Scripting.Interpreter.LightLambda.Run5[T0,T1,T2,T3,T4,TRet](T0 arg0, T1 arg1, T2 arg2, T3 arg3, T4 arg4) bei IronPython.Compiler.PythonCallTargets.OriginalCallTarget4(PythonFunction function, Object arg0, Object arg1, Object arg2, Object arg3) bei Microsoft.Scripting.Interpreter.FuncCallInstruction`7.Run(InterpretedFrame frame) bei Microsoft.Scripting.Interpreter.Interpreter.Run(InterpretedFrame frame) bei Microsoft.Scripting.Interpreter.LightLambda.Run7[T0,T1,T2,T3,T4,T5,T6,TRet](T0 arg0, T1 arg1, T2 arg2, T3 arg3, T4 arg4, T5 arg5, T6 arg6) bei System.Dynamic.UpdateDelegates.UpdateAndExecute6[T0,T1,T2,T3,T4,T5,TRet](CallSite site, T0 arg0, T1 arg1, T2 arg2, T3 arg3, T4 arg4, T5 arg5) bei Microsoft.Scripting.Interpreter.DynamicInstruction`7.Run(InterpretedFrame frame) bei Microsoft.Scripting.Interpreter.Interpreter.Run(InterpretedFrame frame) My OS and MS-Office are German. Is the error maybe because of it? Below you find the Data: [07-BumblebeeTest01.dyn](https://forum.dynamobim.com/uploads/short-url/3MupilTMFZcbYuOk4uOVA8wckTe.dyn) (11.5 KB) [Bumblebee-Test.txt](https://forum.dynamobim.com/uploads/short-url/xyCrdmNDpjsTBIvpIA6OoBMg8OR.txt) (2.3 KB) ---
**Author:** ![babysatch](https://avatars.discourse-cdn.com/v4/letter/b/ecccb3/32.png) [@babysatch](https://forum.dynamobim.com/u/babysatch)\ **Post date:** [May 11, 2017, 6:56am UTC](https://forum.dynamobim.com/t/writing-to-excel-with-multiple-sheet-names/11671/4 "2017-05-11T06:56:50Z")
…now I have input exactly what you have written in your example and it works. I will try to find out what I’m doing wrong in the previous example and let you know. ---
**Author:** ![babysatch](https://avatars.discourse-cdn.com/v4/letter/b/ecccb3/32.png) [@babysatch](https://forum.dynamobim.com/u/babysatch)\ **Post date:** [May 11, 2017, 7:50am UTC](https://forum.dynamobim.com/t/writing-to-excel-with-multiple-sheet-names/11671/5 "2017-05-11T07:50:37Z")
…is it possible to pass an array of e. g. [0,6] instead of “A7” as the origin. I need something like Cell Index Node but in the reverse way, so that I can pass to it say [0,2} and then it returns “C1”. Thank you. ---
**Author:** ![babysatch](https://avatars.discourse-cdn.com/v4/letter/b/ecccb3/32.png) [@babysatch](https://forum.dynamobim.com/u/babysatch)\ **Post date:** [May 11, 2017, 8:48am UTC](https://forum.dynamobim.com/t/writing-to-excel-with-multiple-sheet-names/11671/6 "2017-05-11T08:48:31Z")
Dear Konrad, dear all, I notice that I cannot use your package. I have to come back to my original question of how it is really possible with the core node “write to excel”. can you/someone help?