# ExcelCsvImportOptions

Controls how CSV rows are projected into an Excel worksheet. CSV parsing and schema behavior remain owned by CsvReaderOptions.

Class 

`OfficeIMO.Excel.Csv`

**Namespace**

`OfficeIMO.Excel.Csv`

**Assembly**

`OfficeIMO.Excel.Csv`

**Source revision**

`ba882f6b0d07` with working tree changes

**Source**

[ExcelCsvImportOptions.cs:12](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.Csv/ExcelCsvImportOptions.cs#L12)

**Modifiers**

sealed

Controls how CSV rows are projected into an Excel worksheet. CSV parsing and schema behavior remain owned by CsvReaderOptions.

## Inheritance

- object
- ExcelCsvImportOptions

## Usage

Explore 7 API references to this type

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

### Returned or exposed by 1

- Property [CsvExcelExportOptions.ImportOptions](/api/excel-csv/officeimo-excel-csv-csvexcelexportoptions/#property-importoptions)

### Accepted by parameters 6

- Method [ExcelDocumentCsvExtensions.ImportCsv](/api/excel-csv/officeimo-excel-csv-exceldocumentcsvextensions/#method-importcsv-officeimo-excel-exceldocument-officeimo-csv-csvdocument-officeimo-excel-csv-excelcsvimportoptions-threading-cancellationtoken) parameter `options`
- Method [ExcelDocumentCsvExtensions.ImportCsvFile](/api/excel-csv/officeimo-excel-csv-exceldocumentcsvextensions/#method-importcsvfile-officeimo-excel-exceldocument-string-officeimo-excel-csv-excelcsvimportoptions-threading-cancellationtoken) parameter `options`
- Method [ExcelDocumentCsvExtensions.ImportCsvText](/api/excel-csv/officeimo-excel-csv-exceldocumentcsvextensions/#method-importcsvtext-officeimo-excel-exceldocument-string-officeimo-excel-csv-excelcsvimportoptions-threading-cancellationtoken) parameter `options`
- Method [ExcelSheetCsvExtensions.ImportCsv](/api/excel-csv/officeimo-excel-csv-excelsheetcsvextensions/#method-importcsv-officeimo-excel-excelsheet-officeimo-csv-csvdocument-officeimo-excel-csv-excelcsvimportoptions-threading-cancellationtoken) parameter `options`
- Method [ExcelSheetCsvExtensions.ImportCsvFile](/api/excel-csv/officeimo-excel-csv-excelsheetcsvextensions/#method-importcsvfile-officeimo-excel-excelsheet-string-officeimo-excel-csv-excelcsvimportoptions-threading-cancellationtoken) parameter `options`
- Method [ExcelSheetCsvExtensions.ImportCsvText](/api/excel-csv/officeimo-excel-csv-excelsheetcsvextensions/#method-importcsvtext-officeimo-excel-excelsheet-string-officeimo-excel-csv-excelcsvimportoptions-threading-cancellationtoken) parameter `options`

Filter members 

Show inherited

## Constructors

`public ExcelCsvImportOptions()` [#](#constructor-ctor)

[ExcelCsvImportOptions.cs:12](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.Csv/ExcelCsvImportOptions.cs#L12)

## Inherited Methods

`public virtual bool Equals(object? obj)` [#](#method-equals-object)

Inherited from object

Parameters

**obj object? required**

Returns

`bool`

`public virtual int GetHashCode()` [#](#method-gethashcode)

Inherited from object

Returns

`int`

`public Type GetType()` [#](#method-gettype)

Inherited from object

Returns

`Type`

`public virtual string? ToString()` [#](#method-tostring)

Inherited from object

Returns

`string?`

## Properties

`public CsvReaderOptions ReaderOptions { get; set; }` [#](#property-readeroptions)

[ExcelCsvImportOptions.cs:12](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.Csv/ExcelCsvImportOptions.cs#L12)

Gets or sets the CSV parsing and data-reader projection options.

`public string SheetName { get; set; }` [#](#property-sheetname)

[ExcelCsvImportOptions.cs:15](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.Csv/ExcelCsvImportOptions.cs#L15)

Gets or sets the target worksheet name when importing into a workbook.

`public int StartRow { get; set; }` [#](#property-startrow)

[ExcelCsvImportOptions.cs:18](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.Csv/ExcelCsvImportOptions.cs#L18)

Gets or sets the 1-based target row.

`public int StartColumn { get; set; }` [#](#property-startcolumn)

[ExcelCsvImportOptions.cs:21](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.Csv/ExcelCsvImportOptions.cs#L21)

Gets or sets the 1-based target column.

`public bool IncludeHeaders { get; set; }` [#](#property-includeheaders)

[ExcelCsvImportOptions.cs:24](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.Csv/ExcelCsvImportOptions.cs#L24)

Gets or sets whether field names are written above the data rows.

`public bool CreateTable { get; set; }` [#](#property-createtable)

[ExcelCsvImportOptions.cs:27](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.Csv/ExcelCsvImportOptions.cs#L27)

Gets or sets whether an Excel table is created over the imported range.

`public string? TableName { get; set; }` [#](#property-tablename)

[ExcelCsvImportOptions.cs:33](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.Csv/ExcelCsvImportOptions.cs#L33)

Gets or sets the requested Excel table name. When omitted or whitespace, the effective worksheet name is used.

`public ExcelTableStyle TableStyle { get; set; }` [#](#property-tablestyle)

[ExcelCsvImportOptions.cs:36](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.Csv/ExcelCsvImportOptions.cs#L36)

Gets or sets the Excel table style.

`public bool IncludeAutoFilter { get; set; }` [#](#property-includeautofilter)

[ExcelCsvImportOptions.cs:39](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.Csv/ExcelCsvImportOptions.cs#L39)

Gets or sets whether table filter controls are included.

`public bool AutoFit { get; set; }` [#](#property-autofit)

[ExcelCsvImportOptions.cs:42](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.Csv/ExcelCsvImportOptions.cs#L42)

Gets or sets whether imported columns are auto-fitted.

<!-- PowerForge markdown artifact sha256:6E3471E0F90E9C28E28289C0DF8147591B2B5E19D1DFE66B4A24E0AA767B91BF -->
