Intelligent Media Management:Table

XlAboveBelow

Specifies if the values are above or below average.

• Usage notes

  expression.Enum.XlAboveBelow.xlAboveAverage

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlAboveAverage	0	Above the average.
  xlBelowAverage	1	Below the average.
  xlEqualAboveAverage	2	Equal to the average.

XlAutoFillType

Specifies how the target range is to be filled, based on the contents of the source range.

• Usage notes

  expression.Enum.XlAutoFillType.xlFillDefault

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlFillDefault	0	Determine the values and the formats that are used to fill the target range.
  xlFillCopy	1	Copy the values and formats from the source range to the target range, and repeat if necessary.
  xlFillSeries	2	Extend the values in the source range to the target range as a series. For example, '1, 2' is extended as '3, 4, 5'. Copy the formats from the source range to the target range, and repeat if necessary.
  xlFillFormats	3	Copy only the formats from the source range to the target range, and repeat if necessary.
  xlFillValues	4	Copy only the values from the source range to the target range, and repeat if necessary.
  xlFillDays	5	Extend the names of the days of the week in the source range into the target range. Copy the formats from the source range to the target range, and repeat if necessary.
  xlFillWeekdays	6	Extend the names of the days of the workweek in the source range into the target range. Copy the formats from the source range to the target range, and repeat if necessary.
  xlFillMonths	7	Extend the names of the months in the source range into the target range. Copy the formats from the source range to the target range, and repeat if necessary.
  xlFillYears	8	Extend the years in the source range into the target range. Copy the formats from the source range to the target range, and repeat if necessary.
  xlLinearTrend	9	Extend the numeric values from the source range into the target range, assuming that the relationships between the numbers is additive. For example, '1, 2,' is extended as '3, 4, 5', assuming that each number is a result of adding some value to the previous number. Copy the formats from the source range to the target range, and repeat if necessary.
  xlGrowthTrend	10	Extend the numeric values from the source range into the target range, assuming that the relationships between the numbers in the source range are multiplicative. For example, '1, 2,' is extended as '4, 8, 16', assuming that each number is a result of multiplying the previous number by some value. Copy the formats from the source range to the target range, and repeat if necessary.

XlBorderWeight

Specifies the weight of the border around a range.

• Usage notes

  expression.Enum.XlBorderWeight.xlHairline

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlMedium	-4138	Medium border.
  xlHairline	1	Hairline border (the thinnest border).
  xlThin	2	Thin border.
  xlThick	4	Thick border (the thickest border).

XlBordersIndex

Specifies the border to be retrieved.

• Usage notes

  expression.Enum.XlBordersIndex.xlDiagonalDown

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlDiagonalDown	5	The border running from the upper-left corner to the lower-right corner of each cell in the range.
  xlDiagonalUp	6	The border running from the lower-left corner to the upper-right corner of each cell in the range.
  xlEdgeLeft	7	The border at the left edge of the range.
  xlEdgeTop	8	The border at the top of the range.
  xlEdgeBottom	9	The border at the bottom of the range.
  xlEdgeRight	10	The border at the right edge of the range.
  xlInsideVertical	11	The vertical borders of all cells in the range except borders outside the range.
  xlInsideHorizontal	12	The horizontal borders of all cells in the range except borders outside the range.
  xlOutside	13	The borders at the top, bottom, left, and right edges of the range.
  xlInside	14	The borders of all cells except borders on the edges of the range.

XlChartType

Specifies the chart type.

• Usage notes

  expression.Enum.XlChartType.xlBarClustered

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlArea	1	Area.
  xlAreaStacked	76	Stacked area.
  xlAreaStacked100	77	100% stacked area.
  xlBarClustered	57	Clustered bar.
  xlBarOfPie	71	Bar of pie.
  xlBarStacked	58	Stacked bar.
  xlBarStacked100	59	100% stacked bar.
  xlBubble	15	Bubble.
  xlColumnClustered	51	Clustered column.
  xlColumnStacked	52	Stacked column.
  xlColumnStacked100	53	100% stacked column.
  xlDoughnut	-4120	Doughnut.
  xlLine	4	Line.
  xlLineMarkers	65	Line with markers.
  xlLineMarkersStacked	66	Stacked line with markers.
  xlLineMarkersStacked100	67	100% stacked line with markers.
  xlLineStacked	63	Stacked line.
  xlLineStacked100	64	100% stacked line.
  xlPie	5	Pie.
  xlPieOfPie	68	Pie of pie.
  xlRadar	-4151	Radar.
  xlRadarFilled	82	Filled radar.
  xlRadarMarkers	81	Radar with data markers.
  xlStockHLC	88	High-Low-Close.
  xlStockOHLC	89	Open-High-Low-Close.
  xlStockVHLC	90	Volume-High-Low-Close.
  xlStockVOHLC	91	Volume-Open-High-Low-Close.
  xlXYScatter	-4169	Scatter.
  xlXYScatterLines	74	Scatter with lines.
  xlXYScatterLinesNoMarkers	75	Scatter with lines and without data makers.
  xlXYScatterSmooth	72	Scatter with smooth lines.
  xlXYScatterSmoothNoMarkers	73	Scatter with smooth lines and no data makers.

XlContainsOperator

Specifies the operator used in a function.

• Usage notes

  expression.Enum.XlContainsOperator.xlContains

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlContains	0	Contains the specified value.
  xlDoesNotContain	1	Does not contain the specified value.
  xlBeginsWith	2	Begins with the specified value.
  xlEndsWith	3	Ends with the specified value.

XlDVAlertStyle

Specifies the icon used in message boxes displayed during validation.

• Usage notes

  expression.Enum.XlDVAlertStyle.xlValidAlertStop

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlValidAlertStop	1	Stop icon.
  xlValidAlertWarning	2	Warning icon.
  xlValidAlertInformation	3	Information icon.

XlDVType

Specifies the type of validation test to be performed in conjunction with values.

• Usage notes

  expression.Enum.XlDVType.xlValidateWholeNumber

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlValidateWholeNumber	1	Whole numeric values.
  xlValidateDecimal	2	Numeric values.
  xlValidateList	3	The value must exist in the specified list.
  xlValidateDate	4	Date values.
  xlValidateTime	5	Time values.
  xlValidateTextLength	6	Length of text.
  xlValidateCustom	7	Data is validated by using an arbitrary formula.

XlDirection

Specifies the direction in which to move.

Usage notes

• expression.Enum.XlDirection.xlDown

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlDown	-4121	Down.
  xlToLeft	-4159	To the left.
  xlToRight	-4161	To the right.
  xlUp	-4162	Up.

XlExportImgFormatType

Specifies the format of images to be exported.

• Usage notes

  expression.Enum.XlExportImgFormatType.xlImgTypePNG

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlImgTypePNG	0	The PNG format.
  xlImgTypeJPG	1	The JPEG format.
  xlImgTypeBMP	2	The BMP format.
  xlImgTypeTIF	2	The TIFF format.

XlFixedFormatType

Specifies the type of file format.

• Usage notes

  expression.Enum.XlFixedFormatType.xlTypePDF

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlTypePDF	0	The PDF format.
  xlTypeXPS	1	The XPS format.
  xlTypeIMG	2	The IMG formats, such as PNG, JPEG, BMP, and TIFF.

XlFormatConditionOperator

Specifies the operator to use to compare a formula against the value in a cell or, for xlBetween and xlNotBetween, to compare two formulas.

• Usage notes

  expression.Enum.XlFormatConditionOperator.xlBetween

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlBetween	1	Between. It can be used only if two formulas are provided.
  xlNotBetween	2	Not between. It can be used only if two formulas are provided.
  xlEqual	3	Equal.
  xlNotEqual	4	Not equal.
  xlGreater	5	Greater than.
  xlLess	6	Less than.
  xlGreaterEqual	7	Greater than or equal to.
  xlLessEqual	8	Less than or equal to.

XlFormatConditionType

Specifies whether the conditional format is based on a cell value or an expression.

• Usage notes

  expression.Enum.XlFormatConditionType.xlCellValue

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlCellValue	1	Cell Value.
  xlExpression	2	Expression.
  xlColorScale	3	Color scale.
  xlTop10	5	Top 10 values.
  xlUniqueValues	8	Unique values.
  xlTextString	9	Text string.
  xlBlanksCondition	10	Blanks condition.
  xlTimePeriod	11	Time period.
  xlAboveAverageCondition	12	Above average condition.
  xlNoBlanksCondition	13	No blanks condition.
  xlErrorsCondition	16	Errors condition.
  xlNoErrorsCondition	17	No errors condition.

XlHAlign

Specifies the horizontal alignment for the object.

• Usage notes

  expression.Enum.XlHAlign.xlHAlignRight

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlHAlignRight	-4152	Right.
  xlHAlignLeft	-4131	Left.
  xlHAlignJustify	-4130	Justify.
  xlHAlignDistributed	-4117	Distributed.
  xlHAlignCenter	-4108	Center.
  xlHAlignGeneral	1	Align based on the data type.
  xlHAlignFill	5	Fill.
  xlHAlignCenterAcrossSelection	7	Center across selection.

XlLineStyle

Specifies the line style for the border.

• Usage notes

  expression.Enum.XlLineStyle.xlLineStyleNone

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlLineStyleNone	-4142	No line.
  xlDouble	-4119	Double line.
  xlDot	-4118	Dotted line.
  xlDash	-4115	Dashed line.
  xlContinuous	1	Continuous line.
  xlDashDot	4	Alternating dashes and dots.
  xlDashDotDot	5	Dash followed by two dots.
  xlSlantDashDot	13	Slanted dashes.

XlReferenceStyle

Specifies the reference style.

• Usage notes

  expression.Enum.XlReferenceStyle.xlR1C1

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlR1C1	-4150	Use xlR1C1 to return an R1C1-style reference.
  xlA1	1	Use xlA1 to return an A1-style reference. The default value.

XlRowCol

Specifies whether the values corresponding to a particular data series are in rows or columns.

• Usage notes

  expression.Enum.XlRowCol.xlRows

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlRows	1	The data series is in a column.
  xlColumns	2	The data series is in a row.

XlSheetType

Specifies the worksheet type.

• Usage notes

  expression.Enum.XlSheetType.xlWorksheet

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlWorksheet	-4167	Worksheet.
  xlDialogSheet	-4116	Dialog sheet.
  xlChart	-4109	Chart.
  xlExcel4MacroSheet	3	Excel version 4 macro sheet.
  xlExcel4IntlMacroSheet	4	Excel version 4 international macro sheet.

XlTimePeriods

Specifies the time period.

• Usage notes

  expression.Enum.XlTimePeriods.xlToday

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlToday	0	Today.
  xlYesterday	1	Yesterday.
  xlLast7Days	2	Previous 7 Days.
  xlThisWeek	3	This week.
  xlLastWeek	4	Previous Week.
  xlLastMonth	5	Previous month.
  xlTomorrow	6	Tomorrow.
  xlNextWeek	7	Next week.
  xlNextMonth	8	Next month.
  xlThisMonth	9	This month.

XlVAlign

Specifies the vertical alignment for the object.

• Usage notes

  expression.Enum.XlVAlign.xlVAlignTop

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlVAlignTop	-4160	Top.
  xlVAlignJustify	-4130	Justify.
  xlVAlignDistributed	-4117	Distributed.
  xlVAlignCenter	-4108	Center.
  xlVAlignBottom	-4107	Bottom.

XlXLMMacroType

Specifies what type of macro a name refers to or whether the name refers to a macro.

• Usage notes

  expression.Enum.XlXLMMacroType.xlFunction

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlFunction	1	Custom function.
  xlCommand	2	Custom command.
  xlNotXLM	3	Not a macro.

XlUnderlineStyle

Specifies the type of underline applied to a font.

• Usage notes

  expression.Enum.XlUnderlineStyle.xlUnderlineStyleDouble

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlUnderlineStyleDouble	-4119	Double thick underline.
  xlUnderlineStyleDoubleAccounting	5	Two thin underlines that are placed close together.
  xlUnderlineStyleNone	-4142	No underline.
  xlUnderlineStyleSingle	2	Single underline.
  xlUnderlineStyleSingleAccounting	4	Not supported.

XlInsertShiftDirection

Specifies the direction in which to shift cells during an insertion.

• Usage notes

  expression.Enum.XlInsertShiftDirection.xlShiftDown

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlShiftDown	-4121	Shift cells down.
  xlShiftToRight	-4161	Shift cells to the right.

XlInsertFormatOrigin

Specifies from where to copy the format for inserted cells.

• Usage notes

  expression.Enum.XlInsertFormatOrigin.xlFormatFromLeftOrAbove

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlFormatFromLeftOrAbove	0	Copy the format from cells above or to the left. When you insert a cell below, copy the format from cells above. When you insert a cell to the right, copy the format from cells to the left.
  xlFormatFromRightOrBelow	1	Copy the format from cells below or to the right. When you insert a cell above, copy the format from cells below. When you insert a cell to the left, copy the format from cells to the right.

XlDeleteShiftDirection

Specifies how to shift cells to replace deleted cells.

• Usage notes

  expression.Enum.XlDeleteShiftDirection.xlShiftToLeft

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlShiftToLeft	-4159	Cells are shifted to the left.
  xlShiftUp	-4162	Cells are shifted up.

XlPasteType

Specifies the part of the range to be pasted.

• Usage notes

  expression.Enum.XlPasteType.xlPasteAll

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlPasteAll	0x1	Everything is pasted.
  xlPasteFormulas	0x2	Formulas are pasted.
  xlPasteValues	0x3	Values are pasted.
  xlPasteAllExceptBorders	0x4	Everything except borders is pasted.
  xlPasteColumnWidths	0x5	The copied column width is pasted.
  xlPasteValuesAndNumberFormats	0x7	Values and number formats are pasted.
  xlPasteFormats	0x8	The copied source format is pasted.
  xlPasteComments	0x9	Comments are pasted.
  xlPasteValidation	0xa	Validations are pasted.

XlPasteSpecialOperation

Specifies how numeric data is calculated with the destinations cells on the worksheet.

• Usage notes

  expression.Enum.XlPasteSpecialOperation.xlPasteSpecialOperationAdd

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlPasteSpecialOperationAdd	0x1	Copied data is added to the value in the destination cell.
  xlPasteSpecialOperationDivide	0x4	Copied data divides the value in the destination cell.
  xlPasteSpecialOperationMultiply	0x3	Copied data multiplies the value in the destination cell.
  xlPasteSpecialOperationNone	0x0	No calculation will be done in the paste operation.
  xlPasteSpecialOperationSubtract	0x2	Copied data is subtracted from the value in the destination cell.

XlCalcModeType

Specifies the iterative calculation mode.

• Usage notes

  expression.Enum.XlCalcModeType.manual

  expression: the document type application object.

• Parameters

  Property	Value	Description
  manual	'manual'	Manual calculation.
  automatic	'automatic'	Automatic calculation.

LookIn

Specifies the type of data to search.

• Usage notes

  expression.Enum.LookIn.etSmart

  expression: the document type application object.

• Parameters

  Property	Value	Description
  etSmart	'etSmart'	All.
  etFormulas	'etFormulas'	Formulas.
  etValues	'etValues'	Values.
  etComments	'etComments'	Comments.

LookAt

Specifies whether a match is made against the whole of the search text or any part of the search text.

• Usage notes

  expression.Enum.LookAt.etWhole

  expression: the document type application object.

• Parameters

  Property	Value	Description
  etWhole	'etWhole'	Match against the whole of the search text.
  etPart	'etPart'	Match against any part of the search text.

SearchOrder

Specifies the order in which to search the range.

• Usage notes

  expression.Enum.SearchOrder.etByRows

  expression: the document type application object.

• Parameters

  Property	Value	Description
  etByRows	'etByRows'	Searches across a row, and then moves to the next row.
  etByColumns	'etByColumns'	Searches down through a column, and then moves to the next column.

SearchDirection

Specifies the search direction when searching a range.

• Usage notes

  expression.Enum.SearchDirection.etNext

  expression: the document type application object.

• Parameters

  Property	Value	Description
  etNext	'etNext'	Search for next matching value in range.
  etPrevious	'etPrevious'	Search for previous matching value in range.

FindScope

Specifies the scope of a search.

• Usage notes

  expression.Enum.FindScope.etSheet

  expression: the document type application object.

• Parameters

  Property	Value	Description
  etSheet	0	The worksheet.
  etWorkBook	1	The workbook.

XlYesNoGuess

Specifies whether the first row of an object contains column titles.

Usage notes

• expression.Enum.XlYesNoGuess.xlNo

  expression: the document type application object.

• Parameters

  Property	Value	Description
  xlGuess	0	Specifies whether the table has a title. If yes, specify whether the table has only one title.
  xlNo	2	The default value. All regions of the table are sorted.
  xlYes	1	Not all regions of the table are sorted.

MsoTriState

Specifies True, False, or Mixed.

Usage notes

• expression.Enum.MsoTriState.msoFalse

  expression: the document type application object.

• Parameters

  Property	Value	Description
  msoFalse	0	The image becomes an independent copy of the file.
  msoTrue	-1	The image is linked to the source file from which it is created.