New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › UFT / QTP Others v
Importing sheets which have Formulas

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Importing sheets which have Formulas
dvkbabu Offline
Junior Member
**
Posts: 19
Threads: 7
Joined: Mar 2009
Reputation: 0
#1
Solved: 10 Years, 9 Months, 1 Week ago 03-26-2009, 04:28 PM
I have two sheets in xls file. I am using Formula(sum) in Sheet2 with the values of Sheet1. Like "=SUM(Sheet1!A2,Sheet1!B2)".

I have imported this xls file(both sheets) to QTP using DataTable.ImportSheet method. When I run the script, Data table is showing correct values for sheet1 but Sheet2 value is shown as #REF! and the formula is shown as (=SUM([]Sheet1!A1,[]Sheet1!B1)) in local data table sheet.

Any workaround for this? I am using QTP 9.2

Vijay
Find
Reply


Messages In This Thread
Importing sheets which have Formulas - by dvkbabu - 03-26-2009, 04:28 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Problem in using importing data sheet value and design table value praneeth_be 2 2,180 08-19-2009, 12:51 PM
Last Post: Saket
  Problem in using importing data sheet value and design table value praneeth_be 1 1,821 08-18-2009, 08:29 PM
Last Post: basanth27
Rolleyes Importing test scripts used in QTP into QC ritugoyal 0 2,796 07-10-2009, 10:59 AM
Last Post: ritugoyal

Forum Jump:


Users browsing this thread: 1 Guest(s)