Overview

Overview

Welcome to QTP interview questions

Hello software Quality engineers. Welcome to our Software testing world and common QTP(Quick test pro) related technical issues, interview questions etc. . Over 2 years, I am trying to update all possible interview questions in testing area of QTP. With your continuous comments on the topics and suggestions, we are growing day by day.

Wednesday, December 19, 2007

How to access values from an excel sheet cell ?

To access value from Local Action Sheet of Run Time Data Table,

use the following.Datatable.GetSheet("Sheet Name").SetCurrentRow("Mention Row Number from where you want to access the value")Cell_Value = Datatable.GetSheet("Sheet Name").GetParameter("Mentioned Column Name from where you want to access the Value").ValueMsgbox Cell_Value

To access value from Global Data Sheet of Run Time Data Table, use the following.Datatable.GlobalSheet.SetCurrentRow("Mention Row Number from where you want to access the value")Cell_Value = Datatable.GlobalSheet.GetParameter("Mentioned Column Name from where you want to access the Value").ValueMsgbox Cell_Value

No comments:

Post a Comment