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

One thought on “Excel.WriteToFile

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s