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

Advertisements