How do you read data from an excel sheet , when you are working with QTP?
Set the File you want to use and then Get the Cell Value of that file
Set the File you want to use and then Get the Cell Value of that file
ExcelUtil.SetFile(WorkBookPath, WorkSheet).GetCellValue(Row,
Column)
Examples
'Example 1
ExcelUtil.SetFile "C:\Example.xls",
"Sheet1"
'Example 2: Reading value directly from a file
sCellValue = ExcelUtil.SetFile("C:\Example1.xls",
"Sheet1").GetCellValue(1, 1)
'Example 2: Reading value from another file
sCellValue = ExcelUtil.SetFile("C:\Example2.xls",
"Sheet1").GetCellValue(1, 1)
Links to useful posts:
- Abstraction
- Method
Overriding
- Method
Overloading
- Instance
Variables
- Java Applets
- Pop
ups and Alerts
- Absolute
path
- Relative
path
- Annotations
- JSP Vs
Servlet
- Selenium
Webdriver Browser Commands
- Absolute
path Vs Relative path
- Selenium
Webdriver Pop ups and Alerts
- Testng
Annotations - part 1
- Object
Models in QTP - Part 1
Agile Testing Methodology - Extreme
Programming and customer satisfaction
- Mobile
testing - What are the Challenges in mobile testing & Strategies
we can follow to deal with them
- Crowdsource
testing - Crowdtesting
- Model-based
testing (MBT)
- Big
Data Testing
- Cloud Testing
- TDD
Test Driven Development
- Verification
vs Validation
- Software
Testing Interview Questions - Mock Test CSTE / ISTQB
- Software
testing types
- Risk
Management