Yes, I was speaking of a DataTable in QTP. Not .xls prior to importing. I want to populate the datatable from one action and then in the next action, sort the rows based on the values in the date column. So I wanted to sort my all the data in my rows from most recent to oldest, based on the data under the "Date" column header.
It seems that QTP would offer a sorting function in expert view for their data tables, but I haven't seen one. I'm a little surprised.
It seems to me that you have really 3 options here:
1. export that datasheet to Excel, sort it there, import it back.
2. load that datasheet into a two-dimensional array, sort it, then either use the array in action2 or re-populate the datasheet from the array.
3. (my favorite) modify your first action to populate the datasheet via an Insertion Sort so that when that first action is done, the datasheet is already ordered by date. Note: this is my favorite because it is probably the easiest to do, but it may not be the fastest solution).
"The last 10% of any software project will take 90% of the budgeted time. The first 90% will take the other 90%"
Okay, that third option sounds pretty good. As you suggested, I think I may try accomplishing the sort order on the first action as I'm loading the sheet. Not sure how insertion sort works, but I can use the term as reference to find some examples. Do you know if QTP offers any functionality that could help? Has anyone accomplished something similar to this with data sheets.