OfficeIMO

API Reference

Class

ExcelReadOptions

Namespace OfficeIMO.Excel
Assembly OfficeIMO.Excel
Modifiers sealed

Reading options controlling conversion behavior and execution policy.

Inheritance

  • Object
  • ExcelReadOptions

Constructors

public ExcelReadOptions() #

Initializes reading defaults and per-operation thresholds.

Properties

public ExecutionPolicy Execution { get; } #

Execution policy used to decide Sequential vs Parallel conversion. Reuses the writer-side policy for symmetry.

public Boolean UseCachedFormulaResult { get; set; } #

Use cached formula results when present; otherwise returns the formula string.

public Boolean TreatDatesUsingNumberFormat { get; set; } #

Interpret numeric cells with a date-like number format as DateTime (OADate).

public CultureInfo Culture { get; set; } #

Culture used when parsing numbers and dates stored as strings.

public Boolean FillBlanksInRanges { get; set; } #

When true, matrix/range readers fill unspecified cells with nulls.

public Boolean NormalizeHeaders { get; set; } #

Normalize headers for object mapping by trimming and collapsing whitespace.

public Boolean NumericAsDecimal { get; set; } #

When true, numeric cells are returned as decimal where possible; otherwise double is used.

public Func<ExcelCellContext, ExcelCellValue> CellValueConverter { get; set; } #

Optional cell-level converter hook. If provided and it returns a handled value, the built-in conversion pipeline is skipped and the returned value is used.

public Func<Object, Type, CultureInfo, ValueTuple<Boolean, Object>> TypeConverter { get; set; } #

Optional type conversion hook used by typed readers (ReadColumnAs/ReadRowsAs/ReadRangeAs and object mapping). If it returns ok=true, its value is used; otherwise the built-in converter is used.