# Dynamo export excel fails **URL:** \ **Category:** Revit\ **Tags:** dynamo\ **Created:** [November 25, 2021, 3:41pm UTC](https://forum.dynamobim.com/t/dynamo-export-excel-fails/70768 "2021-11-25T15:41:43Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![aafonsoBYKA8](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/aafonsobyka8/32/134436_2.png) [@aafonsoBYKA8](https://forum.dynamobim.com/u/aafonsoBYKA8)\ **Post date:** [November 25, 2021, 3:41pm UTC](https://forum.dynamobim.com/t/dynamo-export-excel-fails/70768/1 "2021-11-25T15:41:43Z")
Hi. I am trying to run a very simple script to export one schedule to excel. But it is not working. Anyone can help me? ![imagem](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/7/b/7b3560f5c78265b95a164a82de5c25de46cc69df.jpeg) ---
**Author:** ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)\ **Post date:** [November 25, 2021, 6:38pm UTC](https://forum.dynamobim.com/t/dynamo-export-excel-fails/70768/2 "2021-11-25T18:38:48Z")
Hi @aafonsoBYKA8 What’s your Revit Version? ---
**Author:** ![Deniz\_Maral](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/deniz_maral/32/80323_2.png) [@Deniz\_Maral](https://forum.dynamobim.com/u/Deniz_Maral)\ **Post date:** [November 26, 2021, 10:13am UTC](https://forum.dynamobim.com/t/dynamo-export-excel-fails/70768/3 "2021-11-26T10:13:33Z")
I think overWrite option causes that problem. It is a bug in Dynamo because it deletes the sheet and creates a new one. While that happens, it is shown an warning message… Try to do it without overWrite and select a new path. ---
**Author:** ![aafonsoBYKA8](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/aafonsobyka8/32/134436_2.png) [@aafonsoBYKA8](https://forum.dynamobim.com/u/aafonsoBYKA8)\ **Post date:** [November 26, 2021, 11:06am UTC](https://forum.dynamobim.com/t/dynamo-export-excel-fails/70768/4 "2021-11-26T11:06:04Z")
revit 2022.1 ---
**Author:** ![aafonsoBYKA8](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/aafonsobyka8/32/134436_2.png) [@aafonsoBYKA8](https://forum.dynamobim.com/u/aafonsoBYKA8)\ **Post date:** [November 26, 2021, 11:09am UTC](https://forum.dynamobim.com/t/dynamo-export-excel-fails/70768/5 "2021-11-26T11:09:38Z")
I just tried that and the operation fails. It is very frustrating. I just need to find a way to export several schedules to excel… I really dont understand why this very simple thing isnt working. ---
**Author:** ![Deniz\_Maral](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/deniz_maral/32/80323_2.png) [@Deniz\_Maral](https://forum.dynamobim.com/u/Deniz_Maral)\ **Post date:** [November 26, 2021, 11:22am UTC](https://forum.dynamobim.com/t/dynamo-export-excel-fails/70768/6 "2021-11-26T11:22:42Z")
What is shown if you click on “Read more”? ---
**Author:** ![chuongmep](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/chuongmep/32/197537_2.png) [@chuongmep](https://forum.dynamobim.com/u/chuongmep)\ **Post date:** [November 26, 2021, 2:23pm UTC](https://forum.dynamobim.com/t/dynamo-export-excel-fails/70768/7 "2021-11-26T14:23:33Z")
You can send file sample error to here ? I will review and edit it in open source. I have also seen quite a few questions about this. ---
**Author:** ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)\ **Post date:** [November 26, 2021, 6:49pm UTC](https://forum.dynamobim.com/t/dynamo-export-excel-fails/70768/8 "2021-11-26T18:49:48Z")
> [@aafonsoBYKA8](#): > > revit 2022.1 @aafonsoBYKA8 Try using OpnXML export nodes. It’s available for Revit 2022.1: ![10_OpenXML_Nodes](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/5/45d0278dd600260948765e591c93fe443069fbab.jpeg) ---
**Author:** ![m.owens](https://avatars.discourse-cdn.com/v4/letter/m/bbe5ce/32.png) [@m.owens](https://forum.dynamobim.com/u/m.owens)\ **Post date:** [November 26, 2021, 7:00pm UTC](https://forum.dynamobim.com/t/dynamo-export-excel-fails/70768/9 "2021-11-26T19:00:37Z")
A couple of thoughts: 1. you are writing a schedule to excel. It would probably be more simple to export as a text, and import the data into excel via the text file. This offers a nice workflow as you can create a more dynamic link to the data and any post-processing operations in excel, even within the same sheet. 1. there is an excellent add-in from bimONE for writing to excel, which also offers bidirectional exchanges. Doesn’t work well for type-based tables. 2. regarding your error explicitly. Maybe you need to explicitly set the last Boolean to write as strings? 3. Otherwise, you might try replace by condition using the ‚isnull‘ node to clean your data. I doubt this is the issue. I’ve sent ‚null‘ to excel many times…but perhaps if you are not formatting as strings, this is causing an error. ---
**Author:** ![aafonsoBYKA8](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/aafonsobyka8/32/134436_2.png) [@aafonsoBYKA8](https://forum.dynamobim.com/u/aafonsoBYKA8)\ **Post date:** [November 29, 2021, 3:27pm UTC](https://forum.dynamobim.com/t/dynamo-export-excel-fails/70768/10 "2021-11-29T15:27:40Z")
> [@Kulkul](#): > > OpnXML Thank you. I tried like that, but still not working ![imagem](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/e/0/e09191586d3b92c0074868e61c0e839cc1f050b2.png) ---
**Author:** ![aafonsoBYKA8](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/aafonsobyka8/32/134436_2.png) [@aafonsoBYKA8](https://forum.dynamobim.com/u/aafonsoBYKA8)\ **Post date:** [November 29, 2021, 3:29pm UTC](https://forum.dynamobim.com/t/dynamo-export-excel-fails/70768/11 "2021-11-29T15:29:29Z")
![imagem](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/4/24c62c046a07af038041da2afdc7611b317f01e8.jpeg) ---
**Author:** ![aafonsoBYKA8](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/aafonsobyka8/32/134436_2.png) [@aafonsoBYKA8](https://forum.dynamobim.com/u/aafonsoBYKA8)\ **Post date:** [November 29, 2021, 3:30pm UTC](https://forum.dynamobim.com/t/dynamo-export-excel-fails/70768/12 "2021-11-29T15:30:18Z")
Now it only shows this ![imagem](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/e/bef40539d0dae1bd613621ecfe527b73a24fd4b3.png) ---
**Author:** ![aafonsoBYKA8](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/aafonsobyka8/32/134436_2.png) [@aafonsoBYKA8](https://forum.dynamobim.com/u/aafonsoBYKA8)\ **Post date:** [November 29, 2021, 3:32pm UTC](https://forum.dynamobim.com/t/dynamo-export-excel-fails/70768/13 "2021-11-29T15:32:47Z")
I cant upload files because I am a new member. Here is a link to download the file. Hope you can help me. [https://we.tl/t-OnCZWPLhrX](https://we.tl/t-OnCZWPLhrX) ---
**Author:** ![espectrox4000](https://avatars.discourse-cdn.com/v4/letter/e/c77e96/32.png) [@espectrox4000](https://forum.dynamobim.com/u/espectrox4000)\ **Post date:** [November 30, 2021, 8:14pm UTC](https://forum.dynamobim.com/t/dynamo-export-excel-fails/70768/14 "2021-11-30T20:14:42Z")
Check this: > **[“Warning: Data.ImportExcel operation failed. Could not load file or assembly...](https://knowledge.autodesk.com/support/revit/troubleshooting/caas/sfdcarticles/sfdcarticles/Warning-Data-ImportExcel-operation-failed-Could-not-load-file-or-assembly-Microsoft-Office-Interop-Excel-when-running-the-Dynamo-script-in-Revit.html)** > > When running the Dynamo script in Revit, which contains a node to import data from an Excel file the following message appears: “Warning: Data.ImportExcel operation failed. Could not load file or assembly 'Microsoft.Office.Interop.Excel,... ---
**Author:** ![aafonsoBYKA8](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/aafonsobyka8/32/134436_2.png) [@aafonsoBYKA8](https://forum.dynamobim.com/u/aafonsoBYKA8)\ **Post date:** [December 2, 2021, 10:43am UTC](https://forum.dynamobim.com/t/dynamo-export-excel-fails/70768/15 "2021-12-02T10:43:33Z")
This about importing. My issue is when exporting. ---
**Author:** ![SeanP](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/seanp/32/42560_2.png) [@SeanP](https://forum.dynamobim.com/u/SeanP)\ **Post date:** [December 2, 2021, 10:54am UTC](https://forum.dynamobim.com/t/dynamo-export-excel-fails/70768/16 "2021-12-02T10:54:23Z")
Do u have null data in your schedule, meaning empty cells? I have seen that cause this issue. Try to export out a single item from the list where all 4 values exist and see if it fails. Sched[0] from the image appears to have all values Then try with one that doesn’t or doesn’t appear to anyway Sched[1] ---
**Author:** ![atharva.purohit466SX](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/atharva.purohit466sx/32/116951_2.png) [@atharva.purohit466SX](https://forum.dynamobim.com/u/atharva.purohit466SX)\ **Post date:** [December 2, 2021, 11:24am UTC](https://forum.dynamobim.com/t/dynamo-export-excel-fails/70768/17 "2021-12-02T11:24:53Z")
Hi Teresa, till we get a solution to your problem, you can use these- ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/c/9/c94e2e3ba76df498582080c0a690db1cfa8f0cc0.png) let us know if it worked. Regards, ap ---
**Author:** ![aafonsoBYKA8](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/aafonsobyka8/32/134436_2.png) [@aafonsoBYKA8](https://forum.dynamobim.com/u/aafonsoBYKA8)\ **Post date:** [December 2, 2021, 11:29am UTC](https://forum.dynamobim.com/t/dynamo-export-excel-fails/70768/18 "2021-12-02T11:29:35Z")
I have no null values ![imagem](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/7/b7c4c21441d150c5e6dd27ce1b733d21fa012202.jpeg) ---
**Author:** ![SeanP](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/seanp/32/42560_2.png) [@SeanP](https://forum.dynamobim.com/u/SeanP)\ **Post date:** [December 2, 2021, 11:37am UTC](https://forum.dynamobim.com/t/dynamo-export-excel-fails/70768/19 "2021-12-02T11:37:43Z")
Does it work if you use a single list item as I suggested? The grouping headers are potentially causing the issue. ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/e/0/e01a5ade68ca0fad8a767a18595a0413fce361ca.png) ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/0/9/09c3e46ee1790b1623177f50ac962196426088cf.png) ---
**Author:** ![aafonsoBYKA8](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/aafonsobyka8/32/134436_2.png) [@aafonsoBYKA8](https://forum.dynamobim.com/u/aafonsoBYKA8)\ **Post date:** [December 2, 2021, 11:37am UTC](https://forum.dynamobim.com/t/dynamo-export-excel-fails/70768/20 "2021-12-02T11:37:49Z")
Thank you! It exports like this. ![imagem](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/e/de9a622eae9619a3e495e3d73282313f655e6a30.png) Do you know how I can get it into diferent columns? [Next page](https://forum.dynamobim.com/t/dynamo-export-excel-fails/70768.md?page=2)