Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Retrieving test data from Excel sheet
#3
Solved: 11 Years, 4 Months, 4 Weeks ago
Searched all over this forum and found lots of bits of code which required that you knew the rest of the code.

I want to be more specific about my question

I have an Excel file called: testdata.xlsx in the folder "C:\temp"
In this file I have a sheet called "release 1". In the sheet I have 3 columns which looks as follows:
Column A: UserID
Column B: FirstName
Column C: LastName

In my web application, I have 3 WebEdit fields also called UserID, FirstName and LastName

So how should the code look like if I want to retrieve the data from the 3 columns in Excel and populate the WebEdit's in my web application ?
Reply


Messages In This Thread
RE: Retrieving test data from Excel sheet - by janriis - 01-27-2011, 05:43 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Multiple rows of test data Bhuvana 0 1,358 01-03-2020, 09:30 PM
Last Post: Bhuvana
  Want to read the data from excel and set read value in the JavaTable rajeevk7 0 2,355 07-10-2017, 04:20 PM
Last Post: rajeevk7
  dtLocalSheet empty even though excel file contains data cantorre 2 2,451 05-10-2017, 12:47 PM
Last Post: vidhi
  Reading data from excel sheet serenediva 1 9,696 03-03-2017, 10:07 AM
Last Post: vinod123
Question QTP not performing iterations based on local data sheet Breaker 18 56,959 01-25-2016, 04:32 PM
Last Post: arunshuklainbox

Forum Jump:


Users browsing this thread: 9 Guest(s)