Click or drag to resize

SpreadColumn Fields

The SpreadColumn type exposes the following members.

Fields
 NameDescription
Public fieldBeginRowStarting row index for valid data.
Public fieldColIndexColumn index used by the originating application.
Public fieldColumnTypeType of the column in the spreadsheet (X, Y, Z, etc.).
Public fieldCommandCommand or formula associated with this column (if any).
Public fieldDataData values stored in this column. Each element is a Variant.
Public fieldDatasetNameName of the dataset this column belongs to (if any).
Public fieldDecimalPlacesNumber of decimal places used for display.
Public fieldEndRowEnding row index for valid data.
Public fieldImaginaryData The imaginary data. Is only not null if the data are complex.
Public fieldIndexIndex of the column within its sheet or dataset.
Public fieldNameName of the column.
Public fieldNumericDisplayTypeHow numeric values are displayed.
Public fieldNumRowsNumber of rows of data in this column.
Public fieldSheetSheet number this column belongs to.
Public fieldSignificantDigitsNumber of significant digits used for display.
Public fieldValueTypeLogical value type for the column (numeric, text, date, etc.).
Public fieldValueTypeSpecificationFormatting specification for the column values.
Public fieldWidthDisplay width for the column.
Top
See Also