This takes a NavisObject (such as a ‘Node’ in DynaWorks), and lists the Object Names associated with that item.
Author: lukesjohnson
NavisNodes.GetFilesInProject
OpenNavisFile.OpenFile
List.UniqueItems
Element.OwnerView
Str2Pt
Pt2Str
Write Excel
This is an alternate way to write to Excel (instead of using the built in Excel.WriteToFile), found in the Bumblebee package created by Konrad Sobon. It requires the user to set up a ‘BB Data’ node, which is one of the inputs. The full list of inputs is:
FilePath
RunIt – a true / false switch, where true means ‘do it’
ByColumn – a true / false switch that essentially has the effect of Transposing the data before writing it
BB Data – a node that sets up the information to be written to Excel, and it comprehends the ‘Excel way’ of writing cell references, ie. A1, A2 etc.
More information at: http://archi-lab.net/bumblebee-dynamo-and-excel-interop/
Excel.WriteToFile
This is a Standard Node that allows Dynamo to write list data directly to an Excel file. While running, Excel will open and the data will populate.
Inputs:
filePath – path to the desired target Excel file
sheetName – write the data into this Excel sheet
startRow and startCol – 0 based index for the start of the Excel write operation. 0,0 as shown below is equivalent to A1.
data – a list or list of lists. To alter whether data is written by Rows or Columns, a List.Tranpose node can be included immediately before the data input.
overWrite – allows control over whether Excel will overwrite existing information (true), or retain it (false).











