# Data.OpenXMLImportExcel node Error when importing **URL:** \ **Category:** Uncategorized\ **Tags:** excel, dynamo\ **Created:** [September 24, 2025, 9:20am UTC](https://forum.dynamobim.com/t/data-openxmlimportexcel-node-error-when-importing/112453 "2025-09-24T09:20:55Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![raphael.akaemeh](https://avatars.discourse-cdn.com/v4/letter/r/34f0e0/32.png) [@raphael.akaemeh](https://forum.dynamobim.com/u/raphael.akaemeh)\ **Post date:** [September 24, 2025, 9:20am UTC](https://forum.dynamobim.com/t/data-openxmlimportexcel-node-error-when-importing/112453/1 "2025-09-24T09:20:55Z")
Hello Guys, i am faced once again with the excel-dynamo import phase problem. I keep getting the error which states: **The object reference has not been set to an object istance.** Please does anyone have an idea of how to solve this issue without using the **file Path** node which always crashing revit/dynamo entirely when used. Thanks ![grafik](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/7/4725ffcd4110efaf8d98cf4a24f525fca0564235.png) ---
**Author:** ![\_Vijay](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/_vijay/32/91307_2.png) [@\_Vijay](https://forum.dynamobim.com/u/_Vijay)\ **Post date:** [September 24, 2025, 9:50am UTC](https://forum.dynamobim.com/t/data-openxmlimportexcel-node-error-when-importing/112453/2 "2025-09-24T09:50:43Z")
Try with file from path. ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/7/d7d37f4f84480b6a23235304d060bb38f4e0c7ec.png) ---
**Author:** ![raphael.akaemeh](https://avatars.discourse-cdn.com/v4/letter/r/34f0e0/32.png) [@raphael.akaemeh](https://forum.dynamobim.com/u/raphael.akaemeh)\ **Post date:** [September 24, 2025, 10:13am UTC](https://forum.dynamobim.com/t/data-openxmlimportexcel-node-error-when-importing/112453/3 "2025-09-24T10:13:37Z")
Hi Vijay, thanks alot for the swift response. The Problem is that the node file path does not work with me because it crashes my revit and respectively dynamo when i connect it or even click search. that was why the openxml was the only option that has succesfully worked while i did the export. So the thing is that i need a work around to get the file from the saved location without using the file path node. thanks lot ---
**Author:** ![\_Vijay](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/_vijay/32/91307_2.png) [@\_Vijay](https://forum.dynamobim.com/u/_Vijay)\ **Post date:** [September 24, 2025, 11:51am UTC](https://forum.dynamobim.com/t/data-openxmlimportexcel-node-error-when-importing/112453/4 "2025-09-24T11:51:54Z")
Got it. Alternatively, you can use Python to import the data ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/4/145b0e97f7c6ca4c71e628fd83aabda33817ceb0.png) ```auto import clr import System from System.IO import FileInfo import DSOffice # Take path string from Dynamo input path = IN[0] # Convert to FileInfo object fileInfo = FileInfo(path) # Import Excel data = DSOffice.Data.ImportExcel(fileInfo, "Sheet1", False, True) # Output to Dynamo OUT = data ``` ---
**Author:** ![\_Vijay](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/_vijay/32/91307_2.png) [@\_Vijay](https://forum.dynamobim.com/u/_Vijay)\ **Post date:** [September 24, 2025, 11:56am UTC](https://forum.dynamobim.com/t/data-openxmlimportexcel-node-error-when-importing/112453/5 "2025-09-24T11:56:26Z")
you can try with use Crumplev also. it working as excepted. ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/8/4813cbe9594b0fb63c2bc9abe7551566a45b40b5.png) ---
**Author:** ![Mike.Buttery](https://avatars.discourse-cdn.com/v4/letter/m/b19c9b/32.png) [@Mike.Buttery](https://forum.dynamobim.com/u/Mike.Buttery)\ **Post date:** [September 25, 2025, 12:47am UTC](https://forum.dynamobim.com/t/data-openxmlimportexcel-node-error-when-importing/112453/6 "2025-09-25T00:47:14Z")
You need to escape your back-slashes in the file path or use a forward-slash ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/7/7/7761f69b376327f953d6f6518270c9b3da2abfb7.png) ---
**Author:** ![raphael.akaemeh](https://avatars.discourse-cdn.com/v4/letter/r/34f0e0/32.png) [@raphael.akaemeh](https://forum.dynamobim.com/u/raphael.akaemeh)\ **Post date:** [September 28, 2025, 2:09pm UTC](https://forum.dynamobim.com/t/data-openxmlimportexcel-node-error-when-importing/112453/7 "2025-09-28T14:09:15Z")
Thank you so much @Mike.Buttery by just escaping the back-slashes solved the problem so fast. This forum is simply the best so far. Thanks you Sir for the support. ---
**Author:** ![hayet.sassi2](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/hayet.sassi2/32/199553_2.png) [@hayet.sassi2](https://forum.dynamobim.com/u/hayet.sassi2)\ **Post date:** [September 28, 2025, 4:06pm UTC](https://forum.dynamobim.com/t/data-openxmlimportexcel-node-error-when-importing/112453/8 "2025-09-28T16:06:32Z")
Hello, can this help? ![number within the list_2025-09-28_06-04-22](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/f/9/f92b1be125b46996f92c4d42cfe0ccf7d6c5db08.png) ---
**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:** [September 29, 2025, 6:31am UTC](https://forum.dynamobim.com/t/data-openxmlimportexcel-node-error-when-importing/112453/9 "2025-09-29T06:31:55Z")
Noting I retired those nodes in favor of a set that uses pandas. ---
**Author:** ![raphael.akaemeh](https://avatars.discourse-cdn.com/v4/letter/r/34f0e0/32.png) [@raphael.akaemeh](https://forum.dynamobim.com/u/raphael.akaemeh)\ **Post date:** [September 29, 2025, 7:42am UTC](https://forum.dynamobim.com/t/data-openxmlimportexcel-node-error-when-importing/112453/10 "2025-09-29T07:42:13Z")
Hello hayet, i believe this solution was directed to me however, i had solved it using the suggestion from Mike.butterfly. Thanks for your help as well. ---
**Author:** ![mariano.vidalSCLCQ](https://avatars.discourse-cdn.com/v4/letter/m/e68b1a/32.png) [@mariano.vidalSCLCQ](https://forum.dynamobim.com/u/mariano.vidalSCLCQ)\ **Post date:** [March 30, 2026, 4:05pm UTC](https://forum.dynamobim.com/t/data-openxmlimportexcel-node-error-when-importing/112453/11 "2026-03-30T16:05:48Z")
Thank you! With this I have solved it. But I would still like ImportExcel to work for me… I am going to try reinstalling Office ---
**Author:** ![c.poupin](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/c.poupin/32/89152_2.png) [@c.poupin](https://forum.dynamobim.com/u/c.poupin)\ **Post date:** [March 30, 2026, 8:37pm UTC](https://forum.dynamobim.com/t/data-openxmlimportexcel-node-error-when-importing/112453/12 "2026-03-30T20:37:58Z")
> [@mariano.vidalSCLCQ](#): > > ImportExcel to work for me Note that the COM interrop-based node is deprecated in the latest versions of Dynamo.