</ 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%% $$Methods$$" -->XLSheet Class Methods<!--DXMETADATA end--></div></div> </div> <div id="AfterHeaderContent"> <!-- 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> : XLSheet Class</td></tr></table></div><!--DXMETADATA end --> <div id="BodyContent"> <!--DXMETADATA start type="Scrap" name="_MEMBERS_LINK" format="<p>%%scrap%%</p>" --><p>For a list of all members of this type, see <a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet_members.html">XLSheet members</a>.</p><!--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.XLSheet~Clone().html">Clone</a></td><td class="MembersDescriptionCell">Creates a copy of this sheet. </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.XLSheet~CopyFormula.html">CopyFormula</a></td><td class="MembersDescriptionCell">Copies the formula from a source cell to a destination cell, adjusting relative references. </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.XLSheet~GetCell.html">GetCell</a></td><td class="MembersDescriptionCell">Gets a reference to a cell at the specified coordinates or null if the cell doesn't exist. </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.XLSheet~GetFormattedText.html">GetFormattedText</a></td><td class="MembersDescriptionCell">Gets formatted text is using <a href="C1.WPF.Excel.4~C1.WPF.Excel.XLStyle.html">XLStyle</a> format value of the 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.XLSheet~GetRangeToRepeat.html">GetRangeToRepeat</a></td><td class="MembersDescriptionCell">Returns a value indicating whether print titles are specified for this worksheet. (Print titles are rows repeated at top, and columns repeated at left of each page when the sheet is printed.) Output parameters indicate the indices of title rows and columns. </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.XLSheet~Load.html">Load</a></td><td class="MembersDescriptionCell">Overloaded. Loads the Excel worksheet from a file. </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.XLSheet~LoadCsv.html">LoadCsv</a></td><td class="MembersDescriptionCell">Overloaded. Loads data from a file containing comma-separated values (.csv) into the current sheet. </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.XLSheet~SaveCsv.html">SaveCsv</a></td><td class="MembersDescriptionCell">Overloaded. Saves data from the current sheet into a comma-separated values (.csv) formatted file. </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.XLSheet~SetRangeToRepeat.html">SetRangeToRepeat</a></td><td class="MembersDescriptionCell">Specifies the range of rows and columns to use as print titles for this worksheet. (Print titles are rows repeated at top, and columns repeated at left of each page when the sheet is printed.) </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="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=protectedMethods,caption=$$Protected$$ $$Methods$$%%%%filtereditemlist%%<a href="#top">$$Top$$</a></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="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.XLSheet.html">XLSheet 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>