XmlMappedRange Interface

An XmlMappedRange control is a range that is created when a non-repeating schema element is mapped onto a cell.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

[GuidAttribute("ac172e76-a2b5-4fcc-ae02-65ce23f50cb3")]
public interface XmlMappedRange : IBindableComponent, 
	IComponent, IDisposable, ISupportInitialize

The XmlMappedRange type exposes the following members.

  NameDescription
Public propertyAddIndentGets or sets a value that indicates whether text is automatically indented when the text alignment in the XmlMappedRange control is set to equal distribution either horizontally or vertically.
Public propertyAddressGets the range reference of the XmlMappedRange control.
Public propertyAddressLocalGets the range reference of the XmlMappedRange control in the language of the user.
Public propertyAllowEditGets a value that indicates whether the XmlMappedRange control can be edited on a protected worksheet.
Public propertyApplicationGets a Microsoft.Office.Interop.Excel.Application that represents the Microsoft Office Excel application.
Public propertyBindingContextGets or sets the collection of currency managers for the IBindableComponent. (Inherited from IBindableComponent.)
Public propertyBordersGets a Microsoft.Office.Interop.Excel.Borders collection that represents the borders of an XmlMappedRange control.
Public propertyCellsGets a Range that represents the cells in the XmlMappedRange control.
Public propertyCharactersGets a Microsoft.Office.Interop.Excel.Characters object that represents a range of characters within the text of the XmlMappedRange control.
Public propertyColumnGets the number of the column in the XmlMappedRange control.
Public propertyColumnsInfrastructure.
Public propertyColumnWidthGets or sets the width of the column in the XmlMappedRange control.
Public propertyCommentGets a Comment that represents the comment associated with the cell in the upper-left corner of the XmlMappedRange control.
Public propertyContainerInfrastructure.
Public propertyCountGets the number of objects in the XmlMappedRange control.
Public propertyCountLargeGets a value that represents the number of times that the largest value in a range appears.
Public propertyCreatorGets a value that indicates the application in which this XmlMappedRange control was created.
Public propertyCurrentArrayIf the XmlMappedRange is part of an array, gets a Range that represents the entire array.
Public propertyCurrentRegionGets a Range that represents the current region.
Public propertyDataBindingsGets the collection of data-binding objects for this IBindableComponent. (Inherited from IBindableComponent.)
Public propertyDependentsGets a Range that represents the range containing all the dependents of the XmlMappedRange control.
Public propertyDirectDependentsGets a Range that represents the range containing all the direct dependents of an XmlMappedRange control.
Public propertyDirectPrecedentsGets a Range that represents the range containing all the direct precedents of an XmlMappedRange control.
Public propertyDisplayFormatGets an object that represents the display settings for the specified range.
Public propertyEndGets a Range that represents the cell at the end of the region that contains the XmlMappedRange control.
Public propertyEntireColumnGets a Range that represents the entire column that contains the XmlMappedRange control.
Public propertyEntireRowGets a Range that represents the row that contains the XmlMappedRange control.
Public propertyErrorsGets an Errors object that enables you to access error checking options of an XmlMappedRange control.
Public propertyFontGets a Microsoft.Office.Interop.Excel.Font that represents the font of the XmlMappedRange control.
Public propertyFormatConditionsGets a FormatConditions collection that represents all the conditional formats for the XmlMappedRange control.
Public propertyFormulaGets or sets the formula of an XmlMappedRange control in A1-style notation.
Public propertyFormulaArrayGets or sets the array formula of an XmlMappedRange control.
Public propertyFormulaHiddenGets or sets a value that indicates whether the formula in the XmlMappedRange control is hidden when the worksheet is protected.
Public propertyFormulaLabelGets or sets the formula label type for the XmlMappedRange control.
Public propertyFormulaLocalGets or sets the formula for the XmlMappedRange control, using A1-style references in the language of the user.
Public propertyFormulaR1C1Gets or sets the formula for the XmlMappedRange control, using R1C1-style notation.
Public propertyFormulaR1C1LocalGets or sets the formula for the XmlMappedRange control, using R1C1-style notation in the language of the user.
Public propertyHasArrayGets a value that indicates whether the XmlMappedRange control is part of an array formula.
Public propertyHasFormulaGets a value that indicates whether the XmlMappedRange control contains a formula.
Public propertyHeightGets the height, in points, of the XmlMappedRange control.
Public propertyHiddenInfrastructure.
Public propertyHorizontalAlignmentGets or sets the horizontal alignment for the XmlMappedRange control.
Public propertyHyperlinksGets a Hyperlinks collection that represents the hyperlinks for the XmlMappedRange control.
Public propertyIDGets or sets the identifying label for the XmlMappedRange control when the page is saved as a Web page.
Public propertyIndentLevelGets or sets the indent level for the XmlMappedRange control.
Public propertyInnerObjectGets a Microsoft.Office.Interop.Excel.Range that represents the underlying native object for the XmlMappedRange.
Public propertyInteriorGets an Microsoft.Office.Interop.Excel.Interior that represents the interior of the XmlMappedRange control.
Public propertyItemGets a Range that represents a range at an offset to the XmlMappedRange control.
Public propertyLeftGets a value that represents the distance from the left edge of column A to the left edge of the XmlMappedRange control.
Public propertyListHeaderRowsInfrastructure.
Public propertyListObjectGets a Microsoft.Office.Interop.Excel.ListObject for the XmlMappedRange control.
Public propertyLocationInTableGets a constant that describes the part of the PivotTable report that contains the upper-left corner of the XmlMappedRange control.
Public propertyLockedGets or sets a value that indicates whether the XmlMappedRange control is locked.
Public propertyMDXGets an MDX expression that describes the XmlMappedRange.
Public propertyMergeAreaGets a Range that represents the merged range containing the XmlMappedRange control.
Public propertyMergeCellsGets or sets a value that indicates whether the XmlMappedRange control contains merged cells.
Public propertyNameGets or sets a value representing a defined name for an XmlMappedRange control.
Public propertyNextGets a Range that represents the next cell.
Public propertyNumberFormatGets or sets the format code for the XmlMappedRange control.
Public propertyNumberFormatLocalGets or sets the format code for the XmlMappedRange control in the language of the user.
Public propertyOffsetGets a Range that is offset from the XmlMappedRange control.
Public propertyOrientationGets or sets a value that specifies the text orientation.
Public propertyOutlineLevelGets or sets the current outline level of the XmlMappedRange.
Public propertyPageBreakGets or sets the location of a page break.
Public propertyParentGets a Microsoft.Office.Interop.Excel.Worksheet that represents the worksheet containing the XmlMappedRange control.
Public propertyPhoneticGets the Phonetic object which contains information about a specific phonetic text string in the XmlMappedRange control.
Public propertyPhoneticsGets the Phonetics collection of the XmlMappedRange control.
Public propertyPivotCellGets a PivotCell that represents a cell in a PivotTable report.
Public propertyPivotFieldGets a PivotField that represents the PivotTable field containing the upper-left corner of the XmlMappedRange control.
Public propertyPivotItemGets a PivotItem that represents the PivotTable item containing the upper-left corner of the XmlMappedRange control.
Public propertyPivotTableGets a PivotTable that represents the PivotTable report containing the upper-left corner of the XmlMappedRange control, or the PivotTable report associated with the PivotChart report.
Public propertyPrecedentsGets a Range that represents all the precedents of the XmlMappedRange control.
Public propertyPrefixCharacterGets the prefix character for the XmlMappedRange control.
Public propertyPreviousGets a Range that represents the previous cell.
Public propertyQueryTableGets a Microsoft.Office.Interop.Excel.QueryTable that represents the query table that intersects the XmlMappedRange control.
Public propertyReadingOrderGets or sets the reading order for the XmlMappedRange control.
Public propertyResizeGets a resized Range based on the XmlMappedRange control.
Public propertyRowGets the number of the row that contains the XmlMappedRange control.
Public propertyRowHeightGets or sets the height of the row that contains the XmlMappedRange control, measured in points.
Public propertyRowsGets a Range that represents the row that contains the XmlMappedRange control.
Public propertyServerActionsGets the actions that can be performed on the SharePoint server for an XmlMappedRange object.
Public propertyShowDetailGets or sets an object that indicates whether the outline is expanded for the XmlMappedRange control (so that the detail of the column or row is visible).
Public propertyShrinkToFitGets or sets a value that indicates whether text automatically shrinks to fit in the available column width.
Public propertySiteGets or sets the ISite associated with the IComponent. (Inherited from IComponent.)
Public propertySmartTagsGets a Microsoft.Office.Interop.Excel.SmartTags object representing the identifier for the XmlMappedRange control.
Public propertySoundNoteInfrastructure.
Public propertySparklineGroupsGets an object that represents an existing group of sparklines from the specified range.
Public propertyStyleGets or sets a Microsoft.Office.Interop.Excel.Style that represents the style of the XmlMappedRange control.
Public propertySummaryGets a value that indicates whether the XmlMappedRange is an outlining summary row or column.
Public propertyTagGets or sets the object that contains data about the Tag control.
Public propertyTextGets the text for the XmlMappedRange control.
Public propertyTopGets the distance, in points, from the top of row 1 to the top edge of the XmlMappedRange control.
Public propertyUseStandardHeightGets or sets a value that indicates whether the row height of the XmlMappedRange control equals the standard height of the sheet.
Public propertyUseStandardWidthGets or sets a value that indicates whether the column width of the XmlMappedRange control equals the standard width of the sheet.
Public propertyValidationGets the Microsoft.Office.Interop.Excel.Validation object that represents data validation for the XmlMappedRange control.
Public propertyValueGets or sets the value of the XmlMappedRange control.
Public propertyValue2Gets or sets the XmlMappedRange control value.
Public propertyVerticalAlignmentGets or sets the vertical alignment of the XmlMappedRange control.
Public propertyWidthGets the width of the XmlMappedRange control in points.
Public propertyWorksheetGets a Microsoft.Office.Interop.Excel.Worksheet that represents the worksheet containing the XmlMappedRange control.
Public propertyWrapTextGets or sets a value that indicates whether Microsoft Office Excel wraps the text in the XmlMappedRange control.
Public propertyXPathGets an Microsoft.Office.Interop.Excel.XPath that represents the XPath of the element mapped to the XmlMappedRange control.
Top

  NameDescription
Public method_PasteSpecialInfrastructure.
Public method_PrintOutInfrastructure.
Public methodActivateActivates a single cell XmlMappedRange control.
Public methodAddCommentAdds a comment to the XmlMappedRange control.
Public methodAllocateChangesPerforms a writeback operation for all edited cells in an XML mapped range based on an OLAP data source.
Public methodAutoCompleteGets an AutoComplete match from the list.
Public methodAutoFilterFilters a list using the AutoFilter.
Public methodAutoOutlineAutomatically creates an outline for the XmlMappedRange control.
Public methodBeginInitSignals the object that initialization is starting. (Inherited from ISupportInitialize.)
Public methodBorderAroundAdds a border to an XmlMappedRange control and sets the Color, LineStyle, and Weight properties for the new border.
Public methodBorderAround2Adds a border to a XmlMappedRange control and sets the Color, LineStyle, and Weight properties for the new border.
Public methodCalculateCalculates the value of the XmlMappedRange control.
Public methodCalculateRowMajorOrderCalculates the value in each item in the range in row-major order.
Public methodCheckSpellingChecks the spelling of text in the XmlMappedRange control.
Public methodClearClears the entire XmlMappedRange control.
Public methodClearCommentsClears all cell comments from the XmlMappedRange control.
Public methodClearContentsClears the formulas from the XmlMappedRange control.
Public methodClearFormatsClears the formatting of the XmlMappedRange control.
Public methodClearHyperlinksRemoves all hyperlinks from the specified range.
Public methodClearNotesClears notes and sound notes from the XmlMappedRange control.
Public methodClearOutlineClears the outline for the XmlMappedRange control.
Public methodColumnDifferencesGets a Range that represents all the cells whose contents are different from the comparison cell in each column.
Public methodConsolidateConsolidates data from multiple ranges on multiple worksheets into an XmlMappedRange control.
Public methodCopyCopies the contents of the XmlMappedRange control to the specified range or to the Clipboard.
Public methodCopyFromRecordsetCopies the contents of an ADO or DAO recordset onto a worksheet, beginning at the XmlMappedRange control.
Public methodCopyPictureCopies the XmlMappedRange control to the Clipboard as a picture.
Public methodCreateNamesCreates names in the XmlMappedRange control, based on text labels in the worksheet.
Public methodCreatePublisherInfrastructure.
Public methodCutCuts the contents of the XmlMappedRange control to the Clipboard or pastes it into a specified destination.
Public methodDataSeriesCreates a data series in the XmlMappedRange control.
Public methodDialogBoxDisplays a dialog box defined by a dialog box definition table on a Microsoft Office Excel 4.0 macro sheet.
Public methodDirtyDesignates an XmlMappedRange control to be recalculated when the next recalculation occurs.
Public methodDiscardChangesDiscards all changes in the edited cells of the Xml mapped range.
Public methodDisposePerforms application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. (Inherited from IDisposable.)
Public methodEditionOptionsInfrastructure.
Public methodEndInitSignals the object that initialization is complete. (Inherited from ISupportInitialize.)
Public methodExportAsFixedFormatExports to a file of the specified format.
Public methodFillDownFills down from the top cell in the XmlMappedRange control to the bottom of the XmlMappedRange control.
Public methodFillLeftFills left from the rightmost cell in the XmlMappedRange control.
Public methodFillRightFills right from the leftmost cell in the XmlMappedRange control.
Public methodFillUpFills up from the bottom cell in the specified range to the top of the XmlMappedRange control.
Public methodFindFinds specific information in an XmlMappedRange control, and returns a Range that represents the first cell where that information is found.
Public methodFindNextContinues a search that was begun with the Find method.
Public methodFindPreviousContinues a search that was begun with the Find method.
Public methodFunctionWizardStarts the Function Wizard for the XmlMappedRange control.
Public methodget_AddressInfrastructure.
Public methodget_AddressLocalInfrastructure.
Public methodget_CharactersInfrastructure.
Public methodget_EndInfrastructure.
Public methodget_ItemInfrastructure.
Public methodget_OffsetInfrastructure.
Public methodget_RangeInfrastructure.
Public methodget_ResizeInfrastructure.
Public methodget_ValueInfrastructure.
Public methodGetEnumeratorGets an enumerator that can be used to iterate over an XmlMappedRange control.
Public methodGoalSeekCalculates the values necessary to achieve a specific goal.
Public methodGroupWhen the XmlMappedRange control represents a single cell in the data range of a PivotTable field, the Group method performs numeric or date-based grouping in that field.
Public methodInsertInserts a cell into the XmlMappedRange control and shifts other cells away to make space.
Public methodInsertIndentAdds an indent to the XmlMappedRange control.
Public methodJustifyRearranges the text in an XmlMappedRange control so that it fills the range evenly.
Public methodListNamesPastes a list of all displayed names onto the worksheet, beginning with the XmlMappedRange control.
Public methodMergeCreates a merged cell from the XmlMappedRange control.
Public methodNavigateArrowNavigates a tracer arrow for the XmlMappedRange control to the precedent, dependent, or error-causing cell or cells.
Public methodNoteTextGets or sets the cell note associated with the XmlMappedRange control.
Public methodParseParses a range of data and breaks it into multiple cells
Public methodPasteSpecialPastes the contents of a Range from the Clipboard into the XmlMappedRange control.
Public methodPrintOutPrints the XmlMappedRange control.
Public methodPrintOutExPrints out the XmlMappedRange.
Public methodPrintPreviewShows a preview of the XmlMappedRange control as it would look when printed.
Public methodRemoveDuplicatesRemoves duplicate values from a range of values.
Public methodRemoveSubtotalRemoves subtotals from an XmlMappedRange control.
Public methodReplaceReplaces the specified characters in the XmlMappedRange control with a new string.
Public methodRowDifferencesGets a Range that represents the cells whose contents are different from those of the comparison cell in each row.
Public methodRunInfrastructure.
Public methodSelectSelects the XmlMappedRange control.
Public methodset_ItemInfrastructure.
Public methodset_ValueInfrastructure.
Public methodSetPhoneticCreates Phonetic objects for the XmlMappedRange control.
Public methodShowScrolls through the contents of the active window to move the XmlMappedRange control into view.
Public methodShowDependentsDraws tracer arrows to the direct dependents of the XmlMappedRange control.
Public methodShowErrorsDraws tracer arrows through the precedents tree to the cell that is the source of the error, and returns the range that contains that cell.
Public methodShowPrecedentsDraws tracer arrows to the direct precedents of the XmlMappedRange control.
Public methodSpeakCauses the cells of the XmlMappedRange control to be spoken in row order or column order.
Public methodSpecialCellsGets a Range that represents all the cells that match the specified type and value.
Public methodSubscribeToInfrastructure.
Public methodSubtotalCreates subtotals for the XmlMappedRange control.
Public methodTableCreates a data table based on input values and formulas that you define on a worksheet.
Public methodTextToColumnsParses a column of cells that contain text into several columns.
Public methodUngroupPromotes an XmlMappedRange control in an outline (that is, decreases its outline level).
Public methodUnMergeSeparates a merged area into individual cells.
Top

  NameDescription
Public eventBeforeDoubleClickOccurs when an XmlMappedRange control is double-clicked, before the default double-click action.
Public eventBeforeRightClickOccurs when an XmlMappedRange control is right-clicked, before the default right-click action.
Public eventBindingContextChangedInfrastructure.
Public eventChangeOccurs when something changes in the XmlMappedRange control.
Public eventDeselectedOccurs when selection moves from the XmlMappedRange control to an area outside of the XmlMappedRange control.
Public eventDisposedRepresents the method that handles the Disposed event of a component. (Inherited from IComponent.)
Public eventSelectedOccurs when the XmlMappedRange control is selected.
Public eventSelectionChangeOccurs when the selection inside the XmlMappedRange control changes.
Top

The XmlMappedRange control only supports binding to a single data field (simple data binding).

A non-repeating schema element is one in which the maxOccurs attribute equals one.

NoteNote

This interface is implemented by the Visual Studio Tools for Office runtime. It is not intended to be implemented in your code. For more information, see Visual Studio Tools for Office Runtime Overview.

Usage

This documentation describes the version of this type that is used in Office projects that target the .NET Framework 4 and the .NET Framework 4.5. In projects that target the .NET Framework 3.5, this type might have different members and the code examples provided for this type might not work. For documentation about this type in projects that target the .NET Framework 3.5, see the following reference section in the Visual Studio 2008 documentation: http://go.microsoft.com/fwlink/?LinkId=160658.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft