How to read and write in excel through QTP script

Thread Rating:

Thread Modes

How to read and write in excel through QTP script

shwetha_m Offline

Junior Member

Posts: 10
Threads: 7
Joined: Jan 2012
Reputation: 0

02-12-2012, 04:06 PM

Hi,
when i run the below script.

Code:
rc = DataTable.Value ("A", dtGlobalSheet)

msgbox rc

Browser("Google").Page("Google").WebEdit("q").Set rc

Error is displayed as below :

The retrieve DataTable.Value operation failed. The <A> column does not exist.

Line (2):

Code:
"rc = DataTable.Value ("A", dtGlobalSheet)".

Can anyone please assist on this?

Regards,
Shwetha

Find

« Next Oldest | Next Newest »

Messages In This Thread

RE: How to read and write in excel through QTP script - by shwetha_m - 02-12-2012, 04:06 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Want to read the data from excel and set read value in the JavaTable	rajeevk7	0	2,316	07-10-2017, 04:20 PM Last Post: rajeevk7
	VB Script to separate upper & small Letters from a string and store in excel	pradeep537	1	2,211	08-05-2016, 12:26 AM Last Post: Ankur
	UFT taking different script execution timings while comparing 2 excel files.	sudheer	0	2,355	06-26-2015, 03:28 PM Last Post: sudheer
	How to write a script for fly out menus (Parent - Child - Sub Child)	rajkumarsm	3	4,728	09-02-2014, 10:01 AM Last Post: vinod123
	How to mask the particular read only mode fields while capturing screenshot in QTP	kalaivanan123	2	3,531	03-18-2014, 11:31 AM Last Post: basanth27

Users browsing this thread: 2 Guest(s)