Write Table

This action is used to write a DataTable to a specified worksheet.



  • 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.


  • 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


Watch the robot in action:

You can check and download the example from here:

Last updated