Reporting in VS 2008 with Excel as datasource

Question

I have certain data in Excel file which is dynamic. I wanted to make use of Reporting which is available in VS 2008.

I wanted to create a report which can be exported to multiple formats like(PDF, XML, Image, etc) and the datasource will be an excel file. How do I achieve that? I created an Office project with Excel worksheet(with certain rows and columns) in VS 2008 and I added a Report to the project. How will i map the the rows and columns in the Excel(.xlsx) worksheet to the table of the report(.rdlc file) so that I can export it to various formats? Is this Possible? Also I wanted to implement LINQ to the excel inorder to pick only specific rows and columns. Is this possible? How will I achieve this? Kindly Help