 |
Define Variables
Go to Variable Manager and create variables "CurCellValue" and "NxtCellValue" |
Screenshot 1
Screenshot 2
Screenshot 3
|
 |
Create new task
Click on New->Task Editor. |
 |
Open Excel sheet
From Application Category->Excel, Select 'Open Spreadsheet' option. |
 |
Sort data in Excel sheet
Insert Keystroke command to sort data in Excel sheet.
Keystrokes: [CTRL DOWN]a[CTRL UP] in "Microsoft Excel - TestData.xls"
Keystrokes: [ALT DOWN]d[ALT UP] in "Microsoft Excel - TestData.xls"
Keystrokes: s in "Microsoft Excel - TestData.xls"
Keystrokes: [DOWN ARROW][DOWN ARROW] in "Sort"
Keystrokes: [ENTER] in "Sort"
Keystrokes: [ENTER] in "Sort" |
 |
Retreive value of 1st cell
Insert Excel command to get the value of the first cell
Excel: Go to cell "A1" |
 |
Assign value to variable Clipboard
Insert Excel command and assign the value of variable to "Clipboard"
Excel: Get value of Active Cell and assign to variable "Clipboard" |
 |
Go through all the cells until word 'STOP' found
Insert Loop for variable "Clipboard" not equal to "STOP". |
 |
Check for duplicate value
Insert a Loop to check value for currently active cell is equal to that stored in the variable "CurCellValue"
Loop While $CurCellValue$ Equal To $NxtCellValue$ |
 |
Delete the duplicate row
Insert Excel command to delete the entire row.
Excel: Delete Active Cell with option entire row |
 |
If Duplicate value is not found then assign value of cell to the variable
Insert Excel command to store value to Active Cell to "Clipboard"
Excel: Get value of Active Cell and assign to variable "Clipboard". |
chkDuplicateEntries_Excl.atmn 
TestData.xls
