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

List Length Validator

Take a list of lists and check whether all lists have the same length (same number of items in the list). This node is useful to run as part of a data export workflow (perhaps to Excel), to ensure the output lists are matching and thus have integrity.

Collect All FamilyInstance using Element Types

It is often useful to select only the Family Instances (Component Families) from the current document. This can allow easy access to element parameters, or could even be paired with a Family Location node to then access the point coordinates of all family origins. This node takes no inputs, and runs against the current document. It is a simple wrapper of the Element Types and All Elements of Type Standard Nodes, but it uses less screen real estate and is a good building block for more advanced workflows.