GrapeCity.Spreadsheet.IRange.DataTable

DataTable Method

Creates a data table based on input values and formulas that you define on a worksheet.

bool DataTable(string rowInput, string columnInput)

Function DataTable(rowInput As String, columnInput As String) As Boolean

Type	Name	Description
string	rowInput	A single cell to use as the row input for your table.
string	columnInput	A single cell to use as the column input for your table.

Type	Description
bool	`true` if the data table is created; otherwise, `false`.

Creates a data table based on input values and formulas that you define on a worksheet.

bool DataTable(CellReference rowInput, CellReference columnInput)

Function DataTable(rowInput As CellReference, columnInput As CellReference) As Boolean

Type	Name	Description
CellReference	rowInput	A single cell to use as the row input for your table.
CellReference	columnInput	A single cell to use as the column input for your table.

Type	Description
bool	`true` if the data table is created; otherwise, `false`.

Creates a data table based on input values and formulas that you define on a worksheet.

bool DataTable(IRange rowInput, IRange columnInput)

Function DataTable(rowInput As IRange, columnInput As IRange) As Boolean

Type	Name	Description
IRange	rowInput	A single cell to use as the row input for your table.
IRange	columnInput	A single cell to use as the column input for your table.

Type	Description
bool	`true` if the data table is created; otherwise, `false`.