I’m trying to pull Structure information, i.e. station, offset, invert, etc., from a Civil 3d Pipe Network and export it to an excel sheet. I am stuck at converting a double to a var. [dbl to var]

Yeah it might not do to have so many export to excel nodes. The trick is to add all the lists into one which feeds into the “data” input for the same sheet in the excel output node. Here’s a trick to add in column headers too. Hope this helps! Pipe Network v2 KM.dyn (95.4 KB) [Pipe Network v2 KM_…

maybe add a list.create node before the data input?

Oh actually, your inputs for start row and col should be integers not strings sort of like this: [image]

Here’s a basic graph (using Civil3DToolkit) that works for me: Structure Station to Excel v0.dyn (28.9 KB)

This is what I came to and it works but is there a way to condense the export function? Currently, it is exporting each item which is causing potential overwrite issues. Pipe Network.dyn (156.8 KB) Also, side note, how do you download a dyn file? windows 10 wants an .exe file to use for the file …

Thank you! This solved all my issues and gave me ideas on how to move forward.

Pipe Network Information to Excel

Civil 3D

ctodd October 12, 2021, 10:11pm 5

You were correct. I added in number sliders, for ease of use, and it worked. thank you!

1 Like

Topic		Replies	Views
Use Civil3DToolkit to Export List of Pipes/Structures in a Network to Excel Civil 3D excel , dynamo , civil3d	1	745	October 8, 2020
Excel Storm System information into Civil 3d Civil 3D	3	1250	April 11, 2025
Convert civil 3D table to excel and modify simultaneously Civil 3D excel , python , geometry , dynamo , civil3d	6	555	September 18, 2023
Extract pipe network data to Excel Civil 3D	3	162	March 13, 2025
How to map string from Excel to elements Civil 3D	2	492	January 18, 2021

Pipe Network Information to Excel

Related topics