Core Function GUIDataGrid

HotKeySet('{F1}', 'ShowSelectedCells($arg);');
// Triggered by hotkey F1 this will print the cell locations that are selected
Function ShowSelectedCells($arg)
{
	$SelectedCells = GUIDataGrid($GS, "GetSelectedCells");
	if($SelectedCells)
	{
		println("Selected Cells Below");
		foreach($SelectedCells as $cell)
		{
			List( $ColumnID, $RowID ) = $cell;
			println("User has selected cell at ColumnID ' $ColumnID' RowID '$RowID'");
		}
		println("Selected Cells Above");
	}
	else
	{
		println("No Cells are selected");
	}
}

HotKeySet('{F2}', 'ShowSelectedColumns($arg);');
// Triggered by hotkey F2 this will print the columns that are selected
Function ShowSelectedColumns($arg)
{
	$SelectedColumns = GUIDataGrid($GS, "GetSelectedColumns");
	if($SelectedColumns)
	{
		println("Selected Columns Below");
		foreach($SelectedColumns as $ColumnID)
		{
			println("User has selected ColumnID '$ColumnID'");
		}
		println("Selected Columns Above");
	}
	else
	{
		println("No Columns are selected");
	}
}

HotKeySet('{F3}', 'ShowSelectedRows($arg);');
// Triggered by hotkey F3 this will print the rows that are selected
Function ShowSelectedRows($arg)
{
	$SelectedRows = GUIDataGrid($GS, "GetSelectedRows");
	if($SelectedRows)
	{
		println("Selected Rows Below");
		foreach($SelectedRows as $RowID)
		{
			println("User has selected RowID '$RowID'");
		}
		println("Selected Rows Above");
	}
	else
	{
		println("No Rows are selected");
	}
}

GUIDataGrid($GS, "SelectionMode", @CellSelect);

GUIDataGrid($GS, "SelectionMode", @CellSelect | @RowHeaderSelect);

GUIDataGrid($GS, 	"SelectionMode", 
			@CellSelect | 
			@FullColumnSelect | 
			@FullRowSelect | 
			@RowHeaderSelect | 
			@ColumnHeaderSelect);

$k = 0;
For($j = 0; $j < $RowCount; $j++)
{
	For($i = 0; $i < $ColumnCount; $i++)
	{
		$Data = GUIDataGrid($GS, "GetValue", $i, $j);
		println("Col '$i' ROW '$j' DATA '$Data'");
		$k++;
	}
}

$k = 0;
For($j = 0; $j < $RowCount; $j++)
{
	For($i = 0; $i < $ColumnCount; $i++)
	{
		GUIDataGrid($GS, "SetValue", $i, $j, "Meows $i, $j"); 
		$k++;
	}
}

GUIDataGrid($GS, "Clear");

GUIDataGrid($GS, "AddColumn", "Four");

GUIDataGrid($GS, "InsertColumn", 0, "Zero");

GUIDataGrid($GS, "DelColumn", "Two");

GUIDataGrid($GS, "DelColumnAt", 0);

GUIDataGrid($GS, "ClearColumns");

$Columns = GUIDataGrid($GS, "GetColumns");

$ColumnCount = GUIDataGrid($GS, "Columns");

GUIDataGrid($GS, "SetColumns", array("One", "Two", "Three"));

GUIDataGrid($GS, "AddRow", array(1, 2, 3));

GUIDataGrid($GS, "InsertRow", 4, array("ONE", "TWO", "THREE"));

GUIDataGrid($GS, "DelRow", 0);

GUIDataGrid($GS, "ClearRows");

$RowCount = GUIDataGrid($GS, "Rows");