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"

How many types of actions are there in quicktest professional (qtp)?

0 Answers  

What is the keyword view and expert view in qtp?

0 Answers  

What is the BPT(bussiness process testing ).and what is the main difference between BPT and QTP

3 Answers   EDS, GL Noble Denton, IIST,

Explain about the test fusion report of quicktest professional?

0 Answers  

can u tell me website address of VBscript with examples.

2 Answers  

what is the exact testing process in qtp plz explin ?

2 Answers  

how do close the task manager through QTP?

2 Answers  

What is the best institute in Ameerpet? If people think Ameerpet is the pride of hyd they need to go to Delhi/Gurgaon/noida you can find the difference.

3 Answers  

Can we directly automate testscripts accrdoing to requirements? WHY ?

1 Answers  

In qtp what type of data tables are used , name and list out them

1 Answers   Polaris,

what is keyword driven framework in qtp.

13 Answers   Cognizant, TCS,

Maximum synchronizing time out in QTP

3 Answers   Kanbay,