TGridToXLS

The following example clears contents of row three in the range B5:F19

].Range[

'B5'

].Rows[
Workbook.Sheets[1].UsedRange.Rows[1].Font.Bold := true;
Workbook.Sheets[
Workbook.Sheets[1].Range['B5','F19'].Rows[3].ClearContents;
Workbook.Sheets[
Workbook.Sheets[1].RCRange[2, 2, 5, 3].Rows[1].Merge(False);