New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › VB Scripting/Descriptive Programming v
How to read the contents of external excel sheet

Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
How to read the contents of external excel sheet
supputuri Offline
Moderator
*****
Posts: 516
Threads: 17
Joined: Jul 2009
Reputation: 3
#7
Solved: 11 Years, 3 Months, 3 Weeks ago 05-24-2012, 11:43 AM
Hi Guys,

I know I am late but always it's good habit to use the ADODB connection to read the values from excel files so that we can read the data from different kinds of excel files( .xls, .xlsm, .xlsx.....). Please let me know if you need any further information how to use the ADODB connection and read the data, which will save lot of time and resources.
Thanks,
SUpputuri
Find
Reply


Messages In This Thread
RE: How to read the contents of external excel sheet - by supputuri - 05-24-2012, 11:43 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Trying to create List box in excel sheet at Run time with values yes No JACKSPARROW 0 1,714 01-17-2017, 11:05 AM
Last Post: JACKSPARROW
  Custom sort -Excel Sheet kiran 1 3,868 01-28-2014, 09:23 AM
Last Post: supputuri
  Can we save an exported Excel sheet directly from QTP? Akhila 2 3,466 11-28-2013, 10:30 AM
Last Post: Akhila
  How to identify the object reference to the existing(already opened) Excel sheet yogeesh 1 9,965 09-26-2012, 07:00 PM
Last Post: krr
  programming to use different external file of environment variables bundfromnj 1 3,970 01-19-2012, 05:32 PM
Last Post: SteveS

Forum Jump:


Users browsing this thread: 7 Guest(s)