DataColumn Object (Visio)

Allows custom mapping of the properties of a column of a data recordset to Microsoft Visio ShapeSheet spreadsheet cells.

Remarks

The default property of the DataColumn object is Name, which returns the name of the data column in the associated data recordset.

The Visible property specifies whether the data column is visible in the External Data window.

Many of the properties of the DataColumn object correspond closely to the columns of the Shape Data section of the ShapeSheet of shapes linked to data. For example, the DisplayName property, which specifies the name that appears for the associated data column in the External Data window in the Visio user interface, corresponds to the Label column in the Shape Data section, which controls the label that appears for a particular Shape Data item in the Shape Data dialog box.

You can also set the DisplayName property value in the Column Settings dialog box in the Visio user interface (right-click in the External Data window, and then click Column Settings) .

Note that the read-only Name property specifies the programmatic name for this data column in the data recordset that contains the data column, but that you can specify the value of the read/write DisplayName property.

Use the GetProperty method to get the value of the data column property you specify. Data column properties must be one of the enumerated values in VisDataColumnProperties, which is declared in the Visio type library.

Use the SetProperty method to set the value of the data column property you specify, from the members of VisDataColumnProperties. The SetProperty topic contains a table that shows a matrix of allowable data column types and property settings. These settings correspond to those you can set in the Types and Settings dialog box for an individual column (select a column in the Column Settings dialog box, and then click Data Type).