Hello All, Whenever I try to run the “Read.Excel” node in dynamo it opens the excel file along with it. Is there a way to stop opening the excel file? [image]

i have put together a bit of python code which closes the active workbook, you should be able to copy and paste the below code in. It uses an if statement as a trigger. Its a bit messy as you need to use this everytime a spreadsheet is opened. Ideally, would want this to run right at the end and clo…

Hi @Atkins14 , Took so long for me to return to this forum. many thanks for stitching the code, with my basic python knowledge I have edited yours a bit with True or False statement , here below. from System.IO import Directory import re import time import sys sys.path.append('C:\Program Files (x86…

https://stackoverflow.com/questions/25289149/how-can-i-manipulate-excel-data-in-python import clr clr.AddReferenceByName(‘Microsoft.Office.Interop.Excel, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c’) from Microsoft.Office. Interop import Excel Does anyone have the excel 2…

You could find it in the Primary Interop Assemblies like this [grafik] in the C:\Windows\assembly folder.

Next question @Raja : ) Where is the Windows Assembly folder?

My question is, why does excel open in the first place? Does it need to be open? I saw a couple of times that when I tried to run my graph and it started but never finished. I ended up closing Dynamo and that is when I saw that Excel was open. It (excel) appeared to stall Dynamo when it (excel) …

Excel does not need to be open. Somewhere in the implementation of the Excel.ReadFromFile node, the Excel.ApplicationClass has its Visible property set to true. It makes sense why this would be the case for the WriteToFile node, as it displays the file that was created, but it isn’t necessary for th…

Thank you. I was able to get my graph to run successfully (with the exception of Excel opening) it maybe that I am not on the most current dynamo version because I am still in Revit 2018.3 so I tend to only load the packages that do not give me the warning about them being created in a newer versi…

Read Excel file node Opens Excel file

FAQ

Raja March 5, 2019, 8:23am 11

Hi @Ron_Allen, the link seems to be prefixed with http so it didnt work in the last post. Its there in the C:\Windows\assembly folder.

Topic		Replies	Views
Close excel workbook Revit excel , dynamo	6	556	July 11, 2022
Close Excel once the run is finished, CPython3 excel , python , dynamo , cpython3	12	1245	January 8, 2025
Robot Structural Analysis 2025-Close Excel Dynamo Robot Structural Analysis python	10	249	August 7, 2024
Excel.ReadFromFile operation failed Revit revit , excel , dynamo	28	9858	February 16, 2023
Open Excel File with Python Developers	13	5358	February 25, 2020

Read Excel file node Opens Excel file

Related topics