Data.ExportExcel not working with Excel 2016

Revit
1

Hi Everyone

I have an annoying failure warning when trying to export to Excel:

Warning: Data.ExportExcel operation failed.
Could not load file or assembly ‘Microsoft.Office.Interop.Excel, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c’ or one of its dependencies. The system cannot find the file specified.

Racking my head on this one a little bit. Im using Excel 2016.

Let me thank you for your help in advance.

1 Like
2

After some discussion with an IT person it seems that this node is wanting to create the excel file in 2010. The version 14.0.0.0 I think refers to 2010. The advise seems to be to down load the interop from visual studio 2013 but I need to find the right bit because downloading the whole thing is to large and isn’t feasible.

I’m going to get some further advice, but has anybody experienced or solved this problem and managed to get Dynamo talking to Excel 2016?

Once again any help or advice would be greatly appreciated.

Kind Regards, Sam King

3

I found a workaround to solve this

  1. go to: https://www.nuget.org/packages/Microsoft.Office.Interop.Excel/14.0.0.1
    and download the Microsoft.Office.Interop.Excel version 14.0.0.1

  2. Rename the downloaded file from .nupkg to .zip and extract the content of this zip file

  3. Inside the extracted folder go to lib/net20 and copy the “Microsoft.Office.Interop.Excel.dll” and paste it inside Revit Directory in Program Files=> C:\Program Files\Autodesk\Revit [VERSION]

  4. Restart Revit and Dynamo and check if it works now

If it doesn’t work, I suggest pasting it inside the Dynamo Folder too
C:\Program Files\Autodesk\Revit [VERSION]\AddIns\DynamoForRevit

2 Likes
4

Hi Mahmood

Yes, its been a while since i posted this, and i’ve done the Interop. I also had to upgrade MS office to the same as Revit, 64 bit. So all good.

Thanks, will mark as solved.