# FarPoint.Excel.ExcelOpenFlags

## Content

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




  <h1 id="FarPoint_Excel_ExcelOpenFlags" data-uid="FarPoint.Excel.ExcelOpenFlags" class="text-break">ExcelOpenFlags Enum
</h1>
  <div class="markdown level0 summary"><p>Specifies what part of the Excel-compatible file you want to load into the spreadsheet.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <h6><strong>Namespace</strong>: <a class="xref" href="FarPoint.Excel.html">FarPoint.Excel</a></h6>
  <h6><strong>Assembly</strong>: FarPoint.Excel.dll</h6>
  <h5 id="FarPoint_Excel_ExcelOpenFlags_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">[Flags]
public enum ExcelOpenFlags</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">&lt;Flags&gt;
Public Enum ExcelOpenFlags</code></pre>
  </div>
  <h3 id="fields">Fields
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    <thead>
    </thead></thead><tbody>
      <tr>
        <td id="FarPoint_Excel_ExcelOpenFlags_ColumnHeaders">ColumnHeaders</td>
        <td><p>[8] Loads column headers from frozen rows in the Excel-compatible file into the spreadsheet.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelOpenFlags_DataAndFormulasOnly">DataAndFormulasOnly</td>
        <td><p>[3] Loads formulas from the Excel-compatible file into the spreadsheet.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelOpenFlags_DataOnly">DataOnly</td>
        <td><p>[1] Loads only the data from the Excel-compatible file into the spreadsheet.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelOpenFlags_DataValidationAsCombo">DataValidationAsCombo</td>
        <td><p>[32768] Indicates the DataValidation will be imported as ComboBoxCellType.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelOpenFlags_DoNotRecalculateAfterLoad">DoNotRecalculateAfterLoad</td>
        <td><p>[1024] Avoids recalculation after loading the Excel file (by not setting the
SheetView.AutoCalculation property to true and not calling SheetView.Recalculate().</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelOpenFlags_DocumentCaching">DocumentCaching</td>
        <td><p>[512] Loads content from Excel files that is kept while writing back. (e.g. VBA, Macro)</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelOpenFlags_Exchangeable">Exchangeable</td>
        <td><p>Indicates that the extension data will be imported.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelOpenFlags_NoFlagsSet">NoFlagsSet</td>
        <td><p>[0] Opens the spreadsheet from the Excel-compatible file with no special options.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelOpenFlags_PreferDateTime">PreferDateTime</td>
        <td><p>[65536] Convert cell value to .NET DateTime object if the it's the number and cell format is date time.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelOpenFlags_RowAndColumnHeaders">RowAndColumnHeaders</td>
        <td><p>[12] Loads row headers from frozen columns and column headers from frozen rows.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelOpenFlags_RowHeaders">RowHeaders</td>
        <td><p>[4] Loads row headers from frozen columns in the Excel-compatible file into the spreadsheet.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelOpenFlags_TruncateEmptyRowsAndColumns">TruncateEmptyRowsAndColumns</td>
        <td><p>[8192] Truncates empty rows and columns to improve performance.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelOpenFlags_UseOldConditionalFormat">UseOldConditionalFormat</td>
        <td><p>[16384] Uses the old conditional format.</p>
</td>
      </tr>
    </tbody>
  </table>
</div>