Excel Step excelVerifyCellValue
Description
This step verifies the value of a specified cell in an Excel spreadsheet. Note that this step tests the actual stored value of the cell, not what is displayed in the spreadsheet. In particular, formulas will not be evaluated.
Parameters
- text
- Required? yes
- The text value to verify against.
- 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
excelVerifyCellValue
<webtest name="exceltest - verify cell value">
<config .../>
<steps>
<invoke url="testExcel.xls"/>
...
<excelVerifyCellValue cell="O99" text="/\d+/" description="Check number"/>
...
</steps>
</webtest>
<config .../>
<steps>
<invoke url="testExcel.xls"/>
...
<excelVerifyCellValue cell="O99" text="/\d+/" description="Check number"/>
...
</steps>
</webtest>