Micro Focus QTP (UFT) Forums
Reading xls by column name - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: Reading xls by column name (/Thread-Reading-xls-by-column-name)



Reading xls by column name - anbarasu - 04-05-2010

Is it possible to read xls by column name instead of cells(r,c). If so, kindly assist me.


RE: Reading xls by column name - manishbhalshankar - 04-05-2010

You will have to import the xls into the datatable to read by column name.


RE: Reading xls by column name - Saket - 04-05-2010

Yes, you can read the values in excel by column name
this thread - Sorting Data in Excel may help you.