property WorksheetName: String;

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

DBGrid2Excel1.WorksheetName := 'Countries';