Sorting in Excel question

gadzilla1

I've created a report that exports data to Excel. I'd like to sort the report descending on a numeric variable that I created called 'NewValue'. Is there any way to easily sort in the function below? I have seen some great links on sorting excel and I'm just hoping there is a way to accomplish the task in this function. Any ideas? Thanks much.

MakeExcelDataBody()
ExcelBuf.NewRow;
ExcelBuf.AddColumn(Item."No.",FALSE,'',FALSE,FALSE,FALSE,'');
ExcelBuf.AddColumn(Item.Description,FALSE,'',FALSE,FALSE,FALSE,'');
ExcelBuf.AddColumn(NewValue,FALSE,'',FALSE,FALSE,FALSE,'');

(ExcelBuf is a Record variable w/Subtype Excel Buffer)

garak

U can use XLRange.Sort() for this

gadzilla1

Thank you much for the reply.

garak

Please hope it could help you