Write Range

Write range into an excel sheet.

Writes the data from a DataTable variable in a spreadsheet starting with the cell indicated in the Starting Cell field.

This activity can only be used after the Open Excel File activity.

Input

• Input : ExcelHandle Variable A variable name that references the opened excel filehandle.

• Sheet Name : String Argument The name of the sheet in which the range of data is to be written.

• Starting Cell : String Argument The cell from which to start writing the data.

• Number Format : The number format of the range in which the data is to be written

  • Auto - set number format of the cell as the exact format of the given input.

  • Number - set number format of the cell as the number in which data is to be inserted.

  • Date - set number format of the cell as the date on which data is to be inserted.

  • Text - set number format of the cell as the text in which data is to be inserted.

  • Formula - set number format of the cell as a formula in which the data is to be inserted.

The starting cell is specified in A1 format. A1 will select the first cell from the first row.

• Data Table : DataTable Variable The data table values that write to the specified range.