Collection: 2DTableColumns

DIAdem 2018 Help


Edition Date: June 2018
Part Number: 370858P-01
View Product Info

DOWNLOAD (Windows Only)


DIAdem 2015 Help
DIAdem 2017 Help
DIAdem 2018 Help
DIAdem 2019 Help
DIAdem 2020 Help

Collection of all 2DTableColumn objects in DIAdem REPORT. Use the 2DTableColumns collection to access a single column in a 2D table in DIAdem REPORT.

The following example displays the types of all columns in all 2D tables:

Dim oMyReportObj, oMyReportObjects, oMySubObjects, oMySubObj, sOutput
sOutput = ""
Set oMyReportObjects = Report.ActiveSheet.Objects
For Each oMyReportObj in oMyReportObjects
  If oMyReportObj.ObjectType = eReportObject2DTable Then
    Set oMySubObjects = oMyReportObj.Columns
    For Each oMySubObj in oMySubObjects
      sOutput = sOutput & "Column type: " & oMySubObj.Type & vbCrLf
    Next
  End If
Next
Call MsgBoxDisp(sOutput)

Properties

Count

Methods

Add | ChangeType | Copy | Item | Move | Remove | RemoveAll

Returned From

2DTable.Columns

WAS THIS ARTICLE HELPFUL?

Not Helpful