praveen_testing

 Profile Answers by praveen_testing 

• Jul 21st, 2008

 

datatable.improt("Path")
get row count

akothuru

 Profile Answers by akothuru 

• Jul 21st, 2008

 

You can't able to import data related to Excel Object like Images/TextBoxes/Pie-charts.

Only You can access cell data from Excel sheet, nothing else.

Method 1: To access data from Excel sheet, use dataTable methods in QTP

Methods of DataTable
Import, Importsheet, Export, ExportSheet, GetSheet, SetCurrentRow etc...

E.g: DataTable.Import("C:abcd.xls")
dtRowCount = DataTable.GetSheet("Global").GetRowCount



Method 2: create Excel object using CreateObject method.

E.g:
Set ExcelObj = CreateObject("Excel.Application")
ExcelObj.Workbooks.Open "C:abcd.xls"
Set NewSheet = ExcelObj.Sheets.Item(1) 'first sheet
NewSheet.Cells(4,4) = "test" 'set the value to the excel cell
var_Value = NewSheet.Cells(5,4) 'retrieve value of the cell(5,4)

acmanju

 Profile Answers by acmanju Questions by acmanju

• Jul 23rd, 2008

 

First of all I would like tell u thanks,
I know the answeres like u sent . but I am expecting a answer for to fetch Image data.

let me know if anybody knows answer.