New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › VB Scripting/Descriptive Programming v
How to Delete Rows with duplicate values in 1 columns in excel thru QTP.

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
How to Delete Rows with duplicate values in 1 columns in excel thru QTP.
arpan Offline
Junior Member
**
Posts: 30
Threads: 16
Joined: Jun 2013
Reputation: 0
#1
Not Solved 02-09-2015, 08:47 PM
Hi Guys,
I've an excel sheet with 5 columns and 10 rows. I want to check if there are any duplicate values in column B. If i find duplicate values, i want to delete both rows. How can i achieve this using QTP? I've done lot of research but couldn't find an answer to this specific situation. I've the code which would delete one of the duplicate value, but i want to delete both values. Can someone help me out with this?

Thanks
Arpan
Find
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Comparing two unsorted excel columns ProTester 2 2,489 09-13-2018, 02:11 PM
Last Post: ProTester
  Trying to create List box in excel sheet at Run time with values yes No JACKSPARROW 0 1,589 01-17-2017, 11:05 AM
Last Post: JACKSPARROW
  How to delete prepopulate value in powerbuilder qtp-tester 1 1,704 07-04-2016, 06:43 PM
Last Post: venkatesh9032
  How to get center data value in a odd number of rows and columns web table ... sai rajesh 0 2,608 11-13-2013, 10:24 PM
Last Post: sai rajesh
  Delete icon in System tray arpan 2 3,879 07-12-2013, 07:38 PM
Last Post: arpan

Forum Jump:


Users browsing this thread: 1 Guest(s)