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).
One thought on “Excel.WriteToFile”