Dynamo script to read cells in excel sheet

My colleague started developing a Dynamo file to read an excel sheet with a couple of columns that would populate sheet names and titleblocks with sheet name and number. I wanted to see if we could get the dynamo to read more than two columns of data from the excel like up to 8 columns.

My colleague is running into a roadblock solving this and wondered if this is an item in the code to either copy the same code that was being used to read the first two columns or is there another parameter or setting to direct the script to read more cells via extending coordinate region?

I am fairly new to this but figured I’d ask to help my colleague get a solution.

Hi John, welcome :wave:
Please take the time to read the forum FAQ if you haven’t had the chance How to get help on the Dynamo forums

Dynamo has nodes that can read Excel as large as your computer memory can handle
Use Data.OpenXMLImportExcel (This may have issues with certain packages, GeniusLoci *cough*) alternately use the Crumple nodes Excel.Read that uses Python and Pandas on the backend if you are using recent versions of Revit

3 Likes

I really helps if you posted a screenshot of what you have so far with the preview bubbles pinned.

1 Like