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
Unable to import excel sheet to qtp

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Unable to import excel sheet to qtp
nilanjans Offline
Junior Member
**
Posts: 26
Threads: 8
Joined: Apr 2012
Reputation: 0
#4
Not Solved 04-12-2012, 08:24 PM
Hi,

Below is the basic code Importing a spcific sheet from xternal Excel file.
Code:
DataTable.ImportSheet (FilePath, SourceSheetNo., DestinationSheetNo.)


Suppose we have .xls file named "TestDemo.xls", and want to populate its 3rd sheet on datatables Action2 Localsheet.(Sheet Id 3)
So for that purpose,

DataTable.ImportSheet (FilePath, 3, 3) should work fine.

Regards,
Nilanjan
Find
Reply


Messages In This Thread
Unable to import excel sheet to qtp - by shyams - 04-24-2011, 01:31 AM
RE: Unable to import excel sheet to qtp - by nilanjans - 04-12-2012, 08:24 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Reading data from excel sheet serenediva 1 9,622 03-03-2017, 10:07 AM
Last Post: vinod123
  How import final calculated values by cell formula from Excel not the formula itself. qtped 1 4,861 01-17-2017, 04:05 PM
Last Post: sagar.raythatha
Smile Importing Excel sheet - Reference Values are not recognized michiusa69 3 7,885 01-23-2015, 02:36 AM
Last Post: lkng2001
  How to pass a date from Excel sheet to web form revati.shendure 1 2,973 11-27-2014, 11:54 AM
Last Post: revati.shendure
  Datatable import error Prashanth 7 16,400 11-19-2014, 06:53 PM
Last Post: praveen.g3

Forum Jump:


Users browsing this thread: 2 Guest(s)