How to get data from excel sheet to the script? write the
script.
- 6 Answers
- 22615 Views
- Ever, Liquid Hub, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 8 Yes | 2 No |
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);
}
}
| Is This Answer Correct ? | 1 Yes | 1 No |
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")
| Is This Answer Correct ? | 3 Yes | 4 No |
DataTable.Import("xlsheetname.xls")
For i=1 to DataTable.GetRowCount step 1
DataTable.SetCurrentRow(i)
........................................
.......................................
Stmts
......................................
...................................
DataTable.SetNextRow
Next
| Is This Answer Correct ? | 4 Yes | 5 No |
Answer / murali k m
datatable.Importsheet "D:\Keyword\Test Data\data.xls"
| Is This Answer Correct ? | 0 Yes | 4 No |
Hi All, I Want To excute scripts batch without using QC .I need code for that Thanks Balaji
How do you synchronization point through DP?
Hi, I am trying to automate the web application for generating Reports.I am facing issue with IE while running the script. After 4 report IE crashes.I am using QTP 9.5 with IE version 7. Can anubody give me solution for this issue. Thanks in advance-Jyotsna
Did QTP prove efficient for your project? Yes or No, explain?
How we can add actions in the test using QTP?
Can any one explain me what is the procedure to connect the remote desk by using QTP 9.2 ?
How can we encrypt the username using recording mode in login window? There is 2 encrypted types what are it
How to Creating an Output Value using QTP?
How did you resolve conflicts present in Object Repository?
How to automate a script in mainframes environment? I have the terminal emulator Add in. Describe in detail.
what is runmodes in QTP
How to retrieve the property of an object?
WinRunner 
