</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <div id="BeforeHeaderContent"> </div> <div id="HeaderContent"> <!--DXMETADATA start type="Literal" condition="communityenabled" value="%%scrap:name=_COMMUNITY_RATING%%" --><!--DXMETADATA end --> <!--DXMETADATA start type="LogoImage" --><!--DXMETADATA end--> <div id="ProjectTitle"><!--DXMETADATA start type="ProjectTitle" -->DataGrid for WPF and Silverlight<!--DXMETADATA end--></div> <div id="PageTitle"><div id="PageTitleText"><!--DXMETADATA start type="PageItemTitle" format="%%PageItemTitle%% $$Members$$" -->XLCellRange Class Members<!--DXMETADATA end--></div></div> </div> <div id="AfterHeaderContent"> <!--DXMETADATA start type="Literal" condition="childitems:itemtype=field" value="<a class=""PageLink"" href=""#FieldsBookmark"">$$Fields$$</a> " --><!--DXMETADATA end--> <!--DXMETADATA start type="Literal" condition="childitems:itemtype=property" value="<a class=""PageLink"" href=""#PropertiesBookmark"">$$Properties$$</a> " --><a class="PageLink" href="#PropertiesBookmark">Properties</a> <!--DXMETADATA end--> <!--DXMETADATA start type="Literal" condition="childitems:itemtype=method" value="<a class=""PageLink"" href=""#MethodsBookmark"">$$Methods$$</a> " --><a class="PageLink" href="#MethodsBookmark">Methods</a> <!--DXMETADATA end--> <!--DXMETADATA start type="Literal" condition="childitems:itemtype=event" value="<a class=""PageLink"" href=""#EventsBookmark"">$$Events$$</a>" --><!--DXMETADATA end--><!-- Spacing --> <span id="ToggleAllSectionsLink" class="FunctionLink"> <label id="CollapseAllLabel"><!--DXMETADATA start type="Phrase" name="COLLAPSE_ALL" -->Collapse All<!--DXMETADATA end--></label> <label id="ExpandAllLabel" style="display: none;"><!--DXMETADATA start type="Phrase" name="EXPAND_ALL" -->Expand All<!--DXMETADATA end--></label> </span><!--DXMETADATA start type="Literal" condition="communityenabled" value="%%scrap:name=_COMMUNITY_DROPDOWN%%" --><!--DXMETADATA end --><span id="" class="PopupLink" data-popupcontentsource="#MemberFilterCheckboxes" data-popuptitle='<!--DXMETADATA start type="Phrase" name="Members_Filter" -->Members Options<!--DXMETADATA end -->'> <label id="ShowAllMembersLabel"> <!--DXMETADATA start type="Phrase" name="MEMBERS_FILTER_SHOW_ALL" -->Members Options: Show All<!--DXMETADATA end --> </label> <label id="FilteredMembersLabel" style="display: none;"> <!--DXMETADATA start type="Phrase" name="MEMBERS_FILTER_FILTERED" -->Members Options: Filtered<!--DXMETADATA end --> </label> </span> <div class="PopupContent" id="MemberFilterCheckboxes"> <input id="InheritedCheckbox" type="checkbox" class="ToggleFilterCheckbox" checked="true" data-toggleclass="InheritedMember"> <label class="MembersFilter" for="InheritedCheckbox"> <!--DXMETADATA start type="Phrase" name="MEMBERS_FILTER_INHERITED" -->Include Inherited Members<!--DXMETADATA end --> </label> <br> <!--DXMETADATA start type="IncludeProtectedOrFriendMembers" format="<input id=""ProtectedCheckbox"" type=""checkbox"" class=""ToggleFilterCheckbox"" checked=""true"" data-toggleclass=""ProtectedMember"" />" --><!--DXMETADATA end --> <!--DXMETADATA start type="IncludeProtectedOrFriendMembers" format="<label class=""MembersFilter"" for=""ProtectedCheckbox"">$$MEMBERS_FILTER_PROTECTED$$</label><br />" --><!--DXMETADATA end --> </div> <!--DXMETADATA start type="IsWebOutputRootPageLinkEnabled" format="<a href='#' class='PageLink' id='viewInFrameLink' title='$$VIEW_WITH_NAVIGATION_TOOLS_TIP$$' style='display: none' data-root-page='%%WebOutputRootPage%%%%OutputFileExtension%%' target='_top'>$$VIEW_WITH_NAVIGATION_TOOLS_TEXT$$</a>" --><!--DXMETADATA end--> </div> <!--DXMETADATA start type="Breadcrumbs" scrap="_BREADCRUMBS" --><div class="BreadcrumbsContainer"><table><tr><td> <a href="C1.WPF.Excel.4~C1.WPF.Excel_namespace.html">C1.WPF.Excel Namespace</a> : XLCellRange Class</td></tr></table></div><!--DXMETADATA end --> <div id="BodyContent"> <!--DXMETADATA start type="Scrap" name="_OVERVIEW_LINK" format="<p>%%scrap%%</p>" --><p>The following tables list the members exposed by <a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange.html">XLCellRange</a>.</p><!--DXMETADATA end --> <a name="ConstructorsBookmark"></a> <!--DXMETADATA start type="FilteredItemList" scrap="MEMBER_LIST" namespace="constructor" source="Item" filter="scope=public" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=publicConstructors,caption=$$Public$$ $$Constructors$$%%%%filtereditemlist%%<a href="#top">$$Top$$</a></div>" --><div class="SectionHeading" id="publicConstructorsSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">Public Constructors</span></div><div id="publicConstructorsSectionContent" class="SectionContent"><table class="FilteredItemListTable"><tr><th> </th><th>Name</th><th>Description</th></tr> <tr><td class="ImageCell"><img alt="Public Constructor" src="dotnetimages/publicConstructor.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange~_ctor.html">XLCellRange Constructor</a></td><td class="MembersDescriptionCell">Overloaded. </td></tr> </table><a href="#top">Top</a></div><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="MEMBER_LIST" namespace="constructor" source="Item" filter="scope=protected+protected friend+friend" format="<div class=""ProtectedMember"">%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=protectedConstructors,caption=$$Protected$$ $$Constructors$$%%%%filtereditemlist%%<a href="#top">$$Top$$</a></div></div>" --><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="MEMBER_LIST" namespace="constructor" source="Item" filter="scope=private" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=privateConstructors,caption=$$Private$$ $$Constructors$$%%%%filtereditemlist%%<a href="#top">$$Top$$</a></div>" --><!--DXMETADATA end --> <a name="FieldsBookmark"></a> <!--DXMETADATA start type="FilteredItemList" scrap="MEMBER_LIST" namespace="field" source="Item" filter="scope=public" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=publicFields,caption=$$Public$$ $$Fields$$%%%%filtereditemlist%%<a href="#top">$$Top$$</a></div>" --><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="MEMBER_LIST" namespace="field" source="Item" filter="scope=protected+protected friend+friend" format="<div class=""ProtectedMember"">%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=protectedFields,caption=$$Protected$$ $$Fields$$%%%%filtereditemlist%%<a href="#top">$$Top$$</a></div></div>" --><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="MEMBER_LIST" namespace="field" source="Item" filter="scope=private" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=privateFields,caption=$$Private$$ $$Fields$$%%%%filtereditemlist%%<a href="#top">$$Top$$</a></div>" --><!--DXMETADATA end --> <a name="PropertiesBookmark"></a> <!--DXMETADATA start type="FilteredItemList" scrap="MEMBER_LIST" namespace="property" source="Item" filter="scope=public" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=publicProperties,caption=$$Public$$ $$Properties$$%%%%filtereditemlist%%<a href="#top">$$Top$$</a></div>" --><div class="SectionHeading" id="publicPropertiesSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">Public Properties</span></div><div id="publicPropertiesSectionContent" class="SectionContent"><table class="FilteredItemListTable"><tr><th> </th><th>Name</th><th>Description</th></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange~Book.html">Book</a></td><td class="MembersDescriptionCell">Gets a reference to the parent <a href="C1.WPF.Excel.4~C1.WPF.Excel.C1XLBook.html">C1XLBook</a> object. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange~ColumnCount.html">ColumnCount</a></td><td class="MembersDescriptionCell">Gets the number of columns in the range. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange~ColumnFrom.html">ColumnFrom</a></td><td class="MembersDescriptionCell">Gets the index of the left column in the range. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange~ColumnFromRef.html">ColumnFromRef</a></td><td class="MembersDescriptionCell">Gets the reference type of the left column in the range. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange~ColumnTo.html">ColumnTo</a></td><td class="MembersDescriptionCell">Gets or sets the index of the last column in the range. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange~ColumnToRef.html">ColumnToRef</a></td><td class="MembersDescriptionCell">Gets the reference type of the right column in the range. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange~IsEmpty.html">IsEmpty</a></td><td class="MembersDescriptionCell">Determines whether the range is empty. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange~RangeType.html">RangeType</a></td><td class="MembersDescriptionCell">Gets or sets a type (default, indirect or offset) for this cell range. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange~RowCount.html">RowCount</a></td><td class="MembersDescriptionCell">Gets the number of rows in the range. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange~RowFrom.html">RowFrom</a></td><td class="MembersDescriptionCell">Gets the index of the top row in the range. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange~RowFromRef.html">RowFromRef</a></td><td class="MembersDescriptionCell">Gets the reference type of the top row in the range. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange~RowTo.html">RowTo</a></td><td class="MembersDescriptionCell">Gets or sets the index of the last row in the range. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange~RowToRef.html">RowToRef</a></td><td class="MembersDescriptionCell">Gets the reference type of the bottom row in the range. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange~SheetCount.html">SheetCount</a></td><td class="MembersDescriptionCell">Gets the number of sheets in the range. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange~SheetFrom.html">SheetFrom</a></td><td class="MembersDescriptionCell">Gets the index of the first sheet in the range. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange~Sheets.html">Sheets</a></td><td class="MembersDescriptionCell">Gets an array of <a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet.html">XLSheet</a> objects. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange~SheetTo.html">SheetTo</a></td><td class="MembersDescriptionCell">Gets or sets the index of the last sheet in the range. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange~Style.html">Style</a></td><td class="MembersDescriptionCell">Gets or sets the <a href="C1.WPF.Excel.4~C1.WPF.Excel.XLStyle.html">XLStyle</a> object associated with this range of cells. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange~Value.html">Value</a></td><td class="MembersDescriptionCell">Gets or sets the complex value associated with this range of cells. </td></tr> </table><a href="#top">Top</a></div><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="MEMBER_LIST" namespace="property" source="Item" filter="scope=protected+protected friend+friend" format="<div class=""ProtectedMember"">%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=protectedProperties,caption=$$Protected$$ $$Properties$$%%%%filtereditemlist%%<a href="#top">$$Top$$</a></div></div>" --><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="MEMBER_LIST" namespace="property" source="Item" filter="scope=private" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=privateProperties,caption=$$Private$$ $$Properties$$%%%%filtereditemlist%%<a href="#top">$$Top$$</a></div>" --><!--DXMETADATA end --> <a name="MethodsBookmark"></a> <!--DXMETADATA start type="FilteredItemList" scrap="MEMBER_LIST" namespace="method" source="Item" filter="scope=public" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=publicMethods,caption=$$Public$$ $$Methods$$%%%%filtereditemlist%%<a href="#top">$$Top$$</a></div>" --><div class="SectionHeading" id="publicMethodsSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">Public Methods</span></div><div id="publicMethodsSectionContent" class="SectionContent"><table class="FilteredItemListTable"><tr><th> </th><th>Name</th><th>Description</th></tr> <tr><td class="ImageCell"><img alt="Public Method" src="dotnetimages/publicMethod.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange~Clone().html">Clone</a></td><td class="MembersDescriptionCell">Creates a copy of this cell range. </td></tr> <tr><td class="ImageCell"><img alt="Public Method" src="dotnetimages/publicMethod.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange~Contains.html">Contains</a></td><td class="MembersDescriptionCell">Overloaded. Determines whether the range contains a specific cell. </td></tr> <tr><td class="ImageCell"><img alt="Public Method" src="dotnetimages/publicMethod.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange~Intersects.html">Intersects</a></td><td class="MembersDescriptionCell">Determines whether the range intersects another range. </td></tr> <tr><td class="ImageCell"><img alt="Public Method" src="dotnetimages/publicMethod.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange~ToString.html">ToString</a></td><td class="MembersDescriptionCell">Returns a reference string that represents the range. </td></tr> </table><a href="#top">Top</a></div><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="MEMBER_LIST" namespace="method" source="Item" filter="scope=protected+protected friend+friend" format="<div class=""ProtectedMember"">%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=protectedMethods,caption=$$Protected$$ $$Methods$$%%%%filtereditemlist%%<a href="#top">$$Top$$</a></div></div>" --><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="MEMBER_LIST" namespace="method" source="Item" filter="scope=private" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=privateMethods,caption=$$Private$$ $$Methods$$%%%%filtereditemlist%%<a href="#top">$$Top$$</a></div>" --><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" condition="content:content=""%%IncludeExtensionMethods%%"",operator=""="",value=""True""" scrap="EXTENSIONMETHOD_LIST" namespace="method" source="Item" filter="scope=public,type=extension" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=extensionmethods,caption=$$Extension_Methods$$%%%%filtereditemlist%%<a href="#top">$$Top$$</a></div>" --><!--DXMETADATA end --> <a name="EventsBookmark"></a> <!--DXMETADATA start type="FilteredItemList" scrap="MEMBER_LIST" namespace="event" source="Item" filter="scope=public" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=publicEvents,caption=$$Public$$ $$Events$$%%%%filtereditemlist%%<a href="#top">$$Top$$</a></div>" --><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="MEMBER_LIST" namespace="event" source="Item" filter="scope=protected+protected friend+friend" format="<div class=""ProtectedMember"">%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=protectedEvents,caption=$$Protected$$ $$Events$$%%%%filtereditemlist%%<a href="#top">$$Top$$</a></div></div>" --><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="MEMBER_LIST" namespace="event" source="Item" filter="scope=private" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=privateEvents,caption=$$Private$$ $$Events$$%%%%filtereditemlist%%<a href="#top">$$Top$$</a></div>" --><!--DXMETADATA end --> <a name="OperatorsBookmark"></a> <!--DXMETADATA start type="FilteredItemList" scrap="OPERATOR_LIST" namespace="operator" source="Item" filter="" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=publicOperators,caption=$$Public$$ $$Operators$$%%%%filtereditemlist%%<a href="#top">$$Top$$</a></div>" --><!--DXMETADATA end --> <a name="SeeAlsoBookmark"></a> <!--DXMETADATA start type="FilteredItemList" scrap="CATEGORIZED_LINKS" namespace="linkcategory" source="Item" filter="type=members" NoHeader="True" NoFooter="True" format="%%replaceinquotes:value=false%%%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=seealso,caption=""$$See_Also$$%%designlist:tagidentifier=##SEEALSO,itemtype=See Also%%""%%%%filtereditemlist%%</div>"--><div class="SectionHeading" id="seealsoSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">See Also</span></div><div id="seealsoSectionContent" class="SectionContent"><h4 class="subHeading">Reference</h4><p><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRange.html">XLCellRange Class</a> <br><a href="C1.WPF.Excel.4~C1.WPF.Excel_namespace.html">C1.WPF.Excel Namespace</a> </p> </div><!--DXMETADATA end--> </div> <div id="FooterContent"> <!--DXMETADATA start type="Scrap" condition="communityenabled" name="_COMMUNITY_FOOTER" --><!--DXMETADATA end --> <!--DXMETADATA start type="Variable" name="CopyrightNotice" format="<p> </p><p> </p><hr style=""height: 1px"" /><p>%%variable%%</p>" --><!--DXMETADATA end --> <!--DXMETADATA start type="Variable" name="FeedbackLink" format="" --><!--DXMETADATA end--> </div> </body> </html>