ExcelCsvImportOptions
OfficeIMO.Excel.Csv
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
Accepted by parameters 6
Constructors
public ExcelCsvImportOptions() #Inherited Methods
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 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.