Skip rows when importing Excel source-SSIS

1) Set the "OpenRowset" Custom Property of your Excel Connection
2)Right-click your Excel connection > Properties; in the Properties window, look for OpenRowset under Custom Properties).  
3) To ignore the first 6rows in Sheet1, and import columns A-M, you would enter the following value for OpenRowset:  Sheet1$A7:M 
4) You can also specify a row number if you like for end row i.e. M, if you know where records in excel will end

How to limit no. of rows in page in SSRS

Follow the steps to limit the rows on the page

1) Go to the Rows Groups section . Select Add Group -> Parent Group -> Choose Expression in Group By
2) Paste the following code into the expression box.
=int((RowNumber(nothing)-1)/No. of rows you want to keep on the pagr)
3) In the group property go to Page Breaks option and select "Between each instance of a group".
4) If you run your report, you could get error saying "A sort expression for tablix ‘Tablix...’ uses the RowNumber function. RowNumber cannot be used in sort expressions."  To fix the error remove the default sorting expression created in the group properties