Concur with Ashfaque, however not convinced that Microsoft will ever do that.
You could consider putting some code behind the report and pump it into Excel, or a comma separated value (CSV) file to read into Excel.
You could consider using the same query that creates the report within Excel, by using that as a datasource within your Excel model(s)
Of the 2 appraoches the latter will be easier and more straightforward. The downside is that if you have to change the report you (or your successor) have to remember to change the queries aswell (you have to make the same changes to the first option however as its sending the data you change once.