Class Range
Inheritance
Namespace: Syncfusion.EJ2.Spreadsheet
Assembly: Syncfusion.EJ2.dll
Syntax
public class Range : EJTagHelper
Constructors
Range()
Declaration
public Range()
Properties
Address
Specifies the address for updating the dataSource or template.
Declaration
public string Address { get; set; }
Property Value
Type | Description |
---|---|
System.String | The default value is "A1" |
DataSource
Specifies the data as JSON / Data manager to the sheet.
Declaration
public object DataSource { get; set; }
Property Value
Type | Description |
---|---|
System.Object | The default value is null |
FieldsOrder
By default, when a sheet is bound to a data source, columns are assigned to data source fields sequentially. This means that the first data field is assigned to Column A, the second to Column B, and so on. You can customize these assignments by specifying the field names in the desired column order using the 'fieldsOrder' property.
Declaration
public string[] FieldsOrder { get; set; }
Property Value
Type | Description |
---|---|
System.String[] | The default value is null |
Query
Defines the external Query
that will be executed along with data processing.
Declaration
public string Query { get; set; }
Property Value
Type | Description |
---|---|
System.String | The default value is null |
ShowFieldAsHeader
Show/Hide the field of the datasource as header.
Declaration
public bool ShowFieldAsHeader { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean | The default value is true |
StartCell
Specifies the start cell from which the datasource will be populated.
Declaration
public string StartCell { get; set; }
Property Value
Type | Description |
---|---|
System.String | The default value is "A1" |
Template
Template helps to compiles the given HTML String (or HTML Element ID) into HtML Element and append to the Cell.
Declaration
public string Template { get; set; }
Property Value
Type | Description |
---|---|
System.String | The default value is "" |