QTP - Excel to QTP inbuilt data table

GeekInterview.com > Interview Questions > Testing Tools > QTP

Go To First | Previous Question | Next Question

QTP | Question 660 of 677

Excel to QTP inbuilt data table

How to fetch columns data from excel to QTP inbuilt data table, if there is a columns contains Image type of data?

Total Answers and Comments: 3

Last Update: July 23, 2008 Asked by: acmanju

Sponsored Links

Best Rated Answer

—

Submitted by: praveen_testing

datatable.improt("Path")
get row count

Above answer was rated as good by the following members:
ramarao_237

July 21, 2008 05:51:08

praveen_testing

Member Since: January 2008 Contribution: 1

RE: Excel to QTP inbuilt data table

datatable.improt("Path")
get row count

Is this answer useful? Yes | No

1 0

Overall Rating: +1

July 21, 2008 06:35:45

akothuru

Member Since: April 2008 Contribution: 37

RE: Excel to QTP inbuilt data table

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)

Is this answer useful? Yes | No

July 23, 2008 01:21:55

acmanju

Member Since: July 2008 Contribution: 4

RE: Excel to QTP inbuilt data table

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.

Is this answer useful? Yes | No

Go To Top