Whether xlsx extension works while importing data sheet?

Hello There, Guest! Register

New To UFT? Join the best UFT Training Online!

Thread Rating:

4 Vote(s) - 2.75 Average
1
2
3
4
5

Thread Modes

Whether xlsx extension works while importing data sheet?

bfakruddin Offline

Offline

Member

Posts: 146
Threads: 50
Joined: Dec 2008
Reputation: 1

#7

Solved: 11 Years, 3 Months, 2 Weeks ago

03-12-2010, 03:27 PM

Just use below code.. and provide your desired path and run...

make sure that excel file have extension .xlsx

dim xl

set xl=createobject("excel.application")

xl.visible=true

xl.workbooks.open("E:\Baba_QTP\QTP\Data\a.xlsx")

set xl=nothing

Find

Reply

« Next Oldest | Next Newest »

Messages In This Thread

Whether xlsx extension works while importing data sheet? - by Akhila - 09-29-2008, 07:07 AM

RE: Importing data sheet format? - by kishoreinchennai - 09-30-2008, 02:19 AM

RE: Importing data sheet format? - by Akhila - 09-30-2008, 06:26 AM

RE: Importing data sheet format? - by akbarsharifmd - 03-07-2011, 12:24 AM

RE: Whether xlsx extension works while importing data sheet? - by bfakruddin - 01-22-2010, 09:11 PM

RE: Whether xlsx extension works while importing data sheet? - by Saket - 01-25-2010, 10:37 AM

RE: Whether xlsx extension works while importing data sheet? - by RaviKrishnaIL - 03-04-2010, 01:10 PM

RE: Whether xlsx extension works while importing data sheet? - by bfakruddin - 03-12-2010, 03:27 PM

RE: Whether xlsx extension works while importing data sheet? - by Saket - 03-12-2010, 03:35 PM

RE: Whether xlsx extension works while importing data sheet? - by Saket - 06-18-2010, 05:04 PM

RE: Whether xlsx extension works while importing data sheet? - by agarwl.anurag - 10-15-2012, 11:21 PM

RE: Whether xlsx extension works while importing data sheet? - by Ankur - 01-18-2011, 02:07 PM

RE: Whether xlsx extension works while importing data sheet? - by vijaya.t - 01-21-2011, 09:18 AM

RE: Whether xlsx extension works while importing data sheet? - by RGummadidala - 02-08-2011, 09:25 AM

RE: Whether xlsx extension works while importing data sheet? - by Saket - 04-14-2011, 01:20 PM

RE: Whether xlsx extension works while importing data sheet? - by AnujN - 05-25-2011, 08:47 PM

RE: Whether xlsx extension works while importing data sheet? - by mukesh_shenoy18 - 04-12-2011, 11:46 AM

RE: Whether xlsx extension works while importing data sheet? - by swapnanil.jgec@gmail.com - 06-25-2011, 05:11 PM

RE: Whether xlsx extension works while importing data sheet? - by cflow - 07-25-2012, 01:14 PM

RE: Whether xlsx extension works while importing data sheet? - by QTPScript - 08-30-2012, 10:20 PM

RE: Whether xlsx extension works while importing data sheet? - by Ankur - 03-25-2014, 02:28 AM

RE: Whether xlsx extension works while importing data sheet? - by vinod123 - 06-17-2014, 04:02 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Reading data from excel sheet	serenediva	1	9,597	03-03-2017, 10:07 AM Last Post: vinod123
	Chrome Extension UFT Agent for Chrome Browser testing with UFT	santhosh kumar	2	12,439	04-20-2016, 01:20 AM Last Post: santhosh kumar
	QTP not performing iterations based on local data sheet	Breaker	18	56,672	01-25-2016, 04:32 PM Last Post: arunshuklainbox
	How QTP record/play works on google chrome	shobi	6	7,541	01-11-2016, 09:53 AM Last Post: vinod123
	Importing data sheet	Santu	2	3,377	08-20-2015, 11:37 PM Last Post: ADITI1992

Users browsing this thread: 4 Guest(s)