# GrapeCity.Documents.Excel.DataImportOptions

## Content

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



  <h1 id="GrapeCity_Documents_Excel_DataImportOptions" data-uid="GrapeCity.Documents.Excel.DataImportOptions" class="text-break">DataImportOptions Class
</h1>
  <div class="markdown level0 summary"><p>The options for importing data to a range.</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">DataImportOptions</span></div>
  </div>
  <h6><strong>Namespace</strong>: <a class="xref" href="GrapeCity.Documents.Excel.html">GrapeCity.Documents.Excel</a></h6>
  <h6><strong>Assembly</strong>: DS.Documents.Excel.dll</h6>
  <h5 id="GrapeCity_Documents_Excel_DataImportOptions_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public class DataImportOptions</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Class DataImportOptions</code></pre>
  </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="GrapeCity_Documents_Excel_DataImportOptions__ctor" data-uid="GrapeCity.Documents.Excel.DataImportOptions.#ctor">
          <a class="xref" href="GrapeCity.Documents.Excel.DataImportOptions.-ctor.html#GrapeCity_Documents_Excel_DataImportOptions__ctor">DataImportOptions()</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="GrapeCity_Documents_Excel_DataImportOptions_ColumnsSelector" data-uid="GrapeCity.Documents.Excel.DataImportOptions.ColumnsSelector">
          <a class="xref" href="GrapeCity.Documents.Excel.DataImportOptions.ColumnsSelector.html#GrapeCity_Documents_Excel_DataImportOptions_ColumnsSelector">ColumnsSelector</a>
        </td>
        <td class="markdown level1 summary"><p>Selects columns to import. The default behavior is to auto-generate all columns.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_DataImportOptions_IncludeColumnsHeader" data-uid="GrapeCity.Documents.Excel.DataImportOptions.IncludeColumnsHeader">
          <a class="xref" href="GrapeCity.Documents.Excel.DataImportOptions.IncludeColumnsHeader.html#GrapeCity_Documents_Excel_DataImportOptions_IncludeColumnsHeader">IncludeColumnsHeader</a>
        </td>
        <td class="markdown level1 summary"><p>Determines whether to include column header as the first row when importing data.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_DataImportOptions_InsufficientSpaceHandling" data-uid="GrapeCity.Documents.Excel.DataImportOptions.InsufficientSpaceHandling">
          <a class="xref" href="GrapeCity.Documents.Excel.DataImportOptions.InsufficientSpaceHandling.html#GrapeCity_Documents_Excel_DataImportOptions_InsufficientSpaceHandling">InsufficientSpaceHandling</a>
        </td>
        <td class="markdown level1 summary"><p>Determines how to handle insufficient space when importing data.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_DataImportOptions_ItemTypeProvider" data-uid="GrapeCity.Documents.Excel.DataImportOptions.ItemTypeProvider">
          <a class="xref" href="GrapeCity.Documents.Excel.DataImportOptions.ItemTypeProvider.html#GrapeCity_Documents_Excel_DataImportOptions_ItemTypeProvider">ItemTypeProvider</a>
        </td>
        <td class="markdown level1 summary"><p>Gets item type from the specified <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.collections.ienumerable">IEnumerable</a>.
The type is used to generate columns.
The default behavior is to try to get the item type from
the generic parameter of <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.collections.generic.ienumerable-1">IEnumerable&lt;T&gt;</a>,
then try to get type from the first item of the <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.collections.ienumerable">IEnumerable</a>.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>