Hello, My firm uses a Citrix virtual environment to connect to projects around the globe. We are running multiple versions of Revit, MS Office 2016, among many other applications in a Windows 10 environment. We have run across an issue trying to use Excel nodes in Dynamo. I have a very simple sc…

Hi David, I had the same issue and I could resolve it by using normal xls file instead of xlsx. I hope it helps you too.

Hi, Have you seen these topics ? [image] Excel - Operation failed Revit Hi, I have been struggling to fix an error with the Excel and CSV Import and Export nodes. When using them, I receive the following error. I have search the forum and reinstalled Excel, upgraded Ex…

What is the actual version of excel (Including 32 or 64 bit)?

If all else fails, you can give the ExcelReader package a go. It uses an external library to directly read excel’s binary XML format.

32 bit. But my local install is 32 bit and works there as well. I’m having our IT look at some missing key info (instead of extra keys as many of the posts refer to) to see if that resolves the problem.

I did try ExcelFile.Read and that does work. I’m glad you explained that, I was thinking it was something along those lines. But I didn’t see an ExcelFile.Write node to use. Thanks.

No Excel.Write and that’s kind of on purpose :slight_smile: My reasoning is that it’s closed binary formats like xls that got us into this mess in the first place, so we should try to do everything possible we can to avoid them. So I’d recommend you try wriing your data in csv files instead and if…

Understood. I actually use EPPlus in some of my own addins. Thanks.

We’ve taken a look at editing and removing the registry keys and still not working.

@Michael_Coffey this feels like a Citrix issue. No idea how I could test it myself. Can you confirm all programs are installed on the same system (not Revit/Dynamo off Citrix and Excel off your C drive)?

@jacob.small Excel is definitely installed in the citrix environment as I can see the Registry keys there. You can also log into the Citrix environment from your iPad and see all the same programs as well. My only thought now is to try to use the EPPlus library to create my own Excel.Write node.

Data.ImportExcel operation failed

Revit

mellouze October 19, 2018, 1:34pm 2

Hi,

Have you seen these topics ?

Topic		Replies	Views
Excel.ReadFromFile operation failed Revit revit , excel , dynamo	28	9917	February 16, 2023
Import info from Excel? Data.ImportExcel operation Failed Revit revit , excel , importinstance , dynamo , levels	21	16108	September 20, 2023
Warning: Data.ImportExcel operation failed Revit excel , dynamo	1	527	June 12, 2023
Data.Import Excel Revit revit , excel , dynamo	4	401	October 2, 2023
Excel Nodes Fail Dynamo 1.1.0 Revit excel	33	6664	October 31, 2016

Data.ImportExcel operation failed

Related topics