Class JsonImportOptions
Options controlling how JSON text is imported into worksheet cells.
Inherited Members
Namespace: DRIT.Spreadsheet
Assembly: DRIT.Spreadsheet.dll
Syntax
public class JsonImportOptions : ImportOptionsConstructors
JsonImportOptions()
Initializes a new JsonImportOptions for the supplied workbook data.
Declaration
public JsonImportOptions()Properties
ArrayAsTable
Gets or sets whether a top-level JSON array should be treated as tabular data (each element is one row). Default is true.
Declaration
public bool ArrayAsTable { get; set; }Property Value
| Type | Description |
|---|---|
| bool |
ConvertNumericOrDate
Gets or sets whether numeric-looking strings and ISO-8601 date strings should be converted to numbers and DateTime values. Default is true.
Declaration
public bool ConvertNumericOrDate { get; set; }Property Value
| Type | Description |
|---|---|
| bool |
IgnoreArrayTitle
Gets or sets whether to ignore a "title" key that is a sibling of the array being imported as a table.
Declaration
public bool IgnoreArrayTitle { get; set; }Property Value
| Type | Description |
|---|---|
| bool |
IgnoreObjectTitle
Gets or sets whether to ignore a "title" key in object nodes.
Declaration
public bool IgnoreObjectTitle { get; set; }Property Value
| Type | Description |
|---|---|
| bool |
ImportColumnNames
Gets or sets whether to import the property names as the first row (header row). Default is true.
Declaration
public bool ImportColumnNames { get; set; }Property Value
| Type | Description |
|---|---|
| bool |