# GrapeCity.Spreadsheet.IO.OpenXml.ImportOptions

## Content

<div class="doc-site-dotnet-api-container">




  <h1 id="GrapeCity_Spreadsheet_IO_OpenXml_ImportOptions" data-uid="GrapeCity.Spreadsheet.IO.OpenXml.ImportOptions" class="text-break">ImportOptions Enum
</h1>
  <div class="markdown level0 summary"><p>Represents options for importing process.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <h6><strong>Namespace</strong>: <a class="xref" href="GrapeCity.Spreadsheet.IO.OpenXml.html">GrapeCity.Spreadsheet.IO.OpenXml</a></h6>
  <h6><strong>Assembly</strong>: GrapeCity.Spreadsheet.dll</h6>
  <h5 id="GrapeCity_Spreadsheet_IO_OpenXml_ImportOptions_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">[Flags]
public enum ImportOptions</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">&lt;Flags&gt;
Public Enum ImportOptions</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="GrapeCity_Spreadsheet_IO_OpenXml_ImportOptions_CalculationChain">CalculationChain</td>
        <td><p>Indicates that calculation chain will be imported to optimize for calculations.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IO_OpenXml_ImportOptions_ColumnHeader">ColumnHeader</td>
        <td><p>Indicates that the column header will be imported as top rows of the worksheet.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IO_OpenXml_ImportOptions_DataOnly">DataOnly</td>
        <td><p>Indicates that only cell values (included formulas if <a class="xref" href="GrapeCity.Spreadsheet.IO.OpenXml.ImportOptions.html#GrapeCity_Spreadsheet_IO_OpenXml_ImportOptions_NoFormulas">NoFormulas</a> is off) are imported.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IO_OpenXml_ImportOptions_Default">Default</td>
        <td><p>Indicates that default options will be used. It balances the performance of importing process and next actions.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IO_OpenXml_ImportOptions_Exchangeable">Exchangeable</td>
        <td><p>Spread data will be imported from extensions of OpenXML file format.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IO_OpenXml_ImportOptions_NoFormulas">NoFormulas</td>
        <td><p>Indicates that cell formulas aren't imported.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IO_OpenXml_ImportOptions_RowHeader">RowHeader</td>
        <td><p>Indicates that the row header will be imported as left columns of the worksheet.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IO_OpenXml_ImportOptions_StopRecalculate">StopRecalculate</td>
        <td><p>Indicates that recalculation after loading Excel file will be avoided.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IO_OpenXml_ImportOptions_TruncateEmptyRowsAndColumns">TruncateEmptyRowsAndColumns</td>
        <td><p>Truncates empty rows and columns to improve performance.</p>
</td>
      </tr>
    </tbody>
  </table>
</div>
