Specifies the highest possible number of rows per worksheet. The default value is 65535. Read/write Integer.
Syntax
property RowsPerSheet: Integer;
Example
This example sets the highest possible number of rows to 10.
Dataset2Excel1.RowsPerSheet := 10;