Excel Import/Read Node giving Error when linking a file to it


#1

The new Dynamo 7 Excel Read Node is giving me an error as follows:

Warning: Excel.Read 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.

I have heard that Dynamo 7 doesn’t like Office 2007 Files? Is this accurate? If so, anysuggestions besides buying Office 2013 would be much appreciated.

Thanks

Screen Shot 2014-07-30 at 4.19.35 PM


Dynamo data import from excel 2010
#2

Dynamo supports Office 2007 and 2010 and has been tested with both. Some of our users have verified the same: https://github.com/DynamoDS/Dynamo/pull/1933. We have yet to test it with Office 2013 but it should work with that as well. We will test with Office 2013 and update users on this. Are you using the latest versions of Dynamo?


#3

Thanks you Aparajit for the fast response!

I was trying to use the latest version but then it was giving me this error “Warning: Excel.Read operation failed.” on the Read.Excel node in Dynamo 7.1when trying to link with 2007 files, so I’m not sure what is going on.

A new problem has risen though because I ended up just using Dynamo 6.3, which worked with my files that were coming from Office Excel 2007, but then I decided to do a trial of Office 2013, which I later found out does work on a server with Terminal Services so I uninstalled Office 2013. But apparently through that process of installing and uninstalling I am now getting this error in Dynamo 6.3 linking to Excel 2007: “Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft.Office.Interop.Excel.Application’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{000208D5-0000-0000-C000-000000000046}’ failed due to the following error: Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)).” and I guess it has something to do with Excel Reference Library being updated by Office 2013 but now not having Office 2013 installed anymore so I need to roll back the Excel Reference Library to match 2007 (not really totally sure though)

So now I am stuck in the middle with office 2007 not working with either the older Dynamo 6.3 or Dynamo 7, and having to go buy Office 2013 just to link to Dynamo 7.

Any and all help is much appreciated!

(this is the most recent screenshot from dynamo 7.1 trying to link 2007 file)

Screen Shot 2014-08-01 at 10.40.02 AM

In response to the link you supplied I am little confused on where and what I would be changing in relation that? Sorry for not being that knowledgable with these topics. Thanks for the help again


#4

i am reading and writing excel 2013 without any problems


#5

Yea I am having trouble reading and writing with excel 2007


#6

Hi Aparajit sorry to keep adding post but I’ve reinstalled and now I have the Microsoft.Office.Interop.Excel.dll and Office.dll in the bin directory of Dynamo 7 but I am not sure what the next step is because it still isn’t working. You talk about copying them somewhere in https://github.com/DynamoDS/Dynamo/pull/1933 but I am not sure the folder extension that you are specifying in this thread.

Thanks for the help!


#7

I was wondering it is possible to implement an open source library such as Epplus http://epplus.codeplex.com/ instead of microsoft.office.interop.excel.dll for instance.

Thanks

-Paolo


#8

Hey Graham

I am reading data on excel 2007 just fine. I downloaded the support for interop from the following link; http://www.microsoft.com/en-us/download/details.aspx?id=3508


#9

Guys,

Just a quick dumb question here, so i should have Microsoft Excel installed on my desktop for Dynamo to be able to read/write excel file ?

 

Cheers