Method name

explanation

All common methods

For details, please refer to Common Methods.

Method name

explanation

AddRow

Add a line to the end.

AddCol

Add a column to the end.

InsertRow

Insert a row.

InsertCol

Insert a column.

DelRow

Delete a row.

DelCol

Delete a column.

SetData

Set data in the cell.

GetData

Get the data from the cell.

SetColData

Sets data in cells by column. The data is specified as a one-dimensional array that stores the column data.

SetRowData

Sets data in cells by row. The data is specified by a one-dimensional array that stores the row data.

SetTableData

Set data to cells all at once.

GetTableData

Get data from cells in bulk.

FindRowData

Searches data row-wise.

FindColData

Search data column-wise.

ClearData

Clear the data in the cell.

Clear

Delete all cells.

Method name

explanation

AddStyle

Add style.

SetCellStyle

Change cell styles by row or column.

SetDefaultStyle

Sets the default cell style when a cell is added.

ClearStyle

Delete all styles.

SetCellType

Sets the cell type.

SetCellProperty

Set the cell properties.

GetCellProperty

Gets the properties of a cell.

SetColProperty

Set the column property of the cell.

GetColProperty

Gets the column property of the cell.

SetRowProperty

Set the row property of the cell.

GetRowProperty

Gets the row property of the cell.

SetColWidth

Sets the column width.

GetColWidth

Gets the column width.

SetRowHeight

Sets the row height.

GetRowHeight

Gets the row height.

SetGridLine

Show or hide cell borders.

MergeCells

Merge cells.

UnmergeCells

Unmerge merged cells.

Method name

explanation

IsSelectedRow

Gets whether the specified row is selected.

IsSelectedCol

Retrieves whether the specified column is selected.

IsSelectedCell

Gets whether the specified cell is selected.

GetSelectedRow

Gets the display index of the currently selected row.

GetSelectedRows

Gets the display indexes of the currently selected rows as an array.

GetSelectedCol

Gets the display index of the currently selected column.

GetSelectedCols

Gets the display indexes of the currently selected columns as an array.

GetSelectedCell

Gets the display index of the currently selected cell.

SelectCell

Select the cells.

ClearSelection

Deselect the cell.

Method name

explanation

ScrollCell

Scrolls the currently displayed cell position.

GetFirstVisibleRow

Gets the display index of the row of the top-left cell that is currently displayed.

GetFirstVisibleCol

Gets the display index of the column of the top-left cell that is currently displayed.

Method name

explanation

Paging

Perform paging.

SetPage

Specifies the page to display.

GetPage

Gets the currently displayed page.

GetPages

Get the total number of pages.

ClearPaging

Cancel paging.

BaseFilter

Set the base filter.

ClearBaseFilter

Remove the base filter.

FieldFilter

Set the field filter.

ClearFieldFilter

Clear the field filter.

SearchFilter

Set the search filter.

ClearSearchFilter

Clear the search filter.

SortFilter

Set the sort filter.

ClearSortFilter

Clear the sort filter.

ClearAllFilter

Clear all filters (base filter, field filter, search filter, sort filter).

RefreshAllFilter

Reruns all filters and redraws the screen.

IsFilter

Determines if a filter is running.

GetSortTargetFields

Gets the index of the field that is the target of the sort.

GetDisplayRows

Gets the number of rows of display data.

GetDisplayCols

Gets the number of columns of display data.

DisplayRowToRow

Gets the index of a row in the source data from the display index of a row in the display data.

DisplayColToCol

Gets the source data column index from the display index of the display data column.

Method name

explanation

Copy

Copy the grid data.

Paste

Paste the grid data.

Cut

Clips the data in the grid.

Print

Print the grid.

LoadCsvFile

Display data read from a CSV file in a grid.

SaveCsvFile

Writes grid data to a CSV file.