# Issue Exporting to Excel since upgrade to 2024 **URL:** \ **Category:** Revit\ **Tags:** dynamo\ **Created:** [May 24, 2024, 3:22pm UTC](https://forum.dynamobim.com/t/issue-exporting-to-excel-since-upgrade-to-2024/101299 "2024-05-24T15:22:41Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![nathan.dent](https://avatars.discourse-cdn.com/v4/letter/n/e5b9ba/32.png) [@nathan.dent](https://forum.dynamobim.com/u/nathan.dent)\ **Post date:** [May 24, 2024, 3:22pm UTC](https://forum.dynamobim.com/t/issue-exporting-to-excel-since-upgrade-to-2024/101299/1 "2024-05-24T15:22:41Z")
Hello, I have had a data export to excel functioning over the years on versions since 2019 and everything has been mostly ok. Since I just bumped up to 2024, upgraded the needed packages and tried to run the workflow I’m getting a strange result involving the ‘Data.ExportToExcel’ node. All my list nodes/transposing ect seem to be giving correct results but when it hits the Excel export node I’m getting a repeated ‘System.Collections.ArrayList’. ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/1/210460ffd677ba7b643a546c04193f85daee2912.png) Any help would be greatly appreciated Many Thanks in Advance ---
**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:** [May 24, 2024, 5:32pm UTC](https://forum.dynamobim.com/t/issue-exporting-to-excel-since-upgrade-to-2024/101299/2 "2024-05-24T17:32:39Z")
Looks like you are providing a CAV as the input file. Try the write to CSV node instead of the excel one. If you want to keep the excel, I recommend using the OpenXML excel nodes as hey are more stable (any Microsoft update can break the old nodes functionality). ---
**Author:** ![nathan.dent](https://avatars.discourse-cdn.com/v4/letter/n/e5b9ba/32.png) [@nathan.dent](https://forum.dynamobim.com/u/nathan.dent)\ **Post date:** [May 24, 2024, 6:25pm UTC](https://forum.dynamobim.com/t/issue-exporting-to-excel-since-upgrade-to-2024/101299/3 "2024-05-24T18:25:08Z")
Hi Jacob Thanks for replying. I tried both the CSV method and the OPENXML and I still get the same result. I seem to get results all the way from each parameter up to list creation just fine its just the export portion its struggling with. ![REVIT2024 Issue 4](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/f/bf87b03a20f794ffa85d1e4ce150c854dbbc8a0f.png) ![REVIT2024 Issue 3](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/f/4ff62545d63e8440216bd4f184df3659b3bbdefc.jpeg) ---
**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:** [May 24, 2024, 6:53pm UTC](https://forum.dynamobim.com/t/issue-exporting-to-excel-since-upgrade-to-2024/101299/4 "2024-05-24T18:53:39Z")
Check to see what data types you have in the list. It may be that you have something which doesn’t serialize to an array properly, such as an element, or enumerator. Take the last list out of what you are sending into the data input (List.LastItem) and get the data type (Object.Type), then pull the unique items from there (List.UniqueItems). Those should all be basic data types (strings, doubles, integers, etc.). ---
**Author:** ![nathan.dent](https://avatars.discourse-cdn.com/v4/letter/n/e5b9ba/32.png) [@nathan.dent](https://forum.dynamobim.com/u/nathan.dent)\ **Post date:** [May 24, 2024, 7:44pm UTC](https://forum.dynamobim.com/t/issue-exporting-to-excel-since-upgrade-to-2024/101299/5 "2024-05-24T19:44:05Z")
All seem to be System.String ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/5/9/59653462ef0e2c78e91b88447af7eaf5edd4ccc9.png) ---
**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:** [May 24, 2024, 10:13pm UTC](https://forum.dynamobim.com/t/issue-exporting-to-excel-since-upgrade-to-2024/101299/6 "2024-05-24T22:13:33Z")
Try a List.Count with the levels set to @L2. Somewhere on here there is a data type which is off or a data structure which is off. Expand all data previews, zoom tight to one node, and export the canvas as an image. ---
**Author:** ![nathan.dent](https://avatars.discourse-cdn.com/v4/letter/n/e5b9ba/32.png) [@nathan.dent](https://forum.dynamobim.com/u/nathan.dent)\ **Post date:** [May 25, 2024, 3:16pm UTC](https://forum.dynamobim.com/t/issue-exporting-to-excel-since-upgrade-to-2024/101299/7 "2024-05-25T15:16:02Z")
Please see below [COMMS EXPORT IMage 2.pdf](https://forum.dynamobim.com/uploads/short-url/zhnJFrX8DwVCGTDVx2quyoVpbrp.pdf) (2.3 MB) Thanks again for the continued help ---
**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:** [May 25, 2024, 3:37pm UTC](https://forum.dynamobim.com/t/issue-exporting-to-excel-since-upgrade-to-2024/101299/8 "2024-05-25T15:37:39Z")
Try the Object.Type \> List.Unique with the input set to @L2 after the List.Transpose. One thought is the type or instance parameter is throwing things off. Make sure the level is set right. Everything in there should be a string or similar. If that does t work you’ll have to post your dyn and a source rvt. ---
**Author:** ![nathan.dent](https://avatars.discourse-cdn.com/v4/letter/n/e5b9ba/32.png) [@nathan.dent](https://forum.dynamobim.com/u/nathan.dent)\ **Post date:** [May 25, 2024, 5:27pm UTC](https://forum.dynamobim.com/t/issue-exporting-to-excel-since-upgrade-to-2024/101299/9 "2024-05-25T17:27:37Z")
Yeah ok so when i added i can see it changing at the transpose node. ![Tranpose Error](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/7/47e6efeb2c91b54d94c69ca8f0be5a7cc430cda0.jpeg) ---
**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:** [May 25, 2024, 9:08pm UTC](https://forum.dynamobim.com/t/issue-exporting-to-excel-since-upgrade-to-2024/101299/10 "2024-05-25T21:08:40Z")
Set the list level to @L1 on the Object.Type node. ---
**Author:** ![nathan.dent](https://avatars.discourse-cdn.com/v4/letter/n/e5b9ba/32.png) [@nathan.dent](https://forum.dynamobim.com/u/nathan.dent)\ **Post date:** [May 25, 2024, 10:39pm UTC](https://forum.dynamobim.com/t/issue-exporting-to-excel-since-upgrade-to-2024/101299/11 "2024-05-25T22:39:44Z")
Still the same ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/e/be0a1b349594386ba7fa3e54bde4b4c6a008314a.png) ---
**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:** [May 25, 2024, 11:53pm UTC](https://forum.dynamobim.com/t/issue-exporting-to-excel-since-upgrade-to-2024/101299/12 "2024-05-25T23:53:31Z")
Ok… now this is weird. Try the Object.Type followed by List.UniqueItems before the transpose, before the List.Create, all over the graph as you go. The goal is to find the odd thing in the dataset - a null, empty list, or other oddity. If nothing turns up, post a sample rvt to reproduce the issue and your DYN so we can help more directly. ---
**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:** [May 27, 2024, 12:16am UTC](https://forum.dynamobim.com/t/issue-exporting-to-excel-since-upgrade-to-2024/101299/13 "2024-05-27T00:16:00Z")
The best way to test if it’s the excel node or your data is to send in a very basic 2D list and see if it’s a consistent issue. Recommend doing that before we dive right into the data itself… ---
**Author:** ![nathan.dent](https://avatars.discourse-cdn.com/v4/letter/n/e5b9ba/32.png) [@nathan.dent](https://forum.dynamobim.com/u/nathan.dent)\ **Post date:** [May 27, 2024, 2:18pm UTC](https://forum.dynamobim.com/t/issue-exporting-to-excel-since-upgrade-to-2024/101299/14 "2024-05-27T14:18:57Z")
Ok i made a very basic list of 1 element and 2 parameters off that element and it works ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/8/48e0337ca903c6fead9728f737bec177fe57d32b.jpeg) ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/7/e/7e35556b4ef2efe7a11f351e33f3d6e99632fd40.png) I then expanded it back to All my objects again but still only drawing the 2 parameters and im back to the error. I tried it with and without a transpose ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/0/7/077e53126ef6bad0ca6c851d00f0b1910c582c7e.jpeg) ---
**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:** [May 27, 2024, 3:29pm UTC](https://forum.dynamobim.com/t/issue-exporting-to-excel-since-upgrade-to-2024/101299/15 "2024-05-27T15:29:40Z")
Ok - this is feeling like an Add-In conflict. Disable all of your Revit add-ins, restart the CPU, and then see if it reproduces. If so then force quit Revit (don’t close anything after you get the warning) and post your Revit journal from that session. I f it doesn’t reproduce with add-ins disables, then re-enable all the add-ins and see if the issue comes back. if the issue comes back after re-enabling, post both of the journals from the re-enabled and disabled sessions so we can find the difference. ---
**Author:** ![nathan.dent](https://avatars.discourse-cdn.com/v4/letter/n/e5b9ba/32.png) [@nathan.dent](https://forum.dynamobim.com/u/nathan.dent)\ **Post date:** [May 27, 2024, 5:55pm UTC](https://forum.dynamobim.com/t/issue-exporting-to-excel-since-upgrade-to-2024/101299/16 "2024-05-27T17:55:04Z")
Ok thanks for dealing with my spam. Item has been resolved. I turned off Rhythm and Orchid and replaced the nodes from those apps I’ve used for the last 3-4 REVIT versions and it is exporting ok now. Again thanks for the rapid support and apologies for the spam. ---
**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:** [May 27, 2024, 6:38pm UTC](https://forum.dynamobim.com/t/issue-exporting-to-excel-since-upgrade-to-2024/101299/17 "2024-05-27T18:38:30Z")
> [@nathan.dent](#): > > Rhythm and Orchid Rhythm should be fine - reinstall it from the package manager and it will put the latest and correct version into place. The [Orchid Package](https://github.com/erfajo/OrchidForDynamo) may be problematic, but even that is fairly unlikely. Try to get the latest installed and see if that fixes things. If not best to reach out on the project a GitHub (linked above). ---
**Author:** ![nathan.dent](https://avatars.discourse-cdn.com/v4/letter/n/e5b9ba/32.png) [@nathan.dent](https://forum.dynamobim.com/u/nathan.dent)\ **Post date:** [May 27, 2024, 6:53pm UTC](https://forum.dynamobim.com/t/issue-exporting-to-excel-since-upgrade-to-2024/101299/18 "2024-05-27T18:53:25Z")
Thanks, will keep troubleshooting after now that i know i can get something to work when its going to be critical in the next month. Those 2 are the only packages i have installed so Its down to one of them. Many thanks again for the help ---
**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:** [May 27, 2024, 7:20pm UTC](https://forum.dynamobim.com/t/issue-exporting-to-excel-since-upgrade-to-2024/101299/19 "2024-05-27T19:20:49Z")
> [@nathan.dent](#): > > Those 2 are the only packages i have installed so Its down to one of them. Could also be something in Revit causing the issue as those packages are built very well. Disabling Revit add-ins is a must for troubleshooting these kinds of issues (and checking the Revit journals). ---
**Author:** ![john\_pierson](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/john_pierson/32/191977_2.png) [@john\_pierson](https://forum.dynamobim.com/u/john_pierson)\ **Post date:** [June 1, 2024, 1:31pm UTC](https://forum.dynamobim.com/t/issue-exporting-to-excel-since-upgrade-to-2024/101299/20 "2024-06-01T13:31:48Z")
Sharing this here too: > [@Find items in list using two nested list values](https://forum.dynamobim.com/t/find-items-in-list-using-two-nested-list-values/101423/9): > > Hi there! I wanted to take a moment and offer some more information that seems to be leading to these kind of errors. As zerotouch package authors, we use Nuget quite often. Nuget is a package manager for coding, and the dynamo team shares the binaries for dynamo on there. Unfortunately, the dynamo team had a bad upload that included a newer binary in the 2.19 version. Orchid referenced that version and it resulted in these errors. (ProtoGeometry 3.0 was included) The author of orchid actual…