API Reference
ExcelReadPresets
Convenience presets for common read conversions to keep user code minimal. Provides several choices from minimal to more aggressive conversions.
Inheritance
- Object
- ExcelReadPresets
Methods
public static ExcelReadOptions Aggressive() #ExcelReadOptionsAggressive converters for convenience: - Extended bool: true/false/1/0/on/off/y/n/yes/no - Percent strings (e.g., 12%) to decimals (0.12) - Currency and plain numeric strings to decimal/double/int where appropriate - ISO date strings to DateTime
public static Void ApplyBasicConverters(ExcelReadOptions options) #VoidApplies the same converters as returned by Simple to an existing options instance.
Parameters
- options OfficeIMO.Excel.ExcelReadOptions
public static ExcelReadOptions DecimalFirst() #ExcelReadOptionsLike Simple() but prefers decimal for numeric cells when possible.
public static ExcelReadOptions None() #ExcelReadOptionsNo extra converters. Equivalent to default ExcelReadOptions with only built-in behavior.
public static ExcelReadOptions Simple() #ExcelReadOptionsMinimal, non-intrusive converters: - Y/Yes/N/No to bool - Currency-like strings to decimal (tries CurrentCulture, InvariantCulture, a few common locales)
Inherited Methods
public override Boolean Equals(Object obj) #BooleanParameters
- obj Object