code to read data from excel or spread sheet

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

code to read data from excel or spread sheet

Logged in as: Guest

arrSession:exec spGetSession 2,16,64404

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> Post a VBScript >> code to read data from excel or spread sheet
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

code to read data from excel or spread sheet - 9/19/2008 4:09:21 PM

parvathih

Posts: 1
Score: 0
Joined: 9/19/2008
Status: offline

Using test complete I have recorded vb script.While recording for a text fields the user needs to input the data via keyboard. instead of inputing data via keyboard planning to
read it from excelsheet.
how to read the input data from the excel sheet(which as 1 column and n rows) or Spread sheet.
ie, in the below code "iteration1" data is the keyboard input, instead of that it should be read from the excel sheet.
Call w1.WinFormsObject("txtTaskName").Keys("iteration1")
On iterating the script for 10 times, each time the script should read 1 row and should increment.
its for the fist iteration 1row should be read and for the 2nd iteration 2nd row should be read and so on.