Skip to main content

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Documentation Search all OfficeIMO/

API Reference

Class

ExcelCsvImportOptions

Namespace OfficeIMO.Excel.Csv
Assembly OfficeIMO.Excel.Csv
Modifiers sealed

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

Inheritance

  • Object
  • ExcelCsvImportOptions

Usage

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

Accepted by parameters

Constructors

Properties

public CsvLoadOptions LoadOptions { get; set; } #

Gets or sets the CSV parsing options.

public CsvDataReaderOptions ReaderOptions { get; set; } #

Gets or sets the CSV data-reader projection options.

public String SheetName { get; set; } #

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

public Int32 StartRow { get; set; } #

Gets or sets the 1-based target row.

public Int32 StartColumn { get; set; } #

Gets or sets the 1-based target column.

public Boolean IncludeHeaders { get; set; } #

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

public Boolean 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 Boolean IncludeAutoFilter { get; set; } #

Gets or sets whether table filter controls are included.

public Boolean AutoFit { get; set; } #

Gets or sets whether imported columns are auto-fitted.