Hello Mohan,
You have to retrive only those records from database and then bind into excel sheet. e.g.
DECLARE @From = 7;
DECLARE @To = SELECT COUNT(*) FROM MyTable;
WITH NumberedMyTable AS
(
SELECT
Id,
Value,
ROW_NUMBER() OVER (ORDER BY Id) AS RowNumber
FROM
MyTable
)
SELECT
Id,
Value
FROM
NumberedMyTable
WHERE
RowNumber BETWEEN @From AND @To