Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
QTP Tips and Tricks
#10
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!
Reply


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
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
weblist index tip - by rajpes - 07-29-2011, 11:14 PM
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
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 rajpes - 03-02-2012, 01:42 PM

Forum Jump:


Users browsing this thread: 2 Guest(s)