New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › UFT / QTP Beginners v
How to retrieve data from excel to datatable

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
How to retrieve data from excel to datatable
Ankesh Offline
Senior Member
****
Posts: 424
Threads: 10
Joined: Aug 2011
Reputation: 0
#3
Solved: 10 Years, 10 Months ago 02-02-2012, 10:07 AM
Hi Shwetha,

In order to get the datas from excel to QTp datatable, QTp provides import feture...

Use the below code

Datatable.Import "C:\SampleFile.xls","<SheetNameInExcel(SourceSheet)>","<SheetNameIn Datatable(Destination Sheet)>"

please refer to QTp help for more information.

Regards,
Ankesh
Find
Reply


Messages In This Thread
RE: How to retrieve data from excel to datatable - by Ankesh - 02-02-2012, 10:07 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Error as Global Not defined while trying to retrieve value from Datatable siddharth1609 0 862 09-11-2019, 02:52 PM
Last Post: siddharth1609
  Cannot retrieve Native property JeL 1 938 07-29-2019, 05:41 PM
Last Post: JeL
  Want to read the data from excel and set read value in the JavaTable rajeevk7 0 2,178 07-10-2017, 04:20 PM
Last Post: rajeevk7
  dtLocalSheet empty even though excel file contains data cantorre 2 2,259 05-10-2017, 12:47 PM
Last Post: vidhi
  Reading data from excel sheet serenediva 1 9,073 03-03-2017, 10:07 AM
Last Post: vinod123

Forum Jump:


Users browsing this thread: 1 Guest(s)