# How to get Worksheet Names, Excel file **URL:** \ **Category:** Packages\ **Tags:** excel\ **Created:** [June 29, 2018, 9:54am UTC](https://forum.dynamobim.com/t/how-to-get-worksheet-names-excel-file/23233 "2018-06-29T09:54:30Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![maheshnaik.mumbai](https://avatars.discourse-cdn.com/v4/letter/m/ec9cab/32.png) [@maheshnaik.mumbai](https://forum.dynamobim.com/u/maheshnaik.mumbai)\ **Post date:** [June 29, 2018, 9:54am UTC](https://forum.dynamobim.com/t/how-to-get-worksheet-names-excel-file/23233/1 "2018-06-29T09:54:30Z")
![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/7/7/776ddfe452b8958a529fba4deae3a1dc3936c2bf.png) ---
**Author:** ![Jonathan.Olesen](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jonathan.olesen/32/44242_2.png) [@Jonathan.Olesen](https://forum.dynamobim.com/u/Jonathan.Olesen)\ **Post date:** [June 29, 2018, 10:24am UTC](https://forum.dynamobim.com/t/how-to-get-worksheet-names-excel-file/23233/2 "2018-06-29T10:24:20Z")
works fine from my end, what is the output of your “Get Worksheet Names”? ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/5/f/5f9556231aca44517b4ddc98b500a6c1ea48fcd6.png) ---
**Author:** ![Tom\_Kunsman](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/tom_kunsman/32/133796_2.png) [@Tom\_Kunsman](https://forum.dynamobim.com/u/Tom_Kunsman)\ **Post date:** [June 29, 2018, 10:50am UTC](https://forum.dynamobim.com/t/how-to-get-worksheet-names-excel-file/23233/3 "2018-06-29T10:50:39Z")
It would be helpful to know what the issue is, what errors you might be getting, what was your expected result, etc. [https://forum.dynamobim.com/t/how-to-get-help-on-the-dynamo-forums/4677](https://forum.dynamobim.com/t/how-to-get-help-on-the-dynamo-forums/4677) ---
**Author:** ![maheshnaik.mumbai](https://avatars.discourse-cdn.com/v4/letter/m/ec9cab/32.png) [@maheshnaik.mumbai](https://forum.dynamobim.com/u/maheshnaik.mumbai)\ **Post date:** [June 29, 2018, 12:01pm UTC](https://forum.dynamobim.com/t/how-to-get-worksheet-names-excel-file/23233/4 "2018-06-29T12:01:16Z")
It says run completed ,but no output. I am attaching the [exceltrash.xlsx](https://forum.dynamobim.com/uploads/short-url/oLayEu4HeIiIZx1PCPZ0Gm6hLn0.xlsx) (602.9 KB) xlsx file… ---
**Author:** ![Jonathan.Olesen](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jonathan.olesen/32/44242_2.png) [@Jonathan.Olesen](https://forum.dynamobim.com/u/Jonathan.Olesen)\ **Post date:** [June 29, 2018, 12:04pm UTC](https://forum.dynamobim.com/t/how-to-get-worksheet-names-excel-file/23233/5 "2018-06-29T12:04:04Z")
No issues… ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/c/0/c06e5b4f6d3c54f5ca6be5fe1ab43f7fe55946bc.png) You could try and extract the content of the custom node and see if there is any error messages in there when it runs, also please enable the previews (using the little pin) when uploading pictures. ---
**Author:** ![maheshnaik.mumbai](https://avatars.discourse-cdn.com/v4/letter/m/ec9cab/32.png) [@maheshnaik.mumbai](https://forum.dynamobim.com/u/maheshnaik.mumbai)\ **Post date:** [June 29, 2018, 12:11pm UTC](https://forum.dynamobim.com/t/how-to-get-worksheet-names-excel-file/23233/6 "2018-06-29T12:11:26Z")
Thank you.Your output is what i wanted. I reinstalled archi\_lab.net only yesterday for the view type problem which still persists(i resolved it using elements)… I will try again or resinstall dynamo again. ---
**Author:** ![Jonathan.Olesen](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jonathan.olesen/32/44242_2.png) [@Jonathan.Olesen](https://forum.dynamobim.com/u/Jonathan.Olesen)\ **Post date:** [June 29, 2018, 12:14pm UTC](https://forum.dynamobim.com/t/how-to-get-worksheet-names-excel-file/23233/7 "2018-06-29T12:14:12Z")
Remember that this node is a part of “Archi-Lab Bumblebee” 🙂 Also I would suggest that you try extracting the content of the node as the error might be caused by the fact that you’re running Dynamo 2.0 and I’m on 1.3.x ---
**Author:** ![maheshnaik.mumbai](https://avatars.discourse-cdn.com/v4/letter/m/ec9cab/32.png) [@maheshnaik.mumbai](https://forum.dynamobim.com/u/maheshnaik.mumbai)\ **Post date:** [June 29, 2018, 12:17pm UTC](https://forum.dynamobim.com/t/how-to-get-worksheet-names-excel-file/23233/8 "2018-06-29T12:17:30Z")
I am totally at sea with dynamo and revit…Just wandering in the forest. How do I extract the content of the node?. ---
**Author:** ![Jonathan.Olesen](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jonathan.olesen/32/44242_2.png) [@Jonathan.Olesen](https://forum.dynamobim.com/u/Jonathan.Olesen)\ **Post date:** [June 29, 2018, 12:20pm UTC](https://forum.dynamobim.com/t/how-to-get-worksheet-names-excel-file/23233/9 "2018-06-29T12:20:13Z")
Double click it and copy/paste the content to the main graphing area (white background). ![FormatGif](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/9/49f291033a4a5b13c73c37b07da5b5a1b3f9e676.gif) If you’re just starting Dynamo I would really recommend you to start by reading and performing the exercises in the Dynamo Primer: [http://primer.dynamobim.org/en/](http://primer.dynamobim.org/en/) ---
**Author:** ![maheshnaik.mumbai](https://avatars.discourse-cdn.com/v4/letter/m/ec9cab/32.png) [@maheshnaik.mumbai](https://forum.dynamobim.com/u/maheshnaik.mumbai)\ **Post date:** [June 29, 2018, 12:28pm UTC](https://forum.dynamobim.com/t/how-to-get-worksheet-names-excel-file/23233/10 "2018-06-29T12:28:24Z")
I did that before even i wrote the first dynamo picture.I had a old version of dynamo which i updated twice to reach 2.01.I was scarred to reinstall the packages.But I will do that now. ---
**Author:** ![Jonathan.Olesen](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jonathan.olesen/32/44242_2.png) [@Jonathan.Olesen](https://forum.dynamobim.com/u/Jonathan.Olesen)\ **Post date:** [June 29, 2018, 12:30pm UTC](https://forum.dynamobim.com/t/how-to-get-worksheet-names-excel-file/23233/11 "2018-06-29T12:30:11Z")
But you do not show any of the relevant outputs making it very difficult to help you… ---
**Author:** ![maheshnaik.mumbai](https://avatars.discourse-cdn.com/v4/letter/m/ec9cab/32.png) [@maheshnaik.mumbai](https://forum.dynamobim.com/u/maheshnaik.mumbai)\ **Post date:** [June 29, 2018, 12:49pm UTC](https://forum.dynamobim.com/t/how-to-get-worksheet-names-excel-file/23233/12 "2018-06-29T12:49:43Z")
I have been posting the full scripts and the dyn files.Do i post the input files also?.(without expecting howlers!).For your curisity I wast playing around to get the view schedules in revit into a single excel file(which i have managed by now). later i am planning to do geometry. right now i am trying to get copy/paste as you posted. ---
**Author:** ![Jonathan.Olesen](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jonathan.olesen/32/44242_2.png) [@Jonathan.Olesen](https://forum.dynamobim.com/u/Jonathan.Olesen)\ **Post date:** [June 29, 2018, 12:54pm UTC](https://forum.dynamobim.com/t/how-to-get-worksheet-names-excel-file/23233/13 "2018-06-29T12:54:26Z")
Try and read the full post linked in reply number 3… You are not enabling the previews in your posts: ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/8/d853cc32572fa58cdaa4cbccb1f7faa2b8364836.png) You are not showing what you’ve tried e.g. ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/2/a2fbd27aa3deb56e925cfbbfd2a84020499f37c9.png) You have not written your version of: Revit, Dynamo, Excel, Packages used Generally a LOT of information is missing in your original post… > [@maheshnaik.mumbai](#): > > the dyn files Where have you posted your dyn file? Not in this post… ---
**Author:** ![maheshnaik.mumbai](https://avatars.discourse-cdn.com/v4/letter/m/ec9cab/32.png) [@maheshnaik.mumbai](https://forum.dynamobim.com/u/maheshnaik.mumbai)\ **Post date:** [June 29, 2018, 1:15pm UTC](https://forum.dynamobim.com/t/how-to-get-worksheet-names-excel-file/23233/14 "2018-06-29T13:15:47Z")
In this episode i presumed ,that since only 5 nodes were invloved the jpg was enough.I will be more careful as learn the ropes of forums. ---
**Author:** ![maheshnaik.mumbai](https://avatars.discourse-cdn.com/v4/letter/m/ec9cab/32.png) [@maheshnaik.mumbai](https://forum.dynamobim.com/u/maheshnaik.mumbai)\ **Post date:** [June 30, 2018, 11:42am UTC](https://forum.dynamobim.com/t/how-to-get-worksheet-names-excel-file/23233/16 "2018-06-30T11:42:08Z")
Can you help me more with extracting the content of the python script.?. How do I do that?.I tried double clicking but all i got is some dyf file,and lost the dyn ?. I just want to see the getworksheetnames code…Is the problem because of a 2007 excel ?. I have downloaded the primer for version 2 … ---
**Author:** ![jacob.small](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jacob.small/32/161030_2.png) [@jacob.small](https://forum.dynamobim.com/u/jacob.small)\ **Post date:** [June 30, 2018, 12:28pm UTC](https://forum.dynamobim.com/t/how-to-get-worksheet-names-excel-file/23233/17 "2018-06-30T12:28:01Z")
> [@maheshnaik.mumbai](#): > > 2007 excel That will likely be a problem in the future if it isn’t already. Asking current software to work with 11 year old software will usually cause issues. ---
**Author:** ![Jonathan.Olesen](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jonathan.olesen/32/44242_2.png) [@Jonathan.Olesen](https://forum.dynamobim.com/u/Jonathan.Olesen)\ **Post date:** [June 30, 2018, 12:28pm UTC](https://forum.dynamobim.com/t/how-to-get-worksheet-names-excel-file/23233/18 "2018-06-30T12:28:23Z")
Look at the gif it show exactly what you’re asking for… To Jacobs point, that is exactly why I asked you for your version numbers for dynamo, revit and excel… We cannot help you if you do not deliver relevant information… ---
**Author:** ![maheshnaik.mumbai](https://avatars.discourse-cdn.com/v4/letter/m/ec9cab/32.png) [@maheshnaik.mumbai](https://forum.dynamobim.com/u/maheshnaik.mumbai)\ **Post date:** [July 1, 2018, 10:32am UTC](https://forum.dynamobim.com/t/how-to-get-worksheet-names-excel-file/23233/19 "2018-07-01T10:32:15Z")
Err.!.. How did you get that python script code…? ---
**Author:** ![maheshnaik.mumbai](https://avatars.discourse-cdn.com/v4/letter/m/ec9cab/32.png) [@maheshnaik.mumbai](https://forum.dynamobim.com/u/maheshnaik.mumbai)\ **Post date:** [July 1, 2018, 10:53am UTC](https://forum.dynamobim.com/t/how-to-get-worksheet-names-excel-file/23233/20 "2018-07-01T10:53:31Z")
Got it …Thanks. ---
**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:** [August 29, 2018, 7:42pm UTC](https://forum.dynamobim.com/t/how-to-get-worksheet-names-excel-file/23233/21 "2018-08-29T19:42:32Z")
That could be precisely the issue. Bumblebee was not working on Dynamo 2.0 until recently. Please get the latest version from Package Manager. ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/4/6423e9964c7d9ae81afa67c9f66b7ded31c84b13.png) [Next page](https://forum.dynamobim.com/t/how-to-get-worksheet-names-excel-file/23233.md?page=2)