Columns (Collection)

Member of:

TableSection object, ResultSection object

Description:

Represents all columns in Table or Results sections.

Tip:

All collections have a “Item(NameOrIndex)” method. This is the default method for all collections and returns an item in the collection at a particular index or with a specific name. Use brackets ([]) to represent calls to Item (Method). For example, these statements cause identical in behavior: myItem = Documents[1] myItem = Documents.Item(1) myItem = Documents["StartUp.bqy"] myItem = Documents.Item("StartUp.bqy")

Example:

This example shows how to add a computed column, MyComputed to the Results section. This example includes strings and numeric calculations in the same computed columns:

var MyResults = ActiveDocument.Sections["Results"]
var NumColumns = MyResults.Columns.Count
var Expression = ("Number of Columns="+Number(NumColumns+1))
MyResults.Columns.AddComputed("MyComputed", Expression)

Methods:

Add(Name As String) As Column, AddComputed(Name As String, Expression As String) As Column, Item(NameOrIndex) As Column, ModifyComputed(NameOrIndex, Expression As String) As String, RemoveAll()

Properties:

Read-only: Property Count As Number