Sort the records from a table using ORDER BY in OLE DB Source component before sending rows to excel spreadsheet
e.g., SELECT cols......
FROM your_table_name
ORDER BY column_name you want to order
Above statetment should be in OLE DB Source in a Data Flow Task