QTP Tips and Tricks

Hello There, Guest! Register

New To UFT? Join the best UFT Training Online!

Thread Rating:

1 Vote(s) - 5 Average
1
2
3
4
5

Thread Modes

QTP Tips and Tricks

rajpes Offline

Offline

Senior Member

Posts: 275
Threads: 4
Joined: Jul 2011
Reputation: 0

#10

07-30-2011, 05:47 PM (This post was last modified: 07-30-2011, 05:50 PM by rajpes.)

Sometimes you may need to compare two datasheets in run time datatable.
The trick is to supply empty string in "filename" parameter of importsheet method.
Fallowing code copies global sheet's data into "NewSheet"

Code:
DataTable.AddSheet "NewSheet"

DataTable.ImportSheet  "", "Global", "NewSheet" 

'Change values in global sheet , it doesnt affect newsheet's values!

Find

Reply

« Next Oldest | Next Newest »

Messages In This Thread

QTP Tips and Tricks - by rajpes - 07-25-2011, 11:49 AM

How to open and edit multiple scripts - by rajpes - 07-25-2011, 03:48 PM

RE: QTP Tips and Tricks - by Ankur - 07-25-2011, 04:02 PM

To boost performance of scripts execution - by rajpes - 07-26-2011, 10:47 AM

Simplest way to open a webpage - by rajpes - 07-26-2011, 03:24 PM

VBScript to print a pattern - by rajpes - 07-27-2011, 04:05 PM

RE: QTP Tips and Tricks - by nakulgupta18 - 03-07-2014, 04:05 AM

RE: VBScript to print a pattern - by ashitroy1991 - 08-24-2017, 12:46 PM

How to check whether focus is set by default on an object - by rajpes - 07-29-2011, 10:03 AM

weblist index tip - by rajpes - 07-29-2011, 11:14 PM

How to check if a column exists in datatable - by rajpes - 07-30-2011, 08:48 AM

To copy a datatable sheet's content to new sheet in the datatable - by rajpes - 07-30-2011, 05:47 PM

RE: QTP Tips and Tricks - by gaveyom - 08-29-2011, 11:19 AM

@gaveyom - by rajpes - 09-21-2011, 05:11 PM

Initializing a counter in Do loop - by rajpes - 09-21-2011, 06:15 PM

worksheets or sheets - by rajpes - 09-22-2011, 12:13 PM

ComboBox items into array - by rajpes - 09-23-2011, 03:49 PM

DataTable.Import/ImportSheet - by rajpes - 09-25-2011, 12:29 PM

Check if a webtable column is sorted - by rajpes - 09-28-2011, 07:46 PM

How to retrieve test result summary without writing any script - by rajpes - 09-30-2011, 09:26 AM

How to know the password - by rajpes - 10-11-2011, 11:06 AM

RE: QTP Tips and Tricks - by sshukla12 - 12-21-2011, 10:43 AM

RE: QTP Tips and Tricks - by Sathiya - 12-21-2011, 05:54 PM

RE: QTP Tips and Tricks - by rajpes - 01-30-2012, 07:51 PM

RE: QTP Tips and Tricks - by rajpes - 02-02-2012, 04:59 PM

RE: QTP Tips and Tricks - by sshukla12 - 03-02-2012, 02:37 PM

Using "Navigate and Learn" option - by rajpes - 02-06-2012, 07:45 PM

RE: Using "Navigate and Learn" option - by Dhiman - 02-15-2012, 10:02 PM

RE: Using "Navigate and Learn" option - by MVChowdary - 02-16-2012, 10:28 AM

RE: Using "Navigate and Learn" option - by inborntester - 03-02-2012, 11:30 AM

RE: Using "Navigate and Learn" option - by rajpes - 03-02-2012, 01:42 PM

Users browsing this thread: 4 Guest(s)