I believe you may want to look into this article which takes you step-by-step through the process of connecting to an excel file and retrieving a DataSet with all fo the data. Once you have this DataSet you can programmatically control certain Reporting items as in the this documentation article. You can also add a data source programmatically which will also allow you to set up your data through this DataSet.