Class SchemaInferenceOptions

Namespace

ExcelReader.Core.Reader.Schema

Assembly

ExcelReader.Core.dll

Options for guessing a column schema with InferSchema(IExcelSheet, SchemaInferenceOptions?).

public sealed class SchemaInferenceOptions

Inheritance

object

SchemaInferenceOptions

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Properties

Default

Gets the default options: header on row 1, 100 sampled rows, text left as text.

public static SchemaInferenceOptions Default { get; }

Property Value

SchemaInferenceOptions

HeaderRow

Gets the 1-based row number to take column names from. 0 means "no header", so every returned schema is addressable only by Index. Defaults to 1.

public int HeaderRow { get; init; }

Property Value

int

ParseText

Gets whether a text cell (every CSV field, or a number stored as text) counts as an integer, a decimal, true/false, or an ISO-8601 date or date-time when its text has exactly that shape. Numbers with a leading zero (00123), scientific notation (12E4), padded or culture-formatted numbers, and non-ISO dates stay text. A column only gets a non-text type when every sampled value converts to it. Defaults to false.

public bool ParseText { get; init; }

Property Value

bool

SampleSize

Gets how many rows after the header to inspect. Defaults to 100.

public int SampleSize { get; init; }

Property Value

int