- Overview
- Automation Ops Pipelines
- Callout
- Complex Scenarios
- Credentials
- Data Service
- Form
- Release Notes
- Project compatibility
- Real Time Forms
- Updating form data
- Running forms using JavaScript
- Customizing Forms Using CSS
- Conditional components
- Adding multiple components on the same row in Columns
- Using the Data Table component
- Get File/Folder path
- Reading cell values from a Data Grid component
- Displaying PDF files
- Displaying images in forms
- Scrolling through Data Grids
- Using Dev Tools with forms
- Calculate form component values
- Managing dates in forms
- Opening hyperlinks inside forms
- Displaying a default tab in forms
- Displaying the full label of a component
- Searching long strings in drop-down lists
- About the pre 23.4 Form experience
- Project Compatibility
- Real Time Forms
- Dynamic Checkboxes
- Conditional Dropdowns
- Displaying a Default Tab
- Displaying Images
- Displaying PDF Files
- Displaying the Full Label
- Dynamic HTML Elements
- Managing Dates
- Searching Long Strings in Drop-downs
- Customizing Forms Using Local CSS Files
- Executing Do Block On Checkbox Change
- Customizing Columns Width
- Updating Form Data
- Resetting Collection Data
- Advanced Logic
- Executing Do Block on Dropdown Option Change
- Reading Cell Values From a Data Grid Component
- Conditional Components
- Scrolling Through Data Grid Components
- Using the Grid Component
- Dev Tools
- Calculated Value
- Dynamic Dropdowns
- Switching Tabs With Button Click
- Opening Hyperlinks Inside Form
- FTP
- IPC
- Persistence
- Release Notes
- Project Compatibility
- About the Persistence Activities Package
- Bulk Form Designer
- Start Job And Get Reference
- Wait for Job and Resume
- Add Queue Item And Get Reference
- Wait For Queue Item And Resume
- Wait for Form Task and Resume
- Resume After Delay
- Assign Tasks
- Create External Task
- Wait For External Task and Resume
- Complete Task
- Forward Task
- Get Form Tasks
- Get Task Data
- Add Task Comment
- Update Task Labels
- Create App Task
- Wait for App Task and Resume
- Working with App tasks
- Building Your First Form Action
- Advanced Controls for Drop-downs
- Embedding Objects in Form Actions
- Allowing Users to Upload Files to the Storage Bucket
- Adding Advanced Logic Using Java Script
- Setting a Default Tab
- Removing the Delete button from Edit Grid using custom CSS
- Customizing Edit Grid templates
- Using buttons to trigger custom logic
- Using an External Form Layout
- Dynamically expanding form components at runtime
- Sample Workflows
- System
- Release Notes
- About the System Activities Package
- Project Compatibility
- RegEx Builder Wizard
- Is Text Matching
- Find Matching Patterns
- Modify Text
- Modify Date
- Replace Matching Patterns
- Text to Left/Right
- Add Data Column
- Add Data Row
- Build Data Table
- Clear Data Table
- Get Row Item
- Update Row Item
- Merge Data Table
- Output Data Table
- Remove Data Column
- Remove Data Row
- For Each Row in Data Table
- Generate Data Table From Text
- Create List
- Append Item to List
- Read List Item
- Update List Item
- Add Log Fields
- Comment Out / Disabled Activities
- Comment
- Change Type
- Log Message
- Remove Log Fields
- Invoke Com Method
- Format Value
- Lookup Data Table
- Filter Data Table
- Sort Data Table
- Remove Duplicate Rows
- Join Data Tables
- Report Status
- Append Line
- Compress/Zip Files
- Copy File
- Copy Folder
- Create Folder
- Create File
- Delete
- File Exists
- Folder Exists
- Extract/Unzip Files
- Wait for Download
- File Change Trigger
- For Each File in Folder
- For Each Folder in Folder
- Delete File
- Delete Folder
- Move File
- Move Folder
- Rename Folder
- Rename File
- Path Exists
- Read Text File
- Write Text File
- Get File Info
- Get Folder Info
- Get Processes
- Get Username/Password
- Kill Process
- Beep
- Get Environment Folder
- Get Environment Variable
- Invoke Power Shell
- Input Dialog
- Message Box
- Browse for File
- Browse for Folder
- Invoke VBScript
- Process End Trigger
- Process Start Trigger
- File Change Trigger V3
- Trigger Scope
- Repeat Number of Times
- Text to Upper/Lowercase
- Set Environment Variable
- For Each
- Break / Exit Loop
- Retry Scope
- Check True
- Check False
- Workflow Placeholder
- Invoke Workflow File
- Launch Workflow Interactive
- Invoke Code
- Continue / Skip Current
- Multiple Assign
- Invoke Process
- Run Parallel Process
- While
- Do While
- Repeat Number Of Times
- Raise Alert
- Orchestrator HTTP Request
- Get Asset
- Get Credential / Get Orchestrator Credential
- Set Asset
- Set Credential
- Get Jobs
- Get Current Job Info
- Start Job
- Stop Job
- Add Queue Item
- Add Transaction Item
- Delete Queue Items
- Get Queue Items
- Get Transaction Item
- Postpone Transaction Item
- Set Transaction Progress
- Set Transaction Status
- Should Stop
- Wait Queue Item
- Bulk Add Queue Items
- Write Storage Text
- Upload Storage File
- List Storage Files
- Read Storage Text
- Download Storage File
- Delete Storage File
- Custom Input
- Append Item to Collection
- Build Collection
- Collection to Data Table
- Exists in Collection
- Filter Collection
- Merge Collections
- Remove From Collection
- Reset Timer
- Resume Timer
- Start Timer
- Stop Timer
- Timeout Scope
- Manual Trigger
- When New Item Added to Queue
- Stop Local Triggers
- Run Local Triggers
- Repeat Trigger
- Time Trigger
- Disable Local Trigger
- Enable Local Trigger
- Notify Global Variable Changed
- Global Variable Changed Trigger
- Extract Text
- Find and Replace
- Return
- Extract Date and Time from Text
- Change Case for Text
- Add or Subtract from Date
- Download file from URL
- Format Date as Text
- Split Text
- Combine text
- AddDataRow
- AddQueueItem
- AddTransactionItem
- AppendLine
- BulkAddQueueItems
- ClearDataTable
- CompressZipFiles
- CopyFile
- CreateFile
- CreateFolder
- DeleteFileOrFolder
- DeleteQueueItems
- DeleteStorageFile
- DownloadStorageFile
- ExtractUnzipFiles
- FilterDataTable
- GetAsset
- GetCredential
- GetJobs
- GetQueueItem
- GetQueueItems
- GetResourceForLocalPath
- GetRowItem
- GetTransactionItem
- InvokeProcess
- JoinDataTables
- ListStorageFiles
- LookUpDataTable
- MergeDataTable
- MoveFile
- OrchestratorHTTPRequest
- OutputDataTable
- PathExists
- PostponeTransactionItem
- ReadStorageText
- ReadTextFile
- RemoveDataColumn
- RemoveDuplicateRows
- Replace
- SetAsset
- SetCredential
- SetTransactionProgress
- SetTransactionStatus
- SortDataTable
- StartJob
- StopJob
- UpdateRowItem
- UploadStorageFile
- WaitQueueItem
- WriteStorageText
- WriteTextFile
- Testing
- Release Notes
- Project Compatibility
- About the Testing Activities Package
- Project Settings
- Add Test Data Queue Item
- Address
- Attach Document
- Bulk Add Test Data Queue Items
- Delete Test Data Queue Items
- Get Test Data Queue Item
- Get Test Data Queue Items
- Given Name
- Last Name
- Random Date
- Random Number
- Random String
- Random Value
- Verify Control Attribute
- Verify Expression
- Verify Expression With Operator
- Verify Range
- Address
- AddTestDataQueueItem
- AttachDocument
- BulkAddTestDataQueueItems
- DeleteTestDataQueueItems
- GetTestDataQueueItem
- GetTestDataQueueItems
- GivenName
- LastName
- RandomDate
- RandomNumber
- RandomString
- RandomValue
- VerifyAreEqual
- VerifyAreNotEqual
- VerifyContains
- VerifyExpression
- VerifyExpressionWithOperator
- VerifyIsGreater
- VerifyIsGreaterOrEqual
- VerifyIsLess
- VerifyIsLessOrEqual
- VerifyIsRegexMatch
- VerifyRange
- Workflow Events
- Workflow Foundation
Generate Data Table From Text
UiPath.Core.Activities.GenerateDataTable
Generates a DataTable variable from structured text. This activity enables you to select column and row separators according to which the table is generated. This activity is automatically generated when using the Generate Table feature in the Screen Scraping window.
- Input - The source of the structured text.
- Parsing method - Data formatting options for the table. The available options are:
- CSV (Comma Separated Values)
- Custom
- Fixed width columns
Properties
- Autodetect Column Types - When selected, automatically detects the column or row type, whether it is String, Int32, etc.
- Use First Row as Column Headers - If enabled, uses the first identified row as the column header.
- Ignore First Column - If enabled, the first identified column is ignored.
- Continue On Error - Specifies if the automation should continue even when the activity throws an error. This field only supports Boolean values (True, False). The default value is False. As a result, if the field is blank and an error is thrown, the execution of the project stops. If the value is set to True, the execution of the project continues regardless of any error.
- Data Table - The DataTable variable that contains the generated table.
-
Input: - The source of the structured text. In StudioX, you can use the Plus icon to select one of the available options:
- Data from the Project Notebook, a parent Excel file or Outlook account. For example, select an Excel file, and then select Indicate in Excel to indicate a cell from the file, or select an email in Outlook and then select a field in the email that contains the data to be used as input.
- Ask when run - Prompt for the data when the project is executed.
- Paste from clipboard - Paste a value that you previously copied to the clipboard in the project.
- Text - Enter the data in the Text Builder.
- Use Saved Value - Select a value that you previously saved for later use in the project.
- Open in Advanced Editor - Enter a VB expression.
- Options - Click to open the Generate Table Wizard window.
-
DataTable -Â Choose where to save the datatable. In StudioX, you can use the Plus icon to select one of the available options:
- Select a parent Excel file or the Project Notebook, and then select a named range, table, or sheet where to save the data, or select Indicate in Excel to select directly from the file.
- Copy to clipboard - Save the data to the clipboard.
- Save for Later Use - Save the data for later use in your project as input for another activity.
- Open in Advanced Editor - Enter a VB expression.
Properties
Options
- ContinueOnError - Specifies if the automation should continue even when the activity throws an error. This field only supports Boolean values (True, False). The default value is False. As a result, if the field is blank and an error is thrown, the execution of the project stops. If the value is set to True, the execution of the project continues regardless of any error.
-
DisplayName - The display name of the activity.
Note: If this activity is included in Try Catch and the value of the ContinueOnError property is True, no error is caught when the project is executed.
Fixed Formatting Options
- ColumnSizes - Specifies the size of the columns that are to be created in the table. This field supports only IEnumerable variables.
Formatting Options
- ColumnSeparators - Specifies the character that is to be used as a column separator. This field supports only String variables.
- CSVParsing - select if you want to parse the input data as a CSV. This field only supports Boolean values (True, False). The default value is False.
- NewLineSeparator - Specifies the character that is to be used as a newline separator. This field supports only String variables.
Input
- Input: - Specifies the source of the structured text that is to be converted into a table. This field supports only String variables.
- Positions - If OCR is used for scraping, and the Get Words Info check box is selected, this field contains the
IEnumerable<KeyValuePair<Rectangle,String>>
variable that has the WordsInfo value.
Misc
- Private - If selected, the values of variables and arguments are no longer logged at Verbose level.
Output
- DataTable - The DataTable variable that contains the generated table.
Table Options
- AutoDetectTypes - When selected, automatically detects the column or row type, whether it is String, Int32, etc.
- UseColumnHeader - If selected, uses the first identified column as the column header.
- UseRowHeader - If selected, uses the first identified row as the row header.
The Generate Data Table Wizard is only available for Windows and Windows - Legacy projects.
Click the Options... button to open the Generate Data Table Wizard. Use it to easily configure and preview the resulting table format.
Table Options
- AutoDetect Column Types - If checked, automatically detects the column or row type.
- Use First Row as Column Headers - If checked, uses the first identified row as the column header.
- Ignore First Column - If checked, ignores the first identified column.
Data Formatting Options
-
Format - Select the input format to be used:
- CSV (Comma Separated Value) - Allows you to set Column Separators.
- Custom - Allows you to set Column Separators and NewLine separators.
- Fixed Width Columns \- Allows you to set the column width of all columns.
- Column Separators - Specify the character that is to be used as a column separator.
- NewLine Separators - Specify the character that is to be used as a newline separator.
- Preview - Click to generate a preview of the resulting table format.
This example explains how to generate a table with specific information by using the Generate Data Table activity.
This is how the automation process can be built:
- Open Studio and create a new Process.
-
Drag a Sequence container in the Workflow Designer.
Variable Name
Variable Type
Default Value
DT1
DataTable
 Result
String
 Name
GenericValue
 -
Drag a Generate Data Table activity inside the Sequence container.
- In the Properties panel, add the value
False
in the CSVParsing field. - Add the value
Environment.NewLine
in the NewLineSeparator field. - Add the expression
"Name;Surname; John;Doe; James;Liam;"
in the Input: field. - Add the variable
DT1
in the DataTable field. - Select the check box for the UseColumnHeader option.
- In the Properties panel, add the value
-
Click the Options... button to open the Generate Data Table Wizard.
- Select the Custom option from the Format drop-down menu.
- Select the semicolon option from the Column Separators drop-down list.
- Select the space option from the NewLine Separators drop-down list.
- Click OK for closing the wizard.
-
This is how the Generate Data Table Wizard panel should look:
6. Drag an Output Data Table activity below the Generate Data Table activity.
- In the Properties panel, add the variable
DT1
in the DataTable field. - Add the variable
Result
in the Text field.
-
Place a Write Line activity under the Output Data Table activity.
- Add the variable
Result
in the Text field.
- Add the variable
- Run the process. The robot generates a table by using the input data.