'This example uses the ActivateCell method with Microsoft DataGrid control to activate the cell in
'the fifth row and second column.
SwfWindow("DataGrid Control").SwfTable("myDataGrid").ActivateCell 4, 1

'This example uses the ActivateCell method with ComponentOne C1FlexGrid control to activate the
'fourth row of the "Name" column.
SwfWindow("C1FlexGrid:").SwfTable("flex1").ActivateCell 3, "Name"

'This example uses the ActivateCell method with Infragistics UltraWinGrid control to activate the
'first row of the "Total" column in the second-level band.
SwfWindow("SamplesExplorer").SwfWindow("Row Filtering").SwfTable("UltraGrid1").ExpandRow 1
SwfWindow("SamplesExplorer").SwfWindow("Row Filtering").SwfTable("UltraGrid1").ActivateCell "1;0", "Total"

'This example uses the ActivateCell method to activate the cell in the first row and first column
'of a DevExpress Pivot Grid.
SwfWindow("DevExpress Controls").SwfTable("pGridControl").ActivateCell 0, 0

'This example uses the ActivateCell method to activate the cell in the first row and first column
'of a DevExpress Data Grid, and then to activate the cell in the first row and the column named ID.
SwfWindow("DevExpress Controls").SwfTable("gridControl").ActivateCell 0, 0
SwfWindow("DevExpress Controls").SwfTable("gridControl").ActivateCell 0, "ID"

'This example uses the ActivateCell method to activate the first cell in the Path row
'in a DevExpress Vertical Grid and then to activate the Size part of the first cell in the
'House multi-editor row.
SwfWindow("DevExpress Controls").SwfTable("vGridControl").ActivateCell "Path", 0
SwfWindow("DevExpress Controls").SwfTable("vGridControl").ActivateCell "House;(Color;Size)", 0, "Size"

'This example uses the ActivateColumn method with Infragistics UltraWinGrid control to activate the
'"Total" column in the second-level band.
SwfWindow("SamplesExplorer").SwfWindow("Row Filtering").SwfTable("UltraGrid1").ActivateColumn "1;Total"

'This example uses the ActivateColumn method with ComponentOne C1TrueDBGrid control to activate
'the "Freight" column.
SwfWindow("Form1").SwfTable("c1TrueDBGrid1").ActivateColumn "Freight"

'This example uses the ActivateRow method with Infragistics UltraWinGrid control to activate the
'third row in the third-level band.
SwfWindow("Row Filtering").SwfTable("UltraGrid1").ActivateRow "1;0;2"

'This example uses the ActivateRow method with ComponentOne C1TrueDBGrid control to activate the
'fourth row in the grid.
SwfWindow("Form1").SwfTable("c1TrueDBGrid1").ActivateRow 3

'This example uses the SelectCell method to select the first cell in a DevExpress
'Pivot Grid and then the AddCellToSelection method to add the 3rd cell in the 6th row to the selection.

SwfWindow("DevExpress Controls").SwfTable("pGridControl").SelectCell 0, 0
SwfWindow("DevExpress Controls").SwfTable("pGridControl").AddCellToSelection 5, 2

'This example uses the SelectCell method to select the first cell in a DevExpress
'Data Grid and then the AddCellToSelection method to add the Invoice Details cell in the 6th row to the selection.

SwfWindow("DevExpress Controls").SwfTable("gridControl").SelectCell 0, 0
SwfWindow("DevExpress Controls").SwfTable("gridControl").AddCellToSelection 5, "Invoice Details"

'This example uses the SelectCell method to select the first record in the Path row
'and then the AddCellToSelection method to add the Size part of the first cell in the multi-editor row, House, 
' to the set of selected cells in a DevExpress Vertical Grid.
SwfWindow("DevExpress Controls").SwfTable("vGridControl").SelectCell "Path", 0
SwfWindow("DevExpress Controls").SwfTable("vGridControl").AddCellToSelection "House;(Color;Size)", 0, "Size)"

'This example uses the AddRow method to expand the table to display the sixth row in the second-level
'band, and then clicks the "Invoice Details" button to add a row to that band.
SwfWindow("Layouts").SwfTable("gridOne").ExpandRow "0;5"
SwfWindow("Layouts").SwfTable("gridOne").AddRow " Invoice Details", "0;5"

'This example uses the AddRowToSelection method to add the first row
' to the set of selected rows in a DevExpress Data Grid.

SwfWindow("DevExpress Controls").SwfTable("gridControl").SelectRow 1
SwfWindow("DevExpress Controls").SwfTable("gridControl").AddRowToSelection 0

'This example uses the AddRowToSelection method to add the Color row
' to the set of selected rows in a DevExpress Vertical Grid.

SwfWindow("DevExpress Controls").SwfTable("vGridControl").SelectRow "Price;Full Name;Category;Color"
SwfWindow("DevExpress Controls").SwfTable("vGridControl").AddRowToSelection "Price;Last Name;Category;Color"

'This example uses the Back method to return to the parent table after opening a child table in
'the third row and first column of the "myDataGrid" control.
SwfWindow("DataGrid Control").SwfTable("myDataGrid").ExpandRow 2
SwfWindow("DataGrid Control").SwfTable("myDataGrid").OpenCellRelation 2, 0
SwfWindow("DataGrid Control").SwfTable("myDataGrid").Back

'This example uses the ClearGrouping method to clear the grouping in the grid.

SwfWindow("DevExpress Controls").SwfTable("gridControl").GroupByColumn 0
SwfWindow("DevExpress Controls").SwfTable("gridControl").GroupByColumn "Discount"
SwfWindow("DevExpress Controls").SwfTable("gridControl").ClearGrouping()

'This example uses the Click method to click a right mouse button at coordinates 47, 131 on the "button4"
'button.

SwfWindow("Form1").SwfButton("button4").Click 47, 131, 1

'This example uses the CollapseAllGroups method to collapse all expanded groups in the data grid.

SwfWindow("DevExpress Controls").SwfTable("gridControl").GroupByColumn 0
SwfWindow("DevExpress Controls").SwfTable("gridControl").GroupByColumn "Discount"
SwfWindow("DevExpress Controls").SwfTable("gridControl").ExpandAllGroups()
SwfWindow("DevExpress Controls").SwfTable("gridControl").CollapseAllGroups()

'This example uses the CollapseAllRows method to collapse all grouped rows in the Vertical Grid.

SwfWindow("DevExpress Controls").SwfTable("vGridControl").CollapseAllRows()

'This example uses the CollapseRow method with Microsoft Data Grid control to collapse the third
'row in the grid.
SwfWindow("DataGrid Control").SwfTable("myDataGrid").CollapseRow 2

'This example uses the CollapseRow method with Infragistics UltraWinGrid control to collapse the
'sixth row in the second-level band.
SwfWindow("Layouts").SwfTable("gridOne").CollapseRow "0;5"

'This example uses the CollapseRow method with DevExpress Data Grid control to collapse the third
'row in the "Master" view, and then collapse the first row and all rows nested in it.
SwfWindow("MasterView").SwfTable("gridControl1").CollapseRow 2
SwfWindow("MasterView").SwfTable("gridControl1").CollapseRow 0, "True"

'This example uses the CollapseRow method to collapse the Full Name row in a DevExpress Vertical Grid.
SwfWindow("DevExpress Controls").SwfTable("vGridControl").CollapseRow "Path;Full Name"

'This example uses the DblClick method to double-click a right mouse button at coordinates 73, 120 on
'the "Test" window.

SwfWindow("Test").DblClick 73, 120, 1

'This example uses the DeselectCell method to deselect the first cell in a DevExpress
'Pivot Grid and then deselect the 3rd cell in the 6th row.
SwfWindow("DevExpress Controls").SwfTable("pGridControl").SelectCell 0, 0
SwfWindow("DevExpress Controls").SwfTable("pGridControl").AddCellToSelection 5, 2
SwfWindow("DevExpress Controls").SwfTable("pGridControl").DeselectCell 0, 0
SwfWindow("DevExpress Controls").SwfTable("pGridControl").DeselectCell 5, 2

'This example uses the DeselectCell method to deselect the first cell in a DevExpress
'Data Grid and then deselect the Invoice Details cell in the 6th row.
SwfWindow("DevExpress Controls").SwfTable("gridOne").SelectCell 0, 0
SwfWindow("DevExpress Controls").SwfTable("gridOne").AddCellToSelection 5, "Invoice Details"
SwfWindow("DevExpress Controls").SwfTable("gridOne").DeselectCell 0, 0
SwfWindow("DevExpress Controls").SwfTable("gridOne").DeselectCell 5, "Invoice Details"

'This example uses the DeselectCell method to deselect cells in a DevExpress Vertical Grid.
SwfWindow("DevExpress Controls").SwfTable("vGridControl").SelectCell "Path", 0
SwfWindow("DevExpress Controls").SwfTable("vGridControl").AddCellToSelection "Path;(Color;Size)", 0, "Size"
SwfWindow("DevExpress Controls").SwfTable("vGridControl").DeselectCell "Path", 0
SwfWindow("DevExpress Controls").SwfTable("vGridControl").DeselectCell "Path;(Color;Size)", 0, "Size"

'This example uses the DeselectRow method to deselect the first row
' in a DevExpress Data Grid.

SwfWindow("DevExpress Controls").SwfTable("gridControl").SelectRow 0
SwfWindow("DevExpress Controls").SwfTable("gridControl").DeselectRow 0

'This example uses the DeselectRow method to deselect the Color row
' in a DevExpress Vertical Grid.
SwfWindow("DevExpress Controls").SwfTable("vGridControl").SelectRow "Price;Full Name;Category;Color"
SwfWindow("DevExpress Controls").SwfTable("vGridControl").DeselectRow "Price;Full Name;Category;Color"

'This example uses the Drag method to drag the object from coordinates 10, 20 within the "Test" window,
'to coordinates 30, 40 within the "OtherWindow".

SwfWindow("Test").Drag 10, 20
SwfWindow("OtherWindow").Drop 30, 40
'or, within the same window:

SwfWindow("Test").Drag 10, 20
SwfWindow("Test").Drop 30, 40

'This example uses the Drop method to drop the object at coordinates 30, 40 within the "OtherWindow" after
'dragging from coordinates 10, 20 within the "Test" window.

SwfWindow("Test").Drag 10, 20
SwfWindow("OtherWindow").Drop 30, 40
'or, within the same window:
SwfWindow("Test").Drag 10, 20
SwfWindow("Test").Drop 30, 40

'This example uses the GroupByColumn method to group some rows in the data grid, 
'and then uses the ExpandAllGroups method to expand all groups.

SwfWindow("DevExpress Controls").SwfTable("gridControl").GroupByColumn 0
SwfWindow("DevExpress Controls").SwfTable("gridControl").GroupByColumn "Price"
SwfWindow("DevExpress Controls").SwfTable("gridControl").ExpandAllGroups

'This example uses the ExpandAllRows method to expand all groups in the Vertical Grid.

SwfWindow("DevExpress Controls").SwfTable("vGridControl").ExpandAllRows

'This example uses the ExpandRow method with Microsoft Data Grid control to expand the third row
'in the grid to open a cell relation in that row.
SwfWindow("DataGrid Control").SwfTable("myDataGrid").ExpandRow 2
SwfWindow("DataGrid Control").SwfTable("myDataGrid").OpenCellRelation 2, 0

'This example uses the ExpandRow method with Infragistics UltraWinGrid control to expand the second
'row in the top-level band to activate a cell in that band's child table.
SwfWindow("SamplesExplorer").SwfWindow("Row Filtering").SwfTable("UltraGrid1").ExpandRow 1
SwfWindow("SamplesExplorer").SwfWindow("Row Filtering").SwfTable("UltraGrid1").ActivateCell "1;0", "Total"

'This example uses the ExpandRow method with DevExpress Data Grid control to expand the third
'row in the "Master" view, and then expand the first row and all rows nested in it.
SwfWindow("MasterView").SwfTable("gridControl1").GroupByColumn 0
SwfWindow("MasterView").SwfTable("gridControl1").GroupByColumn "Discount"
SwfWindow("MasterView").SwfTable("gridControl1").ExpandRow 2
SwfWindow("MasterView").SwfTable("gridControl1").ExpandRow 0, "True"

'This example uses the ExpandRow method to expand a row in a DevExpress Vertical Grid.
SwfWindow("MasterView").SwfTable("vGridControl1").GroupByColumn 0
SwfWindow("MasterView").SwfTable("vGridControl1").GroupByColumn "Discount"
SwfWindow("DevExpress Controls").SwfTable("vGridControl").ExpandRow "Path;Full Name"

'This example uses the FireEvent method to simulate a Click event on the "Save" button.

SwfWindow("Welcome").SwfButton("Save").FireEvent "Click"

'This example uses the GetCellData method with Infragistics UltraWinGrid control to return the data
'contained in the second row of the "Description" column within the second band level.
MyData = SwfWindow("Layouts").SwfTable("gridOne").GetCellData("0;1", "Description")
MsgBox MyData

'This example uses the GetCellData method to return the data contained in the third row
'of the 2nd column in DevExpress Pivot Grid control. 

MyData = SwfWindow("DevExpress Controls").SwfTable("pGridControl1").GetCellData(2, 1)
MsgBox MyData

'This example uses the GetCellData method to return the data contained in the third row
'of the "CustomerID" column in DevExpress Data Grid control. 

MyData = SwfWindow("DevExpress Controls").SwfTable("gridControl1").GetCellData(2, "CustomerID")
MsgBox MyData

'This example uses the GetCellData method to retrieve the Size value from a cell in a multi-editor 
'row in a DevExpress Vertical Grid.
MyData = SwfWindow("DevExpress Controls").SwfTable("vGridControl").GetCellData "Path;(Color;Size)", 0, "Size"
MsgBox MyData

'Get the salary of the specified employee
Dim cnt, curRow, colWorkName, colSalary
   colWorkName = 1
   colSalary = 7
   ' Sorting by the searched value may help find the Employee Name faster
' if you use a more efficient search algorithm than This example
'   SwfWindow("GridStyles (VB Demo)").SwfTable("GridControl1").Sort _
'        colWorkName, "Descending"
'
' Get the number of rows
   cnt = SwfWindow("GridStyles (VB Demo)").SwfTable("GridControl1").RowCount
'Check the name column in each row
For curRow = 0 To cnt - 1
         workerName = _
SwfWindow("GridStyles (VB Demo)").SwfTable("GridControl1").GetCellProperty(curRow, colWorkName, "value")
'If the employee is found on this row, return the salary from the salary column
If workerName = employeeName Then
             findSalary = _
SwfWindow("GridStyles (VB Demo)").SwfTable("GridControl1").GetCellProperty(curRow, colSalary, "value")
             ExitFunctionEndIfNext' Not found
   findSalary = -1
   'Use example:
'MsgBox findSalary("John Smith")

'This example uses the GetCellProperty method to get the value of the "x" property for the cell
'located in the ninth row, third column of the "myDataGrid" table.
Dim strCellProp
strCellProp = SwfWindow("DataGrid Control Sample").SwfTable("myDataGrid").GetCellProperty(8, 2, "x")

'This example uses the GetColumnsCount method to return the number of visible columns in the grid
'and the number of all columns, including the hidden ones.
ColumnsCount = SwfWindow("DevExpress Controls").SwfTable("gridControl").GetColumnsCount
MsgBox ColumnsCount
ColumnsCount = SwfWindow("DevExpress Controls").SwfTable("gridControl").GetColumnsCount True
MsgBox ColumnsCount

'This example enters some text into an edit box and then uses the
'GetErrorProviderText method to check whether the edit box has an error icon.
'If the method returns a value other than an empty string, then there is an
'error, so the Cancel button is clicked in the dialog box.  If the string is empty,
' then there is no error and the Apply button is clicked.

SwfWindow("Form1").SwfEdit("Ex_textBox").Set Text
     Dim ErrorMessage
    ErrorMessage = SwfWindow("Form1").SwfEdit("Ex_textBox").GetErrorProviderText
    IfLen(ErrorMessage) <> 0 Then
        SwfWindow("Form1").SwfButton("Cancel").Click
    Else
       SwfWindow("Form1").SwfButton("Apply").Click
    EndIf

'This example uses the GetRecordsCount method to return the number of records in the grid.
RecordsCount = SwfWindow("DevExpress Controls").SwfTable("vGridControl").GetRecordsCount  
MsgBox RecordsCount 

'This example uses the GetRowsCount method to return the number of visible rows in the grid
'and the number of all rows, including the hidden ones.
RowsCount = SwfWindow("DevExpress Controls").SwfTable("gridControl").GetRowsCount
MsgBox RowsCount
RowsCount = SwfWindow("DevExpress Controls").SwfTable("gridControl").GetRowsCount True
MsgBox RowsCount

'This example uses the GetTextLocation method to retrieve all of the text within the object.

l = -1
t = -1
r = -1
b = -1
result = SwfWindow("Open").SwfEdit("File &name:").GetTextLocation("2002", l, t, r, b)
If result ThenMsgBox"Text found. Coordinates:" & l & "," & t & "," & r & "," & b
EndIf

'This example uses the GetVisibleText method to retrieve the text from the "Form1" window. If the returned
'string contains the "login": sub-string, the Type method is used to type the "guest" string in the window.

TestText = SwfWindow("Form1").GetVisibleText
IfInStr(1, TestText, "login:", 1) > 0 Then
    SwfWindow("Test").Type "guest"EndIf

'This example uses the GetVisibleText method to retrieve the text within the specified coordinates. If
'the returned string is not Catalog, the ReportEvent method is used to report a failed step.

theText = SwfWindow("Form1").SwfObject("progressBar1").GetVisibleText(16, 25, 56, 92)
If theText <> "Catalog"Then
 Reporter.ReportEvent micFail, "Traders", "Text check failed"EndIf

'This example uses the GroupByColumn method to group the "gridControl1" table by the first Column, then
'selects the "Category" column and groups the grid according to the "Category" column.

SwfWindow("DevExpress Controls").SwfTable("gridControl1").GroupByColumn 0
SwfWindow("DevExpress Controls").SwfTable("gridControl1").GroupByColumn "Category"

'This example uses the HideColumn method to hide the first column and the column named 'ID'.
SwfWindow("DevExpress Controls").SwfTable("gridControl").HideColumn 0
SwfWindow("DevExpress Controls").SwfTable("gridControl").HideColumn "ID"

'This example uses the HideParentRow method to hide the parent row, after the second row of the
'"myDataGrid" control is expanded to display a cell relation.
SwfWindow("DataGrid Control").SwfTable("myDataGrid").ExpandRow 1
SwfWindow("DataGrid Control").SwfTable("myDataGrid").OpenCellRelation 1, 0
SwfWindow("DataGrid Control").SwfTable("myDataGrid").HideParentRow

'This example uses the HideRow method to hide a row in the grid.

SwfWindow("DevExpress Controls").SwfTable("vGridControl").HideRow "Path;(Color;Size)"

'This example uses the MakeCellVisible method to scroll the cell located 
'in the ninth row, third column of the "myDataGrid" table into the view.
SwfWindow("DataGrid Control Sample").SwfTable("myDataGrid").MakeCellVisible 8, 2

'This example uses the MouseMove method to move the mouse pointer to position 10, 5 inside the
'"progressBar1" object.

SwfWindow("Form1").SwfObject("progressBar1").MouseMove 10, 5

'This example uses the MoveColumn method to move columns around inside the grid.
SwfWindow("DevExpress Controls").SwfTable("gridControl").MoveColumn 0, 1
SwfWindow("DevExpress Controls").SwfTable("gridControl").MoveColumn 0, 1, True
SwfWindow("DevExpress Controls").SwfTable("gridControl").MoveColumn 2, "Discount"
SwfWindow("DevExpress Controls").SwfTable("gridControl").MoveColumn "ID", 1
SwfWindow("DevExpress Controls").SwfTable("gridControl").MoveColumn "ID", 1, True
SwfWindow("DevExpress Controls").SwfTable("gridControl").MoveColumn "ID", "Price"
SwfWindow("DevExpress Controls").SwfTable("gridControl").MoveColumn "ID", "Price", True

'This example uses the MoveRow method to move the 'Quantity' row after the Product row,
' move the 'ID' row before the 'Product' row, and move the 'Line' row to be a child of the 'Model' row.
SwfWindow("DevExpress Controls").SwfTable("vGridControl").MoveRow "Quantity", "Product", 2 
SwfWindow("DevExpress Controls").SwfTable("vGridControl").MoveRow "ID", "Product",  0
SwfWindow("DevExpress Controls").SwfTable("vGridControl").MoveRow "Line", "(Description;Model)", 1

'This example uses the OpenCellElement method to open the Color dialog box for the selected cell
'element.
SwfWindow("Form1").SwfTable("fg").SelectCell 4, "Color"
SwfWindow("Form1").SwfTable("fg").OpenCellElement 4, "Color"
SwfWindow("Form1").Dialog("Color").WinButton("OK").Click

'This example uses the OpenCellRelation method to open the cell relation for the second row and
'first column in the grid, after expanding the second row of the "myDataGrid" control.
SwfWindow("DataGrid Control").SwfTable("myDataGrid").ExpandRow 1
SwfWindow("DataGrid Control").SwfTable("myDataGrid").OpenCellRelation 1, 0

'This example uses the OpenSummaryDlg method to display the summary dialog for the "Description"
'column in the third band level, after selecting the count check box in the Select Summaries window.
SwfWindow("V2 Summary Rows").SwfWindow("Select Summaries").SwfCheckBox("Count").Set "ON"
SwfWindow("V2 Summary Rows").SwfWindow("Select Summaries").SwfButton("OK").Click
SwfWindow("V2 Summary Rows").SwfTable("UltraGrid1").OpenSummaryDlg 2, "Description"

'This example uses the SelectCell method with Infragistics UltraWinGrid control to select the cell
'in the first row of the "Description" column in the second band level, and then select the cell in the second row
'of the "Quantity" column in the third band level.
SwfWindow("V2 Summary Rows").SwfTable("UltraGrid1").ExpandRow "0;0"
SwfWindow("V2 Summary Rows").SwfTable("UltraGrid1").SelectCell "0;0", "Description"
SwfWindow("V2 Summary Rows").SwfTable("UltraGrid1").SelectCell "0;0;1", "Quantity"

'This example uses the SelectCell method with DevExpress Pivot Grid control to select the cell in the
'third row of the second column, and then select the cell in the second row of the third column.
SwfWindow("DevExpress Controls").SwfTable("pGridControl1").SelectCell 2, 1
SwfWindow("DevExpress Controls").SwfTable("pGridControl1").SelectCell 1, 2

'This example uses the SelectCell method with DevExpress DataGrid control to select the cell in the
'third row of the "CustomerID" column, and then select the cell in the second row of the third column.
SwfWindow("DevExpress Controls").SwfTable("gridControl1").SelectCell 2, "CustomerID"
SwfWindow("DevExpress Controls").SwfTable("gridControl1").SelectCell 1, 2

'This example uses the SelectCell method with ComponentOne C1FlexGrid control to select the cell in
'the fifth row of the "Currency column", and then select the cell in the sixth row and first column.
SwfWindow("Form1").SwfTable("fg").SelectCell 4, "Currency"
SwfWindow("Form1").SwfTable("fg").SelectCell 5, 0

'This example uses the SelectCell method to select the first cell in the Path row
'in a DevExpress Vertical Grid and then to select the Size part of the first cell in the
'House multi-editor row.
SwfWindow("DevExpress Controls").SwfTable("vGridControl").SelectCell "Path", 0
SwfWindow("DevExpress Controls").SwfTable("vGridControl").SelectCell "House;(Color;Size)", 0, "Size"

'This example uses the SelectColumn method to select the "Freight" column.
SwfWindow("DevExpress Controls").SwfTable("GridControl1").SelectColumn "Freight"

'This example uses the SelectRow method with DevExpress Data Grid control to select the seventh row.

SwfWindow("DevExpress Controls").SwfTable("gridControl1").SelectRow 6

'This example uses the SelectRow method with Infragistics UltraWinGrid control to select the second
'row in the third band level, and then select the second row in the first band level.
SwfWindow("Samples Explorer").SwfWindow("View Styles").SwfTable("UltraGrid1").SelectRow "1;0;1"
SwfWindow("Samples Explorer").SwfWindow("View Styles").SwfTable("UltraGrid1").SelectRow 1

'This example uses the SelectRow method with ComponentOne C1FlexGrid control to select the eighth row
'in the "fg" table.
SwfWindow("Form1").SwfTable("fg").SelectRow 7

'This example uses the SelectRow method to select the 'Full Name' row in a DevExpress Vertical Grid.
SwfWindow("DevExpress Controls").SwfTable("vGridControl").SelectRow "Path;Full Name"

'This example uses the SetCellData method with ComponentOne C1FlexGrid control to select the check
'box (sets the value as True) in the fifth row of the "Boolean" column.
SwfWindow("Form1").SwfTable("fg").SelectCell 4, "Boolean"
SwfWindow("Form1").SwfTable("fg").SetCellData 4, "Boolean", "True"
SwfWindow("Form1").SwfTable("fg").SelectCell 4, "Currency"
SwfWindow("Form1").SwfTable("fg").SetCellData 4, "Boolean", "True"
SwfWindow("Form1").SwfTable("fg").SetCellData 4, "Currency", True
SwfWindow("Form1").Dialog("#32770").WinButton("OK").Click

'This example uses the SetCellData method with Infragistics UltraWinGrid control to set the value
'21 in the second row of the "Shuttle_ID" column in the first band level, and then set the value 7/29/2027 12:00:00 AM in the first row of the Arrival_Date column in the second band level.
SwfWindow("View Styles").SwfTable("UltraGrid1").SelectCell 1, "Shuttle_ID"
SwfWindow("View Styles").SwfTable("UltraGrid1").SetCellData 1, "Shuttle_ID", "21"
SwfWindow("View Styles").SwfTable("UltraGrid1").ExpandRow 3
SwfWindow("View Styles").SwfTable("UltraGrid1").SelectCell "3;0", "Arrival_Date"
SwfWindow("View Styles").SwfTable("UltraGrid1").SetCellData "3;0", "Arrival_Date", "7/29/2027 12:00:00 AM"

'This example uses the SetCellData method with Microsoft Data Grid control to open a cell relation
'and set the value 3/2/2003 12:00:00 AM in the first row and third column of the opened child table.
SwfWindow("Form1").SwfTable("myDataGrid").ExpandRow 2
SwfWindow("Form1").SwfTable("myDataGrid").OpenCellRelation 2, 0
SwfWindow("Form1").SwfTable("myDataGrid").SelectCell 0, 2
SwfWindow("Form1").SwfTable("myDataGrid").SetCellData 0, 2, "3/2/2003 12:00:00 AM"

'This example uses the SetCellData method to enter data in the first row of a Pivot Grid control,
'in the first column and in the fourth column.
SwfWindow("DevExpress Controls").SwfTable("pGridControl").SetCellData 0, 0, "myData"
SwfWindow("DevExpress Controls").SwfTable("pGridControl").SetCellData 0, 3, "True"

'This example uses the SetCellData method to enter data in the first row of a Data Grid control,
'in the first column and in the column named "ID".
SwfWindow("DevExpress Controls").SwfTable("gridControl").SetCellData 0, 0, "myData"
SwfWindow("DevExpress Controls").SwfTable("gridControl").SetCellData 0, "ID", "True"

'This example uses the SetCellData method to enter data in the Size row of a Vertical Grid control,
'in the first record.
SwfWindow("DevExpress Controls").SwfTable("vGridControl").SetCellData "House;(Color;Size)", 0, "myData"

'This example uses the SetMultiCellData method to set data in the Description part of the first cell in the multi-editor ID grid row.
SwfWindow("DevExpress Controls").SwfTable("vGridControl").SetMultiCellData "(ID;Description)", 0, "Description", "myData"

'This example uses the SetFilter method with Infragistics UltraWinGrid control to apply the Fester
'filter to the "FirstName" column in the first band level, and then apply the (Custom) filter to the same column.
SwfWindow("Row Filtering").SwfTable("UltraGrid1").SetFilter 0, "FirstName", "Fester"
SwfWindow("Row Filtering").SwfTable("UltraGrid1").SetFilter 0, "FirstName", "(Custom)"
SwfWindow("Row Filtering").SwfWindow("Enter filter").SwfButton("Cancel").Click

'This example uses the SetFilter method with ComponentOne C1TrueDBGrid control to apply the WELLI
'filter to the "CustomerID" column.
SwfWindow("Form1_2").SwfTable("c1TrueDBGrid1").SetFilter "CustomerID", "WELLI"

'This example uses the SetSelection method to select the top left corner of the table, 
'including the first three cells of the first three rows.
SwfWindow("DevExpress Controls").SwfTable("pivotGridControl").SetSelection 0, 0, 3, 3

'This example uses the ShowColumn method to show the column named 'ID'.

SwfWindow("DevExpress Controls").SwfTable("gridControl").ShowColumn "ID"

'This example uses the ShowParentRow method to display the parent row. In the example, the second row
'of the "myDataGrid" control is initially expanded to display a cell relation, and then the parent row is hidden
'using the HideParentRow method.
SwfWindow("DataGrid Control").SwfTable("myDataGrid").ExpandRow 1
SwfWindow("DataGrid Control").SwfTable("myDataGrid").OpenCellRelation 1, 0
SwfWindow("DataGrid Control").SwfTable("myDataGrid").HideParentRow
'..
'..
SwfWindow("DataGrid Control").SwfTable("myDataGrid").ShowParentRow

'This example uses the ShowRow method to make a hidden row in the grid visible.

SwfWindow("DevExpress Controls").SwfTable("vGridControl").ShowRow "Path;(Color;Size)"

'This example uses the Sort method with Infragistics UltraWinGrid control to sort the first band level
'according to the "Name" column in ascending order. It then expands the second band level to sort the third band
'level according to the "First_Name" column in ascending order.
SwfWindow("View Styles").SwfTable("UltraGrid1").Sort 0, "Name", "Ascending"
SwfWindow("View Styles").SwfTable("UltraGrid1").ExpandRow 1
SwfWindow("View Styles").SwfTable("UltraGrid1").ExpandRow "1;0"
SwfWindow("View Styles").SwfTable("UltraGrid1").Sort 2, "First_Name", "Ascending"

'This example uses the Sort method with ComponentOne C1FlexGrid control to sort the table according
'to the "Last Mod" column in ascending order, and then sorts the table according to the "Name" column in descending
'order.
SwfWindow("C1FlexGrid:").SwfTable("_flex").Sort "Last Mod", "Ascending"
SwfWindow("C1FlexGrid:").SwfTable("_flex").Sort "Name", "Descending"

'This example uses the Type method to press the ENTER (RETURN) key on the button4 button.

SwfWindow("Form1").SwfButton("button4").Type micReturn

'This example uses the GroupBy method to group the "gridControl1" table by the "Supplier" Column, then
'selects the "Category" column and then ungroups the "Supplier" grouping.
SwfWindow("DevExpress Controls").SwfTable("gridControl1").GroupByColumn "Supplier"
SwfWindow("DevExpress Controls").SwfTable("gridControl1").UnGroupByColumn "Supplier"