Write Cell Value
Write value into cell.
Last updated
Write value into cell.
Last updated
Writes a value into a specified spreadsheet cell or a range.
This activity can only be used after the Open Excel File activity.
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 .A1
will 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.