Exporting Data to Excel

00:01

In this session, we will discuss exporting data to Excel.

00:04

We have a completed and organized graph

00:06

already in Dynamo with the intent

00:08

to export that information and share with the project team.

00:12

We are in the final step of importing and exporting

00:15

data workflow.

00:16

Let's get started by switching over to Civil 3D

00:19

and Dynamo my drawing file already open since the graph

00:23

that I'm working with is connected

00:24

to this particular drawing file to open Dynamo.

00:28

We want to head to the Manage tab visual programming panel

00:32

and click on the Dynamo icon.

00:35

Once inside the Dynamo interface we're

00:37

going to open alignment stoichiometry table begin first

00:42

run the graph.

00:43

So that the data is captured from the current drawing file

00:47

the graph is complete with alignment geometry stations

00:50

and coordinate values and our list is organized.

00:54

The final step in this process is

00:56

to export in the Dynamo library under the import export

01:02

category under the data subcategory.

01:05

We have the option to export CSV or Excel.

01:09

Click the Export Excel to add the node to the workspace

01:15

starting at the top left.

01:16

We need to specify the location of the file.

01:19

The data will write to in the import

01:21

export category underneath file system subcategory.

01:26

We're going to scroll down and click on File path

01:31

to add that no to our workspace and moving into place.

01:35

Click browse on the file path node and locate

01:38

the existing Excel document.

01:42

Let's take a look at the Excel document that we just path to.

01:47

As you noticed this alignment data result Excel spreadsheet

01:50

that I've path to is empty and it currently

01:53

has one tab at the bottom by the name of sheet one

01:57

will want to take note of the capitalization.

01:59

So that way we can entered into the node back in Dynamo.

02:03

For now, we need to close out of this document.

02:05

Otherwise Dynamo will give us an error because the document is

02:08

open and it cannot write as read.

02:10

Only it's important to note the Dynamo will not create an Excel

02:14

spreadsheet from scratch.

02:16

So we need the path to an existing Excel spreadsheet

02:19

document before we connect to it.

02:23

Lastly, we connect the output to the input sheet name

02:28

is expecting a string data type.

02:31

So we add a string node to the workspace

02:36

and we enter the name of the tab that we just viewed.

02:38

And it is case sensitive, so we'll enter in sheet 1

02:42

and connect to the input for the Export Excel node rights data

02:50

by rows with sub list written in successive rows both rows

02:54

and columns are 0 indexed meaning a 0 value start

02:58

corresponds to sell a 1 in Excel.

03:01

The only way to skip columns and/or rows

03:04

would be to insert empty values in your data list

03:07

prior to importing that into your data Excel.

03:10

Node will add a number node to the graph

03:16

and enter 0 and connect that to the start row

03:22

and start column input values the data input

03:27

port accepts a variable.

03:29

So we will connect the list transpose data

03:31

node right to the data input our last input value will

03:36

be to overwrite existing data in the Excel document,

03:42

we will add a Boolean node since we are writing data

03:47

to an empty document.

03:49

And this is our first pass at exporting

03:51

we'll just add true to overwrite the data in the existing

03:54

document connect the data ports and run

03:58

the graph at this point, the Excel document

04:01

should open and display the exported information.