OpenNavisFile.OpenFile

This node opens a file in Navisworks, and can be run from Dynamo in sandbox or standalone mode. The Boolean switch optionally allows Navisworks to run ‘hidden’ or in the background (when set to false). The output is a ‘OpenNavisFile’ object, which is used in other DynaWorks nodes.

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).