# C1.WPF.Grid.LoadExcelOptions

## Content

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



  <h1 id="C1_WPF_Grid_LoadExcelOptions" data-uid="C1.WPF.Grid.LoadExcelOptions" class="text-break">LoadExcelOptions Class
</h1>
  <div class="markdown level0 summary"><p>Represents options for loading data from an Excel file.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <div class="inheritance">
    <h5>Inheritance</h5>
    <div class="level0"><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a></div>
    <div class="level1"><span class="xref">LoadExcelOptions</span></div>
  </div>
  <h6><strong>Namespace</strong>: <a class="xref" href="C1.WPF.Grid.html">C1.WPF.Grid</a></h6>
  <h6><strong>Assembly</strong>: C1.WPF.Grid.Excel.dll</h6>
  <h5 id="C1_WPF_Grid_LoadExcelOptions_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public class LoadExcelOptions</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Class LoadExcelOptions</code></pre>
  </div>
  <h5 id="C1_WPF_Grid_LoadExcelOptions_remarks"><strong>Remarks</strong></h5>
  <div class="markdown level0 remarks"><p>These options allow for customization of the import process, such as including only visible rows and columns.</p>
</div>
  <h3 id="constructors">Constructors
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="C1_WPF_Grid_LoadExcelOptions__ctor" data-uid="C1.WPF.Grid.LoadExcelOptions.#ctor">
          <a class="xref" href="C1.WPF.Grid.LoadExcelOptions.-ctor.html#C1_WPF_Grid_LoadExcelOptions__ctor">LoadExcelOptions()</a>
        </td>
        <td class="markdown level1 summary"></td>
      </tr>
    </tbody>
  </table>
  <h3 id="properties">Properties
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="C1_WPF_Grid_LoadExcelOptions_ColumnMaxWidth" data-uid="C1.WPF.Grid.LoadExcelOptions.ColumnMaxWidth">
          <a class="xref" href="C1.WPF.Grid.LoadExcelOptions.ColumnMaxWidth.html#C1_WPF_Grid_LoadExcelOptions_ColumnMaxWidth">ColumnMaxWidth</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the maximum allowable width for the columns.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Grid_LoadExcelOptions_ColumnMinWidth" data-uid="C1.WPF.Grid.LoadExcelOptions.ColumnMinWidth">
          <a class="xref" href="C1.WPF.Grid.LoadExcelOptions.ColumnMinWidth.html#C1_WPF_Grid_LoadExcelOptions_ColumnMinWidth">ColumnMinWidth</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the minimum allowable width for the columns.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Grid_LoadExcelOptions_FreezeRowsAndColumns" data-uid="C1.WPF.Grid.LoadExcelOptions.FreezeRowsAndColumns">
          <a class="xref" href="C1.WPF.Grid.LoadExcelOptions.FreezeRowsAndColumns.html#C1_WPF_Grid_LoadExcelOptions_FreezeRowsAndColumns">FreezeRowsAndColumns</a>
        </td>
        <td class="markdown level1 summary"><p>Specifies whether to freeze rows and columns in the grid after importing.
The default value is <code>true</code>.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Grid_LoadExcelOptions_OnLoadedCallback" data-uid="C1.WPF.Grid.LoadExcelOptions.OnLoadedCallback">
          <a class="xref" href="C1.WPF.Grid.LoadExcelOptions.OnLoadedCallback.html#C1_WPF_Grid_LoadExcelOptions_OnLoadedCallback">OnLoadedCallback</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets a callback that is invoked after the Excel data has been parsed.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Grid_LoadExcelOptions_OverriddenColumnDefaultWidth" data-uid="C1.WPF.Grid.LoadExcelOptions.OverriddenColumnDefaultWidth">
          <a class="xref" href="C1.WPF.Grid.LoadExcelOptions.OverriddenColumnDefaultWidth.html#C1_WPF_Grid_LoadExcelOptions_OverriddenColumnDefaultWidth">OverriddenColumnDefaultWidth</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the width that overrides the default Excel column width.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Grid_LoadExcelOptions_OverriddenRowDefaultHeight" data-uid="C1.WPF.Grid.LoadExcelOptions.OverriddenRowDefaultHeight">
          <a class="xref" href="C1.WPF.Grid.LoadExcelOptions.OverriddenRowDefaultHeight.html#C1_WPF_Grid_LoadExcelOptions_OverriddenRowDefaultHeight">OverriddenRowDefaultHeight</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the height that overrides the default Excel row height.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Grid_LoadExcelOptions_RowMaxHeight" data-uid="C1.WPF.Grid.LoadExcelOptions.RowMaxHeight">
          <a class="xref" href="C1.WPF.Grid.LoadExcelOptions.RowMaxHeight.html#C1_WPF_Grid_LoadExcelOptions_RowMaxHeight">RowMaxHeight</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the maximum allowable height for the rows.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Grid_LoadExcelOptions_RowMinHeight" data-uid="C1.WPF.Grid.LoadExcelOptions.RowMinHeight">
          <a class="xref" href="C1.WPF.Grid.LoadExcelOptions.RowMinHeight.html#C1_WPF_Grid_LoadExcelOptions_RowMinHeight">RowMinHeight</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the minimum allowable height for the rows.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Grid_LoadExcelOptions_SheetCellRange" data-uid="C1.WPF.Grid.LoadExcelOptions.SheetCellRange">
          <a class="xref" href="C1.WPF.Grid.LoadExcelOptions.SheetCellRange.html#C1_WPF_Grid_LoadExcelOptions_SheetCellRange">SheetCellRange</a>
        </td>
        <td class="markdown level1 summary"><p>Represents the range of cells to be processed and loaded into the grid.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Grid_LoadExcelOptions_SheetColumnHeaderRowIndex" data-uid="C1.WPF.Grid.LoadExcelOptions.SheetColumnHeaderRowIndex">
          <a class="xref" href="C1.WPF.Grid.LoadExcelOptions.SheetColumnHeaderRowIndex.html#C1_WPF_Grid_LoadExcelOptions_SheetColumnHeaderRowIndex">SheetColumnHeaderRowIndex</a>
        </td>
        <td class="markdown level1 summary"><p>Specifies the Excel sheet's row index for the column headers.
The default value is <code>0</code>, which means the loaded Excel sheet's first row represents the column headers.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Grid_LoadExcelOptions_SheetRowHeaderColumnIndex" data-uid="C1.WPF.Grid.LoadExcelOptions.SheetRowHeaderColumnIndex">
          <a class="xref" href="C1.WPF.Grid.LoadExcelOptions.SheetRowHeaderColumnIndex.html#C1_WPF_Grid_LoadExcelOptions_SheetRowHeaderColumnIndex">SheetRowHeaderColumnIndex</a>
        </td>
        <td class="markdown level1 summary"><p>Specifies the Excel sheet's column index for the row headers.
The default value is <code>-1</code>, which means the loaded Excel sheet does not have row headers.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Grid_LoadExcelOptions_Transpose" data-uid="C1.WPF.Grid.LoadExcelOptions.Transpose">
          <a class="xref" href="C1.WPF.Grid.LoadExcelOptions.Transpose.html#C1_WPF_Grid_LoadExcelOptions_Transpose">Transpose</a>
        </td>
        <td class="markdown level1 summary"><p>Specifies whether the content should be transposed during the import operation.
The default value is <code>false</code>.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Grid_LoadExcelOptions_UseDefaultRowColumnSizes" data-uid="C1.WPF.Grid.LoadExcelOptions.UseDefaultRowColumnSizes">
          <a class="xref" href="C1.WPF.Grid.LoadExcelOptions.UseDefaultRowColumnSizes.html#C1_WPF_Grid_LoadExcelOptions_UseDefaultRowColumnSizes">UseDefaultRowColumnSizes</a>
        </td>
        <td class="markdown level1 summary"><p>Set to <code>true</code> to use the default row height and column width from the Excel sheet
when row or column sizes are not specified.
The default value is <code>false</code>, and the grid will automatically size rows/columns with undefined dimensions.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Grid_LoadExcelOptions_VisibleOnly" data-uid="C1.WPF.Grid.LoadExcelOptions.VisibleOnly">
          <a class="xref" href="C1.WPF.Grid.LoadExcelOptions.VisibleOnly.html#C1_WPF_Grid_LoadExcelOptions_VisibleOnly">VisibleOnly</a>
        </td>
        <td class="markdown level1 summary"><p>Specifies whether only visible rows and columns should be loaded.<br>
The default value is <code>false</code>.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>