WebTestRecorderExcel Step excelVerifyCellSum
Description
This step verifies that a cell represents the sum of a range of cells, either as a formula (=SUM(<range>)) or numeric value.
Parameters
- range
- Required? yes
- The range of cells to verify sum against. (eg 'A1:A5')
- cell
- Required? yes/no
- The spreadsheet cell to select. eg. A5. Either cell or row and col must be specified.
- col
- Required? no
- The name or number (starting at 1) of the column to select. eg 1 or A. Either cell or row and col must be specified.
- description
- Required? no
- The description of this test step.
- row
- Required? yes/no
- The number of the row to select, starting at 1. Either cell or row and col must be specified.
- sheetIndex
- Required? no
- The index of the sheet to select, starting at zero. If no sheet is selected, the value of the last excelSelectSheet call is used, or defaults to the first sheet.
- sheetName
- Required? no
- The name of the sheet to select. If no sheet is selected, the value of the last excelSelectSheet call is used, or defaults to the first sheet.
Details
excelVerifyCellSum Example
<webtest name="exceltest - verify cell sum">
<config .../>
<steps>
<invoke url="testExcel.xls"/>
...
<excelVerifyCellSum cell="C8" range="C4:C7"/>
...
</steps>
</webtest>
<config .../>
<steps>
<invoke url="testExcel.xls"/>
...
<excelVerifyCellSum cell="C8" range="C4:C7"/>
...
</steps>
</webtest>
