Write Cell Value

Write value into cell.

Writes a value into a specified spreadsheet cell or a range.

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

Input

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

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

• Cell : String Argument The cell name to be written.

The cell is specified in A1 format .A1will select first cell from first row.

• Cell Content : Object Argument The cell content to be written to the specified cell.

• Number Format :

  • The number format of the range in which the data 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 to be inserted.

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

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

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