Civil 3D 2026.2 text string values not transferred with Data.OpenXMLExportExcel

Civil 3D
1

pnames
pnames1441Ă—712 89 KB

Civil 3D 2026.2 text string values not transferred with Data.OpenXMLExportExcel

the export watch node shows pipe names (P1, P2 etc.)

why are the pipe names not transferred the XLSX sheet?

thx for your patience,

K.

flow-v-26-01-23-01.xlsx (12.0 KB)

03c.dwg (1.7 MB)

03-1-export.dyn (28.5 KB)

2

@kbzawork

this node should export according to the datatypes (brown=string, blue=double) but just out of interest, what happens if you force everything to strings by setting writeAsString to true ?

3

same result - pipe names not transferred

4

nope … set cells at text in the XLSX - still not transferred

5

I will try an Autodesk support case … but … I’m pretty sure Dynamo is outside “normal” support

6

ex-to-xl
ex-to-xl1795Ă—881 124 KB

the Data.OpenXMLExportExcel node is in it’s early dev days, causes corrupt XLSX

Use python instead

# Dynamo Python Script
# Works in Civil 3D 2026.2 (IronPython)

import clr
import sys
import os
from traceback import format_exc

# openpyxl is available in Dynamo
from openpyxl import load_workbook

# Inputs
file_path = IN[0]
sheet_name = IN[1]
data = IN[2]
start_col = IN[3]   # 1-based index

# Basic validation
if not os.path.exists(file_path):
    raise Exception("Excel file does not exist: " + file_path)

# Load workbook
wb = load_workbook(file_path)

if sheet_name not in wb.sheetnames:
    raise Exception("Sheet not found: " + sheet_name)

err= "No error";


try:
    ws = wb[sheet_name]
    start_row = 1;
    
    for r, row_data in enumerate(data):
        for c, value in enumerate(row_data):
            ws.cell(
                row=start_row + r,
                column=start_col + c,
                value=value
            )
    
    # Save workbook
    wb.save(file_path)
except:
    err = format_exc()

OUT = err

03-1-export.dyn (33.7 KB)

1 Like