If you need something in specific cell you could look at this. I was looking for something similar and found it very useful.

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/70024/

WHen adding Excel Source and under "Show Advanced Editor" and in Component Properties you could specify your own OpenRowset like Sheet1$A3:H3 where A3 is first column...

If you trying to get a list of all reports path and name of the report you should you catalog table.

SELECT Path,Name

FROM Catalog