Write Table
This action is used to write a DataTable to a specified worksheet.
Properties
Input
Excel Document: File name for the target Excel document.
WorkSheet: The target worksheet name.
Starting Cell: The target cell where the DataTable object will be written to.
Data Table: The DataTable object which will be written to the worksheet.
Print Headers: Specifies if the column names will be written of the first row.
Create Worksheet: Specifies if the target worksheet will be create automatically. True/False.
Starting cell: Needs to be specified as an "A1" notation. If a range is specified, the starting cell will be the top-left cell from that range.
Misc
Display Name: action display name in your implementation project
Wait Before: number milliseconds robot to wait before executing the action.
Wait After: number milliseconds robot to wait until moving to the next action.
Abort on Error: True/False
Retry Times: Specifies the number of times to retry an action if it doesn't end successfully. Default value 0 (no retry); Use -1 if you want to retry indefinitely.
Use Case
Potential Use Cases
Write DataTable objects to excel files.
Write data from excel documents stored in DataTable objects and add them to other documents.
Examples of Using Write Table
Example
Watch the robot in action:
You can check and download the example from here:
Last updated
