Excel Step excelSelectSheet
Description
Provides the ability to select the current sheet. Any subsequent calls to excel steps will use the selected sheet if not overridden
Parameters
- description
- Required? no
- The description of this test step.
- sheetIndex
- Required? yes/no
- The index of the sheet to select, starting at zero. Either sheetName or sheetIndex must be selected.
- sheetName
- Required? yes/no
- The name of the sheet to select. Either sheetName or sheetIndex must be selected.
Details
excelSelectSheet Example
<webtest name="exceltest - select sheet">
<config .../>
<steps>
<invoke url="testExcel.xls"/>
<excelSelectSheet sheetName="Sheet1"/>
<excelVerifyCellValue cell="A1" text="Sheet 1 Cell"/>
...
<excelSelectSheet sheetIndex="1"/>
<excelVerifyCellValue cell="A1" text="Sheet 2 Cell"/>
...
</steps>
</webtest>
<config .../>
<steps>
<invoke url="testExcel.xls"/>
<excelSelectSheet sheetName="Sheet1"/>
<excelVerifyCellValue cell="A1" text="Sheet 1 Cell"/>
...
<excelSelectSheet sheetIndex="1"/>
<excelVerifyCellValue cell="A1" text="Sheet 2 Cell"/>
...
</steps>
</webtest>