calvin_29

 Profile Answers by calvin_29 

• Sep 23rd, 2010

 

First you should select the required cell and use object spy to know rows nos. and col nos. in the selected area then use below in QTP editor
set oReqVal= browser().page().webtable().getcelldata(rows ,cols)
print oReqVal

deepaksporty

 Profile Answers by deepaksporty Questions by deepaksporty

• Nov 12th, 2010

 

Browser("Google").Page("Google").WebTable("Advanced Search").GetCellData(row_number, column_number)

Satyesha

 Profile Answers by Satyesha 

• Mar 29th, 2011

 

Hi there are two approaches to do so-
1.If you want to retrieve data from any external exl sheet.
'Create Excel Object      
 Set excel=createobject("excel.application")          
 'Make it Visible    
 excel.Visible=True    
  
 'Open the Excel File  
 Set workbook=excel.Workbooks.Open("D:excel.xls")  
  
 'Get the Control on Specific Sheet  
 Set worksheet1=excel.Worksheets.Item("Sheet1")  
  
 ' Display the Values  
 Msgbox  worksheet1.cells(1,1).value   
'this can be iterate with for loop by taking the rows count of exl sheet i.e. cells(i,j).
   
 'Close Work Book    
 workbook.Close    
     
 'Quit from Excel Application    
 excel.Quit  
  
2. In case of QTP integrated data table use-
DataTable().getsheet().Getparameter("col name").

ch.bhaskar.mca

 Profile Answers by ch.bhaskar.mca 

• Apr 6th, 2011

 

functions CellData(int rowno,int columnno)
{
Set excel=createobject("excel.application")
excel.Visible=True
Set workbook=excel.Workbooks.Open("D:excel.xls")
Set worksheet1=excel.Worksheets.Item("Sheet1")
getdata=worksheet1.cells(rowno, columnno).value
workbook.Close
excel.Quit
return getdata
}