property WorksheetName: String;

This example sets the name of new worksheet to 'Orders'.

Dataset2Excel1.WorksheetName := 'Orders';