# C1.WPF.Excel.C1XLBook.Load

## Content

<div class="doc-site-dotnet-api-container">



<h1 id="C1_WPF_Excel_C1XLBook_Load_" data-uid="C1.WPF.Excel.C1XLBook.Load*">Load Method
</h1>
<div class="markdown level0 summary"></div>
<div class="markdown level0 conceptual"></div>



<a id="C1_WPF_Excel_C1XLBook_Load_" data-uid="C1.WPF.Excel.C1XLBook.Load*"></a>
<h4 id="C1_WPF_Excel_C1XLBook_Load_System_String_" data-uid="C1.WPF.Excel.C1XLBook.Load(System.String)">Load(string)</h4>
<div class="markdown level1 summary"><p>Loads an Excel worksheet from a file.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public void Load(string fileName)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Sub Load(fileName As String)</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a></td>
      <td><span class="parametername">fileName</span></td>
      <td><p>Name of the file that contains the worksheet.</p>
</td>
    </tr>
  </tbody>
</table>
<h5 id="C1_WPF_Excel_C1XLBook_Load_System_String__remarks">Remarks</h5>
<div class="markdown level1 remarks"><pre><code>&lt;p&gt;Component One Excel infers the file format automatically based on the 
</code></pre>
<p>file name extension. &quot;XLSX&quot; and &quot;ZIP&quot; files are loaded as OpenXml; all
others are loaded as Biff8 files (&quot;xls&quot;).</p>
<p>If the file doesn't exist, is locked, or is not a valid Excel
file, an exception is thrown.</p>
</div>


<a id="C1_WPF_Excel_C1XLBook_Load_" data-uid="C1.WPF.Excel.C1XLBook.Load*"></a>
<h4 id="C1_WPF_Excel_C1XLBook_Load_System_String_System_Boolean_" data-uid="C1.WPF.Excel.C1XLBook.Load(System.String,System.Boolean)">Load(string, bool)</h4>
<div class="markdown level1 summary"><p>Loads an Excel worksheet from a file.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public void Load(string fileName, bool fillSheets)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Sub Load(fileName As String, fillSheets As Boolean)</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a></td>
      <td><span class="parametername">fileName</span></td>
      <td><p>Name of the file that contains the worksheet.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">fillSheets</span></td>
      <td><p>True to load data into the sheets; False to read the sheet names only.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="C1_WPF_Excel_C1XLBook_Load_" data-uid="C1.WPF.Excel.C1XLBook.Load*"></a>
<h4 id="C1_WPF_Excel_C1XLBook_Load_System_String_C1_WPF_Excel_FileFormat_" data-uid="C1.WPF.Excel.C1XLBook.Load(System.String,C1.WPF.Excel.FileFormat)">Load(string, FileFormat)</h4>
<div class="markdown level1 summary"><p>Loads an Excel worksheet from a file.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public void Load(string fileName, FileFormat format)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Sub Load(fileName As String, format As FileFormat)</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a></td>
      <td><span class="parametername">fileName</span></td>
      <td><p>Name of the file that contains the worksheet.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="C1.WPF.Excel.FileFormat.html">FileFormat</a></td>
      <td><span class="parametername">format</span></td>
      <td><p><span class="xref">C1.WPF.Excel.C1XLBook.FileFormat</span> value that specifies the file format.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="C1_WPF_Excel_C1XLBook_Load_" data-uid="C1.WPF.Excel.C1XLBook.Load*"></a>
<h4 id="C1_WPF_Excel_C1XLBook_Load_System_String_C1_WPF_Excel_FileFormat_System_Boolean_" data-uid="C1.WPF.Excel.C1XLBook.Load(System.String,C1.WPF.Excel.FileFormat,System.Boolean)">Load(string, FileFormat, bool)</h4>
<div class="markdown level1 summary"><p>Loads an Excel worksheet from a file.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public void Load(string fileName, FileFormat format, bool fillSheets)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Sub Load(fileName As String, format As FileFormat, fillSheets As Boolean)</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a></td>
      <td><span class="parametername">fileName</span></td>
      <td><p>Name of the file that contains the worksheet.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="C1.WPF.Excel.FileFormat.html">FileFormat</a></td>
      <td><span class="parametername">format</span></td>
      <td><p><span class="xref">C1.WPF.Excel.C1XLBook.FileFormat</span> value that specifies the file format.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">fillSheets</span></td>
      <td><p>True to load data into the sheets; False to read the sheet names only.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="C1_WPF_Excel_C1XLBook_Load_" data-uid="C1.WPF.Excel.C1XLBook.Load*"></a>
<h4 id="C1_WPF_Excel_C1XLBook_Load_System_IO_Stream_" data-uid="C1.WPF.Excel.C1XLBook.Load(System.IO.Stream)">Load(Stream)</h4>
<div class="markdown level1 summary"><p>Loads the worksheet from a stream.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public void Load(Stream stream)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Sub Load(stream As Stream)</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.io.stream">Stream</a></td>
      <td><span class="parametername">stream</span></td>
      <td><p><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.io.stream">Stream</a> that contains the worksheet.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="C1_WPF_Excel_C1XLBook_Load_" data-uid="C1.WPF.Excel.C1XLBook.Load*"></a>
<h4 id="C1_WPF_Excel_C1XLBook_Load_System_IO_Stream_System_Boolean_" data-uid="C1.WPF.Excel.C1XLBook.Load(System.IO.Stream,System.Boolean)">Load(Stream, bool)</h4>
<div class="markdown level1 summary"><p>Loads the worksheet from a stream.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public void Load(Stream stream, bool fillSheets)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Sub Load(stream As Stream, fillSheets As Boolean)</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.io.stream">Stream</a></td>
      <td><span class="parametername">stream</span></td>
      <td><p><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.io.stream">Stream</a> that contains the worksheet.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">fillSheets</span></td>
      <td><p>True to load data into the sheets; False to read the sheet names only.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="C1_WPF_Excel_C1XLBook_Load_" data-uid="C1.WPF.Excel.C1XLBook.Load*"></a>
<h4 id="C1_WPF_Excel_C1XLBook_Load_System_IO_Stream_C1_WPF_Excel_FileFormat_" data-uid="C1.WPF.Excel.C1XLBook.Load(System.IO.Stream,C1.WPF.Excel.FileFormat)">Load(Stream, FileFormat)</h4>
<div class="markdown level1 summary"><p>Loads the worksheet from a stream.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public void Load(Stream stream, FileFormat format)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Sub Load(stream As Stream, format As FileFormat)</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.io.stream">Stream</a></td>
      <td><span class="parametername">stream</span></td>
      <td><p><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.io.stream">Stream</a> that contains the worksheet.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="C1.WPF.Excel.FileFormat.html">FileFormat</a></td>
      <td><span class="parametername">format</span></td>
      <td><p><span class="xref">C1.WPF.Excel.C1XLBook.FileFormat</span> value that specifies the file format.</p>
</td>
    </tr>
  </tbody>
</table>
<h5 id="C1_WPF_Excel_C1XLBook_Load_System_IO_Stream_C1_WPF_Excel_FileFormat__remarks">Remarks</h5>
<div class="markdown level1 remarks"><p>Loading the worksheets without their data is much faster than loading the entire workbook.
This is useful in situations where you want to examine the contents of the file (for example,
to ensure that you will not overwrite an existing sheet).</p>
</div>


<a id="C1_WPF_Excel_C1XLBook_Load_" data-uid="C1.WPF.Excel.C1XLBook.Load*"></a>
<h4 id="C1_WPF_Excel_C1XLBook_Load_System_IO_Stream_C1_WPF_Excel_FileFormat_System_Boolean_" data-uid="C1.WPF.Excel.C1XLBook.Load(System.IO.Stream,C1.WPF.Excel.FileFormat,System.Boolean)">Load(Stream, FileFormat, bool)</h4>
<div class="markdown level1 summary"><p>Loads the worksheet from a stream.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public void Load(Stream stream, FileFormat format, bool fillSheets)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Sub Load(stream As Stream, format As FileFormat, fillSheets As Boolean)</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.io.stream">Stream</a></td>
      <td><span class="parametername">stream</span></td>
      <td><p><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.io.stream">Stream</a> that contains the worksheet.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="C1.WPF.Excel.FileFormat.html">FileFormat</a></td>
      <td><span class="parametername">format</span></td>
      <td><p><span class="xref">C1.WPF.Excel.C1XLBook.FileFormat</span> value that specifies the file format.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">fillSheets</span></td>
      <td><p><b>True</b> to load data into the sheets; <b>False</b> to read the sheet names only.</p>
</td>
    </tr>
  </tbody>
</table>
</div>