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 import final calculated values by cell formula from Excel not the formula itself.

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
How import final calculated values by cell formula from Excel not the formula itself.
qtped Offline
Junior Member
**
Posts: 7
Threads: 3
Joined: Feb 2014
Reputation: 0
#1
Not Solved 03-05-2014, 03:51 AM
Hello

I am having trouble with importing text values calculated by the cell formulas in a excel sheet. Instead of the final calculated values by the formula in a cell the actual formula is being imported. Does anyone know how to solve this issue and import final calculated values by the formula in a cell from excel sheet not the formula itself. I am using the following syntax

Code:
DataTable.AddSheet ("Sheet_Name")
DataTable.ImportSheet "Excel_File_Name.xls", " Sheet_Name ", " Sheet_Name "

Your help is greatly appreciated.
Find
Reply


Messages In This Thread
How import final calculated values by cell formula from Excel not the formula itself. - by qtped - 03-05-2014, 03:51 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Need help for copying values from one excel to another excel vinodhiniqa 0 1,363 07-06-2017, 05:33 PM
Last Post: vinodhiniqa
Smile Importing Excel sheet - Reference Values are not recognized michiusa69 3 7,884 01-23-2015, 02:36 AM
Last Post: lkng2001
  Datatable import error Prashanth 7 16,399 11-19-2014, 06:53 PM
Last Post: praveen.g3
  clearing excel sheet values beejfred 1 7,513 09-25-2014, 11:43 AM
Last Post: vinod123
  How to import .xlsx file type to QTP qtped 3 6,667 03-27-2014, 01:33 PM
Last Post: Ankur

Forum Jump:


Users browsing this thread: 1 Guest(s)