Skip to main content

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Documentation Search all OfficeIMO/
Class

ExcelCsvImportOptions

OfficeIMO.Excel.Csv

Namespace
OfficeIMO.Excel.Csv
Assembly
OfficeIMO.Excel.Csv
Source revision
ba882f6b0d07 with working tree changes
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

Accepted by parameters 6

Constructors

public ExcelCsvImportOptions() #

Properties

public CsvReaderOptions ReaderOptions { get; set; } #

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

public string SheetName { get; set; } #

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

public int StartRow { get; set; } #

Gets or sets the 1-based target row.

public int StartColumn { get; set; } #

Gets or sets the 1-based target column.

public bool IncludeHeaders { get; set; } #

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

public bool CreateTable { get; set; } #

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

public string? TableName { get; set; } #

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

public ExcelTableStyle TableStyle { get; set; } #

Gets or sets the Excel table style.

public bool IncludeAutoFilter { get; set; } #

Gets or sets whether table filter controls are included.

public bool AutoFit { get; set; } #

Gets or sets whether imported columns are auto-fitted.