</ 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" -->Reports for WPF<!--DXMETADATA end--></div> <div id="PageTitle"><div id="PageTitleText"><!--DXMETADATA start type="PageItemTitle" -->XlsFilter Class<!--DXMETADATA end--></div></div> </div> <div id="AfterHeaderContent"> <!--DXMETADATA start type="Literal" value="<a class=""PageLink"" href=""%%itemqualifiedname%%_members%%OutputFileExtension%%"">$$Members$$</a> " condition="content:content=""%%itemtype%%"",operator=""<>"",value=""Enumeration"""--><a class="PageLink" href="C1.WPF.C1Report.4~C1.C1Report.XlsFilter_members.html">Members</a> <!--DXMETADATA end--> <!--DXMETADATA start type="Literal" condition="childitems:itemtype=example,filter=""type=inline""" value="<a class=""PageLink"" href=""#ExampleBookmark"" onclick=""javascript:dxOpenSectionById('exampleSectionHeader');"">$$Example$$</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 --><!-- Spacing --> <span id="LanguageFilterPopupLink" class="PopupLink" data-popupcontentsource="#LanguageCheckboxes" data-popuptitle='<!--DXMETADATA start type="Phrase" name="Language_Filter" -->Language Filter<!--DXMETADATA end -->'> <label id="ShowAllLabel" for="LanguageFilterPopupLink"> <!--DXMETADATA start type="Phrase" name="Language_Filter_All" -->Language Filter: All<!--DXMETADATA end --> </label> <label id="MultipleLabel" for="LanguageFilterPopupLink" style="display: none;"> <!--DXMETADATA start type="Phrase" name="Language_Filter_Multiple" -->Language Filter: Multiple<!--DXMETADATA end --> </label> <label id="VBAllLabel" for="LanguageFilterPopupLink" style="display: none;"> <!--DXMETADATA start type="Phrase" name="Language_Filter" -->Language Filter<!--DXMETADATA end -->: <!--DXMETADATA start type="Phrase" name="Language_VB" -->Visual Basic<!--DXMETADATA end --> </label> <!--DXMETADATA start type="FilteredItemList" scrap="LANGUAGE_LABEL_LIST" namespace="language" filter="type=all" source="Item" format="" --> <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> <!--DXMETADATA end --> </span> <div class="PopupContent" id="LanguageCheckboxes"> <!--DXMETADATA start type="FilteredItemList" scrap="LANGUAGE_CHECKBOX_LIST" namespace="language" filter="type=all" source="Item" format="" --> <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> <!--DXMETADATA end --> </div> </div> <!--DXMETADATA start type="Breadcrumbs" scrap="_BREADCRUMBS" --><div class="BreadcrumbsContainer"><table><tr><td> <a href="C1.WPF.C1Report.4~C1.C1Report_namespace.html">C1.C1Report Namespace</a> : XlsFilter Class</td></tr></table></div><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="GENERICARGUMENT_BUBBLES" namespace="generic argument" source="Item" --><!--DXMETADATA end --> <div id="BodyContent"> <!--DXMETADATA start type="Description" source="Item" format="<div class=""DescriptionContent"">%%description%%</div>" --><div class="DescriptionContent">Class used with the <a href="C1.WPF.C1Report.4~C1.C1Report.C1Report~RenderToFilter.html">C1Report.RenderToFilter</a>method to render reports into Microsoft Excel (XLS) files.</div><!--DXMETADATA end --> <!--DXMETADATA start type="Diagram" source="item" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=objectmodel,caption=$$Object_Model$$%%%%Diagram%%</div>" --><div class="SectionHeading" id="objectmodelSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">Object Model</span></div><div id="objectmodelSectionContent" class="SectionContent"><map id="dxdiagram" name="dxdiagram"><area shape="rect" coords="2,2,82,25" href="C1.WPF.C1Report.4~C1.C1Report.XlsFilter.html" alt="XlsFilter Class"></map><img border="0" src="dotnetdiagramimages/C1_WPF_C1Report_4_C1_C1Report_XlsFilter.png" usemap="#dxdiagram"></div><!--DXMETADATA end --> <!--DXMETADATA start type="SyntaxSection" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=syntax,caption=$$Syntax$$%%%%SyntaxSection%%</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 Class XlsFilter Inherits <a href="C1.WPF.C1Report.4~C1.C1Report.ExportFilter.html">ExportFilter</a></pre> </div> <div id="Syntax-CS" class="FilteredContentCS"> <pre>public class XlsFilter : <a href="C1.WPF.C1Report.4~C1.C1Report.ExportFilter.html">ExportFilter</a> </pre> </div> </div> </div><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="GENERICARGUMENT_LIST" namespace="generic argument" source="Item" filter="" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=genericarguments,caption=$$GenericArguments$$%%%%filtereditemlist%%</div>" --><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="CONTRACT_INVARIANT_LIST" namespace="contract" source="Item" filter="type=invariant" designtime="true" --><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="PERMISSION_LIST" namespace="permission" source="Item" filter="" designtime="true" format="%%replaceinquotes:value=false%%%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=permissions,caption=""$$Permissions$$%%designlist:tagidentifier=##PERMISSION,itemtype=Permission%%""%%%%filtereditemlist%%</div>" --><!--DXMETADATA end --> <!--DXMETADATA start type="TaggedComment" source="Item" id="##REMARKS,##MODULE_REMARKS" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=remarks,caption=$$Remarks$$%%%%comment%%</div>" --><div class="SectionHeading" id="remarksSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">Remarks</span></div><div id="remarksSectionContent" class="SectionContent">Creating an <b>XlsFilter</b> and using it in a call to the <a href="C1.WPF.C1Report.4~C1.C1Report.C1Report~RenderToFilter.html">C1Report.RenderToFilter</a> method is similar to using the <a href="C1.WPF.C1Report.4~C1.C1Report.C1Report~RenderToFile.html">C1Report.RenderToFile</a> method, but offers some extra flexibility because you can set properties on the <b>XlsFilter</b> before calling <b>RenderToFilter</b>.</div><!--DXMETADATA end --> <a name="exampleBookmark"></a> <!--DXMETADATA start type="TaggedComment" source="Item" id="##EXAMPLEINTRO" format="%%replaceinquotes:value=false%%%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=example,caption=""$$Example$$%%designlist:tagidentifier=##EXAMPLECODE,itemtype=Example%%""%%%%comment%%" --><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="EXAMPLEGROUP_LIST" namespace="ExampleGroup" source="Item" filter="type=inline" condition="content:content=""%%GroupExamples%%"",operator=""="",value=""True""" NoHeader="True" NoFooter="True" format="%%replaceinquotes:value=false%%%%taggedcomment:source=item,id=##EXAMPLEINTRO,blankformat=""%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=example,caption=$$Example$$%%"",format= %%%%filtereditemlist%%</div>" blankformat="%%taggedcomment:source=item,id=##EXAMPLEINTRO,format=</div>%%" --><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="INLINE_EXAMPLE" namespace="Example" source="Item" filter="type=inline" condition="content:content=""%%GroupExamples%%"",operator=""<>"",value=""True""" NoHeader="True" NoFooter="True" format="%%replaceinquotes:value=false%%%%taggedcomment:source=item,id=##EXAMPLEINTRO,blankformat=""%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=example,caption=$$Example$$%%"",format= %%%%filtereditemlist%%</div>" blankformat="%%taggedcomment:source=item,id=##EXAMPLEINTRO,format=</div>%%" --><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="MENU_LINK" namespace="example" source="Item" filter="" NoHeader="True" NoFooter="True" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=example,caption=$$Example$$%%%%filtereditemlist%%</div>" --><!--DXMETADATA end --> <!--DXMETADATA start type="InheritanceHierarchy" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=inheritance,caption=$$Inheritance_hierarchy$$%%%%InheritanceHierarchy%%</div>" --><div class="SectionHeading" id="inheritanceSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">Inheritance Hierarchy</span></div><div id="inheritanceSectionContent" class="SectionContent"><p><a href="#" onclick="javascript:navigateToHelp2Keyword('frlrfSystemObjectClassTopic','System.Object')">System.Object</a><br> <a href="C1.WPF.C1Report.4~C1.C1Report.ExportFilter.html">C1.C1Report.ExportFilter</a><br> <strong>C1.C1Report.XlsFilter</strong><br></p></div><!--DXMETADATA end --> <!--DXMETADATA start type="TaggedComment" source="Item" id="##REQUIREMENTS" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=requirements,caption=$$Requirements$$%%%%comment%%</div>" blankformat="%%variable:name=defaulttyperequirements%%" --><div class="SectionHeading" id="requirementsSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">Requirements</span></div><div id="requirementsSectionContent" class="SectionContent"><p><b>Target Platforms:</b> Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2</p></div><!--DXMETADATA end --> <a name="seealsobookmark"></a> <!--DXMETADATA start type="FilteredItemList" scrap="CATEGORIZED_LINKS" namespace="linkcategory" source="Item" filter="" 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.C1Report.4~C1.C1Report.XlsFilter_members.html">XlsFilter Members</a> <br><a href="C1.WPF.C1Report.4~C1.C1Report_namespace.html">C1.C1Report 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>" --><p> </p><p> </p><hr style="height: 1px"><p>Copyright (c) <script type="text/javascript"> var theDate=new Date() document.write(theDate.getFullYear()) </script> GrapeCity, inc. All rights reserved.</p><!--DXMETADATA end --> <!--DXMETADATA start type="Variable" name="FeedbackLink" format="" --><!--DXMETADATA end--> </div> </body> </html>