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]

Thanks @Konrad_K_Sobon I use Bumblebee for my personal use, but when i have to give the visual code to others who doesn’t have the package i either should ask them to install it or use the default nodes in dynamo. In the latter case I came across this issue so i was wondering why.

@Raja did you ever fine a solution to this? i am having same issue with my team not always having bumblebee installed - so using the built in read / write excel would be be easier for sharing scripts.

@Atkins14 sorry for such a late reply, there isnt any solution for me untill now.

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?

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.

Read Excel file node Opens Excel file

FAQ

Konrad_K_Sobon November 30, 2016, 2:23am 2

Try using Bumblebee instead.

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

Read Excel file node Opens Excel file

Related topics