</ 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$$" -->XLSheetCollection 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> : XLSheetCollection 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.XLSheetCollection.html">XLSheetCollection</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>" --><!--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.XLSheetCollection~Book.html">Book</a></td><td class="MembersDescriptionCell">Gets a reference to the <a href="C1.WPF.Excel.4~C1.WPF.Excel.C1XLBook.html">C1XLBook</a> that owns the collection. </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.XLSheetCollection~Count.html">Count</a></td><td class="MembersDescriptionCell">Gets the number of <a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet.html">XLSheet</a> objects in the collection. </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.XLSheetCollection~FirstIndex.html">FirstIndex</a></td><td class="MembersDescriptionCell">Gets or sets the index of the sheet that is initially opened when a <a href="C1.WPF.Excel.4~C1.WPF.Excel.C1XLBook.html">C1XLBook</a> file is loaded into Excel. </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.XLSheetCollection~Item.html">Item</a></td><td class="MembersDescriptionCell">Overloaded. Gets the <a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet.html">XLSheet</a> at a given position in the collection. </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.XLSheetCollection~SelectedIndex.html">SelectedIndex</a></td><td class="MembersDescriptionCell">Gets or sets the index of the sheet that is selected when a <a href="C1.WPF.Excel.4~C1.WPF.Excel.C1XLBook.html">C1XLBook</a> file is loaded into Excel. </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.XLSheetCollection~Add.html">Add</a></td><td class="MembersDescriptionCell">Overloaded. Creates a new <a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet.html">XLSheet</a> and appends it to the collection. </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.XLSheetCollection~Clear.html">Clear</a></td><td class="MembersDescriptionCell">Removes all items from the collection. </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.XLSheetCollection~Contains.html">Contains</a></td><td class="MembersDescriptionCell">Overloaded. Determines whether the collection contains a specific <a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet.html">XLSheet</a> object. </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.XLSheetCollection~IndexOf.html">IndexOf</a></td><td class="MembersDescriptionCell">Overloaded. Gets the index of a given <a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet.html">XLSheet</a> in the collection. </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.XLSheetCollection~Insert.html">Insert</a></td><td class="MembersDescriptionCell">Overloaded. Creates a new <a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet.html">XLSheet</a> and inserts it at a specific position in the collection. </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.XLSheetCollection~Remove.html">Remove</a></td><td class="MembersDescriptionCell">Overloaded. Removes an <a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet.html">XLSheet</a> from the collection. </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.XLSheetCollection~RemoveAt.html">RemoveAt</a></td><td class="MembersDescriptionCell">Removes the <a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet.html">XLSheet</a> at a specific index from the collection. </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.XLSheetCollection.html">XLSheetCollection 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>