Write to Cell in File
This is a pre-built action in Avo Assure and comes under @Excel element, instructs Avo Assure to write the content as specified in the input column to the referenced cell of the Excel sheet and save the result in the dynamic variable.
Syntax
Input Value: <Row>;<Column>;<Value>;<Type>
Row (Required)
Row number specifies which row in the file to write the cell from
Column (Required)
Column number specifies which column in that row to write the cell from.
Value (Required)
The actual data that needs to be written into the specified cell.
Type (Required)
The format of the value to be written, such as String, Number, Dynamic Variable etc.
Output Value:
<Dynamic Variable>(Optional) ;<Dynamic Variable>(Optional)
This variable holds the results in True and False
Example 1
Write a value in particular cell of excel sheet using Write to cell in File Action (For String )
The Write to Cell in File action takes the value from the Input Value column (2;3;IT;String) and writes the given data (IT) into the specified row and column (row 2, column 3) in the set Excel file. The execution status is stored in the {Status} variable, with the following possible values:
True – if the data is written successfully.
False – if writing the data fails.
Example 2
Write a value in particular cell of excel sheet using Write to cell in File Action ( For Number )
The Write to Cell in File action takes the value from the Input Value column (6;4;6000;Number) and writes the given data (IT) into the specified row and column (row 2, column 3) in the set Excel file. The execution status is stored in the {Status} variable, with the following possible values:
True – if the data is written successfully.
False – if writing the data fails.
Last updated
Was this helpful?