# Excel Spreadsheet is Empty when exporting Revit schedule with Dynamo

**URL:** <https://forum.dynamobim.com/t/excel-spreadsheet-is-empty-when-exporting-revit-schedule-with-dynamo/82560>\
**Category:** Uncategorized\
**Created:** [October 28, 2022, 12:47pm UTC](https://forum.dynamobim.com/t/excel-spreadsheet-is-empty-when-exporting-revit-schedule-with-dynamo/82560 "2022-10-28T12:47:42Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![staylor](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/staylor/32/94307_2.png) [@staylor](https://forum.dynamobim.com/u/staylor)\
**Post date:** [October 28, 2022, 12:47pm UTC](https://forum.dynamobim.com/t/excel-spreadsheet-is-empty-when-exporting-revit-schedule-with-dynamo/82560/1 "2022-10-28T12:47:42Z")

</div>

I apologize if this has been brought up before.  
When using Dynamo to export schedules out to excel, sometimes the spreadsheet comes up blank as shown below. The data is exported out though. What is weird, after this happens, trying to open that spreadsheet or any other spreadsheet by directly clicking on the file, all of them come out blank. The only way to see the data is by opening excel first and then open the file from within excel. Usually after doing that, excel goes back to working normally and you can open a file and see the data by directly clicking on the file. Attached is my script.

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/6/261b121b05ab37f483966579ca03b5497eecb8d2.png)  
[Export Multiple Selected Schedules to Excel.dyn](https://forum.dynamobim.com/uploads/short-url/g8towvy18lBahAqwYpLMZNodBhQ.dyn) (48.7 KB)

---

<div class="post-metadata">

**Author:** ![Daan](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/daan/32/82246_2.png) [@Daan](https://forum.dynamobim.com/u/Daan)\
**Post date:** [October 31, 2022, 10:34am UTC](https://forum.dynamobim.com/t/excel-spreadsheet-is-empty-when-exporting-revit-schedule-with-dynamo/82560/2 "2022-10-31T10:34:08Z")

</div>

Hi @staylor ,

It seems like this is more of an Office problem rather than a Revit/Dynamo problem.  
Perhaps an Office Installation reparation may fix your issue(s).

---

<div class="post-metadata">

**Author:** ![Vladimir](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/vladimir/32/147600_2.png) [@Vladimir](https://forum.dynamobim.com/u/Vladimir)\
**Post date:** [October 31, 2022, 11:36am UTC](https://forum.dynamobim.com/t/excel-spreadsheet-is-empty-when-exporting-revit-schedule-with-dynamo/82560/3 "2022-10-31T11:36:22Z")

</div>

Try to export your data with Data.OpenXMLExportExcel node.

---

<div class="post-metadata">

**Author:** ![staylor](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/staylor/32/94307_2.png) [@staylor](https://forum.dynamobim.com/u/staylor)\
**Post date:** [October 31, 2022, 3:35pm UTC](https://forum.dynamobim.com/t/excel-spreadsheet-is-empty-when-exporting-revit-schedule-with-dynamo/82560/4 "2022-10-31T15:35:52Z")

</div>

Which package carries that node?

---

<div class="post-metadata">

**Author:** ![Vladimir](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/vladimir/32/147600_2.png) [@Vladimir](https://forum.dynamobim.com/u/Vladimir)\
**Post date:** [October 31, 2022, 3:41pm UTC](https://forum.dynamobim.com/t/excel-spreadsheet-is-empty-when-exporting-revit-schedule-with-dynamo/82560/5 "2022-10-31T15:41:04Z")

</div>

Built-in for Dynamo 2.12 in Revit 2022. You can also export in csv for test and convert it in Excel.

---

<div class="post-metadata">

**Author:** ![staylor](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/staylor/32/94307_2.png) [@staylor](https://forum.dynamobim.com/u/staylor)\
**Post date:** [October 31, 2022, 3:57pm UTC](https://forum.dynamobim.com/t/excel-spreadsheet-is-empty-when-exporting-revit-schedule-with-dynamo/82560/6 "2022-10-31T15:57:47Z")

</div>

Okay. Company is still using 2020 and 2021, depending on who we are contracting with. So would need a fix for those versions also. It doesn’t happen all the time, so it’s more of an annoyance than an issue.  
Thanks for the feedback.

---

<div class="post-metadata">

**Author:** ![sovitek](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/sovitek/32/116237_2.png) [@sovitek](https://forum.dynamobim.com/u/sovitek)\
**Post date:** [October 31, 2022, 4:31pm UTC](https://forum.dynamobim.com/t/excel-spreadsheet-is-empty-when-exporting-revit-schedule-with-dynamo/82560/7 "2022-10-31T16:31:35Z")

</div>

Hi @staylor …i had the same issue comes and go for some reason…anyway now i just use bumblebee without any issues

---

<div class="post-metadata">

**Author:** ![staylor](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/staylor/32/94307_2.png) [@staylor](https://forum.dynamobim.com/u/staylor)\
**Post date:** [October 31, 2022, 5:25pm UTC](https://forum.dynamobim.com/t/excel-spreadsheet-is-empty-when-exporting-revit-schedule-with-dynamo/82560/8 "2022-10-31T17:25:16Z")

</div>

thanks for the response @sovitek. I will give that a try. Marking your response as the solution.

---

<div class="post-metadata">

**Author:** ![GavinNicholls](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/gavinnicholls/32/190442_2.png) [@GavinNicholls](https://forum.dynamobim.com/u/GavinNicholls)\
**Post date:** [November 1, 2022, 2:30am UTC](https://forum.dynamobim.com/t/excel-spreadsheet-is-empty-when-exporting-revit-schedule-with-dynamo/82560/9 "2022-11-01T02:30:23Z")

</div>

Noting the XML nodes have some pretty big issues such as not knowing how to read date time data properly (it reads them as numbers).

I built some nodes in Crumple to deal with this in Python with some code by Cyril Poupin. Maybe try those out if Bumblebee doesn’t quite fit.

---

<div class="post-metadata">

**Author:** ![staylor](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/staylor/32/94307_2.png) [@staylor](https://forum.dynamobim.com/u/staylor)\
**Post date:** [November 1, 2022, 12:20pm UTC](https://forum.dynamobim.com/t/excel-spreadsheet-is-empty-when-exporting-revit-schedule-with-dynamo/82560/10 "2022-11-01T12:20:14Z")

</div>

Thanks for the heads up @GavinNicholls
