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

NameDescription
System_CAPS_pubpropertyAddIndent

Gets 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.

System_CAPS_pubpropertyAddress

Gets the range reference of the XmlMappedRange control.

System_CAPS_pubpropertyAddressLocal

Gets the range reference of the XmlMappedRange control in the language of the user.

System_CAPS_pubpropertyAllowEdit

Gets a value that indicates whether the XmlMappedRange control can be edited on a protected worksheet.

System_CAPS_pubpropertyApplication

Gets a Microsoft.Office.Interop.Excel.Application that represents the Microsoft Office Excel application.

System_CAPS_pubpropertyBindingContext

(Inherited from IBindableComponent.)

System_CAPS_pubpropertyBorders

Gets a Microsoft.Office.Interop.Excel.Borders collection that represents the borders of an XmlMappedRange control.

System_CAPS_pubpropertyCells

Gets a Range that represents the cells in the XmlMappedRange control.

System_CAPS_pubpropertyCharacters

Gets a Microsoft.Office.Interop.Excel.Characters object that represents a range of characters within the text of the XmlMappedRange control.

System_CAPS_pubpropertyColumn

Gets the number of the column in the XmlMappedRange control.

System_CAPS_pubpropertyColumns

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubpropertyColumnWidth

Gets or sets the width of the column in the XmlMappedRange control.

System_CAPS_pubpropertyComment

Gets a Comment that represents the comment associated with the cell in the upper-left corner of the XmlMappedRange control.

System_CAPS_pubpropertyContainer

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubpropertyCount

Gets the number of objects in the XmlMappedRange control.

System_CAPS_pubpropertyCountLarge

Gets a value that represents the number of times that the largest value in a range appears.

System_CAPS_pubpropertyCreator

Gets a value that indicates the application in which this XmlMappedRange control was created.

System_CAPS_pubpropertyCurrentArray

If the XmlMappedRange is part of an array, gets a Range that represents the entire array.

System_CAPS_pubpropertyCurrentRegion

Gets a Range that represents the current region.

System_CAPS_pubpropertyDataBindings

(Inherited from IBindableComponent.)

System_CAPS_pubpropertyDependents

Gets a Range that represents the range containing all the dependents of the XmlMappedRange control.

System_CAPS_pubpropertyDirectDependents

Gets a Range that represents the range containing all the direct dependents of an XmlMappedRange control.

System_CAPS_pubpropertyDirectPrecedents

Gets a Range that represents the range containing all the direct precedents of an XmlMappedRange control.

System_CAPS_pubpropertyDisplayFormat

Gets an object that represents the display settings for the specified range.

System_CAPS_pubpropertyEnd

Gets a Range that represents the cell at the end of the region that contains the XmlMappedRange control.

System_CAPS_pubpropertyEntireColumn

Gets a Range that represents the entire column that contains the XmlMappedRange control.

System_CAPS_pubpropertyEntireRow

Gets a Range that represents the row that contains the XmlMappedRange control.

System_CAPS_pubpropertyErrors

Gets an Errors object that enables you to access error checking options of an XmlMappedRange control.

System_CAPS_pubpropertyFont

Gets a Microsoft.Office.Interop.Excel.Font that represents the font of the XmlMappedRange control.

System_CAPS_pubpropertyFormatConditions

Gets a FormatConditions collection that represents all the conditional formats for the XmlMappedRange control.

System_CAPS_pubpropertyFormula

Gets or sets the formula of an XmlMappedRange control in A1-style notation.

System_CAPS_pubpropertyFormulaArray

Gets or sets the array formula of an XmlMappedRange control.

System_CAPS_pubpropertyFormulaHidden

Gets or sets a value that indicates whether the formula in the XmlMappedRange control is hidden when the worksheet is protected.

System_CAPS_pubpropertyFormulaLocal

Gets or sets the formula for the XmlMappedRange control, using A1-style references in the language of the user.

System_CAPS_pubpropertyFormulaR1C1

Gets or sets the formula for the XmlMappedRange control, using R1C1-style notation.

System_CAPS_pubpropertyFormulaR1C1Local

Gets or sets the formula for the XmlMappedRange control, using R1C1-style notation in the language of the user.

System_CAPS_pubpropertyHasArray

Gets a value that indicates whether the XmlMappedRange control is part of an array formula.

System_CAPS_pubpropertyHasFormula

Gets a value that indicates whether the XmlMappedRange control contains a formula.

System_CAPS_pubpropertyHeight

Gets the height, in points, of the XmlMappedRange control.

System_CAPS_pubpropertyHorizontalAlignment

Gets or sets the horizontal alignment for the XmlMappedRange control.

System_CAPS_pubpropertyHyperlinks

Gets a Hyperlinks collection that represents the hyperlinks for the XmlMappedRange control.

System_CAPS_pubpropertyID

Gets or sets the identifying label for the XmlMappedRange control when the page is saved as a Web page.

System_CAPS_pubpropertyIndentLevel

Gets or sets the indent level for the XmlMappedRange control.

System_CAPS_pubpropertyInnerObject

Gets a Microsoft.Office.Interop.Excel.Range that represents the underlying native object for the XmlMappedRange.

System_CAPS_pubpropertyInterior

Gets an Microsoft.Office.Interop.Excel.Interior that represents the interior of the XmlMappedRange control.

System_CAPS_pubpropertyItem

Gets a Range that represents a range at an offset to the XmlMappedRange control.

System_CAPS_pubpropertyLeft

Gets a value that represents the distance from the left edge of column A to the left edge of the XmlMappedRange control.

System_CAPS_pubpropertyListObject

Gets a Microsoft.Office.Interop.Excel.ListObject for the XmlMappedRange control.

System_CAPS_pubpropertyLocationInTable

Gets a constant that describes the part of the PivotTable report that contains the upper-left corner of the XmlMappedRange control.

System_CAPS_pubpropertyLocked

Gets or sets a value that indicates whether the XmlMappedRange control is locked.

System_CAPS_pubpropertyMDX

Gets an MDX expression that describes the XmlMappedRange.

System_CAPS_pubpropertyMergeArea

Gets a Range that represents the merged range containing the XmlMappedRange control.

System_CAPS_pubpropertyMergeCells

Gets or sets a value that indicates whether the XmlMappedRange control contains merged cells.

System_CAPS_pubpropertyName

Gets or sets a value representing a defined name for an XmlMappedRange control.

System_CAPS_pubpropertyNext

Gets a Range that represents the next cell.

System_CAPS_pubpropertyNumberFormat

Gets or sets the format code for the XmlMappedRange control.

System_CAPS_pubpropertyNumberFormatLocal

Gets or sets the format code for the XmlMappedRange control in the language of the user.

System_CAPS_pubpropertyOffset

Gets a Range that is offset from the XmlMappedRange control.

System_CAPS_pubpropertyOrientation

Gets or sets a value that specifies the text orientation.

System_CAPS_pubpropertyOutlineLevel

Gets or sets the current outline level of the XmlMappedRange.

System_CAPS_pubpropertyPageBreak

Gets or sets the location of a page break.

System_CAPS_pubpropertyParent

Gets a Microsoft.Office.Interop.Excel.Worksheet that represents the worksheet containing the XmlMappedRange control.

System_CAPS_pubpropertyPhonetic

Gets the Phonetic object which contains information about a specific phonetic text string in the XmlMappedRange control.

System_CAPS_pubpropertyPhonetics

Gets the Phonetics collection of the XmlMappedRange control.

System_CAPS_pubpropertyPivotCell

Gets a PivotCell that represents a cell in a PivotTable report.

System_CAPS_pubpropertyPivotField

Gets a PivotField that represents the PivotTable field containing the upper-left corner of the XmlMappedRange control.

System_CAPS_pubpropertyPivotItem

Gets a PivotItem that represents the PivotTable item containing the upper-left corner of the XmlMappedRange control.

System_CAPS_pubpropertyPivotTable

Gets 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.

System_CAPS_pubpropertyPrecedents

Gets a Range that represents all the precedents of the XmlMappedRange control.

System_CAPS_pubpropertyPrefixCharacter

Gets the prefix character for the XmlMappedRange control.

System_CAPS_pubpropertyPrevious

Gets a Range that represents the previous cell.

System_CAPS_pubpropertyQueryTable

Gets a Microsoft.Office.Interop.Excel.QueryTable that represents the query table that intersects the XmlMappedRange control.

System_CAPS_pubpropertyReadingOrder

Gets or sets the reading order for the XmlMappedRange control.

System_CAPS_pubpropertyResize

Gets a resized Range based on the XmlMappedRange control.

System_CAPS_pubpropertyRow

Gets the number of the row that contains the XmlMappedRange control.

System_CAPS_pubpropertyRowHeight

Gets or sets the height of the row that contains the XmlMappedRange control, measured in points.

System_CAPS_pubpropertyRows

Gets a Range that represents the row that contains the XmlMappedRange control.

System_CAPS_pubpropertyServerActions

Gets the actions that can be performed on the SharePoint server for an XmlMappedRange object.

System_CAPS_pubpropertyShowDetail

Gets 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).

System_CAPS_pubpropertyShrinkToFit

Gets or sets a value that indicates whether text automatically shrinks to fit in the available column width.

System_CAPS_pubpropertySite

(Inherited from IComponent.)

System_CAPS_pubpropertySoundNote

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubpropertySparklineGroups

Gets an object that represents an existing group of sparklines from the specified range.

System_CAPS_pubpropertyStyle

Gets or sets a Microsoft.Office.Interop.Excel.Style that represents the style of the XmlMappedRange control.

System_CAPS_pubpropertySummary

Gets a value that indicates whether the XmlMappedRange is an outlining summary row or column.

System_CAPS_pubpropertyTag

Gets or sets the object that contains data about the Tag control.

System_CAPS_pubpropertyText

Gets the text for the XmlMappedRange control.

System_CAPS_pubpropertyTop

Gets the distance, in points, from the top of row 1 to the top edge of the XmlMappedRange control.

System_CAPS_pubpropertyUseStandardHeight

Gets or sets a value that indicates whether the row height of the XmlMappedRange control equals the standard height of the sheet.

System_CAPS_pubpropertyUseStandardWidth

Gets or sets a value that indicates whether the column width of the XmlMappedRange control equals the standard width of the sheet.

System_CAPS_pubpropertyValidation

Gets the Microsoft.Office.Interop.Excel.Validation object that represents data validation for the XmlMappedRange control.

System_CAPS_pubpropertyValue

Gets or sets the value of the XmlMappedRange control.

System_CAPS_pubpropertyValue2

Gets or sets the XmlMappedRange control value.

System_CAPS_pubpropertyVerticalAlignment

Gets or sets the vertical alignment of the XmlMappedRange control.

System_CAPS_pubpropertyWidth

Gets the width of the XmlMappedRange control in points.

System_CAPS_pubpropertyWorksheet

Gets a Microsoft.Office.Interop.Excel.Worksheet that represents the worksheet containing the XmlMappedRange control.

System_CAPS_pubpropertyWrapText

Gets or sets a value that indicates whether Microsoft Office Excel wraps the text in the XmlMappedRange control.

System_CAPS_pubpropertyXPath

Gets an Microsoft.Office.Interop.Excel.XPath that represents the XPath of the element mapped to the XmlMappedRange control.

NameDescription
System_CAPS_pubmethodActivate()

Activates a single cell XmlMappedRange control.

System_CAPS_pubmethodAddComment(Object)

Adds a comment to the XmlMappedRange control.

System_CAPS_pubmethodAllocateChanges()

Performs a writeback operation for all edited cells in an XML mapped range based on an OLAP data source.

System_CAPS_pubmethodAutoComplete(String)

Gets an AutoComplete match from the list.

System_CAPS_pubmethodAutoFilter(Object, Object, XlAutoFilterOperator, Object, Object)

Filters a list using the AutoFilter.

System_CAPS_pubmethodAutoOutline()

Automatically creates an outline for the XmlMappedRange control.

System_CAPS_pubmethodBeginInit()

(Inherited from ISupportInitialize.)

System_CAPS_pubmethodBorderAround2(Object, XlBorderWeight, XlColorIndex, Object, Object)

Adds a border to a XmlMappedRange control and sets the Color, LineStyle, and Weight properties for the new border.

System_CAPS_pubmethodCalculate()

Calculates the value of the XmlMappedRange control.

System_CAPS_pubmethodCalculateRowMajorOrder()

Calculates the value in each item in the range in row-major order.

System_CAPS_pubmethodCheckSpelling(Object, Object, Object, Object)

Checks the spelling of text in the XmlMappedRange control.

System_CAPS_pubmethodClear()

Clears the entire XmlMappedRange control.

System_CAPS_pubmethodClearComments()

Clears all cell comments from the XmlMappedRange control.

System_CAPS_pubmethodClearContents()

Clears the formulas from the XmlMappedRange control.

System_CAPS_pubmethodClearFormats()

Clears the formatting of the XmlMappedRange control.

System_CAPS_pubmethodClearHyperlinks()

Removes all hyperlinks from the specified range.

System_CAPS_pubmethodClearNotes()

Clears notes and sound notes from the XmlMappedRange control.

System_CAPS_pubmethodClearOutline()

Clears the outline for the XmlMappedRange control.

System_CAPS_pubmethodColumnDifferences(Object)

Gets a Range that represents all the cells whose contents are different from the comparison cell in each column.

System_CAPS_pubmethodConsolidate(Object, Object, Object, Object, Object)

Consolidates data from multiple ranges on multiple worksheets into an XmlMappedRange control.

System_CAPS_pubmethodCopy(Object)

Copies the contents of the XmlMappedRange control to the specified range or to the Clipboard.

System_CAPS_pubmethodCopyFromRecordset(Object, Object, Object)

Copies the contents of an ADO or DAO recordset onto a worksheet, beginning at the XmlMappedRange control.

System_CAPS_pubmethodCopyPicture(XlPictureAppearance, XlCopyPictureFormat)

Copies the XmlMappedRange control to the Clipboard as a picture.

System_CAPS_pubmethodCreateNames(Object, Object, Object, Object)

Creates names in the XmlMappedRange control, based on text labels in the worksheet.

System_CAPS_pubmethodCut(Object)

Cuts the contents of the XmlMappedRange control to the Clipboard or pastes it into a specified destination.

System_CAPS_pubmethodDataSeries(Object, XlDataSeriesType, XlDataSeriesDate, Object, Object, Object)

Creates a data series in the XmlMappedRange control.

System_CAPS_pubmethodDialogBox()

Displays a dialog box defined by a dialog box definition table on a Microsoft Office Excel 4.0 macro sheet.

System_CAPS_pubmethodDirty()

Designates an XmlMappedRange control to be recalculated when the next recalculation occurs.

System_CAPS_pubmethodDiscardChanges()

Discards all changes in the edited cells of the Xml mapped range.

System_CAPS_pubmethodDispose()

(Inherited from IDisposable.)

System_CAPS_pubmethodEditionOptions(XlEditionType, XlEditionOptionsOption, Object, Object, XlPictureAppearance, XlPictureAppearance, Object)

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubmethodEndInit()

(Inherited from ISupportInitialize.)

System_CAPS_pubmethodExportAsFixedFormat(XlFixedFormatType, Object, Object, Object, Object, Object, Object, Object, Object)

Exports to a file of the specified format.

System_CAPS_pubmethodFillDown()

Fills down from the top cell in the XmlMappedRange control to the bottom of the XmlMappedRange control.

System_CAPS_pubmethodFillLeft()

Fills left from the rightmost cell in the XmlMappedRange control.

System_CAPS_pubmethodFillRight()

Fills right from the leftmost cell in the XmlMappedRange control.

System_CAPS_pubmethodFillUp()

Fills up from the bottom cell in the specified range to the top of the XmlMappedRange control.

System_CAPS_pubmethodFind(Object, Object, Object, Object, Object, XlSearchDirection, Object, Object, Object)

Finds specific information in an XmlMappedRange control, and returns a Range that represents the first cell where that information is found.

System_CAPS_pubmethodFindNext(Object)

Continues a search that was begun with the Find method.

System_CAPS_pubmethodFindPrevious(Object)

Continues a search that was begun with the Find method.

System_CAPS_pubmethodFunctionWizard()

Starts the Function Wizard for the XmlMappedRange control.

System_CAPS_pubmethodget_Value(Object)

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubmethodGetEnumerator()

Gets an enumerator that can be used to iterate over an XmlMappedRange control.

System_CAPS_pubmethodGroup(Object, Object, Object, Object)

When 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.

System_CAPS_pubmethodInsert(Object, Object)

Inserts a cell into the XmlMappedRange control and shifts other cells away to make space.

System_CAPS_pubmethodInsertIndent(Int32)

Adds an indent to the XmlMappedRange control.

System_CAPS_pubmethodJustify()

Rearranges the text in an XmlMappedRange control so that it fills the range evenly.

System_CAPS_pubmethodListNames()

Pastes a list of all displayed names onto the worksheet, beginning with the XmlMappedRange control.

System_CAPS_pubmethodMerge(Object)

Creates a merged cell from the XmlMappedRange control.

System_CAPS_pubmethodNavigateArrow(Object, Object, Object)

Navigates a tracer arrow for the XmlMappedRange control to the precedent, dependent, or error-causing cell or cells.

System_CAPS_pubmethodNoteText(Object, Object, Object)

Gets or sets the cell note associated with the XmlMappedRange control.

System_CAPS_pubmethodParse(Object, Object)

Parses a range of data and breaks it into multiple cells

System_CAPS_pubmethodPasteSpecial(XlPasteType, XlPasteSpecialOperation, Object, Object)

Pastes the contents of a Range from the Clipboard into the XmlMappedRange control.

System_CAPS_pubmethodPrintOutEx(Object, Object, Object, Object, Object, Object, Object, Object)

Prints out the XmlMappedRange.

System_CAPS_pubmethodPrintPreview(Object)

Shows a preview of the XmlMappedRange control as it would look when printed.

System_CAPS_pubmethodRemoveDuplicates(Object, XlYesNoGuess)

Removes duplicate values from a range of values.

System_CAPS_pubmethodRemoveSubtotal()

Removes subtotals from an XmlMappedRange control.

System_CAPS_pubmethodReplace(Object, Object, Object, Object, Object, Object, Object, Object)

Replaces the specified characters in the XmlMappedRange control with a new string.

System_CAPS_pubmethodRowDifferences(Object)

Gets a Range that represents the cells whose contents are different from those of the comparison cell in each row.

System_CAPS_pubmethodSelect()

Selects the XmlMappedRange control.

System_CAPS_pubmethodset_Value(Object, Object)

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubmethodSetPhonetic()

Creates Phonetic objects for the XmlMappedRange control.

System_CAPS_pubmethodShow()

Scrolls through the contents of the active window to move the XmlMappedRange control into view.

System_CAPS_pubmethodShowDependents(Object)

Draws tracer arrows to the direct dependents of the XmlMappedRange control.

System_CAPS_pubmethodShowErrors()

Draws tracer arrows through the precedents tree to the cell that is the source of the error, and returns the range that contains that cell.

System_CAPS_pubmethodShowPrecedents(Object)

Draws tracer arrows to the direct precedents of the XmlMappedRange control.

System_CAPS_pubmethodSpeak(Object, Object)

Causes the cells of the XmlMappedRange control to be spoken in row order or column order.

System_CAPS_pubmethodSpecialCells(XlCellType, Object)

Gets a Range that represents all the cells that match the specified type and value.

System_CAPS_pubmethodSubscribeTo(String, XlSubscribeToFormat)

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubmethodSubtotal(Int32, XlConsolidationFunction, Object, Object, Object, XlSummaryRow)

Creates subtotals for the XmlMappedRange control.

System_CAPS_pubmethodTable(Object, Object)

Creates a data table based on input values and formulas that you define on a worksheet.

System_CAPS_pubmethodTextToColumns(Object, XlTextParsingType, XlTextQualifier, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Parses a column of cells that contain text into several columns.

System_CAPS_pubmethodUngroup()

Promotes an XmlMappedRange control in an outline (that is, decreases its outline level).

System_CAPS_pubmethodUnMerge()

Separates a merged area into individual cells.

NameDescription
System_CAPS_pubeventBeforeDoubleClick

Occurs when an XmlMappedRange control is double-clicked, before the default double-click action.

System_CAPS_pubeventBeforeRightClick

Occurs when an XmlMappedRange control is right-clicked, before the default right-click action.

System_CAPS_pubeventBindingContextChanged

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubeventChange

Occurs when something changes in the XmlMappedRange control.

System_CAPS_pubeventDeselected

Occurs when selection moves from the XmlMappedRange control to an area outside of the XmlMappedRange control.

System_CAPS_pubeventDisposed

(Inherited from IComponent.)

System_CAPS_pubeventSelected

Occurs when the XmlMappedRange control is selected.

System_CAPS_pubeventSelectionChange

Occurs when the selection inside the XmlMappedRange control changes.

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.

System_CAPS_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.

This documentation describes the version of this type that is used in Office projects that target the .NET Framework 4 or later. 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.

Return to top
Show: