Data.lmportExcel- node doesn't work properly

,
1

When try to read data from excel file
A waring messgege displayed

IMG-20240928-WA0001
IMG-20240928-WA0001927×495 81 KB

IMG-20240928-WA0010

After searching for this issue
The solution from autodesk webpage :

https://www.autodesk.com/support/technical/article/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

2

Hi @HaniTartour

Please try to go with openXML OOTB node to import from excel it’ll help u for sure.

Regards,
BM

3

Run the online repair, or switch to the OpenXML node as noted by @bharat.minocha.

Microsoft breaks excel interop with many updates of late (not just office), so moving past excel and into an open format such as CSV is advisable.