Exporting to Excel

When dealing with data in Dynamo you may find that it's very difficult to review the results limited by the Dynamo interface. To improve the visualization of large amounts of data, one of the best ways to review the results is to export the data to an Excel sheet which makes it easier to read. This is achieved by using the [ExportExcel] node. Note that this is the standard out-of-the-box Excel export node, not the nodes found in various packages.

In Dynamo version 2.x, the node is named [ExportExcel].

In Dynamo version 1.x and 0.x, the node is named [Excel.WriteToFile].

Search for the Export Excel node by typing in "Excel" in the search bar. There are 6 inputs to this node:

1. File Path
   • The File Path input requires a location where your Excel sheet is located. Search for the File Path node by typing in "File Path" in the search bar.
2. Sheet Name
   • The "Sheet Name" is the name of the sheet in Excel you wish to export your data to. If the sheet does not exist, Excel will automatically create the sheet for you. This input requires a string input. We recommend using a [String] node. A [Code Block] node using quotations inside the node works too.
3. Start Row
   • The “Start Row” is the row where you wish your data to start. We recommend to start your data in row “1” to allow headings to be added in your Excel sheet at row 0 (the top most row in Excel). The next time you export data, the headings will be maintained. This requires an integer input. We recommend using a [Code Block] and simply typing in a “1” into the code block.
4. Start Column
   • The “Start Column” is the column where you wish your data to start. We recommend to start your column in row “0”. This requires an integer input. We recommend using a [Code Block] and simply typing in a “0” into the code block.
5. Data
   • The "Data" is a list of information that will be exported from Dynamo into Excel. This can be any list in Dynamo.
6. Overwrite
   • You may attach a [Boolean] node to this input. If the Boolean switch is set to "True", then the entire sheet in Excel will be deleted and overwritten with the new “Data”. We recommend not attaching a [Boolean] node and leaving the default input value as “False”.