# Write Table

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

## **Properties**

<figure><img src="https://649489153-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MSSr3DfBuOYIkk2T9ec%2Fuploads%2FDrMBeZhW41LQ4p0FwWVU%2Fimage.png?alt=media&#x26;token=b3bd0e31-8098-4c1f-8104-6c5eadc0b2f1" alt=""><figcaption></figcaption></figure>

### **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.

{% hint style="info" %}
**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.
{% endhint %}

### **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.&#x20;

## **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**&#x20;

Watch the robot in action:

{% embed url="<https://www.youtube.com/watch?v=pmk-9YhPUjg>" %}

You can check and download the example from here:

{% file src="<https://649489153-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MSSr3DfBuOYIkk2T9ec%2Fuploads%2Fp6578d6cGtwRYGaGZ3OE%2FWrite%20table.zip?alt=media&token=3e664799-40e0-47cc-b332-29c5c373dfd6>" %}
