Reading an excel file by range

Revit
, , ,
1

Hello,
I’m trying to be able to read a particular range of an excel file, but when I’m using the node “ReadExcel.ByRange” it returns null. I’ve been able to read the entire file when using the “ReadFromFile” node. I’ve attached the excel file I’m reading from along with the dynamo file, thanks!
Alex motor schedule test.xlsx (9.7 KB)
Schedule.CreateKeySchedule(Filter data from excel).dyn (4.1 KB)

image.png719×481 68.1 KB

Also I believe I have the most up-to-date BB package, listed below.

2

I had the same problem, try to use the node Read Excel with ORIGIN AND EXTEND data

1 Like
3

What version of Dynamo are you on? 1.3 is not supported yet.

1 Like
4

I’ve found an ugly work around for now @skd.arquitectos . Will you please reply when the new version is supported @Konrad_K_Sobon ? Thanks!

5

I think it´s the supported version @anelson

Captura de pantalla (47).png1920×1080 226 KB

1.2 DYNAMO VERSION

6

What gave it away? :wink: Yes, unfortunately I had to upgrade Dynamo to 1.3 to utilize the “ScheduleView.CreateSchedule” node that is not supported by Dynamo 1.2. I wonder if there is a way to set up a virtual environment to keep everything isolated and allow scripts to run on previous versions of Dynamo until everything is working in sync.