Qtp-dt-sheet
提供：Dev Guides
QTP-DTSheetメソッド
| Method Name | Description | Syntax |
|---|---|---|
| AddParameter | Adds the specified column to the sheet in the run-time data table. | DTSheet.AddParameter (ParameterName, Value) |
| DeleteParameter | Deletes the specified parameter from the run-time data table. | DTSheet.DeleteParameter (ParameterID) |
| GetCurrentRow | Returns the row number of the active row in the run-time Data Table. | DTSheet.GetCurrentRow |
| GetParameter | Returns the specified parameter from the run-time Data Table. | DTSheet.GetParameter (ParameterID) |
| GetParameterCount | Returns the total number of Columns in the run-time Data Table. | DTSheet.GetParameterCount |
| GetRowCount | Returns the total number of rows in the run-time Data Table. | DTSheet.GetRowCount |
| SetCurrentRow | Sets the Focus on the specified Row of the Data Table | DTSheet.SetCurrentRow (RowNumber) |
| SetNextRow | Shifts the Focus to the next Row of the Data Table. | DTSheet.SetNextRow |
| SetPrevRow | Shifts the Focus to the Previous Row of the Data Table. | DTSheet.SetPrevRow |
例
'Accessing Datatable to get Row Count and Column Count
rowcount = DataTable.GetSheet("Global").GetRowCount
msgbox rowcount ' Displays 4
colcount = DataTable.GetSheet("Global").GetParameterCount
msgbox colcount ' Displays 3
DataTable.SetCurrentRow(2)
val_rate = DataTable.Value("Rate","Global")
print val_rate ' Displays 7%
val_ppl = DataTable.Value("Principal","Global")
print val_ppl ' Displays 2556
val_Time = DataTable.Value("Time","Global")
print val_Time ' Displays 5