Have you tried using an SQL command (or SQL command from variable) as the data access mode for the Excel source?
You can then set SQL command text as select top 6 from $worksheetname
Creating it from a variable would mean you could also set the worksheet name and rows required dynamically. Variable needs to be created with EvaluateAsExpression = true then use code above as expression "select top " + (DT_WSTR, 10) @[i_rows] + " from " + (DT_WSTR, 10) @[s_ws_name]. Where i_rows and s_ws_name are variables you have created.