</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <div id="BeforeHeaderContent"> </div> <div id="HeaderContent"> <div id="ProjectTitle">Excel for UWP</div> <div id="PageTitle"><div id="PageTitleText">Insert(Int32,XLRow) Method</div></div> </div> <div id="AfterHeaderContent"> <!-- Spacing --> <span id="ToggleAllSectionsLink" class="FunctionLink"> <label id="CollapseAllLabel">Collapse All</label> <label id="ExpandAllLabel" style="display: none;">Expand All</label> </span><!-- Spacing --> <span id="LanguageFilterPopupLink" class="PopupLink" data-popupcontentsource="#LanguageCheckboxes" data-popuptitle='Language Filter'> <label id="ShowAllLabel" for="LanguageFilterPopupLink"> Language Filter: All </label> <label id="MultipleLabel" for="LanguageFilterPopupLink" style="display: none;"> Language Filter: Multiple </label> <label id="VBAllLabel" for="LanguageFilterPopupLink" style="display: none;"> Language Filter: Visual Basic </label> <label id="VBLabel" for="LanguageFilterPopupLink" style="display: none;">Language Filter: Visual Basic (Declaration)</label> <label id="CSLabel" for="LanguageFilterPopupLink" style="display: none;">Language Filter: C#</label> </span> <div class="PopupContent" id="LanguageCheckboxes"> <input data-languagename="VB" id="VBLanguageCheckbox" type="checkbox" class="ToggleLanguageCheckbox" checked="true" data-toggleclass="FilteredContentVB"> <label class="LanguageFilter" for="VBCheckbox"> Visual Basic (Declaration) </label> <br><input data-languagename="CS" id="CSLanguageCheckbox" type="checkbox" class="ToggleLanguageCheckbox" checked="true" data-toggleclass="FilteredContentCS"> <label class="LanguageFilter" for="CSCheckbox"> C# </label> </div> </div> <div class="BreadcrumbsContainer"><table><tr><td> <a href="C1.UWP.Excel.html">C1.UWP.Excel Assembly</a> > <a href="C1.UWP.Excel~C1.Xaml.Excel_namespace.html">C1.Xaml.Excel Namespace</a> > <a href="C1.UWP.Excel~C1.Xaml.Excel.XLRowCollection.html">XLRowCollection Class</a> > <a href="C1.UWP.Excel~C1.Xaml.Excel.XLRowCollection~Insert.html">Insert Method</a> : Insert(Int32,XLRow) Method</td></tr></table></div> <div id="indexPopupContent" class="PopupContent"> Position where the item will be inserted. </div> <div id="rowPopupContent" class="PopupContent"> Item that will be inserted. </div> <div id="BodyContent"> <div class="DescriptionContent">Inserts an <a href="C1.UWP.Excel~C1.Xaml.Excel.XLRow.html">XLRow</a> object at a specific position in the collection.</div> <div class="SectionHeading" id="syntaxSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">Syntax</span></div><div id="syntaxSectionContent" class="SectionContent"> <div class="TabContainer" id="TabContainer"> <ul> <li class="FilteredContentVBAll"><a href="#Syntax-VBAll">Visual Basic</a></li> <li class="FilteredContentCS"><a href="#Syntax-CS">C#</a></li> </ul> <div id="Syntax-VB" class="FilteredContentVB"> <pre>'Declaration Public Overloads Function Insert( _ ByVal <i><a class="PopupLink" id="indexPopupLink" data-popupcontentsource="#indexPopupContent" data-popupshowevent="click mouseenter">index</a></i> As System.Integer, _ ByVal <i><a class="PopupLink" id="rowPopupLink" data-popupcontentsource="#rowPopupContent" data-popupshowevent="click mouseenter">row</a></i> As <a href="C1.UWP.Excel~C1.Xaml.Excel.XLRow.html">XLRow</a> _ ) As <a href="C1.UWP.Excel~C1.Xaml.Excel.XLRow.html">XLRow</a></pre> </div> <div id="Syntax-CS" class="FilteredContentCS"> <pre>public <a href="C1.UWP.Excel~C1.Xaml.Excel.XLRow.html">XLRow</a> Insert( System.int <i><a class="PopupLink" id="indexPopupLink" data-popupcontentsource="#indexPopupContent" data-popupshowevent="click mouseenter">index</a></i>, <a href="C1.UWP.Excel~C1.Xaml.Excel.XLRow.html">XLRow</a> <i><a class="PopupLink" id="rowPopupLink" data-popupcontentsource="#rowPopupContent" data-popupshowevent="click mouseenter">row</a></i> )</pre> </div> </div> <h4 class="dxh4">Parameters</h4><dl><dt><i>index</i></dt> <dd>Position where the item will be inserted.</dd><dt><i>row</i></dt> <dd>Item that will be inserted.</dd></dl> <h4 class="dxh4">Return Value</h4><div class="ReturnsContent">A reference to the item that was added to the collection.</div></div> <div class="SectionHeading" id="remarksSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">Remarks</span></div><div id="remarksSectionContent" class="SectionContent"><p>The maximum number of <a href="C1.UWP.Excel~C1.Xaml.Excel.XLRow.html">XLRow</a> objects in a <a href="C1.UWP.Excel~C1.Xaml.Excel.XLSheet.html">XLSheet</a> is 65,536. This is a limitation imposed by Excel 2003 and below.</p> <p>For Excel 2007 and above, the maximum number of <a href="C1.UWP.Excel~C1.Xaml.Excel.XLRow.html">XLRow</a> objects in an <a href="C1.UWP.Excel~C1.Xaml.Excel.XLSheet.html">XLSheet</a> is 1,048,576.</p></div> <a name="exampleBookmark"></a> <a name="seealsobookmark"></a> <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.UWP.Excel~C1.Xaml.Excel.XLRowCollection.html">XLRowCollection Class</a> <br><a href="C1.UWP.Excel~C1.Xaml.Excel.XLRowCollection_members.html">XLRowCollection Members</a> <br><a href="C1.UWP.Excel~C1.Xaml.Excel.XLRowCollection~Insert.html">Overload List</a> </p> </div> </div> <div id="FooterContent"> <p> </p><p> </p><hr style="height: 1px"><p>Copyright © <script type="text/javascript"> var theDate=new Date() document.write(theDate.getFullYear()) </script> GrapeCity, inc. All rights reserved.</p> <a href="http://our.componentone.com/groups/" target="_blank">Product Support Forum</a> | <a href="http://feedback.componentone.com/forums/255783-xaml-documentation" target="_blank">Documentation Feedback</a> </div> </body> </html>