Class XmlMap

Represents a data binding between an XML schema and worksheet cells, enabling XML data import/export. Excel UI: "Developer > Source > XML Maps".

Inheritance

object

XmlMap

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: DRIT.Spreadsheet

Assembly: DRIT.Spreadsheet.dll

Syntax

public class XmlMap

Remarks

An XmlMap describes how XML elements map to worksheet ranges. When loaded from an existing workbook, the map definition (schema, root element, data binding) is preserved for round-trip fidelity.

Constructors

XmlMap()

Creates a new, empty XML map.

Declaration

public XmlMap()

Remarks

An XmlMap describes how XML elements map to worksheet ranges. When loaded from an existing workbook, the map definition (schema, root element, data binding) is preserved for round-trip fidelity.

Properties

Append

Gets or sets whether imported data is appended to existing data.

Declaration

public bool Append { get; set; }

Property Value

Type	Description
bool

Remarks

An XmlMap describes how XML elements map to worksheet ranges. When loaded from an existing workbook, the map definition (schema, root element, data binding) is preserved for round-trip fidelity.

AutoFit

Gets or sets whether columns are auto-fitted on import.

Declaration

public bool AutoFit { get; set; }

Property Value

Type	Description
bool

Remarks

An XmlMap describes how XML elements map to worksheet ranges. When loaded from an existing workbook, the map definition (schema, root element, data binding) is preserved for round-trip fidelity.

DataBinding

Specifies the data binding for this XML map.

Declaration

public XmlDataBinding DataBinding { get; set; }

Property Value

Type	Description
XmlDataBinding

Remarks

An XmlMap describes how XML elements map to worksheet ranges. When loaded from an existing workbook, the map definition (schema, root element, data binding) is preserved for round-trip fidelity.

Id

Specifies the unique identifier of the XML map.

Declaration

public uint Id { get; set; }

Property Value

Type	Description
uint

Remarks

An XmlMap describes how XML elements map to worksheet ranges. When loaded from an existing workbook, the map definition (schema, root element, data binding) is preserved for round-trip fidelity.

Name

Specifies the display name of the XML map.

Declaration

public string Name { get; set; }

Property Value

Type	Description
string

Remarks

An XmlMap describes how XML elements map to worksheet ranges. When loaded from an existing workbook, the map definition (schema, root element, data binding) is preserved for round-trip fidelity.

PreserveFormat

Gets or sets whether to preserve cell formatting on import.

Declaration

public bool PreserveFormat { get; set; }

Property Value

Type	Description
bool

Remarks

An XmlMap describes how XML elements map to worksheet ranges. When loaded from an existing workbook, the map definition (schema, root element, data binding) is preserved for round-trip fidelity.

PreserveSortAutoFilterLayout

Gets or sets whether to preserve sort auto-filter layout.

Declaration

public bool PreserveSortAutoFilterLayout { get; set; }

Property Value

Type	Description
bool

Remarks

An XmlMap describes how XML elements map to worksheet ranges. When loaded from an existing workbook, the map definition (schema, root element, data binding) is preserved for round-trip fidelity.

RootElement

Specifies the root element name of the XML data.

Declaration

public string RootElement { get; set; }

Property Value

Type	Description
string

Remarks

An XmlMap describes how XML elements map to worksheet ranges. When loaded from an existing workbook, the map definition (schema, root element, data binding) is preserved for round-trip fidelity.

SchemaContent

Specifies the XSD schema content (inner XML string).

Declaration

public string SchemaContent { get; }

Property Value

Type	Description
string

Remarks

An XmlMap describes how XML elements map to worksheet ranges. When loaded from an existing workbook, the map definition (schema, root element, data binding) is preserved for round-trip fidelity.

SchemaId

Specifies the schema identifier referenced by this map.

Declaration

public string SchemaId { get; set; }

Property Value

Type	Description
string

Remarks

An XmlMap describes how XML elements map to worksheet ranges. When loaded from an existing workbook, the map definition (schema, root element, data binding) is preserved for round-trip fidelity.

SchemaNamespace

Gets the schema namespace, when available.

Declaration

public string SchemaNamespace { get; }

Property Value

Type	Description
string

Remarks

An XmlMap describes how XML elements map to worksheet ranges. When loaded from an existing workbook, the map definition (schema, root element, data binding) is preserved for round-trip fidelity.

ShowImportExportValidationErrors

Gets or sets whether to show import/export validation errors.

Declaration

public bool ShowImportExportValidationErrors { get; set; }

Property Value

Type	Description
bool

Remarks

An XmlMap describes how XML elements map to worksheet ranges. When loaded from an existing workbook, the map definition (schema, root element, data binding) is preserved for round-trip fidelity.