Geeks Talk

Prepare for your Next Interview




Create a table in excel

This is a discussion on Create a table in excel within the WinRunner forums, part of the Software Testing category; How want to create a table in excel through which winrunner reads the data according to the parameters...


Go Back   Geeks Talk > Software Testing > WinRunner

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 02-13-2008
Junior Member
 
Join Date: Feb 2008
Posts: 2
Thanks: 0
Thanked 2 Times in 1 Post
demo676 is on a distinguished road
Create a table in excel

How want to create a table in excel through which winrunner reads the data according to the parameters
Reply With Quote
The Following 2 Users Say Thank You to demo676 For This Useful Post:
Sponsored Links
  #2 (permalink)  
Old 02-13-2008
Expert Member
 
Join Date: Oct 2007
Location: Mumbai
Posts: 347
Thanks: 4
Thanked 54 Times in 44 Posts
bizzzzzare is on a distinguished road
Re: Create a table in excel

Hi,

Firstly create a Excel sheet with required Column names and specify the data required under it.

Data-driven tests in Winrunner as basically carried out using the ddt statements. The following steps would provide a guideline as to how to read data from an Excel file and parameterize your script -

------------------------Start of Code---------------------------

Datatbl = ddt_Open("Path of Excel File", ddt_mode_read);
ddt_get_row_count(Datatbl,rowcount);
## Rowcount is the output variable where number of Rows is stored.
for(i=0;i your field.value = ddt_val(Datatbl,parameterName);
ddt_next_row;

## ParameterName would be the Column Name in Excel sheet under which your data would be stored.

-------------------------End of Code-----------------------------

You could also the Data-Driver wizard to carry out parameterization. Select the Excel file you have created, map the parameters to the columns in the Excel. It should generate the same code listed as above.

Cheers....
__________________
Regards,

V.Umesh Krishnan
QA Consultant
Reply With Quote
Reply

  Geeks Talk > Software Testing > WinRunner


Thread Tools
Display Modes


Similar Threads

Thread Thread Starter Forum Replies Last Post
How to create an index on a column while creating table maruduri Oracle 2 08-09-2007 03:50 AM
Create same table JobHelper Database General 5 08-07-2007 01:03 PM
Can you create internal table dynamically Geek_Guest SAP R/3 0 07-19-2007 09:55 AM
How can I execute a file which include 'create table ' statement Geek_Guest Oracle 1 07-17-2007 01:33 AM
Create an index on table containg BLOB type vidya_kr Oracle 0 04-24-2007 02:33 AM


All times are GMT -4. The time now is 06:21 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved