How to get data from data table in Ascending order

[dipashri]

hi friends,
Suppose there is a sheet in data table of qtp with values like 5,9,1,7 or g,a,r,q,b how to sort them and display in Ascending Order using script

[jacosta]

Hi,

Try this code:

Code:

call SortArray()
Function SortArray()
'================================================
'Author:QTP Lab:a touch of madness!
'Date:23/11/2009
'Description:This function sorts an array into ascending
'            and descending order using .Net class methods.
'Function:SortArray()
'=========================================================
Dim myObj,MyArrAux
MyArrAux=""
Set myObj=CreateObject("System.Collections.ArrayList")
myObj.Add("Ba")
myObj.Add("R")
myObj.Add("A")
myObj.Add("Bb")
myObj.Add("S")
myObj.Add("M")
myObj.Add("D")
myObj.Add("J")
myObj.Add("Bc")
myObj.sort()

For each sNames in myObj
    MyArrAux=MyArrAux& sNames &":"
Next
msgbox MyArrAux,0,"Ascending order"

Set myObj=Nothing

End Function