| < Day Day Up > |
|
x-axis on a PivotChart, 346
x-axis title in a chart, 322
.xla file extension, 283
XLA file type, 239, 242
xlA1 constant, 180
xlAbsrowRelColumn constant, 180
xlBackgroundAutomatic constant, 232
xlBackgroundTransparent constant, 232
xlBetween constant, 188
XlBordersIndex constants, 236
XlBorderWeight constants, 236
xlBuiltinDialog constant, 384
xlBuiltinDialog property, 384
.xlc file extension, 283
XlCalculate constants, 156
xlCalculationAutomatic constant, 157
xlCalculationManual constant, 157
xlCalculationSemiautomatic constant, 157
xlCellType constants, 176
xlChart constant, 151
XlCmdType enumeration, 352
xlColorIndexAutomatic constant, 230, 236
xlColorIndexNone constant, 236
xlColumnDataType constants, 133
xlColumnField constant, 363
xlContinuous constant, 236
xlDash constant, 236
xlDashDot constant, 236
xlDashDotDot constant, 236
xlDatabase argument, 357
xlDataField constant, 363
xlDelimited constant, 133
xlDiagonalDown constant, 236
xlDiagonalUp constant, 236
xlDialog constants, 384
xlDialog intrinsic constants, 390
xlDialogActiveCellFont constant, 391
xlDialogAddChartAutoformat constant, 391
xlDialogAlignment constant, 391
xlDialogApplyNames constant, 392
xlDialogAutoCorrect constant, 392
xlDialogAxes constant, 391
xlDialogBorder constant, 386, 391
xlDialogCellProtection constant, 386, 388, 391
xlDialogChartAddData constant, 391
xlDialogChartWizard constant, 391
xlDialogColorPalette constant, 392
xlDialogColumnWidth constant, 392
xlDialogCreateNames constant, 392
xlDialogDataLabel constant, 391
xlDialogDataSeries constant, 391
xlDialogDefineName constant, 392
xlDialogDefineStyle constant, 392
xlDialogEditSeries constant, 391
xlDialogFilterAdvanced constant, 392
xlDialogFont constant, 390, 391
xlDialogFontProperties constant, 386, 391
xlDialogFormatChart constant, 391
xlDialogFormatCharttype constant, 392
xlDialogFormatFont constant, 391
xlDialogFormatLegend constant, 392
xlDialogFormatNumber intrinsic constant, 386
xlDialogFormulaGoTo constant, 385, 389
xlDialogGallery3dBar constant, 392
xlDialogGallery3dColumn constant, 392
xlDialogGallery3dLine constant, 392
xlDialogGallery3dPie constant, 392
xlDialogGalleryDoughnut constant, 392
xlDialogGalleryLine constant, 392
xlDialogGalleryPie constant, 392
xlDialogGoalSeek constant, 392
xlDialogInsertObject constant, 392
xlDialogMainChartType constant, 392
xlDialogOpen constant, 392
xlDialogPageSetup constant, 393
xlDialogPatterns constant, 386, 391
xlDialogSaveAs constant, 393
xlDialogSelectSpecial intrinsic constant, 386
xlDialogSendMail constant, 393
xlDialogShowToolbar constant, 393
xlDialogZoom constant, 393
xlDisplayShapes constant, 140
xlDMYFormat constant, 133
xlDot constant, 236
xlDot intrinsic constant, 59
xlDouble constant, 236
xlDYMFormat constant, 133
xlEdgeBottom constant, 236
xlEdgeLeft constant, 236
xlEdgeRight constant, 236
xlEdgeTop constant, 236
xlEMDFormat constant, 133
xlEqual constant, 188
xlErrors constant, 176
xlExcel4IntMacroSheet constant, 151
xlExcel4MacroSheet constant, 151
xlExclusive constant, 136
xlFileFormat constants, 136
xlFixedWidth constant, 133
xlGeneralFormat constant, 133
xlGreater constant, 188
xlGreaterEqual constant, 188
xlHairline constant, 236
xlHidden constant, 363
xlHide constant, 140
xlInputOnly validation type, 189
xlLess constant, 188
xlLessEqual constant, 188
XlLineStyle constants, 236
xlLineStyleNone constant, 236
XlListConflict constants, 543
XlListObjectSourceType constants, 543
xlLocalSessionChanges constant, 136
xlLocationAsNewSheet option, 323
xlLocationAsObject option, 323
xlLocationAutomatic option, 323
xlLogical constant, 176
.xlm file extension, 283
xlMDYFormat constant, 133
xlMedium constant, 236
xlNoChange constant, 136
xlNone constant, 155
xlNoRestrictions constant, 159
xlNoSelection constant, 159
xlNotBetween constant, 188
xlNotEqual constant, 188
xlNumbers constant, 176
xlOtherSessionChanges constant, 136
xlPageBreakManual constant, 155
xlPageBreakNone constant, 155
xlPageField constant, 363
XlPattern constants, 234
xlPatternAutomatic constant, 234
xlPatternChecker constant, 234
xlPatternCrissCross constant, 234
xlPatternDown constant, 234
xlPatternGray constants, 234
xlPatternGrid constant, 234
xlPatternHorizontal constant, 234
xlPatternLightDown constant, 234
xlPatternLightHorizontal constant, 234
xlPatternLightUp constant, 234
xlPatternLightVertical constant, 234
xlPatternNone constant, 234
xlPatternSemiGray75 constant, 234
xlPatternSolid constant, 234
xlPatternUp constant, 234
xlPatternVertical constant, 234
XlPivotFieldDataType enumeration, 354
XlPivotFieldOrientation constants, 362
XlPivotFieldOrientation types, 355
XlPivotFormatType formats, 350
xlPlaceHolders constant, 140
XlQueryType enumeration, 353
xlR1C1 constant, 180
xlReferenceStyle constants, 180
xlReferenceType constants, 180
xlRelative constant, 180
xlRelRowAbsColumn constant, 180
xlRowField constant, 363
.xls file extension, 135, 283
XLSaveConflictResolution constants, 136
xlShared constant, 136
xlSheetHidden constant, 150
xlSheetVeryHidden constant, 150
xlSheetVisible constant, 150
xlSkipColumn, 133
xlSlantDashDot constant, 236
xlSpecialCellsValues constants, 176
*.xlt file, opening for editing, 131
.xlt file extension, 283
xlTextFormat constant, 133
XlTextParsingType constants, 133
XlTextQualifer constant, 133
xlTextQualifierDoubleQuote constant, 133
xlTextQualifierSingleQuote constant, 133
xlTextValues constant, 176
xlThick constant, 236
xlThin constant, 236
xlUnderlineStyleDouble constant, 232
xlUnderlineStyleDoubleAccounting constant, 232
xlUnderlineStyleNone constant, 232
xlUnderlineStyleSingle constant, 232
xlUnderlineStyleSingleAccounting constant, 232
xlUnlockedCells constant, 159
xlUserResolution constant, 136
xlValidAlertInformation constant, 188
xlValidAlertStop constant, 188
xlValidAlertWarning constant, 188
xlValidateCustom validation type, 188, 189
xlValidateDate validation type, 188, 189
xlValidateDecimal validation type, 188, 189
xlValidateInputOnly validation type, 188
xlValidateList validation type, 188, 189
xlValidateTextLength validation type, 188, 189, 198
xlValidateTime validation type, 188, 189
xlValidateWholeNumber validation type, 188, 189
xlWorksheet constant, 151
xlXmlExportSuccess constant, 554
xlXmlExportValidationFailed constant, 554
xlXmlImportElementsTruncated constant, 555
xlXmlImportSuccess constant, 555
xlXmlImportValidationFailed constant, 555
xlYDMFormat constant, 133
xlYMDFormat constant, 133
XML, 3
adding to a workbook manually, 550-53
adding to a worksheet programmatically, 553-62
capabilities extended, 8, 9
elements, 548
files, 13, 550
map, 553
schema files, 548
support for, 539
XML data. See data files
XML Map Properties dialog box, 552
XML Maps dialog box, 551
XML Path language. See XPath
XML schemas. See schemas
XML Source task pane, 20
displaying, 547, 551
Options button, 552
XML Spreadsheet Schema, 9
XmlMap object, 553-56
XmlMap property, 542
XmlMaps collection, 555
XmlSchemas collection, 554
XPath, 557-62
xpos argument for an input box, 71
.xsd file, 10
| < Day Day Up > |
|