Class MarkerDesigner

Namespace

Spire.Xls

Assembly

Spire.XLS.dll

WorkbookDesignerused for template markers to the workbook and worksheet.

public class MarkerDesigner

Inheritance

object

MarkerDesigner

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Properties

IsDetectDataTypes

Whether detect the dataTypes when apply marker

public bool IsDetectDataTypes { get; set; }

Property Value

bool

Prefix

Prefix of Marker

public string Prefix { get; set; }

Property Value

string

Methods

AddArray(string, object[])

public void AddArray(string paraName, object[] paramValues)

Parameters

paraName string

paramValues object[]

AddDataColumn(string, DataColumn)

public void AddDataColumn(string paramName, DataColumn paramValue)

Parameters

paramName string

paramValue DataColumn

AddDataTable(string, DataTable)

Add datatable to template markers(Match column name automatically).

public void AddDataTable(string paraName, DataTable dataTable)

Parameters

paraName string

Parameter Name

dataTable DataTable

Datatable object

AddDataTable(string, DataTable, int)

Add datatable to template markers(Match column name automatically).

public void AddDataTable(string paraName, DataTable dataTable, int rowCount)

Parameters

paraName string

Parameter Name

dataTable DataTable

Datatable object

rowCount int

Number of data rows used per apply

AddDataView(string, DataView)

Add dataview to template markers(Match column name automatically).

public void AddDataView(string paraName, DataView dataView)

Parameters

paraName string

Parameter Name

dataView DataView

AddParameter(string, object)

Adds parameter to template markers.

public void AddParameter(string paraName, object paramValue)

Parameters

paraName string

Parameter Name

paramValue object

Parameter Value

Apply()

Apply templates markers

public void Apply()

Contains(string)

Checks parameter is exist.

public void Contains(string paramName)

Parameters

paramName string

RemoveParameter(string)

Removes parameter from template marker.

public void RemoveParameter(string paraName)

Parameters

paraName string