</ 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" -->Excel for WPF and Silverlight<!--DXMETADATA end--></div> <div id="PageTitle"><div id="PageTitleText"><!--DXMETADATA start type="ItemTitle" -->Load(Stream,FileFormat,Boolean) Method<!--DXMETADATA end--></div></div> </div> <div id="AfterHeaderContent"> <!--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> <!--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> > <a href="C1.WPF.Excel.4~C1.WPF.Excel.C1XLBook.html">C1XLBook Class</a> > <a href="C1.WPF.Excel.4~C1.WPF.Excel.C1XLBook~Load.html">Load Method</a> : Load(Stream,FileFormat,Boolean) Method</td></tr></table></div><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="GENERICARGUMENT_BUBBLES" namespace="generic argument" source="Item" --><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="PARAMETERS_BUBBLES" namespace="parameter" source="Item" --> <div id="streamPopupContent" class="PopupContent"> <strong>System.IO.Stream</strong> that contains the worksheet. </div> <div id="formatPopupContent" class="PopupContent"> <strong>FileFormat</strong> value that specifies the file format. </div> <div id="fillSheetsPopupContent" class="PopupContent"> <b>True</b> to load data into the sheets; <b>False</b> to read the sheet names only. </div> <!--DXMETADATA end --> <div id="BodyContent"> <!--DXMETADATA start type="Description" source="Item" format="<div class=""DescriptionContent"">%%description%%</div>" --><div class="DescriptionContent">Loads the worksheet from a stream.</div><!--DXMETADATA end --> <!--DXMETADATA start type="TaggedComment" source="Item" id="##OVERLOADS" format="%%comment%%" --><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="OVERLOAD_LIST" namespace="method" source="Item" filter="" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=overloadlist,caption=$$OverloadList$$%%%%filtereditemlist%%</div>" --><!--DXMETADATA end --> <!--DXMETADATA start type="SyntaxSection" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=syntax,caption=$$Syntax$$%%%%SyntaxSection%%" --><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><pre><span style="color: #008000; ">'Declaration </span> </pre><pre><span style="color: #0000FF; ">Public</span> <span style="color: #0000FF; ">Overloads</span> <span style="color: #0000FF; ">Sub</span> Load( _ <span style="color: #0000FF; ">ByVal</span> <i><a class="PopupLink" id="streamPopupLink" data-popupcontentsource="#streamPopupContent" data-popupshowevent="click mouseenter">stream</a></i> <span style="color: #0000FF; ">As</span> System.IO.Stream, _ <span style="color: #0000FF; ">ByVal</span> <i><a class="PopupLink" id="formatPopupLink" data-popupcontentsource="#formatPopupContent" data-popupshowevent="click mouseenter">format</a></i> <span style="color: #0000FF; ">As</span> <a href="C1.WPF.Excel.4~C1.WPF.Excel.FileFormat.html">FileFormat</a>, _ <span style="color: #0000FF; ">ByVal</span> <i><a class="PopupLink" id="fillSheetsPopupLink" data-popupcontentsource="#fillSheetsPopupContent" data-popupshowevent="click mouseenter">fillSheets</a></i> <span style="color: #0000FF; ">As</span> System.Boolean _ ) </pre></pre> </div> <div id="Syntax-CS" class="FilteredContentCS"> <pre><pre><span style="color: #0000FF; ">public</span> <span style="color: #0000FF; ">void</span> Load( System.IO.Stream <i><a class="PopupLink" id="streamPopupLink" data-popupcontentsource="#streamPopupContent" data-popupshowevent="click mouseenter">stream</a></i>, <a href="C1.WPF.Excel.4~C1.WPF.Excel.FileFormat.html">FileFormat</a> <i><a class="PopupLink" id="formatPopupLink" data-popupcontentsource="#formatPopupContent" data-popupshowevent="click mouseenter">format</a></i>, System.<span style="color: #0000FF; ">bool</span> <i><a class="PopupLink" id="fillSheetsPopupLink" data-popupcontentsource="#fillSheetsPopupContent" data-popupshowevent="click mouseenter">fillSheets</a></i> )</pre></pre> </div> </div> <!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="PARAMETERS_LIST" namespace="parameter" source="Item" filter="" NoCr="True" format="<h4 class=dxh4>$$ParameterList$$</h4>%%filtereditemlist%%" --><h4 class="dxh4">Parameters</h4><dl><dt><i>stream</i></dt> <dd><strong>System.IO.Stream</strong> that contains the worksheet.</dd><dt><i>format</i></dt> <dd><strong>FileFormat</strong> value that specifies the file format.</dd><dt><i>fillSheets</i></dt> <dd><b>True</b> to load data into the sheets; <b>False</b> to read the sheet names only.</dd></dl><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="GENERICARGUMENT_LIST" namespace="generic argument" source="Item" filter="" format="<h4 class=dxh4>$$GenericArguments$$</h4>%%filtereditemlist%%" --><!--DXMETADATA end --> <!--DXMETADATA start type="TaggedComment" source="Item" id="##RETURNS" format="<h4 class=dxh4>$$Return_Type$$</h4><div class=""ReturnsContent"">%%comment%%</div></div>" blankformat="</div>" --></div><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="EXCEPTION_LIST" namespace="exception" source="Item" filter="" designtime="true" format="%%replaceinquotes:value=false%%%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=exceptions,caption=""$$Exceptions$$%%designlist:tagidentifier=##EXCEPTION,itemtype=Exception%%""%%%%filtereditemlist%%</div>" --><!--DXMETADATA end --> <!--DXMETADATA start type="Literal" condition="childitems:itemtype=contract,filter=""type=requires+ensures+ensuresonthrow+pure""" value="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=contracts,caption=$$Contracts$$%%%%filtereditemlist:scrap=CONTRACT_LIST,namespace=contract,source=item,filter=""type=requires+ensures+ensuresonthrow""%%</div>" --><!--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" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=remarks,caption=$$Remarks$$%%%%comment%%</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="TaggedComment" source="Item" id="##REQUIREMENTS" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=requirements,caption=$$Requirements$$%%%%comment%%</div>" blankformat="%%variable:name=defaultmemberrequirements%%" --><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.Excel.4~C1.WPF.Excel.C1XLBook.html">C1XLBook Class</a> <br><a href="C1.WPF.Excel.4~C1.WPF.Excel.C1XLBook_members.html">C1XLBook Members</a> <br><a href="C1.WPF.Excel.4~C1.WPF.Excel.C1XLBook~Load.html">Overload List</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>