DataGridView

Inspiration

Input data and its structure and standardization are important for the quality of processing. Garbage in, garbage out. With this activity we provide an elegant and simple solution to allow human operators to tag data such that the robot can then further process it.

What it does

This custom activity is used to display any kind of data in a Windows Form using a dataGridView. The input is a dataTable and how the screen should be displayed, the output is the new dataTable and the last selected cell.

This could be used to change data, selected cells and transforming unstructured data to structured data with human assistance, by asking the user to select a cell in the column with a certain type of data.

Input These are the input parameters

InputTable - DataTable - The data to be displayed
Suffix (optional) - String - The name of the window
ShowAsDialog (optional) - Boolean - If the UiPath code should continue running or should wait for the form to be closed

Processing It displays a Windows Form containing only a DataGridView element That's it! A really simple and elegant data display.

Output These are the output parameters

OutputTable - DataTable - The altered data
SelectedCell - Dictionary<string, string> - All the information about the last selected cell:
  rowIndex - The row number of the cell
  columnIndex - The index of the last selected column
  columnName - The name of the column of the cell
  value - The value of the cell in string form

How we built it

Built in Visual Studio using C# implementing a CodeActivity

Demo Video

For a small showcase please see: plotTable show case

Credits

Sebastiaan Smits

Bas van der Pol

Ciphix B.V. @ Rotterdam

Built With

Share this project:
×

Updates