IRange IRange IRange Interface

Definition

Für die interne Verwendung reserviert. Reserved for internal use.

public interface class IRange : System::Collections::IEnumerable
[System.Runtime.InteropServices.Guid("00020846-0001-0000-C000-000000000046")]
public interface IRange : System.Collections.IEnumerable
Public Interface IRange
Implements IEnumerable
Attribute
Implementiert

Eigenschaften

_Default[Object, Object] _Default[Object, Object] _Default[Object, Object]
AddIndent AddIndent AddIndent
Address[Object, Object, XlReferenceStyle, Object, Object] Address[Object, Object, XlReferenceStyle, Object, Object] Address[Object, Object, XlReferenceStyle, Object, Object]
AddressLocal[Object, Object, XlReferenceStyle, Object, Object] AddressLocal[Object, Object, XlReferenceStyle, Object, Object] AddressLocal[Object, Object, XlReferenceStyle, Object, Object]
AllowEdit AllowEdit AllowEdit
Application Application Application
Areas Areas Areas
Borders Borders Borders
Cells Cells Cells
Characters[Object, Object] Characters[Object, Object] Characters[Object, Object]
Column Column Column
Columns Columns Columns
ColumnWidth ColumnWidth ColumnWidth
Comment Comment Comment
Count Count Count
CountLarge CountLarge CountLarge
Creator Creator Creator
CurrentArray CurrentArray CurrentArray
CurrentRegion CurrentRegion CurrentRegion
Dependents Dependents Dependents
DirectDependents DirectDependents DirectDependents
DirectPrecedents DirectPrecedents DirectPrecedents
DisplayFormat DisplayFormat DisplayFormat
End[XlDirection] End[XlDirection] End[XlDirection]
EntireColumn EntireColumn EntireColumn
EntireRow EntireRow EntireRow
Errors Errors Errors
Font Font Font
FormatConditions FormatConditions FormatConditions
Formula Formula Formula
FormulaArray FormulaArray FormulaArray
FormulaHidden FormulaHidden FormulaHidden
FormulaLabel FormulaLabel FormulaLabel
FormulaLocal FormulaLocal FormulaLocal
FormulaR1C1 FormulaR1C1 FormulaR1C1
FormulaR1C1Local FormulaR1C1Local FormulaR1C1Local
HasArray HasArray HasArray
HasFormula HasFormula HasFormula
Height Height Height
Hidden Hidden Hidden
HorizontalAlignment HorizontalAlignment HorizontalAlignment
Hyperlinks Hyperlinks Hyperlinks
ID ID ID
IndentLevel IndentLevel IndentLevel
Interior Interior Interior
Item[Object, Object] Item[Object, Object] Item[Object, Object]
Left Left Left
ListHeaderRows ListHeaderRows ListHeaderRows
ListObject ListObject ListObject
LocationInTable LocationInTable LocationInTable
Locked Locked Locked
MDX MDX MDX
MergeArea MergeArea MergeArea
MergeCells MergeCells MergeCells
Name Name Name
Next Next Next
NumberFormat NumberFormat NumberFormat
NumberFormatLocal NumberFormatLocal NumberFormatLocal
Offset[Object, Object] Offset[Object, Object] Offset[Object, Object]
Orientation Orientation Orientation
OutlineLevel OutlineLevel OutlineLevel
PageBreak PageBreak PageBreak
Parent Parent Parent
Phonetic Phonetic Phonetic
Phonetics Phonetics Phonetics
PivotCell PivotCell PivotCell
PivotField PivotField PivotField
PivotItem PivotItem PivotItem
PivotTable PivotTable PivotTable
Precedents Precedents Precedents
PrefixCharacter PrefixCharacter PrefixCharacter
Previous Previous Previous
QueryTable QueryTable QueryTable
Range[Object, Object] Range[Object, Object] Range[Object, Object]
ReadingOrder ReadingOrder ReadingOrder
Resize[Object, Object] Resize[Object, Object] Resize[Object, Object]
Row Row Row
RowHeight RowHeight RowHeight
Rows Rows Rows
ServerActions ServerActions ServerActions
ShowDetail ShowDetail ShowDetail
ShrinkToFit ShrinkToFit ShrinkToFit
SmartTags SmartTags SmartTags
SoundNote SoundNote SoundNote
SparklineGroups SparklineGroups SparklineGroups
Style Style Style
Summary Summary Summary
Text Text Text
Top Top Top
UseStandardHeight UseStandardHeight UseStandardHeight
UseStandardWidth UseStandardWidth UseStandardWidth
Validation Validation Validation
Value[Object] Value[Object] Value[Object]
Value2 Value2 Value2
VerticalAlignment VerticalAlignment VerticalAlignment
Width Width Width
Worksheet Worksheet Worksheet
WrapText WrapText WrapText
XPath XPath XPath

Methoden

_PasteSpecial(XlPasteType, XlPasteSpecialOperation, Object, Object) _PasteSpecial(XlPasteType, XlPasteSpecialOperation, Object, Object) _PasteSpecial(XlPasteType, XlPasteSpecialOperation, Object, Object)
_PrintOut(Object, Object, Object, Object, Object, Object, Object) _PrintOut(Object, Object, Object, Object, Object, Object, Object) _PrintOut(Object, Object, Object, Object, Object, Object, Object)
Activate() Activate() Activate()
AddComment(Object) AddComment(Object) AddComment(Object)
AdvancedFilter(XlFilterAction, Object, Object, Object) AdvancedFilter(XlFilterAction, Object, Object, Object) AdvancedFilter(XlFilterAction, Object, Object, Object)
AllocateChanges() AllocateChanges() AllocateChanges()
ApplyNames(Object, Object, Object, Object, Object, XlApplyNamesOrder, Object) ApplyNames(Object, Object, Object, Object, Object, XlApplyNamesOrder, Object) ApplyNames(Object, Object, Object, Object, Object, XlApplyNamesOrder, Object)
ApplyOutlineStyles() ApplyOutlineStyles() ApplyOutlineStyles()
AutoComplete(String) AutoComplete(String) AutoComplete(String)
AutoFill(Range, XlAutoFillType) AutoFill(Range, XlAutoFillType) AutoFill(Range, XlAutoFillType)
AutoFilter(Object, Object, XlAutoFilterOperator, Object, Object) AutoFilter(Object, Object, XlAutoFilterOperator, Object, Object) AutoFilter(Object, Object, XlAutoFilterOperator, Object, Object)
AutoFit() AutoFit() AutoFit()
AutoFormat(XlRangeAutoFormat, Object, Object, Object, Object, Object, Object) AutoFormat(XlRangeAutoFormat, Object, Object, Object, Object, Object, Object) AutoFormat(XlRangeAutoFormat, Object, Object, Object, Object, Object, Object)
AutoOutline() AutoOutline() AutoOutline()
BorderAround(Object, XlBorderWeight, XlColorIndex, Object) BorderAround(Object, XlBorderWeight, XlColorIndex, Object) BorderAround(Object, XlBorderWeight, XlColorIndex, Object)
BorderAround2(Object, XlBorderWeight, XlColorIndex, Object, Object) BorderAround2(Object, XlBorderWeight, XlColorIndex, Object, Object) BorderAround2(Object, XlBorderWeight, XlColorIndex, Object, Object)
Calculate() Calculate() Calculate()
CalculateRowMajorOrder() CalculateRowMajorOrder() CalculateRowMajorOrder()
CheckSpelling(Object, Object, Object, Object) CheckSpelling(Object, Object, Object, Object) CheckSpelling(Object, Object, Object, Object)
Clear() Clear() Clear()
ClearComments() ClearComments() ClearComments()
ClearContents() ClearContents() ClearContents()
ClearFormats() ClearFormats() ClearFormats()
ClearHyperlinks() ClearHyperlinks() ClearHyperlinks()
ClearNotes() ClearNotes() ClearNotes()
ClearOutline() ClearOutline() ClearOutline()
ColumnDifferences(Object) ColumnDifferences(Object) ColumnDifferences(Object)
Consolidate(Object, Object, Object, Object, Object) Consolidate(Object, Object, Object, Object, Object) Consolidate(Object, Object, Object, Object, Object)
Copy(Object) Copy(Object) Copy(Object)
CopyFromRecordset(Object, Object, Object) CopyFromRecordset(Object, Object, Object) CopyFromRecordset(Object, Object, Object)
CopyPicture(XlPictureAppearance, XlCopyPictureFormat) CopyPicture(XlPictureAppearance, XlCopyPictureFormat) CopyPicture(XlPictureAppearance, XlCopyPictureFormat)
CreateNames(Object, Object, Object, Object) CreateNames(Object, Object, Object, Object) CreateNames(Object, Object, Object, Object)
CreatePublisher(Object, XlPictureAppearance, Object, Object, Object, Object) CreatePublisher(Object, XlPictureAppearance, Object, Object, Object, Object) CreatePublisher(Object, XlPictureAppearance, Object, Object, Object, Object)
Cut(Object) Cut(Object) Cut(Object)
DataSeries(Object, XlDataSeriesType, XlDataSeriesDate, Object, Object, Object) DataSeries(Object, XlDataSeriesType, XlDataSeriesDate, Object, Object, Object) DataSeries(Object, XlDataSeriesType, XlDataSeriesDate, Object, Object, Object)
Delete(Object) Delete(Object) Delete(Object)
DialogBox() DialogBox() DialogBox()
Dirty() Dirty() Dirty()
DiscardChanges() DiscardChanges() DiscardChanges()
EditionOptions(XlEditionType, XlEditionOptionsOption, Object, Object, XlPictureAppearance, XlPictureAppearance, Object) EditionOptions(XlEditionType, XlEditionOptionsOption, Object, Object, XlPictureAppearance, XlPictureAppearance, Object) EditionOptions(XlEditionType, XlEditionOptionsOption, Object, Object, XlPictureAppearance, XlPictureAppearance, Object)
ExportAsFixedFormat(XlFixedFormatType, Object, Object, Object, Object, Object, Object, Object, Object) ExportAsFixedFormat(XlFixedFormatType, Object, Object, Object, Object, Object, Object, Object, Object) ExportAsFixedFormat(XlFixedFormatType, Object, Object, Object, Object, Object, Object, Object, Object)
FillDown() FillDown() FillDown()
FillLeft() FillLeft() FillLeft()
FillRight() FillRight() FillRight()
FillUp() FillUp() FillUp()
Find(Object, Object, Object, Object, Object, XlSearchDirection, Object, Object, Object) Find(Object, Object, Object, Object, Object, XlSearchDirection, Object, Object, Object) Find(Object, Object, Object, Object, Object, XlSearchDirection, Object, Object, Object)
FindNext(Object) FindNext(Object) FindNext(Object)
FindPrevious(Object) FindPrevious(Object) FindPrevious(Object)
FlashFill() FlashFill() FlashFill()
FunctionWizard() FunctionWizard() FunctionWizard()
GetEnumerator() GetEnumerator() GetEnumerator()
GoalSeek(Object, Range) GoalSeek(Object, Range) GoalSeek(Object, Range)
Group(Object, Object, Object, Object) Group(Object, Object, Object, Object) Group(Object, Object, Object, Object)
Insert(Object, Object) Insert(Object, Object) Insert(Object, Object)
InsertIndent(Int32) InsertIndent(Int32) InsertIndent(Int32)
Justify() Justify() Justify()
ListNames() ListNames() ListNames()
Merge(Object) Merge(Object) Merge(Object)
NavigateArrow(Object, Object, Object) NavigateArrow(Object, Object, Object) NavigateArrow(Object, Object, Object)
NoteText(Object, Object, Object) NoteText(Object, Object, Object) NoteText(Object, Object, Object)
Parse(Object, Object) Parse(Object, Object) Parse(Object, Object)
PasteSpecial(XlPasteType, XlPasteSpecialOperation, Object, Object) PasteSpecial(XlPasteType, XlPasteSpecialOperation, Object, Object) PasteSpecial(XlPasteType, XlPasteSpecialOperation, Object, Object)
PrintOut(Object, Object, Object, Object, Object, Object, Object, Object) PrintOut(Object, Object, Object, Object, Object, Object, Object, Object) PrintOut(Object, Object, Object, Object, Object, Object, Object, Object)
PrintOutEx(Object, Object, Object, Object, Object, Object, Object, Object) PrintOutEx(Object, Object, Object, Object, Object, Object, Object, Object) PrintOutEx(Object, Object, Object, Object, Object, Object, Object, Object)
PrintPreview(Object) PrintPreview(Object) PrintPreview(Object)
RemoveDuplicates(Object, XlYesNoGuess) RemoveDuplicates(Object, XlYesNoGuess) RemoveDuplicates(Object, XlYesNoGuess)
RemoveSubtotal() RemoveSubtotal() RemoveSubtotal()
Replace(Object, Object, Object, Object, Object, Object, Object, Object) Replace(Object, Object, Object, Object, Object, Object, Object, Object) Replace(Object, Object, Object, Object, Object, Object, Object, Object)
RowDifferences(Object) RowDifferences(Object) RowDifferences(Object)
Run(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) Run(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) Run(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)
Select() Select() Select()
SetPhonetic() SetPhonetic() SetPhonetic()
Show() Show() Show()
ShowDependents(Object) ShowDependents(Object) ShowDependents(Object)
ShowErrors() ShowErrors() ShowErrors()
ShowPrecedents(Object) ShowPrecedents(Object) ShowPrecedents(Object)
Sort(Object, XlSortOrder, Object, Object, XlSortOrder, Object, XlSortOrder, XlYesNoGuess, Object, Object, XlSortOrientation, XlSortMethod, XlSortDataOption, XlSortDataOption, XlSortDataOption) Sort(Object, XlSortOrder, Object, Object, XlSortOrder, Object, XlSortOrder, XlYesNoGuess, Object, Object, XlSortOrientation, XlSortMethod, XlSortDataOption, XlSortDataOption, XlSortDataOption) Sort(Object, XlSortOrder, Object, Object, XlSortOrder, Object, XlSortOrder, XlYesNoGuess, Object, Object, XlSortOrientation, XlSortMethod, XlSortDataOption, XlSortDataOption, XlSortDataOption)
SortSpecial(XlSortMethod, Object, XlSortOrder, Object, Object, XlSortOrder, Object, XlSortOrder, XlYesNoGuess, Object, Object, XlSortOrientation, XlSortDataOption, XlSortDataOption, XlSortDataOption) SortSpecial(XlSortMethod, Object, XlSortOrder, Object, Object, XlSortOrder, Object, XlSortOrder, XlYesNoGuess, Object, Object, XlSortOrientation, XlSortDataOption, XlSortDataOption, XlSortDataOption) SortSpecial(XlSortMethod, Object, XlSortOrder, Object, Object, XlSortOrder, Object, XlSortOrder, XlYesNoGuess, Object, Object, XlSortOrientation, XlSortDataOption, XlSortDataOption, XlSortDataOption)
Speak(Object, Object) Speak(Object, Object) Speak(Object, Object)
SpecialCells(XlCellType, Object) SpecialCells(XlCellType, Object) SpecialCells(XlCellType, Object)
SubscribeTo(String, XlSubscribeToFormat) SubscribeTo(String, XlSubscribeToFormat) SubscribeTo(String, XlSubscribeToFormat)
Subtotal(Int32, XlConsolidationFunction, Object, Object, Object, XlSummaryRow) Subtotal(Int32, XlConsolidationFunction, Object, Object, Object, XlSummaryRow) Subtotal(Int32, XlConsolidationFunction, Object, Object, Object, XlSummaryRow)
Table(Object, Object) Table(Object, Object) Table(Object, Object)
TextToColumns(Object, XlTextParsingType, XlTextQualifier, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) TextToColumns(Object, XlTextParsingType, XlTextQualifier, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) TextToColumns(Object, XlTextParsingType, XlTextQualifier, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)
Ungroup() Ungroup() Ungroup()
UnMerge() UnMerge() UnMerge()

Gilt für: