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
Reading xls by column name

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Reading xls by column name
anbarasu Offline
Junior Member
**
Posts: 44
Threads: 30
Joined: Aug 2009
Reputation: 0
#1
Solved: 11 Years, 3 Months, 4 Weeks ago 04-05-2010, 11:48 AM
Is it possible to read xls by column name instead of cells(r,c). If so, kindly assist me.
Find
Reply
manishbhalshankar Offline
Member
***
Posts: 189
Threads: 0
Joined: Jul 2009
Reputation: 1
#2
Solved: 11 Years, 3 Months, 4 Weeks ago 04-05-2010, 12:01 PM
You will have to import the xls into the datatable to read by column name.
Find
Reply
Saket Offline
Super Senior Member
*****
Posts: 1,199
Threads: 5
Joined: Nov 2008
Reputation: 0
#3
Solved: 11 Years, 3 Months, 4 Weeks ago 04-05-2010, 12:26 PM
Yes, you can read the values in excel by column name
this thread - Sorting Data in Excel may help you.

Find
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Reading XML Data from a WebPage shaan.mishra87@gmail.com 1 2,210 09-28-2016, 09:16 PM
Last Post: supputuri
  Reading an amount from statement shipu 0 1,909 12-24-2013, 01:42 AM
Last Post: shipu
  to count the number of used rows in a particular column sujaravi123 3 11,158 06-12-2013, 03:17 PM
Last Post: sujaravi123
  How to recognize table row and column siwani 4 5,037 04-05-2012, 05:06 PM
Last Post: verma.vik6
  reading a value for GIF image sujaravi123 1 2,498 03-29-2012, 07:47 PM
Last Post: Ankesh

Forum Jump:


Users browsing this thread: 2 Guest(s)