ActiveXLS v6.4.0 API Documentation

Constant Values


Contents
ActiveXLS.Constants

ActiveXLS.Constants.Alignment
public const System.String ALIGNMENT_BOTTOM "bottom"
public const System.String ALIGNMENT_CENTER "center"
public const System.String ALIGNMENT_CENTER_ACROSS_SELECTION "center across selection"
public const System.String ALIGNMENT_FILL "fill"
public const System.String ALIGNMENT_GENERAL "general"
public const System.String ALIGNMENT_JUSTIFY "justify"
public const System.String ALIGNMENT_LEFT "left"
public const System.String ALIGNMENT_MIDDLE "middle"
public const System.String ALIGNMENT_RIGHT "right"
public const System.String ALIGNMENT_TOP "top"

ActiveXLS.Constants.Border
public const int BORDER_DASH_DOT 9
public const int BORDER_DASH_DOT_DOT 11
public const int BORDER_DASHED 3
public const int BORDER_DOTTED 4
public const int BORDER_DOUBLE 6
public const int BORDER_HAIR 7
public const int BORDER_MEDIUM 2
public const int BORDER_MEDIUM_DASH_DOT 10
public const int BORDER_MEDIUM_DASH_DOT_DOT 12
public const int BORDER_MEDIUM_DASHED 8
public const int BORDER_NONE 0
public const int BORDER_SLANTED_DASH_DOT 13
public const int BORDER_THICK 5
public const int BORDER_THIN 1

ActiveXLS.Constants.Chart
public const int AXIS_TICK_MARK_LABEL_HIGH 2
public const int AXIS_TICK_MARK_LABEL_LOW 1
public const int AXIS_TICK_MARK_LABEL_NEXT_TO_AXIS 3
public const int AXIS_TICK_MARK_LABEL_NONE 0
public const int AXIS_TICK_MARK_TYPE_CROSS 3
public const int AXIS_TICK_MARK_TYPE_INSIDE 1
public const int AXIS_TICK_MARK_TYPE_NONE 0
public const int AXIS_TICK_MARK_TYPE_OUTSIDE 2
public const int CHART_TYPE_AREA 50
public const int CHART_TYPE_AREA_100_PERCENT_STACKED 52
public const int CHART_TYPE_AREA_3D 53
public const int CHART_TYPE_AREA_3D_100_PERCENT_STACKED 55
public const int CHART_TYPE_AREA_3D_STACKED 54
public const int CHART_TYPE_AREA_STACKED 51
public const int CHART_TYPE_BAR_100_PERCENT_STACKED 12
public const int CHART_TYPE_BAR_3D_100_PERCENT_STACKED 15
public const int CHART_TYPE_BAR_3D_CLUSTERED 13
public const int CHART_TYPE_BAR_3D_STACKED 14
public const int CHART_TYPE_BAR_CLUSTERED 10
public const int CHART_TYPE_BAR_OF_PIE 35
public const int CHART_TYPE_BAR_STACKED 11
public const int CHART_TYPE_BUBBLE 90
public const int CHART_TYPE_BUBBLE_3D_EFFECT 91
public const int CHART_TYPE_COLUMN_100_PERCENT_STACKED 2
public const int CHART_TYPE_COLUMN_3D 6
public const int CHART_TYPE_COLUMN_3D_100_PERCENT_STACKED 5
public const int CHART_TYPE_COLUMN_3D_CLUSTERED 3
public const int CHART_TYPE_COLUMN_3D_STACKED 4
public const int CHART_TYPE_COLUMN_CLUSTERED 0
public const int CHART_TYPE_COLUMN_STACKED 1
public const int CHART_TYPE_CONE_BAR 123
public const int CHART_TYPE_CONE_BAR_100_PERCENT_STACKED 125
public const int CHART_TYPE_CONE_BAR_STACKED 124
public const int CHART_TYPE_CONE_COLUMN 120
public const int CHART_TYPE_CONE_COLUMN_100_PERCENT_STACKED 122
public const int CHART_TYPE_CONE_COLUMN_3D 126
public const int CHART_TYPE_CONE_COLUMN_STACKED 121
public const int CHART_TYPE_CYLINDER_BAR 113
public const int CHART_TYPE_CYLINDER_BAR_100_PERCENT_STACKED 115
public const int CHART_TYPE_CYLINDER_BAR_STACKED 114
public const int CHART_TYPE_CYLINDER_COLUMN 110
public const int CHART_TYPE_CYLINDER_COLUMN_100_PERCENT_STACKED 112
public const int CHART_TYPE_CYLINDER_COLUMN_3D 116
public const int CHART_TYPE_CYLINDER_COLUMN_STACKED 111
public const int CHART_TYPE_DOUGHNUT 60
public const int CHART_TYPE_DOUGHNUT_EXPLODED 61
public const int CHART_TYPE_LINE 20
public const int CHART_TYPE_LINE_100_PERCENT_STACKED 22
public const int CHART_TYPE_LINE_100_PERCENT_STACKED_MARKERS 25
public const int CHART_TYPE_LINE_3D 26
public const int CHART_TYPE_LINE_MARKERS 23
public const int CHART_TYPE_LINE_STACKED 21
public const int CHART_TYPE_LINE_STACKED_MARKERS 24
public const int CHART_TYPE_PIE 30
public const int CHART_TYPE_PIE_3D 31
public const int CHART_TYPE_PIE_3D_EXPLODED 34
public const int CHART_TYPE_PIE_EXPLODED 33
public const int CHART_TYPE_PIE_OF_PIE 32
public const int CHART_TYPE_PYRAMID_BAR 133
public const int CHART_TYPE_PYRAMID_BAR_100_PERCENT_STACKED 135
public const int CHART_TYPE_PYRAMID_BAR_STACKED 134
public const int CHART_TYPE_PYRAMID_COLUMN 130
public const int CHART_TYPE_PYRAMID_COLUMN_100_PERCENT_STACKED 132
public const int CHART_TYPE_PYRAMID_COLUMN_3D 136
public const int CHART_TYPE_PYRAMID_COLUMN_STACKED 131
public const int CHART_TYPE_RADAR 70
public const int CHART_TYPE_RADAR_FILLED 72
public const int CHART_TYPE_RADAR_MARKERS 71
public const int CHART_TYPE_SCATTER 40
public const int CHART_TYPE_SCATTER_LINES 44
public const int CHART_TYPE_SCATTER_LINES_MARKERS 43
public const int CHART_TYPE_SCATTER_SMOOTHED_LINES 42
public const int CHART_TYPE_SCATTER_SMOOTHED_LINES_MARKERS 41
public const int CHART_TYPE_STOCK_HIGH_LOW_CLOSE 100
public const int CHART_TYPE_STOCK_OPEN_HIGH_LOW_CLOSE 101
public const int CHART_TYPE_STOCK_VOLUME_HIGH_LOW_CLOSE 102
public const int CHART_TYPE_STOCK_VOLUME_OPEN_HIGH_LOW_CLOSE 103
public const int CHART_TYPE_SURFACE_3D 80
public const int CHART_TYPE_SURFACE_3D_WIREFRAME 81
public const int CHART_TYPE_SURFACE_CONTOUR 82
public const int CHART_TYPE_SURFACE_CONTOUR_WIREFRAME 83
public const int KEYS_ARRANGEMENT_DIRECTION_HORIZONTAL 0
public const int KEYS_ARRANGEMENT_DIRECTION_VERTICAL 1
public const int LEGEND_BOTTOM 0
public const int LEGEND_CORNER 1
public const int LEGEND_LEFT 4
public const int LEGEND_NOT_DOCKED_OR_INSIDE_THE_PLOT_AREA 7
public const int LEGEND_RIGHT 3
public const int LEGEND_TOP 2
public const int LINE_STYLE_DARK_GRAY 6
public const int LINE_STYLE_DASH 1
public const int LINE_STYLE_DASH_DOT 3
public const int LINE_STYLE_DASH_DOT_DOT 4
public const int LINE_STYLE_DOT 2
public const int LINE_STYLE_LIGHT_GRAY 8
public const int LINE_STYLE_MEDIUM_GRAY 7
public const int LINE_STYLE_NONE 5
public const int LINE_STYLE_SOLID 0
public const int LINE_WEIGHT_HAIRLINE -1
public const int LINE_WEIGHT_MEDIUM 1
public const int LINE_WEIGHT_NARROW 0
public const int LINE_WEIGHT_WIDE 2
public const int LINE_WEIGHT_ZERO 65535
public const int SERIES_DATA_LABELS_NONE 0
public const int SERIES_DATA_LABELS_SHOW_BUBBLE_SIZE 5
public const int SERIES_DATA_LABELS_SHOW_LABEL 3
public const int SERIES_DATA_LABELS_SHOW_LABEL_AND_PERCENT 4
public const int SERIES_DATA_LABELS_SHOW_PERCENT 2
public const int SERIES_DATA_LABELS_SHOW_VALUE 1
public const int SERIES_IN_COLUMNS 1
public const int SERIES_IN_ROWS 0
public const int SERIES_MARKER_AUTOMATIC -1
public const int SERIES_MARKER_CIRCLE 8
public const int SERIES_MARKER_DIAMOND 2
public const int SERIES_MARKER_DOW_JONES 6
public const int SERIES_MARKER_NONE 0
public const int SERIES_MARKER_PLUS_SIGN 9
public const int SERIES_MARKER_SQUARE 1
public const int SERIES_MARKER_STANDARD_DEVIATION 7
public const int SERIES_MARKER_STAR 5
public const int SERIES_MARKER_TRIANGLE 3
public const int SERIES_MARKER_X 4

ActiveXLS.Constants.ConditionalFormatting
public const int CONDITIONAL_FORMATTING_TYPE_COMPARE_CELL_VALUE 1
public const int CONDITIONAL_FORMATTING_TYPE_EVALUATE_FORMULA 2
public const int OPERATOR_BETWEEN 1
public const int OPERATOR_EQUAL_TO 3
public const int OPERATOR_GREATER_THAN 5
public const int OPERATOR_GREATER_THAN_OR_EQUAL_TO 7
public const int OPERATOR_LESS_THAN 6
public const int OPERATOR_LESS_THAN_OR_EQUAL_TO 8
public const int OPERATOR_NO_COMPARATION 0
public const int OPERATOR_NOT_BETWEEN 2
public const int OPERATOR_NOT_EQUAL_TO 4

ActiveXLS.Constants.DataGroup
public const int GROUP_BY_COLUMNS 1
public const int GROUP_BY_ROWS 0

ActiveXLS.Constants.DataType
public const System.String AUTOMATIC "automatic"
public const System.String BOOLEAN "bool"
public const System.String DATE "date"
public const System.String ERROR "error"
public const System.String NUMERIC "numeric"
public const System.String STRING "string"

ActiveXLS.Constants.DataValidator
public const int ERROR_INFO 2
public const int ERROR_STOP 0
public const int ERROR_WARNING 1
public const int OPERATOR_BETWEEN 0
public const int OPERATOR_EQUAL_TO 2
public const int OPERATOR_GREATER_THAN 4
public const int OPERATOR_GREATER_THAN_OR_EQUAL_TO 6
public const int OPERATOR_LESS_THAN 5
public const int OPERATOR_LESS_THAN_OR_EQUAL_TO 7
public const int OPERATOR_NOT_BETWEEN 1
public const int OPERATOR_NOT_EQUAL_TO 3
public const int VALIDATE_ANY_VALUE 0
public const int VALIDATE_CUSTOM 7
public const int VALIDATE_DATE 4
public const int VALIDATE_DECIMAL 2
public const int VALIDATE_LIST 3
public const int VALIDATE_TEXT_LENGTH 6
public const int VALIDATE_TIME 5
public const int VALIDATE_WHOLE_NUMBER 1

ActiveXLS.Constants.ErrorType
public const int DIV0 7
public const int NA 42
public const int NAME 29
public const int NULL 0
public const int NUM 36
public const int REF 23
public const int VALUE 15

ActiveXLS.Constants.FileProperty
public const long VT_BLOB 65l
public const long VT_BOOL 11l
public const long VT_FILETIME 64l
public const long VT_I2 2l
public const long VT_I4 3l
public const long VT_LPSTR 30l
public const long VT_NULL 1l
public const long VT_NUMBER 5l
public const long VT_VARIANT 12l

ActiveXLS.Constants.FontSettings
public const int UNDERLINE_STYLE_DOUBLE 2
public const int UNDERLINE_STYLE_DOUBLE_ACCOUNTING 34
public const int UNDERLINE_STYLE_NONE 0
public const int UNDERLINE_STYLE_SINGLE 1
public const int UNDERLINE_STYLE_SINGLE_ACCOUNTING 33

ActiveXLS.Constants.Footer
public const System.String POSITION_CENTER "C"
public const System.String POSITION_LEFT "L"
public const System.String POSITION_RIGHT "R"

ActiveXLS.Constants.Format
public const System.String FORMAT_AS_HALVES "# ?/2"
public const System.String FORMAT_AS_QUARTERS "# ?/4"
public const System.String FORMAT_AS_TENTHS "# ?/10"
public const System.String FORMAT_CURRENCY "$0.00"
public const System.String FORMAT_DATE "MM/dd/yyyy"
public const System.String FORMAT_DATE_TIME "MM/dd/yyyy HH:mm:ss"
public const System.String FORMAT_FLOAT_2DECIMALS "0.00"
public const System.String FORMAT_FLOAT_2DECIMALS_PERCENT "0.00%"
public const System.String FORMAT_GENERAL "General"
public const System.String FORMAT_INTEGER "0"
public const System.String FORMAT_INTEGER_PERCENT "0%"

ActiveXLS.Constants.Header
public const System.String POSITION_CENTER "C"
public const System.String POSITION_LEFT "L"
public const System.String POSITION_RIGHT "R"

ActiveXLS.Constants.HyperlinkType
public const System.String CELL "cell"
public const System.String FILE "file"
public const System.String NOHYPERLINK "nohyperlink"
public const System.String UNC "unc"
public const System.String UNKNOWN "unknown"
public const System.String URL "url"

ActiveXLS.Constants.PageSetup
public const int COMMENTS_AS_DISPLAYED_ON_SHEET 2
public const int COMMENTS_AT_END_OF_SHEET 1
public const int COMMENTS_NONE 0
public const System.String ORIENTATION_LANDSCAPE "Landscape"
public const System.String ORIENTATION_PORTRAIT "Portrait"
public const int PAGE_ORDER_DOWN_THEN_OVER 0
public const int PAGE_ORDER_OVER_THEN_DOWN 1
public const int PAPER_SIZE_16K 123
public const int PAPER_SIZE_A2_PAPER 66
public const int PAPER_SIZE_A3 8
public const int PAPER_SIZE_A3_EXTRA_PAPER 63
public const int PAPER_SIZE_A3_EXTRA_TRANSVERSE_PAPER 68
public const int PAPER_SIZE_A3_TRANSVERSE_PAPER 67
public const int PAPER_SIZE_A4 9
public const int PAPER_SIZE_A4_EXTRA_PAPER 53
public const int PAPER_SIZE_A4_PLUS_PAPER 60
public const int PAPER_SIZE_A4_SMALL 10
public const int PAPER_SIZE_A4_TRANSVERSE_PAPER 55
public const int PAPER_SIZE_A5 11
public const int PAPER_SIZE_A5_EXTRA_PAPER 64
public const int PAPER_SIZE_A5_TRANSVERSE_PAPER 61
public const int PAPER_SIZE_A6 70
public const int PAPER_SIZE_B4 12
public const int PAPER_SIZE_B4_ISO 42
public const int PAPER_SIZE_B5_EXTRA_PAPER_ISO 65
public const int PAPER_SIZE_B5_ISO 119
public const int PAPER_SIZE_B5_JIS 13
public const int PAPER_SIZE_B5_JIS_TRANSVERSE_PAPER 62
public const int PAPER_SIZE_C_PAPER 24
public const int PAPER_SIZE_CUSTOM 0
public const int PAPER_SIZE_D_PAPER 25
public const int PAPER_SIZE_DOUBLE_POST_CARD 120
public const int PAPER_SIZE_E_PAPER 26
public const int PAPER_SIZE_ENVELOPE_10 20
public const int PAPER_SIZE_ENVELOPE_11 21
public const int PAPER_SIZE_ENVELOPE_12 22
public const int PAPER_SIZE_ENVELOPE_14 23
public const int PAPER_SIZE_ENVELOPE_6_3PER4 38
public const int PAPER_SIZE_ENVELOPE_9 19
public const int PAPER_SIZE_ENVELOPE_B4 33
public const int PAPER_SIZE_ENVELOPE_B5 34
public const int PAPER_SIZE_ENVELOPE_B6 35
public const int PAPER_SIZE_ENVELOPE_C3 29
public const int PAPER_SIZE_ENVELOPE_C4 30
public const int PAPER_SIZE_ENVELOPE_C5 28
public const int PAPER_SIZE_ENVELOPE_C6 31
public const int PAPER_SIZE_ENVELOPE_C65 32
public const int PAPER_SIZE_ENVELOPE_DL 27
public const int PAPER_SIZE_ENVELOPE_INVITE 47
public const int PAPER_SIZE_ENVELOPE_ITALY 36
public const int PAPER_SIZE_ENVELOPE_MONARCH 37
public const int PAPER_SIZE_EXECUTIVE 7
public const int PAPER_SIZE_FOLIO_PAPER 14
public const int PAPER_SIZE_GERMAN_LEGAL_FANFOLD 41
public const int PAPER_SIZE_GERMAN_STANDARD_FANFOLD 40
public const int PAPER_SIZE_JAPANESE_DOUBLE_POSTCARD 43
public const int PAPER_SIZE_LEDGER 4
public const int PAPER_SIZE_LEGAL 5
public const int PAPER_SIZE_LEGAL_EXTRA_PAPER 51
public const int PAPER_SIZE_LETTER 1
public const int PAPER_SIZE_LETTER_EXTRA_PAPER 50
public const int PAPER_SIZE_LETTER_EXTRA_TRANSVERSE_PAPER 56
public const int PAPER_SIZE_LETTER_PLUS_PAPER 59
public const int PAPER_SIZE_LETTER_SMALL 2
public const int PAPER_SIZE_LETTER_TRANSVERSE_PAPER 54
public const int PAPER_SIZE_NOTE_PAPER 18
public const int PAPER_SIZE_POST_CARD 121
public const int PAPER_SIZE_QUARTO_PAPER 15
public const int PAPER_SIZE_STANDARD_PAPER_10_BY_11 45
public const int PAPER_SIZE_STANDARD_PAPER_10_BY_14 16
public const int PAPER_SIZE_STANDARD_PAPER_11_BY_17 17
public const int PAPER_SIZE_STANDARD_PAPER_15_BY_11 46
public const int PAPER_SIZE_STANDARD_PAPER_9_BY_11 44
public const int PAPER_SIZE_STATEMENT 6
public const int PAPER_SIZE_SUPER_A_PER_SUPER_A_PER_A4 57
public const int PAPER_SIZE_SUPER_B_PER_SUPER_B_PER_A3 58
public const int PAPER_SIZE_TABLOID 3
public const int PAPER_SIZE_TABLOID_EXTRA_PAPER 52
public const int PAPER_SIZE_US_STANDARD_FANFOLD 39

ActiveXLS.Constants.Pattern
public const int PATTERN_12PERCENT_GRAY 17
public const int PATTERN_25PERCENT_GRAY 4
public const int PATTERN_50PERCENT_GRAY 2
public const int PATTERN_6PERCENT_GRAY 18
public const int PATTERN_75PERCENT_GRAY 3
public const int PATTERN_DIAGONAL_CROSSHATCH 9
public const int PATTERN_DIAGONAL_STRIPE 8
public const int PATTERN_HORIZONTAL_STRIPE 5
public const int PATTERN_NONE 0
public const int PATTERN_REVERSE_DIAGONAL_STRIPE 7
public const int PATTERN_SOLID 1
public const int PATTERN_THICK_DIAGONAL_CROSSHATCH 10
public const int PATTERN_THIN_DIAGONAL_CROSSHATCH 16
public const int PATTERN_THIN_DIAGONAL_STRIPE 14
public const int PATTERN_THIN_HORIZONTAL_CROSSHATCH 15
public const int PATTERN_THIN_HORIZONTAL_STRIPE 11
public const int PATTERN_THIN_REVERSE_DIAGONAL_STRIPE 13
public const int PATTERN_THIN_VERTICAL_STRIPE 12
public const int PATTERN_VERTICAL_STRIPE 6

ActiveXLS.Constants.Styles
public const int AUTOFORMAT_3D_EFFECTS1 37
public const int AUTOFORMAT_3D_EFFECTS1_RIGHT_TOTAL 39
public const int AUTOFORMAT_3D_EFFECTS1_SUBTOTAL 38
public const int AUTOFORMAT_3D_EFFECTS1_TOTALS 40
public const int AUTOFORMAT_3D_EFFECTS2 41
public const int AUTOFORMAT_3D_EFFECTS2_SUBTOTAL 42
public const int AUTOFORMAT_ACCOUNTING1 11
public const int AUTOFORMAT_ACCOUNTING1_RIGHT_TOTAL 13
public const int AUTOFORMAT_ACCOUNTING1_SUBTOTAL 12
public const int AUTOFORMAT_ACCOUNTING1_TOTALS 14
public const int AUTOFORMAT_ACCOUNTING2 15
public const int AUTOFORMAT_ACCOUNTING2_SUBTOTAL 16
public const int AUTOFORMAT_ACCOUNTING3 17
public const int AUTOFORMAT_ACCOUNTING3_SUBTOTAL 18
public const int AUTOFORMAT_ACCOUNTING4 19
public const int AUTOFORMAT_ACCOUNTING4_SUBTOTAL 20
public const int AUTOFORMAT_ACTIVEXLS1 43
public const int AUTOFORMAT_ACTIVEXLS1_SUBTOTAL 44
public const int AUTOFORMAT_ACTIVEXLS2 45
public const int AUTOFORMAT_ACTIVEXLS2_SUBTOTAL 46
public const int AUTOFORMAT_ACTIVEXLS3 47
public const int AUTOFORMAT_ACTIVEXLS3_SUBTOTAL 48
public const int AUTOFORMAT_CLASSIC1 3
public const int AUTOFORMAT_CLASSIC1_RIGHT_TOTAL 5
public const int AUTOFORMAT_CLASSIC1_SUBTOTAL 4
public const int AUTOFORMAT_CLASSIC1_TOTALS 6
public const int AUTOFORMAT_CLASSIC2 7
public const int AUTOFORMAT_CLASSIC2_SUBTOTAL 8
public const int AUTOFORMAT_CLASSIC3 9
public const int AUTOFORMAT_CLASSIC3_SUBTOTAL 10
public const int AUTOFORMAT_COLORFUL1 21
public const int AUTOFORMAT_COLORFUL1_SUBTOTAL 22
public const int AUTOFORMAT_COLORFUL2 23
public const int AUTOFORMAT_COLORFUL2_RIGHT_TOTAL 25
public const int AUTOFORMAT_COLORFUL2_SUBTOTAL 24
public const int AUTOFORMAT_COLORFUL2_TOTALS 26
public const int AUTOFORMAT_COLORFUL3 27
public const int AUTOFORMAT_COLORFUL3_RIGHT_TOTAL 29
public const int AUTOFORMAT_COLORFUL3_SUBTOTAL 28
public const int AUTOFORMAT_COLORFUL3_TOTALS 30
public const int AUTOFORMAT_LIST1 31
public const int AUTOFORMAT_LIST1_SUBTOTAL 32
public const int AUTOFORMAT_LIST2 33
public const int AUTOFORMAT_LIST2_SUBTOTAL 34
public const int AUTOFORMAT_LIST3 35
public const int AUTOFORMAT_LIST3_SUBTOTAL 36
public const int AUTOFORMAT_NONE 0
public const int AUTOFORMAT_SIMPLE 1
public const int AUTOFORMAT_SIMPLE_SUBTOTAL 2

ActiveXLS.Constants.Table
public const int MAX_COLUMNS 16384
public const int MAX_COLUMNS_OFFICE_97_2003 256
public const int MAX_ROWS 1048576
public const int MAX_ROWS_OFFICE_97_2003 65536


Copyright 2009 On Time Computing Solutions