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"

difference between recording methods and recording modes in QTP

5 Answers   Ordain Solutions,

If our application contain one image while executing script application failed to show that image but you have to check that image by importing dynamically from other location... Can we use Check Points here on dynamically imported image?

2 Answers   ADP,

Hello Everybody, Please tell me can we create Test Plan in QTP? This I am asking irrespective to integrating with Test Director.I mean is there any option to create Test Plan in QTP itself. Thanks, Gaytri

4 Answers  

How to make "TEST Batches" in manual testing . How it is possible plz explin in detail?

1 Answers  

As u told write Libarary files in QTP. Do u use ever oject repositary 0r spy while writing scripts and for which type of testing u prepared test scripts.

1 Answers  

Hello! i am having two comboboxes.Each having 10 items in it.when i select first item in first combobox,it is not similar in the second combobox.for ex in first combo if it is Hyderabad,in second it should be some chenai or some other item .Write a VBSCRIPT for that?

3 Answers   Tech Mahindra,

what are the different data driven types?

6 Answers  

With out using the task manager,how to close the application using vbscript and what is the statement?

1 Answers  

Where virtual objects stores results?

4 Answers  

How to connect to data base?

2 Answers  

Hello Everybody, How to maintain the page state in QTP. My scenario is: 1. I opened a notepad file. 2. Entered some text in the notepad file. 3.And changed the font type and color of the notepad file. And saved that. 4.Now next time when I will open the notepad it is showing the changed font type and color, rather than the default values. Please provide the code. Thanks, Gaytri

5 Answers  

what sort of things what u put in Bug Report ?

1 Answers