Answer / jyothi

Set a= Createobject("Excel.Application
Set b = a.workbooks.open"D:\Keyword\Test Data\data.xls"
Set c = b.Worksheets("sheet name")


Then retrieve the data like

set x= c.cells(1,1).value

Answer / cheryl

datatable.import("xlsheetname.xls")

Answer / he he eheyyy he ... baa

Excel.Workbook workBook = app.Workbooks.Open(Path, 0,
true,
5,
"",
"",
true,
Excel.XlPlatform.xlWindows,
"\t",
false,
false,
0,
true,
1,
0);

//// Get The Active Worksheet Using Sheet Name Or
Active Sheet
Excel.Worksheet workSheet =
(Excel.Worksheet)workBook.ActiveSheet;

try
{
string[] email = new string[40];
for (int i = 1; i < email.Length; i++)
{
if (i <= 40 )
{
if
(((Excel.Range)workSheet.Cells[rowIndex, colIndex1]).Value2
!= null)
{
rowIndex = 2 + index;
string emailid =
((Excel.Range)workSheet.Cells[rowIndex,
colIndex1]).Value2.ToString();
//string[] email = new string[9];

//string lastName =
((Excel.Range)workSheet.Cells[rowIndex,colIndex2]).Value2.ToString();
//string emailid =
((Excel.Range)workSheet.Cells[rowIndex,
colIndex3]).Value2.ToString();
Class1.SendMail(emailid);

//Response.Write(emailid);




index++;

}
}
}

}
catch (Exception ex)
{
app.Quit();
Response.Write(ex.Message);
}
}

Answer / srinath

close the excel sheet which you want to open in QTP
first row will always be column name which will be used in
script

datatable.import("c:\path,,,\xlsheetname.xls")
a=datatable.value("jksdfj")

Answer / rao' prasad

DataTable.Import("xlsheetname.xls")
For i=1 to DataTable.GetRowCount step 1
DataTable.SetCurrentRow(i)
........................................
.......................................
Stmts
......................................
...................................
DataTable.SetNextRow
Next

Answer / murali k m

datatable.Importsheet "D:\Keyword\Test Data\data.xls"

Does QTP work in UNIX environment

5 Answers   BirlaSoft, C1 India,

please give me the code for doing retesting of gmail login page using functions so the function has to give the value

0 Answers  

Brief the process of testing with UFT?

0 Answers  

Define QTP ?

10 Answers   TCS,

. My application is updating the user information in the application. Every time it is Adding on record in my application and Validating the information like “Record has added successfully”. Which Check point I have to put in this situation? Why?

5 Answers   Polaris,

How to check the value for variables during run time. Pls anybody can give the answer.. Thanks in advance...

4 Answers   Navis,

What is obsolute path and relative path in QTP..? How to access them and what are the differences between them...??

3 Answers   Virtusa,

what is the data driven testing?

0 Answers  

I am sathish , i want to test the Application of JIL.org ,Mobile Emulator ,by using QTP10.0. I am trying to do testing on that Application , but Child Objects are not identified by the QTP. Please can any one help me

0 Answers  

Hi, Is there any function or vbscript in QTP to clear the cookies,sessions. Please help me in this.

6 Answers  

How does Parameterization and Data-Driving relate to each other in QTP?

2 Answers  

How can we get a textcheckpoint in QTP9.1?

2 Answers   EmTechPro,