Excel.ReadFromFile operation fails


#1

The operation fails for some unknown reason. Importing the same file as a CSV works; however, I can’t use this workaround because some of the cells I need to import contain commas.

I am working with Dynamo 0.8.0.950 and Microsoft Excel 2007

Dynamo Problem

 


#2

I’ve had the same problem when dealing with Excel files not saved on the local machine. Put the Excel file on your Desktop and I bet it will work.


#3

Thanks for the quick response. I tried moving it to my desktop but unfortunately I’m getting the same error.

 

This is my excel file.

Dynamo Problem 2


#4

EDIT: So I guess even although I moved it to my “desktop” my entire office works in a VM environment so it still isn’t a ‘local’ machine really. I’m not sure if this would affect the issue but I don’t really have a workaround as all of the Revit licenses in my firm are in a virtual environment.


#5

To test whether that is the issue, you could try saving the Excel file as a CSV, then reading the CSV file into Dynamo instead of the Excel file.


#6

I am seeing the exact same problem. Last night I was running Dynamo via Remote Desktop Connection, this morning I tried on my local machine with the XLS file saved to the desktop, still no luck. I have also tried versions 7.5 and 8.1.

Excel.ReadFromFile not working


#7

Add File.FromPath node. Cheers!!!

 

Read From File


#8

Luke and Kyle I was having the same issue previously then i updated my excel 2007 version to Excel version 2013 it solved the issue.:-)


#9

Bummer, I have Excel 2010… Not sure if my company is planning to upgrade to 2013 in the near future, too bad the node doesn’t like older versions.


#10

Thanks Kulkul Kulkul, inserting the File.FromPath node did the trick! Looks like I can stick with Excel 2010.