Class JsonOptions

Namespace

Openize.Cells

Assembly

Openize.OpenXMLSDK.dll

Configuration options for JSON import and export operations.

public class JsonOptions

Inheritance

object

JsonOptions

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Properties

ArrayValueSeparator

Gets or sets the separator for array values when converting to strings.

public string ArrayValueSeparator { get; set; }

Property Value

string

AutoDetectDataTypes

Gets or sets whether to auto-detect data types during import.

public bool AutoDetectDataTypes { get; set; }

Property Value

bool

ConvertArraysToStrings

Gets or sets whether to handle arrays by converting them to comma-separated strings.

public bool ConvertArraysToStrings { get; set; }

Property Value

bool

Culture

Gets or sets the number format culture (e.g., "en-US", "de-DE").

public string Culture { get; set; }

Property Value

string

DateFormat

Gets or sets the date format for parsing and formatting date values.

public string DateFormat { get; set; }

Property Value

string

DateTimeFormat

Gets or sets the date-time format for parsing and formatting datetime values.

public string DateTimeFormat { get; set; }

Property Value

string

FlattenNestedObjects

Gets or sets whether to flatten nested objects into columns with dot notation. Example: {"user": {"name": "John"}} becomes "user.name" column.

public bool FlattenNestedObjects { get; set; }

Property Value

bool

IgnoreNullValues

Gets or sets whether to ignore null or empty values during import.

public bool IgnoreNullValues { get; set; }

Property Value

bool

IncludeHeaders

Gets or sets whether to include property names as headers in the first row.

public bool IncludeHeaders { get; set; }

Property Value

bool

MaxRecords

Gets or sets the maximum number of records to import (0 = no limit).

public int MaxRecords { get; set; }

Property Value

int

NestedPropertySeparator

Gets or sets the separator for flattened nested object property names.

public string NestedPropertySeparator { get; set; }

Property Value

string