×
Use Easybots Studio to download and use the bots from this app
App
Data Tables
Free
Description
Provides bots in form of DataTables that keep data rows, and can iterate through the rows.Author
Easybots DevsVersion
1.0.30.0Available bots in this app
DataTableBot
Triggers
RowAdded
NextRow
Actions
SetDataTable
ClearRows
GetNextRow
TriggerNextRow
ResetIterator
CountRows
GetDataTable
AddRow
GetRowsAsTables
RowAdded
Returns
- addedRowAsDataTable : DataTable
NextRow
Returns
- currentRowAsDataTable : DataTable
- isFirstRow : Boolean
- isLastRow : Boolean
- currentRowIndex : Int32
SetDataTable
Inputs
- dataTable : DataTable
Returns
ClearRows
Inputs
Returns
GetNextRow
Inputs
Returns
- currentRowAsDataTable : DataTable
- isFirstRow : Boolean
- isLastRow : Boolean
- currentRowIndex : Int32
TriggerNextRow
Inputs
Returns
ResetIterator
Inputs
Returns
CountRows
Inputs
Returns
- return : Int32
GetDataTable
Inputs
Returns
- return : DataTable
AddRow
Inputs
- value 0 : Object
- value 1 : Object
- value 2 : Object
- value 3 : Object
- value 4 : Object
- value 5 : Object
- value 6 : Object
- value 7 : Object
- value 8 : Object
- value 9 : Object
Returns
GetRowsAsTables
Inputs
Returns
- return : DataTable[]
DataTableUtils
Actions
GetValueFromFirstRowByColumnName
Create
CountRows
CompareAndCount
Compare
DistinctFromColumn
DistinctWithCountsFromColumn
Contains
GetRowsWhere
GetRowsAsTables
ToStringArray
GetValueFromFirstRowByColumnName
Inputs
- dataTable : DataTable
- columnName : String
Returns
- return : Object
Create
Inputs
- columnName0 : String
- columnName1 : String
- columnName2 : String
- columnName3 : String
- columnName4 : String
- columnName5 : String
- columnName6 : String
- columnName7 : String
- columnName8 : String
- columnName9 : String
Returns
- return : DataTable
CountRows
Inputs
- dataTable : DataTable
Returns
- return : Int32
CompareAndCount
Inputs
- DataTable1 : DataTable
- DataTable2 : DataTable
Returns
- Result DataTable : DataTable
- RowsCount : Int32
Compare
Inputs
- DataTable1 : DataTable
- DataTable2 : DataTable
Returns
- return : DataTable
DistinctFromColumn
Inputs
- dataTable : DataTable
- columnName : String
Returns
- return : DataTable
DistinctWithCountsFromColumn
Inputs
- dataTable : DataTable
- columnName : String
- ascendingOrder : Boolean
Returns
- return : DataTable
Contains
Inputs
- dataTable : DataTable
- columnName : String
- value : Object
Returns
- return : Boolean
GetRowsWhere
Inputs
- dataTable : DataTable
- columnName : String
- value : Object
Returns
- return : DataTable
GetRowsAsTables
Inputs
- input : DataTable
Returns
- return : DataTable[]
ToStringArray
Inputs
- dataTable : DataTable
- columnName : String
Returns
- Result : String[]
- Count : Int32