Corridor - Edit Code Set Style in Excel

Last updated: 2025-06-02

Overview

This tool provides an option to manage and edit code set styles using Excel instead of directly in the Civil 3D interface.

Usage

WisDOT Design tab > Design panel > Corridor dropdown > Edit Code Set Style in Excel

The tool can also be accessed from the command line: DOTEditCodeSetStyleInExcel

Code Set Styles are listed in Toolspace > Settings tab > General > Multipurpose Styles > Code Set Styles

Editing a code set style using this tool consists of two operations, Export and Import

Export

  1. Select Code Set Style: In the dropdown, select a code set style that exists in the current drawing.

  2. Save As: Name the Excel file and choose a location where the file will be saved.

Color by Link - Point and Link Codes.xlsx example code set style in Excel format

Create/Edit code set styles in Excel

Excel file requirements to create Code Set Style:

  1. Named Range in workbook scope called "Civil3D_Import" that defines the code set style.
  2. Named Range must contain 10 columns and 3 rows. (Column * require a value, otherwise may be left blank)
    1. Column 1* = Type ("Link", "Point", or "Shape")
    2. Column 2* = Name (code name)
    3. Column 3 = Description (code description)
    4. Column 4* = Style (style name)
    5. Column 5 = Label Style
    6. Column 6 = Render Material
    7. Column 7 = Material Area Fill Style
    8. Column 8 = Feature Line Style
    9. Column 9 = Pay items (Comma separated if multiple)
    10. Column 10 = Classification Code
  3. Code Set Style name must be in the upper left corner cell of the named range

  4. The cell below the Code Set Style name is reserved for an optional style description

Info: Notifications are listed in the command line if styles listed in the edited code set style do not exist in the consuming drawing.

Import

Info: The file generated by the Export function comes properly formatted for the Import function.

  1. Select the code set style Excel file.

  2. The code set style is listed under Toolspace > Settings tab > General > Multipurpose Styles > Code Set Styles

    Info: The "Overwrite" function will replace an existing code set style in the drawing regardless if it is currently in use or not. If the drawing code set style is populated from a reference template, the import process will overwrite a duplicate code set style only for that session. The code set style will revert back to the reference template version when the drawing is reopened no matter if the drawing is saved or not.

  3. The code set style is listed under Toolspace > Settings tab > General > Multipurpose Styles > Code Set Styles